CODEWITHSUNDEEP
mysqlreverse-engineeringerd
Zak
Zak

Reputation: 25217

Open source ER diagramming tool for mysql

I want to reverse engineer (import into diagram form) the database definition dump of a database I have, then since no foreign keys are defined in this particular database, I want to be able to manually create the table to table key mappings (using crow feet notation if possible).

I've taken a look at MySQL Workbench, and it gets me 85% of the way there. The nice little relationship lines won't show up though, and the auto arrange is horrible. A quick search of google turns up several other options, so I can evaluate these on my own, but:

Can I get some feedback from you guys for which are your favorite tools to use for this scenario? Why do you like that(your) particular tool?

My intended purpose is to take a legacy database, and train jr. engineers on the organization of the DB. Visual aids are nifty. My fallback option is to recreate an ER diagram by hand. Not fun for 250+ tables.

Upvotes: 9

Views: 26349

Answers (7)

bcag2
bcag2

Reputation: 2439

I use dbeaver which can manage mysql and many others like postgresql
Useful link :
https://dbeaver.com/docs/wiki/Database-Structure-Diagrams/

Upvotes: 0

Sualeh Fatehi
Sualeh Fatehi

Reputation: 4784

SchemaCrawler is a free, open source tool that can generate E-R diagrams, with the help of GraphViz. You can use regular expressions to select the tables and columns you want to display. Relationships are inferred from commonly used naming conventions.

Upvotes: 5

Sairam Krish
Sairam Krish

Reputation: 11731

I am using Mysql Workbench 6.1. By default the diagram will look crunched for large number of tables, making it difficult to figure out relationship between tables. Many tables will overlay on other tables. This is because, the default layout size is small.

In the menu, Go to Model >> "Diagram properties and size".

Change width and size to some thing big (for example width 23 and height 5) - enter image description here

Then in the menu, Go to Arrange >> Autolayout.

Now we should see a clean diagram with all the relations. Now we can re-adjust width and height, more meaningfully

Upvotes: 0

Suresh Kamrushi
Suresh Kamrushi

Reputation: 16086

Generate ERD with PHPMyAdmin is also a better option. PHPMyadmin added this functionality from version 3.4

detail step to generate ERD : http://goo.gl/0z3vFE

You can refer to PHPMyAdmin documentation for more info: http://www.phpmyadmin.net/documentation/#pmadb

Upvotes: 0

Bartek
Bartek

Reputation: 287

Check out Vertabelo.

It's an online database modeler that works under Chrome browser.

It provides you with:

  • DB model versioning and validation,
  • generating SQL scripts for particular database,
  • supports collaboration - allows sharing DB model with other members of your team,
  • supports reverse enginnering.

Moreover it's free of charge.

Upvotes: 1

dkretz
dkretz

Reputation: 37655

You might check out DBDesigner ...

Now known as MySQL Workbench

http://dev.mysql.com/downloads/workbench/5.0.html

Upvotes: 16

Tim Howland
Tim Howland

Reputation: 7970

I've had some success using two commercial (but relatively cheap!) tools- but I still haven't found any really solid open source ones after months of looking.

  • MyEclipseIDE is a subscription product, I think it's around $60 a year. It's a set of bundled plugins for Eclipse, one of them is an ERD analyzer that works OK. If you're programming in Java (or another eclipse-supported language), it may be worth it.
  • SQLMaestro for MySQL: This one is a bit more expensive, with a $99 noncommercial / $179 single seat license. The ERD it generates is much better, and it provides other tools that make it easier to administer and maintain a more complex schema.

My understanding is that MySQL Workbench is still under active development, but they've been banging on it for a long time without really wrapping it up. Maybe now that Sun owns them, they'll get it together.

Upvotes: 2

Related Questions