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

dModelAid

dModelAid is the perfect modeling tool for documenting a complex database design in a simple, interactive diagram. It offers smart visualization features to help you design the database structure and to identify potential errors before any code has been written. Your database project gets documented along the way, simplifying the learning process for new employees, team members and/or substitutes.

Desktop/Cloud: Cloud
Generate DDL scripts: Yes
Free edition: No
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

erwin Data Modeler

erwin Data Modeler helps to create & maintain sound relational database designs.

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

MySQL Workbench

MySQL Workbench enables a DBA, developer, or data architect to visually design, model, generate, and manage databases. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering.

Desktop/Cloud: Desktop
Generate DDL scripts: Yes
Free edition: No
ER Diagram: Yes

DbSchema

DbSchema is a intuitive designer for complex databases, visual interaction and documentation.

Desktop/Cloud: Desktop
Generate DDL scripts: Yes
Free edition: No
ER Diagram: Yes

Moon Modeler

Moon modeler is a visual database designer tool for MongoDB. The key features include the visual design of hierarchical structurs, MongoDB script generation, various display modes, possibility to add custom notes to diagram and more.

Desktop/Cloud: Desktop
Generate DDL scripts: Yes
Free edition: No
ER Diagram: Yes