MySQL SQLyog

I have been actively using SQL Server 2005 for the past three four years. One of the things I like about it is its management studio , most of times I spend trying to design my queries , optimize them and add indexes accordingly.

Its graphical nature helps me work around SQL's in a better manner. I have not tried the express edition which is free .

One of the opensource databases around includes MySQL. It lacks a elegant GUI management portal. The Query Browser provides some features but not all.

I have recently come across this GUI management tool for the same called SQLyog. It provides all features similar to MS SQL Server management studio.

Convenient to make ER diagrams.

Powerful report generation.

Monitoring Support. etc

I will keep updating this post as and when I come across some more useful features.