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: | |
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: | |
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: | |
Export: | MS Excel,Plain text |
Apricot DB
Allows to perform the Reverse Engineering of all supported databases
Commercial: | Free |
---|---|
Free edition: | |
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: | |
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: | |
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: | |
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: | |
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: | |
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: | |
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: | |
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: | |
Export: | - |
Adminer
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP.
Commercial: | Free |
---|---|
Free edition: | |
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: | |
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: | |
Export: | Image,PDF,SVG |