A good database modeling tool for PostgreSQL? [closed]

Question

PostgreSQL comes with the excellent pgAdmin-tool for managing the database but lacks GUI data-modeling utility?

I found this list: http://www.databaseanswers.org/modelling_tools.htm but don't have time to evaluate them.

Which one do YOU recommend?

Dbeaver provides diagrams, but not reverse engineering from models - github.com/dbeaver/dbeaver/wiki/ER-Diagrams — chrismarx
– chrismarx, Commented May 15, 2018 at 14:22
See Moon Modeler - data design tool that offers data modeling, reverse engineering and forward engineering features. Free version is available. — Vaclav
– Vaclav, Commented Sep 22, 2020 at 21:59

Frison Alexander · Accepted Answer · 2012-09-27 13:22:41Z

14

pgModeler looks promising: http://pgmodeler.com.br

answered Sep 27, 2012 at 13:22

Frison Alexander

3,2563 gold badges31 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

ach Over a year ago

I really like the interface/functionality but unfortunately it's still extremely buggy. I wouldn't do any work with it that you wouldn't mind completely losing (I learned this the hard way).

Matty Over a year ago

pgModeler is quite stable now, I'm using v0.9.3 with no problems. To compile it you can follow this guide I wrote medium.com/@mglaving/…

user330315 · Accepted Answer · 2010-07-27 22:26:18Z

7

You might also want to have a look at Power*Architect.

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

answered Jul 27, 2010 at 22:26

user330315

Comments

Alix Axel · Accepted Answer · 2010-05-28 19:42:20Z

6

WWW SQL Designer is a great lightweight modeling tool, and it supports PostgreSQL.

SQuirreL also seems nice, I haven't tried it though.

answered May 28, 2010 at 19:42

Alix Axel

155k99 gold badges406 silver badges508 bronze badges

1 Comment

iman Over a year ago

This is the online version of WWW SQL Designer: ondras.zarovi.cz/sql/demo

duffymo · Accepted Answer · 2010-05-28 18:43:10Z

3

The MySQL workbench is a fine modeling tool that's free, but you'll have to modify the SQL it generates for PostgreSQL.

If you have to pay, ERWin is a standard.

edited May 28, 2010 at 18:43

answered May 28, 2010 at 9:32

duffymo

310k46 gold badges376 silver badges570 bronze badges

2 Comments

Dave Over a year ago

ERWin doesn't support PostgreSQL. FYI.

warchantua Over a year ago

but generated mysql code can be converted into postgresql

pcent · Accepted Answer · 2010-05-28 19:45:59Z

3

Commercial tools:

dbwrench

Embarcadero ER Studio

answered May 28, 2010 at 19:45

pcent

2,0412 gold badges16 silver badges17 bronze badges

Comments

Sergey · Accepted Answer · 2019-10-18 00:18:14Z

3

I've been satisfied for years with PostgreSQL Maestro. It's a mature solution and easy to use, but comprehensive.

edited Oct 18, 2019 at 0:18

Sergey

1,6661 gold badge28 silver badges41 bronze badges

answered Feb 13, 2012 at 0:27

dajood

4,09011 gold badges48 silver badges70 bronze badges

Collectives™ on Stack Overflow

A good database modeling tool for PostgreSQL? [closed]

6 Answers 6

2 Comments

Comments

1 Comment

2 Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

Comments

1 Comment

2 Comments

Comments

Comments

Linked

Related