Design Tools

From PostgreSQL wiki

Jump to: navigation, search

Tools to help with designing a schema, via creating [Entity-Relationship diagrams] and similar.

Contents

Windows

Commercial

Aqua Data Studio

http://www.aquafold.com/aquadatastudio/er_modeler.html

The Aqua Data Studio Entity Relationship Modeler (ER Modeler) helps you design complex database models for all major RDBMS vendors and versions. Use the Forward Engineer feature to model entities and convert them into SQL Scripts, or Reverse Engineer existing databases to visualize a database model.

DeZign

http://www.datanamic.com/dezign/index.html

Aan intuitive database design and modeling tool for developers and DBA's that can help you model, create and maintain databases. The software uses entity relationship diagrams (ERDs, data models) to graphically design databases and automatically generates the most popular SQL and desktop databases.

PostgreSQL Maestro

https://www.sqlmaestro.com/products/postgresql/maestro/

Toad Data Modeller

https://www.quest.com/products/toad-data-modeler/

Toad Data Modeler enables you to rapidly deploy accurate changes to data structures across more than 20 different platforms. It allows you to construct logical and physical data models, compare and synchronize models, quickly generate complex SQL/DDL, create and modify scripts, as well as reverse and forward engineer both databases and data warehouse systems.

May have free versions? Website is a bit of a wreck.

EMS SQL Manager

https://www.sqlmanager.net/en/products/postgresql/manager


Obsolete or End-of-Life

DB Designer Fork

https://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.DB Designer Fork generates SQL scripts for Oracle, SQL Server, MySQL, FireBird, SQLite and PostgreSQL.

ModelRight

http://www.modelright.com

ModelRight allows you to graphically view your database, enforce complex constraints, manage database views, validate design decisions, and generate complete CREATE and ALTER scripts.

Docs mention support for Windows 7 and PostgreSQL 9.0.

Linux

Open Source / Free Software / Zero Cost

pgdesigner

http://pgdesigner.sourceforge.net/en/index.html

Cross-Platform

Open Source / Free Software / Zero Cost

pgModeler

https://github.com/pgmodeler https://www.pgmodeler.com.br

Windows / Linux / macOS

This is open source (GPLv3) and can be freely built yourself, if you have Qt available, but downloadable binaries appear to be time-limited demos that can be unlocked with paypal (?).

Open System Architect

http://www.codebydesign.com

Windows / macOS / Linux / Solaris

OSA currently supports data modelling (physical and logical) with UML in the works.

SQL Power Architect

http://software.sqlpower.ca/page/architect

Java

The SQL Power Architect data modeling tool was created by data warehouse designers and 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.

Valentina Studio

https://www.valentina-db.com/en/valentina-studio-overview

Windows / macOS / Linux

Free version supports reverse-engineering an existing schema, but only the commercial version supports forward-engineering.

Open ModelSphere

http://www.modelsphere.com/org/

Java

Open ModelSphere is a powerful data, process and UML modeling tool - supporting user interfaces in English and French.

Umbrello

https://umbrello.kde.org

Windows / macOS / Linux

Umbrello UML Modeller is a Unified Modelling Language (UML) diagram program based on KDE Technology.

UML allows you to create diagrams of software and other systems in a standard format to document or design the structure of your programs.

ERDesignerNG

http://mogwai.sourceforge.net/erdesignerng.html

Java, GPL

Commercial

DbSchema

http://www.dbschema.com

Windows / macOS / Linux / Java

Features interactive diagrams, relational data browse, schema compare and synchronization, query builder, query editor, HTML5 documentation, random data generator, forms and reports.

DbVisualizer

http://www.dbvis.com

Windows / macOS / Linux / Java

A client that does a lot of things other than schema design. It has a free version that provides many of the features, but not apparently design and DDL export.

DbWrench

http://www.dbwrench.com

Windows / macOS / Linux / Java

Diagramming / Forward & Reverse Engineering

StarUML

http://staruml.io

Windows / macOS / Ubuntu

https://github.com/adrianandrei-ca/staruml-postgresql - extension to support PostgreSQL

(This is version 2. The much older, open source version 1 is available at http://staruml.sourceforge.net/v1/download.php)

Vertabelo

http://www.vertabelo.com

Purely web-based, a monthly fee per user.

Navicat

https://www.navicat.com/en/products/navicat-for-postgresql

Windows, macOS, iOS

A general purpose client with good modeling features.

Obsolete or End-of-Life

Druid 3

https://sourceforge.net/projects/druid/

Java

The druid is a tools that allows users to create databases in a graphical way. The user can add tables, fields, folders to group tables and can modify most of the database options that follow the SQL-92 standard. In addition to sql options, the user can document each table and each field with HTML information.

Commandline Tools

Tools that take a description of a database schema in one format and convert it to SQL, and sometimes vice-versa.

dbmstools

https://github.com/charlesnagy/xml2ddl

Python, uses XML as the one true format and generates migration scripts from that.

SQLFairy

http://sqlfairy.sourceforge.net

Perl, manipulate structured data definitions (mostly database schemas) in interesting ways, such as converting among different dialects of CREATE syntax (e.g., MySQL-to-Oracle), visualizations of schemas (pseudo-ER diagrams: GraphViz or GD), automatic code generation (using Class::DBI), converting non-RDBMS files to SQL schemas (xSV text files, Excel spreadsheets), serializing parsed schemas (via Storable, YAML and XML), creating documentation (HTML and POD), and more.

Other Resources

GUI Database Design Tools - older list that this page was started from

Personal tools