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 for PostgreSQL
List of database ER diagram (ERD) / schema visualization / reverse engineering tools .
Jeddict
Jeddict is an open source development platform that simplifies development tasks of creating complex entity relationship models. It provides forward & reverse engineering capabilities, import models from existing database, generate complex SQL/DDL, and much more. Make it available again by importing the existing database and create new ER diagram.
| Commercial: | Free |
|---|---|
| Free edition: |
|
| Export: | Image,SQL script |
Xcase
Xcase sophisticated visual interface helps you quickly design an accurate database by capturing every detail of your customer’s business information world. It provides complete and accurate reverse and forward engineering capabilities that transform your existing database into presentation quality diagrams.
| Commercial: | Commercial |
|---|---|
| Free edition: |
|
| Export: | CSV |
AnySQL Maestro
AnySQL Maestro is the premier multi-purpose admin tool for database development and management which include editing, grouping, sorting and filtering abilities. It is a handy SQL Editor with code folding and multi-threading features.
| Commercial: | Commercial |
|---|---|
| Free edition: |
|
| Export: | CSV,HTML,Image,MS Excel,PDF,Plain text,RTF |
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 |
ERDesigner NG
Mogwai ERDesigner is an open source entity relationship modeling/design tool. It generates true 3D anaglyphic views from your database structure and has an integrated reverse engineering module for existing schemas.
| Commercial: | Free |
|---|---|
| Free edition: |
|
| Export: | HTML,Image,PDF,RTF,SVG |
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 |
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 |
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 |
