Database design tools

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

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 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: Yes
Free edition: Yes
ER Diagram: Yes

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: 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

ERDPlus

ERDPlus is a web-based database modeling tool for creating entity relationship diagrams, relational schemas, star schemas, and SQL DDL statements. It automatically converts ER diagrams into relational schemas and works with most contemporary RDBMS tools.

Desktop/Cloud: Cloud
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

TablePlus

TablePlus is a native tool with an intuitive interface that you can use to create, query, edit, and save your databases in a very fast and secure way.

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

Navicat Data Modeler

Navicat Data Modeler is a powerful and cost-effective database design tool that helps to build high-quality conceptual, logical, and physical data models. It allows to visually design database structures, perform reverse/forward engineering processes, import models from ODBC data sources, generate complex SQL/DDL, print models to files, and much more.

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

HeidiSQL

HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases and PostgreSQL. It enables you to browse and edit data, create and edit tables, views, procedures, triggers, and scheduled events.

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

Toad Data Modeler

Toad Data Modeler enables developers, DBAs, and designers to create, maintain, and document quality database designs and structures across various database platforms.

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

DbVisualizer

DbVisualizer is the universal database tool for developers, DBAs, and analysts. It is aimed to simplify database development and management. It provides tree-based navigation through database objects and let multiple objects to be displayed side-by-side.

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

RazorSQL

RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool. It provides visual tools to create, alter, describe, execute, and drop database objects such as tables, views, indexes, stored procedures, functions, triggers, and more.

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

DBDesigner 4

DBDesigner 4 is a visual database design system that integrates database design, modeling, creation, maintenance, and documentation into a single, seamless environment.

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

dbDiffo

dbDiffo is a free online database schema designer and provides unlimited tables and projects creation services.

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