If you are fan of a opensource products, this is for you!

Today,  I learned about a new db design tool, which is open source and free of cost. More importantly, its light weight and easy to use. Its just 92KB size and you can start using right after extracting it. Awesome.

WWW SQL Designer is a OSS tool hosted on Google Code. You can download the latest version of it from here.

Here is the sample diagram that I made with the help of this tool. This is just for your understanding.

Sample ER diagram

you can generate SQL script for the above tables on fly and  create them on a db – mysql etc. Not all databases are supported but most of the Opensource db’s are supported with this tool.  mySQL , SQLLite , PostGRESQL are supported.

More to be added here when I get more time to investigate with this tool.

Cheers

Vikram