Home » Questions » Computers [ Ask a new question ]

Auto Generate Database Diagram MySQL [closed]

Auto Generate Database Diagram MySQL [closed]

"Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.

Want to improve this question? Update the question so it's on-topic for Stack Overflow.

Closed 7 years ago.

Improve this 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"

Asked by: Guest | Views: 109
Total answers/comments: 4
Guest [Entry]

"Try MySQL Workbench, formerly DBDesigner 4:


This has a ""Reverse Engineer Database"" mode:

Database -> Reverse Engineer"
Guest [Entry]

I've recently started using https://github.com/schemaspy/schemaspy . It strikes me as having a good balance between usability and simplicity. (GraphViz now optional)
Guest [Entry]

On a Mac, SQLEditor will do what you want.
Guest [Entry]

This http://code.google.com/p/database-diagram/ will reverse engineer your database. Just do an export 'structure only' then paste the SQL into the tool.