Introducing
The Slant team built an AI & it’s awesome
Find the best product instantly
Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to Safari
Try it now
4.7 star rating
0
What is the best alternative to SchemaCrawler?
Ad
Ad
ERBuilder
All
7
Experiences
Pros
6
Specs
Top
Pro
Ease of use
See More
Top
Pro
Affordable
Very affordable compared to pricey alternatives.
See More
Top
Pro
Supports many databases
See More
Top
Pro
ER Builder is easy to use and a complete modeling tool
Very interesting tool, powerful and easy to use. Can do reverse and forward engineering, generate SQL script, and more.
See More
Top
Pro
Lightweight
Small install size.
See More
Top
Pro
Supports Amazon Redshift data modeling
See More
Specs
Platforms:
Windows
Hide
See All
Experiences
49$+
22
0
SchemaSpy
All
6
Experiences
Pros
2
Cons
3
Specs
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
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
Specs
Platforms:
Windows, Linux, Mac
Technology:
Java
Database management:
JDBC-compliant
Hide
Get it
here
13
1
DbSchema
All
8
Experiences
Pros
7
Specs
Top
Pro
Graphical Diagram Editor
Includes the possibility to edit tables and data directly in the diagram without writing SQL statements.
See More
Top
Pro
Multi-platform
Runs on Windows, Mac, and Linux.
See More
Top
Pro
Virtual Foreign Keys
If the Database schema is missing real foreign keys, it is possible to create virtual ones to be used within the tool.
See More
Top
Pro
Generator for Random Data
Includes the possibility to generate random numerical data or fetch random entries from a text file to populate the database.
See More
Top
Pro
Generate schema from existing database
Includes the possibility to generate an ER diagram from an existing database.
See More
Top
Pro
SQL editor with syntax highlighting
Includes an SQL editor with syntax highlighting and code completion feature.
See More
Top
Pro
Graphical Query Editor
Includes a visual query editor capable of using different join types, filters as well as the 'group by' clause.
See More
Specs
Platforms:
Windows, Linux, Mac
Technology:
Java
Price (2023-06-26):
196$ + Taxes
Hide
See All
Experiences
$127
17
0
DbDesigner
All
5
Experiences
Pros
3
Cons
1
Specs
Top
Pro
Templates
Has lots of templates with example database designs.
See More
Top
Con
Beta
Seems to be in beta status.
See More
Top
Pro
Reverse and forward engineering
Supports MySQL, PostgreSQL and Oracle reverse engineering. Support for MS SQL and SQLite is planned.
See More
Top
Pro
Generic design
Can create a "generic" design for all supported databases.
See More
Specs
Platforms:
Web
Hide
Free / paid
9
0
DBeaver
All
10
Experiences
Pros
6
Cons
3
Specs
Top
Pro
Cross-platform
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
See More
Top
Con
Never-ending function errors
Like, 'Communications link failure', 'Connection refused' (Community Edition 6.2.1).
See More
Top
Pro
Free
It is licensed under GPL v2.
See More
Top
Con
Cannot view function
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
Con
Trigger edition
Until version 3.5.8 you can not edit triggers, only view (since 3.5.6).
See More
Top
Pro
Follow foreign key to their primary key
If you have a table with a foreign key you can click on it to see the table row where this key references to.
See More
Top
Pro
Formatted text view
It has the classic grid view and a well-organized text view that you can quick-select with CTRL-A.
See More
Top
Pro
Easy to use, clean neat inteface
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
Hide
See All
Experiences
Free / paid
1323
134
Schemaball
All
3
Experiences
Pros
2
Cons
1
Top
Pro
Supports reading schemas from multiple sources
Schemaball can read schemas from multiple sources such as SQL schema dumps, flat files or live databases.
See More
Top
Con
Visualizations may be hard to get used to
Since schemas are visualized by using stylized "schema balls" it may be hard getting used to them since they are so different from the other, more straightforward options.
See More
Top
Pro
Interesting twist on visual interface
Gives a quick way to grasp an overview on the past/present complexity of the database (or group of tables) undergoing inspection.
See More
Hide
Get it
here
3
1
MySQL Workbench
All
9
Experiences
Pros
5
Cons
3
Specs
Top
Con
Mixed experience
Doesn't support HiDPi mode on Windows, everything looks blurry. On Linux it has missing features. On Mac seems to be working just fine. But overall a mixed experience.
See More
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
Unintuitive UI
Workbench's user interface is regarded by a lot of users as unintuitive and hard to use. It seems cluttered and hard to get used to. The left side of the application has several sections (which you get to choose which to open) with several tools for each. A lot of features are hidden behind menus and need some getting used to find them.
See More
Top
Pro
Community version
There is a community edition available that is free and open source; licensed under GPL.
See More
Top
Con
Freezes constantly
Running any kind of query with more than a thousand records or even just opening a file and other actions crashes the application. You are unable to actually stop a query. You have to kill from Windows Task Manager every single time.
See More
Top
Pro
EER diagramming
MySQL Workbench has enhanced entity–relationship modeling support.
See More
Top
Pro
Cross-platform
Works on Windows, Linux, OS X.
See More
Top
Pro
Database synchronization
Forward & reverse engeneering
See More
Specs
Platforms:
Windows, Linux, Mac
Hide
See All
Experiences
FREE
194
66
SQLGate
All
9
Experiences
Pros
6
Cons
2
Specs
Top
Pro
Quick data analysis
Functions; filter, sort and group on grid / Copy, past, sum and statistics functions like excel.
See More
Top
Con
Logon
The logon process after starting up the application is rather long winded (tested with PostgreSQL, no defaults shown for e.g. port number).
See More
Top
Pro
Saves time with autocomplete & template functions
See More
Top
Con
Free version is limited
e.g. only 10 tables allowed in ERD designer.
See More
Top
Pro
Fast processing and easy customization
They put out weekly updates, so there are new and impressive functions being added pretty consistently.
See More
Top
Pro
Supports cloud-based DB such as AWS & Azure
See More
Top
Pro
Includes PL/SQL editor and debugger
See More
Top
Pro
ER diagrams
Entity Relationship database diagrams limitations are: only supports reverse engineering, and can not export to formats other than .erd
See More
Specs
Platforms:
Windows
Hide
See All
Experiences
Free / paid
73
0
Model Xtractor
All
6
Experiences
Pros
4
Cons
1
Specs
Top
Pro
Complete diagrams
Generates complete diagrams of a database with one click.
See More
Top
Con
Driver download
Some database drivers need to be installed manually, e.g. for PostgreSQL the Npgsql MSI installer.
See More
Top
Pro
Lightweight
Only a 5 Mb download.
See More
Top
Pro
Multiple databases
Supports multiple databases: Oracle, SQL Server, PostgreSQL, MySQL, Azure, Amazon Redshift, SQLite and Firebird.
See More
Top
Pro
Easy
Very user friendly.
See More
Specs
Platforms:
Windows
Hide
Free
1
0
SQL Power Architect
All
6
Experiences
Pros
4
Cons
1
Specs
Top
Pro
Convert
Can convert databases and copy the data from tables.
See More
Top
Con
The manual is not free
The SQL Power Architect User Guide costs $ 99.
See More
Top
Pro
OLAP schema modeling
Cubes, Measures, Dimensions, Hierarchies & Levels.
See More
Top
Pro
Reverse engineering
See More
Top
Pro
Drag and Drop
See More
Specs
Platforms:
Windows, Linux, Unix, Mac
Technology:
Java
Hide
Free / paid
5
0
pgModeler
All
5
Experiences
Pros
3
Cons
1
Specs
Top
Pro
Diff scripts
Can generate scripts to synchronize a database.
See More
Top
Con
Compiling
Can't be compiled in Microsoft Visual Studio because of gcc/clang extensions. Instructions on how to compile for Windows.
See More
Top
Pro
Reverse engineering
Can generate diagrams from an existing database.
See More
Top
Pro
Export formats
Can export to SQL script file, PNG, SVG or directly to PostgreSQL.
See More
Specs
Platforms:
Windows, Linux, Mac
Technology:
C++, Qt
Database management:
PostgreSQL
Hide
Free / paid
4
0
dbdiagram.io
All
6
Experiences
Pros
3
Cons
2
Specs
Top
Pro
Multi database
Can export to MySQL, PostgreSQL and SQL Server, can also import Ruby on Rails.
See More
Top
Con
Limited free version
The free version allows 10 diagrams and advanced options like color can not be used.
See More
Top
Pro
Clean interface
See More
Top
Con
No Crowfeet
Does not show "Crowfeet" symbols in relations.
See More
Top
Pro
Ease of use
See More
Specs
Platforms:
Web
Hide
Free / paid
3
0
SQLeo
All
7
Experiences
Pros
5
Cons
1
Specs
Top
Pro
Data compare
See More
Top
Con
Java
Needs JRE 1.7+
See More
Top
Pro
Query builder
See More
Top
Pro
Import / Export
html, insert, text or csv
See More
Top
Pro
Color
Background color per connection.
See More
Top
Pro
Schema compare
See More
Specs
Platforms:
Windows, Linux, Mac
Hide
See All
Experiences
Free
2
0
DbVisualizer
All
6
Experiences
Pros
4
Cons
1
Specs
Top
Pro
Professional tool
This is a good and stable tool with really good and useful functionality: import/export, SSH tunnelling, fast searching, duplication, DDL visualization etc. If you are a professional, don't complain about the pricing. If you're an amateur, maybe this isn't for you.
See More
Top
Con
Expensive
License for the full product is costly.
See More
Top
Pro
Duplicate row button
Makes it really easy to stub out example data while developing, just change the values with unique constraints and you have extra data ready to go.
See More
Top
Pro
Wildcard finder
Has a search box that will highlight any matching row, regardless of what field is matched (spans multiple columns).
See More
Top
Pro
In-line editing
Allows you to edit and save db rows through a spread-sheet like editor.
See More
Specs
Platforms:
Windows, Linux, Mac
Technology:
Java
Hide
Get it
here
97
10
Rise
All
5
Experiences
Pros
4
Specs
Top
Pro
Import database
Import from SQL Server, MySQL, PostgreSQL, Oracle, DB2.
See More
Top
Pro
Code generators
Code generators for C#, PHP, SOAP web services.
See More
Top
Pro
Multi database
Support for popular databases like PostgreSQL, MySQL, SQL Server.
See More
Top
Pro
Visual Studio extension
A Visual Studio extension is available (14 days trial version).
See More
Specs
Platforms:
Windows
Hide
Free / paid
1
0
Toad
All
4
Experiences
Pros
2
Cons
2
Top
Pro
Reliable
Toad is maintained by Dell and has great community support.
See More
Top
Con
Fewer features
Still some more features are required to add. Other than that its perfectly fine.
See More
Top
Pro
Free
Toad is free to use.
See More
Top
Con
No built-in SSH tunneling
Toad currently doesn't provide built-in SSH tunneling.
See More
Hide
Paid
53
12
HeidiSQL
All
17
Experiences
Pros
10
Cons
6
Specs
Top
Pro
Free
Licensed under GNU GPL.
See More
Top
Con
Can be buggy
HeidiSQL is known to have some bugs that results in crashes.
See More
Top
Pro
Portable
Alongside the possibility of downloading the installer and sourcecode, a portable version of the software is available.
See More
Top
Con
Intellisense is not intelligent
No intellisense for columns unless table name is aliased.
See More
Top
Pro
Great UI and ease of use
HeidiSQL has a comprehensive and intuitive interface.
See More
Top
Con
UI design is very bad
Generic windows form
See More
Top
Pro
Syntax completion
See More
Top
Con
No session backup
You cannot recover your session after close or even worse crash.
See More
Top
Pro
Lightweight
See More
Top
Con
Works under Linux only with Wine
It works quite well under Wine with Linux, but you must always take notice if the last version of HeidiSQL has been tested, for it may not run at all. There are some bugs in the Wine version that can be annoying and you have to kill the program and restart it. A native Linux version would be great.
See More
Top
Pro
Great user management
The user manager of HeidiSQL can easily set privileges on a per-database level or give access to only certain commands.
See More
Top
Con
No built-in debugger included
See More
Top
Pro
Data synchronization
HeidiSQL can compare and synchronize your data and structure between local and remote databases.
See More
Top
Pro
SSH tunnel
HeidiSQL allows connecting to your MySQL database via SSH tunnel.
See More
Top
Pro
Connect to servers via command line
You can use command line parameters to automate connections.
See More
Top
Pro
Works fine with Wine under Linux
See More
Specs
Platforms:
Windows
License:
GPL-2.0
Technology:
Delphi
Database management:
PostgreSQL, MariaDB, MySQL, SQL Server, SQLite
Hide
See All
Experiences
FREE
437
69
Valentina Studio
All
5
Experiences
Pros
4
Specs
Top
Pro
Free version
You can download a free version from the app store.
See More
Top
Pro
Multi DB
Supports several databases, MySQL/ MSSQL / PostGresSQL / and more
See More
Top
Pro
Cross-platform
Valentina Studio works on Windows, Linux and OS X.
See More
Top
Pro
Good UI
Valentina Studio has a responsive and clean user interface.
See More
Specs
Platforms:
Windows, Linux, Mac
Technology:
C++, QT
Hide
Get it
here
46
21
Built By the Slant team
Find the best product instantly.
4.7 star rating
Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to Safari
Try it now - it's free
{}
undefined
url next
price drop