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 1

I believe DB Designer does something like that. And I think they even have a free version.

edit Never mind. Michael's link is much better.

Answer 2

Try MySQL Workbench, formally DBDesigner 4:

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

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

Answer 3

The "Reverse Engineer Database" mode in Workbench in only part of the paid version not the free one.

Answer 4

@John Downey

With the Free version, you can still generate the schema and diagrams by importing a mysqldump.

Answer 5

On a Mac, SQLEditor will do what you want.

Answer 6

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.

Answer 7

Try SchemaBank. They support reverse engineering too.

Answer 8

Hello, I'm interested in similar tool for reverse engineering, but for MSSQL database. Can you help me finding something like this.