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.
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 |
DB Browser for SQLite
DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | Yes |
| Free edition: | Yes |
| ER Diagram: | No |
ERDPlus
ERDPlus is a database modeling tool for creating Entity Relationship Diagrams, Relational Schemas, Star Schemas, and SQL DDL statements.
| 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 which 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 for database administrators and developers.
| 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 for Windows, macOS, Mac OS X, Linux, and Solaris.
| 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 and maintenance into a single, seamless environment.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | No |
| Free edition: | Yes |
| ER Diagram: | Yes |
