Database diagram / Reverse Engineering tools

List of database ER diagram (ERD) / schema visualization / reverse engineering tools .

SchemaSpy

SchemaSpy is a Java-based free and open source tool that generates interactive entity-relationship diagrams to HTML from database schema metadata analysis.

Commercial: Free
Free edition: Yes
Export: HTML

SchemaCrawler

SchemaCrawler is a free database schema discovery and comprehension tool. It has grep functionality that allows you to search for table and column names using regular expressions.

Commercial: Free
Free edition: Yes
Export: CSV,HTML,JSON,Plain text

Linkifier

Linkifier is a Java-based tool for sniffing of primary and foreign key constraints, even if they are not explicitly defined in the database. The identified constraints can be visualized with ER-diagram or exported as SQL alter queries.

Commercial: Free
Free edition: Yes
Export: MS Excel,Plain text

Apricot DB

Allows to perform the Reverse Engineering of all supported databases

Commercial: Free
Free edition: Yes
Export: MS Excel,PDF,PNG

ERD Concepts

ERD Concepts is an ERD tool combining professional diagramming with a light and pleasant user-interface. With ERD Concepts you can connect to almost any available database on the market today using ODBC and ADO connections. Using the advanced reverse engineering software you can create a new ERD diagram from an existing database.

Commercial: Free
Free edition: Yes
Export: HTML,Printer

pgDesigner

pgDesigner is an open source data model designer 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.

Commercial: Free
Free edition: Yes
Export: CSV,HTML,MS Excel,PDF,Plain text

dbDiffo

dbDiffo is a free online database schema designer and provides unlimited tables and projects creation services along with reverse engineering of databases.

Commercial: Free
Free edition: Yes
Export: SQL script

dbdiagram.io

dbdiagram.io is a free, quick and simple database designer to help you draw your database diagrams using their own Domain-specific language (DSL). It allows you to save and share your diagrams online.

Commercial: Free
Free edition: Yes
Export: Image,PDF

SQL Schema Explorer (discontinued)

SQL Schema Explorer is a open source tool that creates a dynamic website visible only to you that gives you effortless access to the tables, relationships, and data in your database.

Commercial: Free
Free edition: Yes
Export: HTML

WWW SQL Designer

WWW SQL Designer allows you to draw and create database schemas (ER diagrams) directly in the browser, without the need for any external programs. It also has the ability to import existing database design.

Commercial: Free
Free edition: Yes
Export: SQL script

SQuirreL SQL

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.

Commercial: Free
Free edition: Yes
Export: CSV,Image,Printer

Sequel Pro

Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases.

Commercial: Free
Free edition: Yes
Export: -

Adminer

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

Commercial: Free
Free edition: Yes
Export: SQL script

pgModeler

pgModeler is an open source tool for modeling databases that merges the classical concepts of entity-relationship diagrams with specific features that only PostgreSQL implements. With the column propagation mechanism, pgModeler creates automatically all columns and constraints as the user links tables using the available relationship objects.

Commercial: Free
Free edition: Yes
Export: Image,SQL script,SVG

Oracle SQL Developer Data Modeler

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

Commercial: Free
Free edition: Yes
Export: Image,PDF,SVG