The Slant team built an AI & it’s awesome

Find the best product instantly

4.7 star rating

DevelopmentDatabasesERMSQLDiagram

What are the best SQL graphical schema viewer / editor / import/export programs?

19

Options
Considered

108

User
Recs.

Nov 29, 2023

Last
Updated

15 Options Considered

Best SQL graphical schema viewer / editor / import/export programs	Price	Platforms	Technology
-- MySQL Workbench	-	Windows, Linux, Mac	-
-- DBeaver	Free / paid	Windows, Linux, MacOS	Java
-- SchemaSpy	-	Windows, Linux, Mac	Java
-- SchemaCrawler	Free	Windows, Linux, Mac	Java
-- DbDesigner	Free / paid	Web	-

MySQL Workbench

Top Pro

Easy to use

Actions can be directly carried out on tables. The software prepares the relevant query for approval before execution. See More

Top Con

Diagram elements often overlap each other, requiring a great deal of manual intervention

When generating a diagram from a database or schema, of even moderate complexity, MySQL Workbench does not automatically prevent table elements from overlapping or even overlying each other, and requires a fair amount of manual dragging to get a useful diagram to show a client. See More

Specs

Platforms:Windows, Linux, Mac

Top Pro

Community version

There is a community edition available that is free and open source; licensed under GPL. See More

Top Con

Has problems when talking to MariaDB

MySQL Workbench, while great, has some issues dealing with the supposed 'drop in replacement', MariaDB in its current incarnation (6.2.5.0 build 397), and them being in somewhat competition I don't see the compatibility agenda being pushed any time soon See More

Top Pro

Database synchronization

Forward & reverse engeneering See More

Top Pro

Cross-platform

Works on Windows, Linux, OS X. See More

Top Pro

EER diagramming

MySQL Workbench has enhanced entity–relationship modeling support. See More

DBeaver

Top Pro

Cross-platform

Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86). See More

Top Con

No Crow's foot

By default DBeaver uses IDEF1X notation for table relations, which is not like Crow's foot notation what a lot of users are used to. See More

Specs

Platforms:Windows, Linux, MacOS

Technology:Java

Database management:PostgreSQL, MySQL, Oracle, IBM DB2, SQL Server, Access, Sybase, Firebird, Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source

Top Pro

Free

It is licensed under GPL v2. See More

Top Con

Limited free version

Some databases are only supported in the paid version. Although the free version offers a generous amount of functions, some are only available in the paid version, like: Visual Query Builder Schema compare Data compare See More

Top Pro

Works for many types of databases

MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Microsoft Access, Sybase, Java DB (Derby), Firebird (Interbase), Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source See More

Top Pro

ER diagram

Can visualize data tables and their relationships with the ER Diagram view. See More

SchemaSpy

Top Pro

Entity Relationship Digramming for nearly any JDBC-compliant database

SchemaSpy can analyze database metadata in order to reverse engineer ER (Entity Relationship) diagrams for any JDBC-compliant database which includes Oracle, MySQL, Sql-Server and Postgres among others. See More

Top Con

Does not work with schema dumpfiles

SchemaSpy has no methods for dealing with when you only have a schema generated via something like (mysqldump --no-data [options] >schema-only_dump.sql) , and do not currently have access to a live database to connect with. See More

Specs

Platforms:Windows, Linux, Mac

Technology:Java

Database management:JDBC-compliant

Top Pro

Has a GUI option available

SchemaSpy is a CLI tool. For people who prefer GUI-based tools there's one available from a different maintainer which stands on top of the CLI version. See More

Top Con

GUI option is a separate download by a different maintainer

Since the GUI version is from a different maintainer, it may be abandoned and eventually break if SchemaSpy development continues beyond that. Or it may implement new features much later than the CLI version. See More

Top Con

Project may be dead or dying

The codebase on sourceforge hasn't seen an update since 2010. See More

SchemaCrawler

Top Con

Need Java

Top Pro

Many options for output formats in addition to graphical

The text-based output serves for database documentation, and is designed to be diff-ed against other database schemas. See More

Specs

Platforms:Windows, Linux, Mac

Technology:Java

Top Con

Does not work with schema dumpfiles

SchemaCrawler has no methods for dealing with when you only have a schema generated via something like (mysqldump --no-data [options] >schema-only_dump.sql) , and do not currently have access to a live database to connect with. See More

Top Pro

Extensive and detailed documentation online

Including visuals of the results of command-line option usage. See More

Top Pro

Free

databasediagram.com

Top Pro

Generate DDL

Built By the Slant team

Find the best product instantly.

4.7 star rating

Try it now - it's free

Vetted.ai illustration