Looking for a tool that will automatically create a graphical representation of a MySQL DB schema from a live database, showing tables, columns, and relationships (an ER diagram). Ideally something that would run on OS X would be great but I'll take what I can get and run it on a different machine if necessary.
I checked Google and del.icio.us. Seems most products that do this are commercial. I guess they're expensive to develop?
MySQL has the Workbench but it costs extra for the reverse engineering features.
This open source tool SchemaSpy looks kind of promising, but maybe a little awkward to install and use. Before I dive into that, I thought I'd check whether anyone knows of something more "instant gratification."
To reverse engineer database go to menu Database and choose Reverse Engineer... option. Provide connection details to your database and click Next. Wait for the connection and click Next again.
Check out SQuirreL.
You need to right click the table and choose the option, 'Add to Graph'. Then it will open a new tab. After switching to that tab you will see the table represented in a box. Just right click the box and select 'Add all children', and 'Add all Parent'. It will include the complete hierarchy, with the Entity, and Relationships. So, you can say it would generate an ERD.
Hope this would help.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With