CODEWITHSUNDEEP
mysqlmappingrelational-database
Tilendor
Tilendor

Reputation: 48923

Is there a tool that can visually map table relationships in MySQL?

I'm looking for a tool that can map the relationships in my database in mysql. I would like something like the view that is generated in MS-SQL Server Management Studio in the 'Show Diagram Pane'. Does such a thing exist?

I'm in charge of the design of the database and its using rails conventions. I would not be adverse to specifying relationships by hand.

Upvotes: 1

Views: 11329

Answers (6)

Ethan
Ethan

Reputation: 60179

MySQL Workbench 5.1.16 is buggy on my OS X 10.5.7 system. I found that it does things like crashes and vanishes with no error. Or it will error out when trying to change page size in the print setup.

I also tried running it on Windows XP under VMWare. It seemed more stable and usable there. I was able to reverse engineer a DB and create a diagram.

Upvotes: 1

hromanko
hromanko

Reputation: 583

Doesn't MySQL Toad have a schema diagram tool? I think it does. I'm not a diagram guy (much happier with mysqldump output) but I've worked with many people who swear by Toad.

Upvotes: 2

Aleksandr Panzin
Aleksandr Panzin

Reputation: 2037

Maybe the official tool has that?

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

Upvotes: 2

Michel
Michel

Reputation: 1492

Altova DatabaseSpy will show them if you are on Windows. If not, the easiest way is to query INFORMATION_SCHEMA (if you're using v5 or later of MySQL) and check out the key column usage statistics for all the tables. This is easy to script.

Upvotes: 0

Ruben
Ruben

Reputation: 9120

One year ago I used DBVis together with Oracle. It believe it also works with MySql.

Upvotes: 0

Sean McSomething
Sean McSomething

Reputation: 6517

Most MySQL databases still use MyISAM tables, which do not provide foreign key constraints. Without explicit FKs the best you can do is guess at the relationships between tables.

Upvotes: -2

Related Questions