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
Log in
•
Sign up
Add Question
Follow
Development
Databases
SQL
Diagram
What are the best database design programs?
24
Options
Considered
217
User
Recs.
Nov 21, 2023
Last
Updated
Related Questions
Activity
Here’s the Deal
Slant is powered by a community that helps you make informed decisions. Tell us what you’re passionate about to get your personalized feed and help others.
Let's go!
Have feedback or ideas?
Join our community
on Discord
Ad
17
Options
Considered
Best database design programs
Price
Platforms
Technology
--
DBeaver
Free / paid
Windows, Linux, MacOS
Java
--
SQLGate
Free / paid
Windows
-
--
MySQL Workbench
FREE
Windows, Linux, Mac
-
--
DbSchema
Free / paid
Windows, Linux, Mac
Java
--
TablePlus
59
Windows, Linux, Mac
-
See Full List
--
DBeaver
My Rec
ommendation
for
DBeaver
My Recommendation for
DBeaver
All
12
Experiences
3
Pros
6
Cons
2
Specs
Top
Con
•••
Cannot view function
See More
Top
Pro
•••
Free
It is licensed under GPL v2.
See More
ThriftyBeag's Experience
Very limited free version. I ended up using https://www.erdlab.io which is totally free and cloud based. Very quick and intuitive. I highly recommend https://www.erdlab.io
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
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
•••
Visual ER Diagram View
Can visualize data tables and their relationships with the ER Diagram view.
See More
Winnie Brockett's Experience
Universal Database Tool. Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases.
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
CredibleEkwensu's Experience
You can filter direct on rows, supports most of db engines, very fast, it's possible to save queries and much more!
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
•••
Cross-Platform
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
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
Hide
See All
Free / paid
Recommend
26
1
--
SQLGate
My Rec
ommendation
for
SQLGate
My Recommendation for
SQLGate
All
16
Experiences
7
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
RickZeeland's Experience
Free database editor and designer, supported Databases: Oracle, SQL Server, PostgreSQL, MariaDB, MySQL, IBM DB2, Tibero.
See More
Specs
Platforms:
Windows
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
Melissa's Experience
Pretty high quality database tool. The free version gives access to all the tools, but there are incentives and cons to upgrade to the paid version as well.
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
celine's Experience
Free SQL Database Management Program, it' s easy to use and user-friendly experience.
See More
Top
Pro
•••
Supports cloud-based DB such as AWS & Azure
See More
Brant Hwang's Experience
SQLGate is best Database IDE
See More
Top
Pro
•••
Includes PL/SQL editor and debugger
See More
한건국's Experience
to develope web
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
jayden-lee's Experience
SQLGate proved to be a very easy and powerful tool. First of all, it's fast! The quick data analysis really did wonders for speeding up my work, and the functions are both intuitive and easy to pick up. It includes a PL/SQL editor and debugger that helps catch any mistakes which comes in handy. Better yet, there are plenty of autcomplete and template functions that really help speed things up. There are also a few options for skin color, so you can customize the window with a color that suits you. I really like the dark skin.
See More
Ellie Hyeon's Experience
designer / SQL / database
See More
Hide
See All
Free / paid
Recommend
44
--
MySQL Workbench
My Rec
ommendation
for
MySQL Workbench
My Recommendation for
MySQL Workbench
Add Video or Image
All
13
Pros
7
Cons
5
Specs
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
Specs
Platforms:
Windows, Linux, Mac
Top
Pro
•••
Cross-platform
Works on Windows, Linux, and OSX.
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
•••
Good quality diagram
See More
Top
Con
•••
Doesn't support enclosed queries
See More
Top
Pro
•••
Database synchronization
Forward and reverse engineering.
See More
Top
Con
•••
Weak debuger
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
•••
Synchronization between model and database is a little bit buggy
See More
Top
Pro
•••
You can export an EER Diagram to SQL
Create your database schema directly from your diagram.
See More
Top
Pro
•••
EER diagramming
MySQL Workbench has enhanced entity–relationship modeling support.
See More
Hide
See All
FREE
Recommend
14
1
--
DbSchema
My Rec
ommendation
for
DbSchema
My Recommendation for
DbSchema
Add Video or Image
All
9
Experiences
1
Pros
7
Specs
Top
Pro
•••
Multi-platform
Runs on Windows, Mac, and Linux.
See More
Mike's Experience
DBSchema is a multi-platform database tool for relational databases (plus a few NoSQL databases) including a graphical schema and query editor. It served me very well over the last years.
See More
Specs
Platforms:
Windows, Linux, Mac
Technology:
Java
Price (2023-06-26):
196$ + Taxes
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
•••
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
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
•••
Generate schema from existing database
Includes the possibility to generate an ER diagram from an existing database.
See More
Hide
See All
Free / paid
Recommend
7
--
TablePlus
My Rec
ommendation
for
TablePlus
My Recommendation for
TablePlus
Add Video or Image
All
3
Pros
2
Specs
Top
Pro
•••
Native, beautiful and friendly
TablePlus is a native app which helps you easily edit database data and structure.
See More
Specs
Platforms:
Windows, Linux, Mac
Top
Pro
•••
Powerful SQL editor
Equipped with the following features: •Highlight syntax •Indent SQL Command •Split Results into Tabs •Save favorite SQL to snippet •Customize font size
See More
Hide
See All
59
Recommend
5
--
SSuite MonoBase Database
My Rec
ommendation
for
SSuite MonoBase Database
My Recommendation for
SSuite MonoBase Database
Add Video or Image
All
5
Pros
4
Specs
Top
Pro
•••
Create 2D or 3D charts for colorful and highly informative results of data tables
One click chart creation for any data results, even from SQL queries.
See More
Specs
Platforms:
Windows All
Technology:
Delphi
Custom Reports:
Yes
ODBC:
Yes
See All Specs
Top
Pro
•••
Great looking interface with easy access to all options and features
Connects to any database that is compatible with the ODBC engine found in all Windows operating systems.
See More
Top
Pro
•••
Installs and runs on any Windows system
Integrates very well with any Windows.
See More
Top
Pro
•••
It is completely free
See More
Hide
See All
FREE
Recommend
1
--
DbDesigner
My Rec
ommendation
for
DbDesigner
My Recommendation for
DbDesigner
All
7
Experiences
2
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
ThriftyBeag's Experience
Great
See More
Specs
Platforms:
Web
Top
Pro
•••
Reverse and forward engineering
Supports MySQL, PostgreSQL and Oracle reverse engineering. Support for MS SQL and SQLite is planned.
See More
RickZeeland's Experience
Online database designer supporting most popular databases. See this mini tutorial on freecodecamp https://medium.freecodecamp.org/how-to-create-database-schemas-quickly-and-intuitively-with-dbdesigner-2f4adf79a29d.
See More
Top
Pro
•••
Generic design
Can create a "generic" design for all supported databases.
See More
Hide
See All
Free / paid
Recommend
6
--
SchemaSpy
My Rec
ommendation
for
SchemaSpy
My Recommendation for
SchemaSpy
Add Video or Image
All
6
Pros
2
Cons
3
Specs
Top
Con
•••
Project may be dead or dying
The codebase on sourceforge hasn't seen an update since 2010.
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
Specs
Platforms:
Windows, Linux, Mac
Technology:
Java
Database management:
JDBC-compliant
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
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
Hide
See All
Get it
here
Recommend
5
1
--
ERBuilder
My Rec
ommendation
for
ERBuilder
My Recommendation for
ERBuilder
All
11
Experiences
2
Pros
8
Specs
Top
Pro
•••
Lightweight
Only 8 Mb install size.
See More
DashingJatasur's Experience
The best one 👍
See More
Specs
Platforms:
Windows
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
RickZeeland's Experience
ERBuilder Data Modeler is a Windows program for designing or modifying databases, it is free for students and non-profit organisations. Supported databases: Oracle, MS SQL Server, PostgreSQL, MySQL, SQLite and Firebird.
See More
Top
Pro
•••
Supports Amazon Redshift data modeling
See More
Top
Pro
•••
Crow's Foot notation
Supports Crow's Foot notation.
See More
Top
Pro
•••
Ease of use
See More
Top
Pro
•••
Supports many databases
See More
Top
Pro
•••
Generate HTML
Can generate a HTML user interface from a database (Enterprise edition).
See More
Top
Pro
•••
Not limited
The free version does not seem limited (for personal use).
See More
Hide
See All
Free / paid
Recommend
3
--
SchemaCrawler
My Rec
ommendation
for
SchemaCrawler
My Recommendation for
SchemaCrawler
Add Video or Image
All
6
Pros
4
Cons
1
Specs
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
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
Specs
Platforms:
Windows, Linux, Mac
Technology:
Java
Top
Pro
•••
Extensive and detailed documentation online
Including visuals of the results of command-line option usage.
See More
Top
Pro
•••
Free
See More
Top
Pro
•••
Web application
The SchemaCrawler Web Application can generate a database diagram of an SQLite database online.
See More
Hide
See All
Free
Recommend
2
--
Valentina Studio
My Rec
ommendation
for
Valentina Studio
My Recommendation for
Valentina Studio
Add Video or Image
All
1
Specs
Specs
Platforms:
Windows, Linux, Mac
Technology:
C++, QT
Hide
Free / paid
Recommend
6
--
databasediagram.com
My Rec
ommendation
for
databasediagram.com
My Recommendation for
databasediagram.com
Add Video or Image
All
1
Pros
1
Top
Pro
•••
Online tool, no signup is required
See More
Hide
FREE
Recommend
1
--
DbForge Studio for PostgreSQL
My Rec
ommendation
for
DbForge Studio for PostgreSQL
My Recommendation for
DbForge Studio for PostgreSQL
All
5
Pros
5
Top
Pro
•••
Query Profiler
Helpful diagrams of query execution, and also the list of operations that takes place on the server
See More
Top
Pro
•••
Advanced code completion features
Prompting the names of existing materialized views, as well as context prompting of database objects
See More
Top
Pro
•••
Object Explorer
Provides a quick navigation through the object tree
See More
Top
Pro
•••
File format support
Dozen of file formats are supported, including Google sheets.
See More
Top
Pro
•••
Data Editor
The table settings can be easily managed: adjustable column width, paginal or auto-search mode, coloring and formatting the rows/cells with a rich set of fonts and sizes.
See More
Hide
See All
Free / paid
Recommend
2
1
--
Database .NET
My Rec
ommendation
for
Database .NET
My Recommendation for
Database .NET
Add Video or Image
All
4
Experiences
1
Pros
2
Specs
Top
Pro
•••
Portable
See More
RickZeeland's Experience
Not only supports most popular databases, but also Excel. Advanced functionality however is only available in the paid version.
See More
Specs
Platforms:
Windows
Technology:
.NET
Top
Pro
•••
Multiple databases
Supported databases: SQL Server SQL Azure LocalDB MySQL Oracle IBM DB2 Informix PostgreSQL HP Vertica NuoDB Teradata Sybase ASE Firebird SQLite SQLCe Access Excel VistaDB dBase FoxPro OleDB ODBC OData Text NoSQL
See More
Hide
See All
Free / paid
Recommend
2
--
Model Xtractor
My Rec
ommendation
for
Model Xtractor
My Recommendation for
Model Xtractor
Add Video or Image
All
7
Experiences
1
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
RickZeeland's Experience
So far the best free database modeling tool I could find, can generate models or diagrams from scratch, ready for further customization. Supports several image formats for saving, and can also save as PDF.
See More
Specs
Platforms:
Windows
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
Hide
See All
Free
Recommend
1
--
Schemaball
My Rec
ommendation
for
Schemaball
My Recommendation for
Schemaball
Add Video or Image
All
3
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
See All
Get it
here
Recommend
--
Socrates
My Rec
ommendation
for
Socrates
My Recommendation for
Socrates
Add Video or Image
All
2
Pros
1
Cons
1
Top
Pro
•••
Parses an uploaded sql file to generate information about tables, fields and primary keys
(current 750K Max filesize)
See More
Top
Con
•••
Screenshots require a browser plugin
ones that support full-page screenshots (that go beyond the browser viewport when grabbing an image of the page), as this visualizer does not generate the images itself
See More
Hide
Free
Recommend
Don't see your favorite option? Add it.
--
dbForge Studio for MySQL
My Rec
ommendation
for
dbForge Studio for MySQL
My Recommendation for
dbForge Studio for MySQL
$0-249.95
Recommend
53
--
DbForge Studio for MySQL
My Rec
ommendation
for
DbForge Studio for MySQL
My Recommendation for
DbForge Studio for MySQL
FREE/PAID
Recommend
6
--
dbForge Studio for SQL Server
My Rec
ommendation
for
dbForge Studio for SQL Server
My Recommendation for
dbForge Studio for SQL Server
Paid
Recommend
23
See flagged products
Hide flagged products
I Recommend...
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
One sec!
Are you sure that you want to abandon your hard work?
Delete Work
Continue working
{}
undefined
url next
price drop