In April MySQL Workbench 5.0.x reached GA status. I had a chance to try it and wow — it rocks.
It’s super-easy to use and I’ll just copy its feature list:
- Cairo based diagramming canvas which allows output to different targets such as OpenGL, Win32, X11, Quartz, PostScript, PDF etc
- visual representation of tables, views, stored procedure/functions and foreign keys
- live database and SQL script file reverse-engineering
- database/model synchronization
- SQL script generation
- extensible architecture
- export as SQL CREATE script
- import DBDesigner4 models
- support for MySQL 5 features
- selectable notations for diagram
For me, it’s a very useful tool for importing an SQL script, visually modifying it, and exporting a working SQL script. It’s also a cinch to just create ER diagrams in 5 damn minutes that look decent and map out foreign key relationships.
I’ve used DBD4 in the past as well as Aqua Data Studio and this tool gets me more excited. If you design or work with MySQL databases, you should check it out (see screenshots). Right now it’s Windows-only but they plan on releasing Linux and OSX in June, 2008.
Overall, very nice work MySQL — this tool is light years ahead of its predecessors.