Database design tools

List of tools that allow for the design of a database.

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

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

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

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

ER/Studio

ER/Studio Data Architect helps to easily reverse- and forward-engineer, compare and merge, and visually document data assets across multiple platforms and data sources. It enables data professionals to better manage data models and metadata in complex and dynamic enterprise environments.

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

RazorSQL

RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris.

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

Hackolade

Hackolade is a tool for Agile visual data modeling for JSON and NoSQL databases. It provides graphic visualization of complex data structures using Entity-Relationship diagrams to represent denormalized data in a user-friendly way.

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