29 Database ER Diagram (ERD) Tools

This is the list of all database schema visualization / ERD reverse engineering tools for popular relational databases (Oracle, SQL Server, MySQL or PostgreSQL) we found on the web. If you found something else or see any inaccuracies, let us know and we'll fix it.

Share

Dataedo

dataedo.com

Supports: SQL Server, Oracle, MySQL, MariaDB, Azure SQL Database, Amazon Aurora

Notable features: Ability to add missing FKs to the diagram, multiple diagrams per database, ability to provide description for each model with rich text and pasted images, teamwork with repository

more...

Export: PDF, HTML, MS Excel

Type: Commercial

Free edition: no, Pricing from: $399

Last updated: 30 Nov -0001

dbForge Studio for SQL Server

www.devart.com/dbforge/sql/studio/database-diagram.html

bForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting and analysis.

Supports: SQL Server

more...

Export: Printer

Type: Commercial

Free edition: yes, Pricing from: $250

Last release: Sep 2016 (5.3.56)

Last updated: 30 Nov -0001

dbForge Studio for Oracle

www.devart.com/dbforge/sql/studio/database-diagram.html

dbForge Studio for Oracle is a powerful integrated development environment (IDE) which helps Oracle developers to increase PL/SQL coding speed, provides versatile data editing tools for managing in-database and external data.

Supports: Oracle

more...

Export: Printer

Type: Commercial

Free edition: yes, Pricing from: $150

Last release: Oct 2016 (3.9.22)

Last updated: 30 Nov -0001

dbForge Studio for MySQL

www.devart.com/dbforge/mysql/studio/database-designer.html

With dbForge Studio for MySQL you can visualize your database structure and get the simplest way to create, analyze, reverse-engineer, print, customize, and do any database development tasks.

Supports: MySQL

more...

Export: Printer

Type: Commercial

Free edition: yes, Pricing from: $120

Last release: Nov 2016 (7.02.1934)

Last updated: 30 Nov -0001

Toad Data Modeler

www.casestudio.com

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

Supports: SQL Server, Oracle, MySQL, PostgreSQL, Access, DB2, Teradata, SAP ASE, SAP SQL Anywhere, SAP IQ, SQLite

more...

Export: HTML/RTF/PDF

Type: Commercial

Free edition: yes, Pricing from: $700

Last updated: 30 Nov -0001

DbSchema

www.dbschema.com/

DbSchema is diagram designer and query tool.

Supports: SQL Server, Oracle, MySQL, Amazon Redshift, Cache, Cassandra, DaffodilDB, DB2, Apache Derby, JavaDB, Exasol, Firebird, Filemaker, FoxPro, FrontBase, HBase, H2, Hive, HyperSQL, Informix, Ingres, JDataStore, MariaDb, MongoDb, Access, Micro

Notable features: relational data browse, schema compare and synchronization, query builder, query editor, random data generator, saves schema in XML

more...

Export: PDF, HTML

Type: Commercial

Free edition: yes, Pricing from: $127

Last updated: 30 Nov -0001

Sequel Pro + GraphViz

www.sequelpro.com/

Easy-to-use Mac database management application for MySQL

Supports: MySQL

more...

Type: Free

Free edition: yes

Last release: Apr 2016 (1.1.2)

Last updated: 30 Nov -0001

Enterprise Architect

www.sparxsystems.com.au/products/ea/index.html

Enterprise Architect is a visual modeling and design tool based on the OMG UML.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, Access, Firebird, DB2

more...

Export: .bmp, .jpg, .png, .gif, .emf, and, .wmf

Type: Commercial

Free edition: yes, Pricing from: $199

Last release: Nov 2016 (Version 13, Build 1308)

Last updated: 30 Nov -0001

Oracle SQL Developer Data Modeler

www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html

Oracle SQL Developer Data Modeler is a free graphical tool that enhances productivity and simplifies data modeling tasks.

Supports: Oracle, SQL Server, DB2

more...

Export: PDF, PNG, JPG, SVG

Type: Free

Free edition: yes

Last release: Sep 2016 (4.1.5.907)

