Auto Generate Database Diagram MySQL *

Question

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 ;) ):

see full size diagram

Answer

Try MySQL Workbench, formally DBDesigner 4:

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

This has a "Reverse Engineer Database" mode as far as I remember,

< br > via < a class="StackLink" href=" http://stackoverflow.com/questions/2488/" >Auto Generate Database Diagram MySQL< /a>

Share on Google Plus

About Cinema Guy

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.