Database design tools

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

DTM Data Modeler

DTM Data Modeler is an easy-to-use tool allowing you to work both with logical and physical data models in the form of an entity-relationship diagram. The program can create database schema objects directly in the database and can create SQL scripts corresponding to the model taking into account the specified settings.

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

DB Designer Fork

DB Designer Fork is a fork of the fabFORCE DBDesigner 4 and a premium database design tool. It integrates entity relationship design, front-end, and SQL exporting.

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

Jeddict

Jeddict is an open source development platform that simplifies development tasks of creating complex entity relationship models. It provides forward & reverse engineering capabilities, import models from existing database, generate complex SQL/DDL, and much more.

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

DatabaseSpy

Altova DatabaseSpy is the unique multi-database query, design, and database comparison tool that even generates elegant charts directly from query results.

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

Database Deployment Manager

Database Deployment Manager (DDM) tool is a multi-platform tool that allows database administrators and users to create database structures (tables, queries, etc.) using an object-oriented methodology that can be used to populate multiple databases. It creates E-R diagrams between chosen tables, export these as graphics or SVG.

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

Database Designer for MySQL

Database Designer for MySQL is a powerful solution for visual database development: creation, modification, and reverse engineering.

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

Xcase

Xcase is a complete database design tool engineered to help you accomplish all your database-related tasks – from database design to modeling to daily modifications – with greater speed, higher quality, and better adherence to best practices.

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

AnySQL Maestro

AnySQL Maestro is the premier multi-purpose admin tool for database management, control and development.

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

SQL Maestro for MySQL

SQL Maestro for MySQL is the premier tool for MySQL and MariaDB database management, control, and development. It provides a rich set of GUI tools for anyone who uses MySQL and/or MariaDB. Its key features include support for all the MySQL server versions from 3.23, direct support for MariaDB-specific features, easy database object management, database designer, comfortable access to MySQL security features, data management and data analysis tools, many more.

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

RISE

RISE is a software suite for model driven information system development, packed with features and functions needed to build your information model and to turn it into a complete information management solution. You can generate your entire information solution including database, web services, and documentation.

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

Valentina Studio

Valentina Studio is a database management tool that helps to create, administer, query, and explore Valentina DB, MySQL, MariaDB, PostgreSQL, and SQLite databases for FREE.

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

ERDesigner NG

The Mogwai ERDesigner is an entity relationship modeling/design tool(ERD). It is open source tool designed to make database modeling easier and support the developer in the whole development process, from database design to schema and code generation.

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

DB-Main

DB-Main is an easy-to-use data modelling and data architecture platform. It is a generic CASE tool dedicated to database applications engineering, and in particular to database design, reverse engineering, re-engineering, integration, maintenance, and evolution.

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

ModelRight

ModelRight is a database design and data modeling tool. It is used by data modelers, database developers, and database architects to create, visualize, and document their databases as an Entity Relationship Diagram (ERD).

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

pgDesigner

pgDesigner is an open source program for graphic design database for PostgreSQL. It has an easy to use interface and comprises of different handy features to support database development, management, and reverse engineering in a graphical way.

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