SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Database diagram / Reverse Engineering tools
List of database ER diagram (ERD) / schema visualization / reverse engineering tools .
DB-Main (discontinued)
DB-Main is an easy-to-use data modelling and data architecture platform. The software helps developers and analysts in most of their daily tasks and covers all data engineering processes by simplifying activities, such as design processes, transformations, reverse engineering, and management.
| Commercial: | Commercial |
|---|---|
| Free edition: |
|
| Export: | - |
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).
| Commercial: | Commercial |
|---|---|
| Free edition: |
|
| Export: | Image,MS Excel,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 |
Astah
Astah's modeling tools allow you to quickly and effortlessly build diagrams that create a clear understanding among teams. By installing the reverse engineering plug-in, you can import an existing database into a visual ER diagram.
| Commercial: | Commercial |
|---|---|
| Free edition: |
|
| Export: | CSV,HTML,Image,MS Excel,RTF |
Software Ideas Modeler
Software Ideas Modeler is a lightweight and powerful CASE tool. It helps to create different diagrams, such as UML diagrams and ERDs. ERDs can be exported to SQL to create the database. It also provides database reverse engineering support. Select the database tables or source code files and it will turn the data to the more readable form – diagrams.
| Commercial: | Commercial |
|---|---|
| Free edition: |
|
| Export: | Image,PDF,SVG |
SQL Power Architect
SQL Power Architect data modeling tool has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases and auto-generate ETL metadata.
| Commercial: | Commercial |
|---|---|
| Free edition: |
|
| Export: |
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 |
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 |
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 |
MagicDraw
MagicDraw is the award-winning business process, architecture, software and system modeling tool with teamwork support. It includes entity-relationship diagram, SQL database modeling/diagramming and DDL script generation/reverse features.
| Commercial: | Commercial |
|---|---|
| Free edition: |
|
| Export: | CSV,HTML,MS Excel,PDF |
IBM InfoSphere Data Architect
IBM® InfoSphere® Data Architect is a collaborative enterprise data modeling and design solution. It enables to create a physical data model using reverse engineering feature.
| Commercial: | Commercial |
|---|---|
| Free edition: |
|
| Export: | - |
dbConstructor
dbConstructor is a database design tool that speeds up and eases the database creation and maintenance process by means of an extremely user-friendly interface. It also lets you do reverse engineering, change management, schema verification, and many more.
| Commercial: | Commercial |
|---|---|
| Free edition: |
|
| Export: | Image,SQL script |
Innovator for Information Architects
Innovator for Information Architects provides a data modeling technique based on the entity relationship model (ERM). You can use the import wizard to add the right tables from your database into your Innovator model in a few easy steps.
| Commercial: | Commercial |
|---|---|
| Free edition: |
|
| Export: | SQL script |
Modelio
Modelio SQL Designer Module provides strong support for database modeling, from logical UML class models to relational databases. It provides reverse engineering from SQL code to SQL table diagrams.
| Commercial: | Commercial |
|---|---|
| Free edition: |
|
| Export: | - |
SQL Manager
SQL Manager in a simple and direct way provides reverse engineering operation by building a relationship diagram on the basis of the current database's structure. The objects are arranged automatically within the diagram model.
| Commercial: | Commercial |
|---|---|
| Free edition: |
|
| Export: | HTML,Image,MS Excel,PDF,RTF |
