Get UML diagram from relational database [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 3 years ago.

开发者_高级运维 Improve this question

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

Thanks

---

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

http://www.dbvis.com/

It's free.

---

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

---

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

Plus:

1. it generates postegres sql scheme files too
2. Both are free.

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

pip install psycopg2

---

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.

---

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

---

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.

---

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.