DBDesigner for mySQL
dbDesigner is a fabulous tool that allows you to visually design your databases. This tool is completely free and under a GNU license.
dbDesigner has many features starting from a reverse engineering engine to automatically retrieve a model from existing databases, extensive modeling tools and editors to a syncronisation function which will apply model changes automatically to the underlying database.
Here is a complete list of features:
- Available on Linux / MS Windows
- User Interfaced based on industry standard layouting software
- Canvas navigation similar to Adobe Illustrator® and Photoshop®
- Palettes (docked / floating) including “Bird Eyes view”
- Available objects include tables, realtions, labels, regions, images
- Extensive Drag’n’drop support
- Extensive Popup-Menu support
- Advanced Editors
- UNLIMITED Undo-/Redo- functions
- Copy-/Cut-/Paste clipboard functions (XML, DDL)
- Align functions
- Design Mode / Query Mode
- Reverse engineering MySQL, Oracle, MSSQL and any ODBC databases
- Userdefined schema-generation
- Model-To-Database syncronisation
- Index support
- Automatic foreign key placement
- Weak entity support
- Standard Inserts storing and sync
- Full documentation capabilities
- Advanced model printing
- Output as image
- All MySQL datatypes with all options
- User defined datatypes
- Database storage, ability to save model within database
- Network-/Multiuser access through database storage
- Version control*
- SQL Query Builder
- SQL Command History
- SQL Command storage within model
- Plugin interface



