A good database modeling tool for PostgreSQL?

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 - https://github.com/dbeaver/dbeaver/wiki/ER-Diagrams — chrismarx, May 15 '18 at 14:22
See [Moon Modeler](https://www.datensen.com) - data design tool that offers data modeling, reverse engineering and forward engineering features. Free version is available. — Vaclav, Sep 22 '20 at 21:59

score 14 · Answer 1 · answered Sep 27 '12 at 13:22

14

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

answered Sep 27 '12 at 13:22

Frison Alexander

2

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). – ach Jun 03 '13 at 15:35
pgModeler is quite stable now, I'm using v0.9.3 with no problems. To compile it you can follow this guide I wrote https://medium.com/@mglaving/how-to-compile-pgmodeler-0-9-3-on-ubuntu-20-04-19f045ec5b1d – Matty Oct 07 '21 at 17:57

score 7 · Answer 2 · answered Jul 27 '10 at 22:26

7

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

answered Jul 27 '10 at 22:26

score 6 · Answer 3 · answered May 28 '10 at 19:42

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 '10 at 19:42

Alix Axel

This is the online version of WWW SQL Designer: http://ondras.zarovi.cz/sql/demo/ – iman Dec 05 '13 at 11:31

duffymo · Answer 4 · 2010-05-28T18:43:10.557

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 '10 at 18:43

answered May 28 '10 at 09:32

duffymo

2

ERWin doesn't support PostgreSQL. FYI. – Dave Apr 05 '11 at 14:30
but generated mysql code can be converted into postgresql – warchantua Dec 02 '18 at 20:12

score 3 · Answer 5 · answered May 28 '10 at 19:45

3

Commercial tools:

answered May 28 '10 at 19:45

pcent

score 3 · Answer 6 · edited Oct 18 '19 at 00:18

3

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

edited Oct 18 '19 at 00:18

Sergey

answered Feb 13 '12 at 00:27

dajood

6 Answers6