SQL to UML diagram or graphic tool

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.

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.

You can use Erwin Data Modeler, Embarcadero's ER Studio, or Microsoft's Visio. For a longer list visit this site http://www.databaseanswers.org/modelling_tools.htm.

Enterprise Architect from Sparx Systems is a commercial UML modelling tool, with data(base) modelling facilities which include forward (to SQL) and reverse (from ODBC) schema engineering.

It supports most of the biggest databases, including Oracle, Sybase, MySQL, Access, SQL Server and PostgreSQL.

I would recommend to use the Dali plugin of Eclipse. You just need a jdbc conncetor and can create java code from your database. From java code you then just reverse engineer the code into UML model in order to get class diagrams.

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.

The resulting ERD can then be exported in multiple formats:

actually i found a software that do what you want it is called draw.io its main use is to create diagrams but if you went to arrange section then insert and chose advanced you will find SQL where you can put your SQL code and it will make it as diagram