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: | Yes |
| Free edition: | Yes |
| ER Diagram: | Yes |
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: | Yes |
| Free edition: | No |
| ER Diagram: | Yes |
Visual Paradigm
Visual Paradigm provides a tool to create and communicate visual database design with professional ERD tool.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | Yes |
| Free edition: | No |
| ER Diagram: | Yes |
Vertabelo
Vertabelo gives the user the power of visual design of database online. It provides perfect UI to create database quickly and easily manage tables, views, references, etc.
| Desktop/Cloud: | Cloud |
|---|---|
| Generate DDL scripts: | Yes |
| Free edition: | No |
| ER Diagram: | Yes |
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: | Yes |
| Free edition: | Yes |
| ER Diagram: | Yes |
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: | Yes |
| Free edition: | No |
| ER Diagram: | Yes |
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: | Yes |
| Free edition: | Yes |
| ER Diagram: | Yes |
DbDesigner.net
DbDesigner with a friendly and fast UI helps in designing database without writing SQL.
| Desktop/Cloud: | Cloud |
|---|---|
| Generate DDL scripts: | Yes |
| Free edition: | Yes |
| ER Diagram: | Yes |
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: | Yes |
| Free edition: | Yes |
| ER Diagram: | Yes |
QuickDBD
Quick Database Diagrams (QuickDBD) is a simple online tool to quickly draw database diagrams by typing.
| Desktop/Cloud: | Cloud |
|---|---|
| Generate DDL scripts: | Yes |
| Free edition: | Yes |
| ER Diagram: | Yes |
DBeaver
DBeaver is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | Yes |
| Free edition: | Yes |
| ER Diagram: | Yes |
SQLGate
SQLGate is an integrated database management and development solution that simplifies construction and operation of databases. It makes easier and quicker to deal with databases holding large amounts of data.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | Yes |
| Free edition: | Yes |
| ER Diagram: | Yes |
Model Xtractor
Model Xtractor is a software utility designed to inspect modeling for tradition or enhanced ER models, with support for most relational database platforms.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | Yes |
| Free edition: | Yes |
| ER Diagram: | Yes |
ERBuilder Data Modeler
ERBuilder Data Modeler allows developers to graphically design databases by using entity relationship diagrams, and automatically generates the most popular SQL databases.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | Yes |
| Free edition: | Yes |
| ER Diagram: | Yes |
Adminer
Adminer is a tool for managing contents of MySQL databases, formerly known as phpMinAdmin. It is a full-featured database management tool written in PHP.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | Yes |
| Free edition: | Yes |
| ER Diagram: | Yes |