Last updated: 30 Nov -0001

SAP Sybase PowerDesigner

powerdesigner.de/

PowerDesigner is the industry-leading business process / data modeling software and metadata management solution for data architecture, information architecture and enterprise architecture.

Supports: Access, Greenplum, Hadoop + Hive, HP Neoview, DB2, Informix, Ingres, Interbase, MySQL, Netezza, NonStop SQL, Oracle, PostgreSQL, Red Brick, SAP business Suite, SAP HANA, SAP ASE, SAP IQ, SAP SQL Anywhere, SQL Server

more...

Export: MetaFile (.emf), Bitmap, JPEG, PNG, GIF, TIF, SVG, rtf, html

Type: Commercial

Free edition: yes, Pricing from: $2,700

Last release: Jan 2013 (16.5)

Last updated: 30 Nov -0001

DbWrench

www.dbwrench.com/

Database design and synchronization tool

Supports: SQL Server, Oracle, MySQL, PostgreSQL

more...

Type: Commercial

Free edition: yes, Pricing from: $99

Last release: Nov 2016 (4.0)

Last updated: 30 Nov -0001

Lucidchart

www.lucidchart.com

Online diagram application makes it easy to sketch and share professional flowchart diagrams.

Supports: SQL Server, Oracle, MySQL, PostgreSQL

Notable features: Web application

more...

Export: PDF, PNG, JPEG, VDX

Type: Commercial

Free edition: yes, Pricing from: $4

Last updated: 30 Nov -0001

SchemaScrawler

sualeh.github.io/SchemaCrawler/

SchemaCrawler is a free database schema discovery and comprehension tool.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, SQLite, Sybase, DB2, MariaDB

more...

Export: plain text, CSV, HTML5, JSON

Type: Free

Free edition: yes, Pricing from: $0

Last release: Jan 2017 (14.14.01)

Last updated: 30 Nov -0001

SQuirreL

squirrel-sql.sourceforge.net/

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, Sybase, DB2, Interbase, InstantDB, Access, SAP DB, Vertica, ThinkSQL, Teradata, OpenEdge, Pointbase, Netezza, Mimer SQL, Mckoi SQL, Ingres, DB2, H2, HyperSQL, FrontBase

more...

Export: JPEG

Type: Free

Free edition: yes, Pricing from: $0

Last updated: 30 Nov -0001

DB Designer Fork

sourceforge.net/projects/dbdesigner-fork/

DB Designer Fork is a fork of the fabFORCE DBDesigner 4. It integrates entity relationship design,front-end (you can run queries) and SQL exporting

Supports: SQL Server, Oracle, MySQL, Firebird, SQLite, PostgreSQL

more...

Export: DDL script

Type: Free

Free edition: yes, Pricing from: $0

Last updated: 30 Nov -0001

Database Designer for MySQL

www.microolap.com/products/database/mysql-designer

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

Supports: MySQL

more...

Export: PNG, JPEG, GIF, BMP, EMF, SQL script

Type: Commercial

Free edition: yes, Pricing from: $125

Last release: Apr 2016 (2.1.7.1051)

Last updated: 30 Nov -0001

DatabaseSpy

www.altova.com/databasespy.html

The Altova DatabaseSpy® 2017 graphical database Design Editor lets you view and edit the structures of all your databases through one graphical user interface.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, SAP ASE, Firebird, DB2, Informix, Access, Azure SQL Database, OpenEdge, SQLite

more...

Export: PNG, BMP, GIF, JPG, SQL script

Type: Commercial

Free edition: yes, Pricing from: $107

Last release: Oct 2016

Last updated: 30 Nov -0001

Database Deployment Manager

ddmproject.weebly.com/

Database Deployment Manager (DDM) tool is a multi-platform tool that allows database administrators and users to create database structures (tables, queries, etc...) using object oriented methodology which can be used to populate multiple databases.

Supports: MySql, SQLite, CUBRID

more...

Type: Free

Last updated: 30 Nov -0001

ModelSphere

www.modelsphere.com/org/open_modelsphere.html

