GUI Database Design Tools

Languages:

English  • 日本語  • Русский

If you're building a complicated data model, support from tools that provide for the creation of Entity-Relationship diagrams and similar techniques are extremely useful. Some tools that have been suggested as useful by the PostgreSQL community are:

• Datastudio
• DbDesigner fork
• DbSchema
• dbwrench
• DeZign for Database
• Druid III

• ModelRight
• Moskitt and its spatial plugin for PostGIS users

• Open System Architect

• PGmodeler
• PostgreSQL Maestro
• Power*Architect

• TCM - Toolkit for Conceptual Modelling
• Toad Data Modeler

• Valentina Studio

• StarUML with its extension for Postgresql DDL generation [1]

• Vertabelo (designing db online)

• WaveMaker Visual Ajax Studio

• xml to DDL

Also, pgadmin3 isn't a serious design tool, but can be helpful for browsing and simple additions