What is a good MySQL Database Schema tool?

Question

I'm starting a new project soon and I'd like to try to use some better tools this time around. The last project, I wrote all my Database creation SQL by hand for MySQL. I'm hoping there are some good tools out there for creating, maintaining and modifying database schema in MySQL. My budget is out-of-my-own-pocket, so free (as in beer) would probably be best. :)

Solution 1

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

It is free and very easy to use. I usually create schema diagrams and export it as a .sql file to use with phpMyAdmin

Solution 2

http://dev.mysql.com/downloads/gui-tools/5.0.html offers a list of GUI tools to use.

Solution 3

Mac options, try Querious or Sequel Pro - here's a comparison:

http://theappleblog.com/2009/02/27/mysql-showdown-querious-vs-sequel-pro/

Solution 4

I know this is an old thread but this is too good to miss out on. I've only just found out about this recently...
HeidiSQL

It supports connecting through SSH tunnels. It uses PuTTY (plink.exe) to do this but avoids having to manually fiddle with your PuTTY settings. It's even easier if you're using this nice portable version of PuTTY... http://jakub.kotrla.net/putty/

Plus it's open source. I strongly urge you to donate though as it's a great tool.

Another one that looks good is DBeaver

I used to really like MySQL Administrator but the new Workbench is way too bloated. I just want a quick way to browse the schema without having to SHOW TABLE STATUS

View more solutions