Alex Rivera | Logout

Auto Generate Database Diagram MySQL

Asked 2008-08-05T15:45:02.930
359

I'm tired of opening Dia and creating a database diagram at the beginning of every project. Is there a tool out there that will let me select specific tables and then create a database diagram for me based on a MySQL database? Preferably it would allow me to edit the diagram afterward since none of the foreign keys are set...

Here is what I am picturing diagram-wise (please excuse the horrible data design, I didn't design it. Let's focus on the diagram concept and not on the actual data it represents for this example ;) ):

diagram see full size diagram

Edit
Report

2 Answers

443

Try MySQL Workbench, formerly DBDesigner 4:

http://dev.mysql.com/workbench/

This has a "Reverse Engineer Database" mode:

Database -> Reverse Engineer

enter image description here

answered 2008-08-05T15:48:11.707
0

Try SchemaBank. They support reverse engineering too.

answered 2009-10-07T10:04:43.593

Your Answer