SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Database design tools
List of tools that allow for the design of a database.
SqlDBM
SqlDBM offers an easy, convenient way to design a database absolutely anywhere on any browser, working away without need for any extra database engine or database modelling tools or apps.
| Desktop/Cloud: | Cloud |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
Aqua Data Studio Entity Relationship Modeler
Aqua Data Studio Entity Relationship Modeler (ER Modeler) helps in designing database models and uses the Forward Engineer feature to model entities and convert them into SQL Scripts, or Reverse Engineer existing databases to visualize a database model.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
Visual Paradigm
Visual Paradigm provides a tool to create and communicate visual database design with professional ERD tool.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
Vertabelo
Vertabelo is a database modeler that gives you the power of visual design of databases online. It allows the user to generate metadata of the database and write comments for the database objects.
| Desktop/Cloud: | Cloud |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
Lucidchart
Lucidchart is a quicker tool to design and maintain a properly functioning database. It makes it easy to organize database tables, including keys, fields and relationships.
| Desktop/Cloud: | Cloud |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
DeZign for Databases
DeZign for Databases uses ERD and data models to graphically design databases and automatically generates the most popular databases.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
DbWrench
DbWrench helps in creating and modifying databases quicker and easier. It streamlines many common database tasks and supports many operating systems and databases in a single license.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
DbDesigner.net
DbDesigner with a friendly and fast UI helps in designing a database without writing SQL. You can start from scratch just like creating a UML diagram or import an existing database. Then you can use our powerful features to save time and reduce errors. You can share and collaborate with your team. When you are finished, you can generate an SQL script in one click.
| Desktop/Cloud: | Cloud |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
dbdiagram.io
dbdiagram.io is a free, simple tool to draw ER diagrams by just writing code. It is designed for developers and data analysts.
| Desktop/Cloud: | Cloud |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
QuickDBD
Quick Database Diagrams (QuickDBD) is a simple online tool to quickly draw database diagrams by typing.
| Desktop/Cloud: | Cloud |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
DbSchema
DbSchema is a intuitive designer for complex databases, visual interaction and documentation.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
Moon Modeler
Moon Modeler is a visual database design tool for both relational and noSQL databases. The key features include the visual design of hierarchical structures, MongoDB script generation, various display modes, possibility to add custom notes to the diagram, and more. For PostgreSQL, MariaDB and MongoDB reverse engineering features are available.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
DBeaver
DBeaver is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
SQLGate
SQLGate is an integrated database management and development solution that simplifies the construction and operation of databases. It makes it easier and quicker to deal with databases holding large amounts of data.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
Model Xtractor
Model Xtractor is a software utility designed to inspect modeling for traditional or enhanced ER models, with support for most relational database platforms.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: |
|
| Free edition: |
|
| ER Diagram: |
|
