views:

439

answers:

4

I have mysql database and I want a software which can draw the database design for me?

is there any way to do this?

Thanks

+7  A: 

I think you can use MySQL Workbench, it's supposed to have reverse engineering (from database to model).

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

Oskar
+1 Yes, this is the tool for diagramming database schema. Currently MySQL Workbench can reverse-engineer an SQL script, but not a live database. But it's easy to save any database schema as an SQL script with `mysqldump --no-data`
Bill Karwin
I'm pretty sure next version will have option to do forward and reverse engineering on live database. I've seen it in one of the Alpha releases.
Raf
+1  A: 

Toad for Mysql also does a pretty good job.

CodeToGlory
+1  A: 
Boris Guéry
DBDesigner is no longer in development. In fact MySQL workbench is it's successor.
Raf
I just read it on their website ! thanks
Boris Guéry
+2  A: 

Have a look at MySQL Workbench, it's free and next release (currently alpha) will be major step forward (it will replace MySQL Query Browser).

You can do reverse engineering with Visual Architect or Power Designer but you have to pay.

Raf