Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL to UML diagram or graphic tool

Tags:

sql

uml

I have a database and want to output a UML Diagram. Is there software that does this?

Ideally it will be UML, but a graphics representation of the database could work.

like image 449
MassiveAttack Avatar asked Oct 24 '25 02:10

MassiveAttack


2 Answers

Boxes and arrows are all you need, but I'd recommend that you try E/R tools. They are similar to UML, but intended for relational databases. A good one can import and export SQL, which you won't get from a UML tool.

If you use MySQL, the MySQL Workbench does a very nice job, indeed.

like image 111
duffymo Avatar answered Oct 25 '25 17:10

duffymo


The IntelliJ IDEA built-in Database tool window does perfect job and supports a load of DBMS types.

Generate a diagram for a database object

In the Database tool window (View | Tool Windows | Database), right-click a database object and select Diagrams | Show Visualization.

Generate a diagram for a database object

The resulting ERD can then be exported in multiple formats:

enter image description here

like image 25
Denis Abakumov Avatar answered Oct 25 '25 17:10

Denis Abakumov



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!