Open ModelSphere is a powerful data, process and UML modeling tool - supporting user interfaces in English and French.

Supports: SQL Server, Oracle, MySQL, Access, Informix, Ingres, HyperSQL, PostgreSQL, DB2

more...

Type: Free

Free edition: yes, Pricing from: $0

Last release: Jan 2016 (3.2.2)

Last updated: 30 Nov -0001

Adminer

iner.org

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, SQLite, Firebird, SimpleDB, ElasticSearch, MongoDB

more...

Export: SQL script

Type: Free

Free edition: yes, Pricing from: $0

Last release: Jun 2016 (4.2.5)

Last updated: 30 Nov -0001

Schema Surf

external.informer.com/atlantis-interactive.co.uk/products%2Fschemasurf%2Fdefault.aspx

Atlantis Schema Surf is our SQL dependency & live entity ER diagram tool - it is an animated graphing tool which allows you to easily visualize the dependencies between the objects in your SQL Server databases in a live entity ER diagram.

Supports: SQL Server

more...

Export: BMP, JPG, PNG

Type: Commercial

Free edition: yes

Last release: Jan 2017 (2017.1.3)

Last updated: 30 Nov -0001

DBeaver

dbeaver.jkiss.org/

Free multi-platform database tool for developers, SQL programmers, database administrators and analysts.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, SQLite, DB2, Sybase, Teradata, MongoDB, Cassandra, Redis

more...

Export: GIF, PNG, BMP, GraphML

Type: Free

Free edition: yes, Pricing from: $0

Last release: Jan 2017 (3.8.5)

Last updated: 30 Nov -0001

SQL Database Studiio

atabasestudio.com

SQL Database Studio automates repetitive tasks such as filtering, sorting, searching and much more.

Supports: SQL Server

more...

Export: PNG

Type: Commercial

Free edition: yes, Pricing from: $215

Last release: Dec 2016 (3.6.0)

Last updated: 30 Nov -0001

ConceptDraw PRO

www.conceptdraw.com/

The main tool of domain modeling at the stage of conceptual design is the Entity-relationship model, also called ER-model.

Supports: SQL Server, Oracle, MySQL, InterBase, Access, Firebird

more...

Export: graphics files and PDF

Type: Commercial

Free edition: yes, Pricing from: $199

Last updated: 30 Nov -0001

Dico

www.guh-software.de/dico_en.html

Dico is a Java application to display database-schema.

Supports: SQL Server, Oracle, MySQL, PostgreSQL

more...

Export: PDF, EMF, SVG, printer

Type: Commercial

Free edition: yes, Pricing from: $41

Last updated: 30 Nov -0001

RISE Editor

www.risetobloome.com/Page_1_S.aspx?ITEM=1853

RISE is a software suite for model driven information system development.

Supports: SQL Server, MySQL, PostgreSQL

more...

Type: Commercial

Free edition: yes, Pricing from: $0

Last updated: 30 Nov -0001

DataGrip

www.jetbrains.com/datagrip/

DataGrip is database IDE that is tailored to suit specific needs of professional SQL developers.

Supports: SQL Server, Oracle, MySQL, PostgreSQL, Sybase, DB2, SQLite, HyperSQL, Apache Derby, H2

more...

Export: image files

Type: Commercial

Free edition: yes, Pricing from: $248

Last release: Nov 2016 (2016.3.3)

Last updated: 30 Nov -0001

Oracle JDeveloper

www.oracle.com/technetwork/developer-tools/jdev/overview/index.html

Oracle JDeveloper is a free integrated development environment that simplifies the development of Java-based applications addressing every step of the application lifecycle.

Supports: Oracle

more...

Type: Free

Free edition: yes, Pricing from: $0

Last updated: 30 Nov -0001

Valentina Studio

www.valentina-db.com/

Valentina Studio is your universal database management tool.

Supports: SQL Server, MySQL, MariaDB, PostgreSQL, SQLite , Valentina DB

more...

Type: Commercial

Free edition: yes, Pricing from: $200

Last updated: 30 Nov -0001

Last research made on 16 September 2016

Share