I am proud to announce, DbGate now supports creating ER diagrams.
See the latest news about DbGate
The main highlight of this release is under the hood of electron app. But there are also significant UX improvements.
The main highlight of this release in database schema compare tool. It can compare tables with keys, connstraints and indexes, and also views, stored procedures and functions. It works on all supported database engines (MySQL, SQL Server, PostgreSQL, SQLite, MariaDB, CockroachDB, Redshift). Database compare tool is super fast, compare to other DB compare tools, as it uses already cached DB models.
This release brings schema editor. You can edit table schema, define primary keys, foreign keys, indexes and unique constraints.
When alter operation is not directly supported by SQL engine (eg. drop constraint on SQLite), DbGate generates table recreate script.