20 Diagram / Reverse Engineering tools for PostgreSQL

This is the list of all database schema visualization / ERD reverse engineering tools for 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, PostgreSQL, DB2, Azure SQL Database, Amazon Aurora, PostgreSQL, Amazon Redshift, Snowflake

Notable features: Ability to add missing FKs to the diagram, ability to provide description for each model with rich text and images, global repository, interactive HTML export

more...

Export: PDF, HTML, MS Excel

Type: Commercial

Free edition: no, Pricing from: $999

Last updated: 07 Dec 2018

Navicat Data Modeler

www.navicat.com/en/products/navicat-data-modeler

Navicat Data Modeler is a database design tool which helps you build conceptual, logical and physical data models. It allows you to visually design database structures, perform reverse/forward engineering processes, import models from ODBC data sources, generate complex SQL/DDL, print models to files.

Supports: MySQL, MariaDB, Oracle, SQL Server, PostgreSQL and SQLite

more...

Export: PDF, PNG, JPG

Type: Commercial

Last updated: 05 Mar 2018

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

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

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, SAP ASE, 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: 16 Jan 2018

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 ASE, 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: 16 Jan 2018

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

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

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

www.adminer.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: 23 Aug 2018

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, SAP ASE, 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: 16 Jan 2018

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, SAP ASE, 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: 16 Jan 2018

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

Database Designer for PostgreSQL

microolap.com/products/database/postgresql-designer/

Database structure modeling, generation and modification focused on PostgreSQL

Supports: PostgreSQL

more...

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

Type: Commercial

Free edition: yes, Pricing from: $124

Last release: Nov -0001

Last updated: 06 Nov 2017

ER/One Data Modeler

soft-builder.com

Free data modeling tool for popular SQL databases.

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

more...

Type: Free

Free edition: yes

Last updated: 25 Jul 2018

Share