This is the list of all database modeling and design 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.
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
Notable features: Model synchronization, generation of HTML, RTF and PDF reports, generation of alter (change) scripts
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
Simple web-based data modeling tool with very interesting text based designer.
Supports: MySQL, MariaDB, Oracle, PostgreSQL, SQL Server
Notable features: Very useful text editor
Database design and modeling tool
Supports: SQL Server, Oracle, MySQL, PostgreSQL, DB2, Access, SQLite3, SAP ASE, Firebird, Interbase, NexusDB, SAP SQL Anywhere
Notable features: Forward engineering (generates complete DDL scripts), subdiagrams (subviews), compare and merge models utility, model (model-to-database and database-to-model)
Database Workbench offers a single development environment for developing with multiple database engines.
Supports: SQL Server, Oracle, MySQL, MariaDB, PostgreSQL, SAP SQL Anywhere, InterBase, Firebird, NexusDB
Data Modeling for Multi-Platform Environments
Supports: SQL Server, Oracle, MySQL, PostgreSQL, DB2, SAP ASE, MongoDB, Hadoop + Hive, Firebird, Hadoop, Hive, Access, SAP ASE, SAP IQ, Teradata
Database design and synchronization tool
Supports: SQL Server, Oracle, MySQL, PostgreSQL
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
Jeddict is an open source graphical tool that enhances productivity and simplifies development tasks of creating complex entity relationship models.
Supports: SQL Server, Oracle, MySQL, SAP ASE, PostgreSQL, Access, H2, Apache Derby
Notable features: Plugin to Netbeans
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, IBM DB2, Informix, Access, Azure SQL Database, OpenEdge, SQLite
DbDesigner is a web application which allows you to design your database schema without writing SQL.
Supports: SQL Server, Oracle, MySQL, PostgreSQL, SQLite
Notable features: Online designer
Xcase is a complete database design tool engineered to help you accomplish all your database-related tasks – from database design to modeling to daily modifications – with greater speed, higher quality, and better adherence to best practices.
Supports: SQL Server, Oracle, MySQL, PostgreSQL, SAP ASE, DB2, Firebird, Interbase, Informix, FoxPro, VFP, MaxDB, SAP SQL Anywhere
Notable features: Converting database
The Aqua Data Studio Entity Relationship Modeler (ER Modeler) helps you design complex database models for all major RDBMS vendors and versions.
Supports: SQL Server, Oracle, MySQL, Amazon Redshift, Apache Cassandra, Apache Derby, Apache Hive, Apache Spark, DB2, Excel, JDBC, ODBC, Google BigQuery, Greenplum, Informix, MongoDB, Netezza, ParAccel, PostgreSQL, SAP HANA
MagicDraw is the award-winning business process, architecture, software and system modeling tool with teamwork support.
Supports: SQL Server, Oracle, MySQL, PostgreSQL, DB2, Standard SQL, PointBase, SAP ASE, Pervasive, Cloudscape, Access
Anchor Modeling is an Open Source database modeling technique built on the premise that the environment surrounding a data warehouse is in constant change.
Supports: SQL Server, Oracle, PostgreSQL, Vertica
Notable features: online
RISE is a software suite for model driven information system development.
Supports: SQL Server, MySQL, PostgreSQL
The Mogwai ERDesigner is an entity relationship modeling/design tool(ERD) such as ERWin and co.
Supports: SQL Server, Oracle, MySQL, PostgreSQL, H2, HyperSQL
Valentina Studio is your universal database management tool.
Supports: SQL Server, MySQL, MariaDB, PostgreSQL, SQLite, Valentina DB
ER/One Data Modeler allows developers to graphically design databases by using physical models and entity relationship diagrams to automatically generate the most popular SQL databases.
Supports: SQL Server, PostgreSQL, MySQL, Oracle, Interbase, Firebird