SQLyog

Webyog, company that creates innovative data management tools for thousands of customers across 100+ countries, has two main products to offer. There’s SQLyog, a MySQL manager and admin tool meant for developers, and then there’s MONyog, a tool meant to help database admins manage more MySQL servers. Focusing on SQLyog alone, it must be mentioned that it blends together functionality you would expect to get from MySQL Administrator, phpMyAdmin, and other MySQL Front Ends and MySQL GUI tools.

The setup wizard that will help you install SQLyog will ask you to pick one of the following supported languages: English, Chinese (Simplified), Japanese, and Korean. The setup wizard will also ask you to pick the components you want to install: core files, Start Menu shortcuts, desktop shortcut, Quick Launch shortcut. When the installation completes and you launch SQLyog, you will be invited to pick a UI language. Again, you can choose between English, Chinese (Simplified), Japanese, and Korean.

When you launch SQLyog, you will be presented with the “Connect to MySQL Host” window. After you establish a connection, you will be presented with the application’s interface. All your connections will be presented as tabs on said interface. Above the tabs there’s a toolbar with buttons for all the various features and functions SQLyog has to offer. You are sure to get accustomed to the interface quickly and without having to go through a steep learning curve.

As mentioned above, SQLyog is a MySQL manager and admin tool meant for developers. The top features offered by the application are as follows: visually compare data and sync differences, SSH and HTTP tunneling, wizards for backup and scheduled tasks, SQL formatting and autocomplete, visual query builder, query profiler, data search, form view and FK lookups, schema optimizer and index analyzer, visual schema designer, schema and data sync. You have 30 days at your disposal to use the SQLyog trial and test out all its features.

With the powerful functionality it has to offer, SQLyog is sure to put a smile on a developer’s face.