Get UML diagram from relational database

Question

I use PostegresQL 9. Is there a free tool to derive UML diagrams from my databases?

Thanks

score 25 · Accepted Answer · answered Nov 13 '10 at 16:17

25

For creating ER diagrams by db reflection, I use: DbVisualizer

http://www.dbvis.com/

It's free.

answered Nov 13 '10 at 16:17

vonPetrushev

5,457
6
39
51

This is exactly what I was looking for. DbVisualizer connects to a database and outputs the relationships along with lots of other useful information. Very straightforward, available for Mac/Linux/Windows. – Martin Preusse Nov 16 '10 at 13:40
Yep, yet is a rare case when I have to admit that a java app is quite good :) – vonPetrushev Nov 16 '10 at 21:18
1

i just found it is included in arch linux's aur database. – vonPetrushev Oct 12 '12 at 21:53

gorthx · Answer 2 · 2015-07-20T14:28:49.603

3

There's also postgresql_autodoc which can create GraphViz or Dia output. The diagrams will likely require further tweaking, though.

edited Jul 20 '15 at 14:28

answered Nov 12 '10 at 18:01

gorthx

311
1
4

That link is now broken – beldaz Nov 26 '14 at 20:00

score 3 · Answer 3 · answered Oct 17 '19 at 08:01

Found DBeaver here:

https://softwarerecs.stackexchange.com/questions/34552/generate-database-table-diagrams-from-a-postgresql-database

Tested it with postgres. Works great.

https://dbeaver.io/download/

free, multi-platform universal SQL client. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.

score 1 · Answer 4 · answered Aug 16 '16 at 17:16

1

There's a free tool called Dia and a plugin called PostDia. They would do it for you.

Plus:

it generates postegres sql scheme files too
Both are free.

Requirements for PostDia: python and psycopg2, to install the second one:

pip install psycopg2

answered Aug 16 '16 at 17:16

FabricioFCarv

474
4
5

Unreason · Answer 5 · 2010-11-12T16:21:31.057

0

I think ArgoUML can do it. Let us know

EDIT: Actually ArgoUML does not seem to reverse engineer, take a look at http://databasetouml.org/roadmap.php or search more for extensions to Eclipse

edited Nov 12 '10 at 16:21

answered Nov 12 '10 at 16:15

Unreason

12,556
2
34
50

UML GURU · Answer 6 · 2010-11-15T09:35:36.377

0

EclipseUML can do the job but it is not free. What is cool with this tool is that they have a database profile therefore you can see full database information into your class diagram.

edited Nov 15 '10 at 09:35

answered Nov 12 '10 at 22:37

UML GURU

1,452
1
9
7

score 0 · Answer 7 · answered Nov 14 '10 at 11:21

There was Azzurri Clay plugin for Eclipse with db reverse engineering support (v 1.4 as I remember). But in v 2.0 the company developing this plugin moved the reverse engineering feature to the licensed version of the plugin. There were some manuals in the internet how to downgrade from v2 to v1.

Get UML diagram from relational database

7 Answers7