Visual MySQL Database Designer

Visual MySQL Database Designer

Visual MySQL Database Designer

UPDATE: DB Designer has been depreciated.  Similar features can be found within – MySQL Workbench 5.0 Distribution

I have tried many programs on Windows to visually design MySQL database tables.  Recently I have been using an opensource program called DB Designer by FabForce.  DB Designer is in its 4th version and runs on both Windows and Linux.  Its layout is quite similar to Illustrator and Photoshop.  The toolbars make it very convenient to access all of the relationship types.  You can also manually edit the queries for total custom control.  Once created you can easily export the SQL for creation on your server, or generate the tables right from within the software.

Here are just a few of the many features available:

  • 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

UPDATE: DB Designer has been depreciated.  Similar features can be found within – MySQL Workbench 5.0 Distribution


About the Author

Chad

Freelance web developer and designer residing in Pittsburgh, PA I enjoy creating custom applications and websites to solve real-world problems. When I am not coding away I enjoy trying new craft beers from around the world.

Leave a Reply

New Blog Post: MySQL Using the JOIN Operand Within a Query - http://goo.gl/KHUij