Get UML diagram from relational database
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.
There's also postgresql_autodoc which can create GraphViz or Dia output. The diagrams will likely require further tweaking, though.
For creating ER diagrams by db reflection, I use: DbVisualizer
http://www.dbvis.com/
It's free.
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