Review SQLyog MySQL GUI

Monday, 15 February 2010 22:55
User Rating: / 22

SQLyog reviewSQLyog - is one of the best managers to work with the database MySQL. This program supports databases MySQL 4.1.x and higher, HTTP tunneling and SSH tunneling in the case of blocking the standard port for database access, ODBC import / export data.

Also built into the program SQLyog possible to synchronize data between databases, creating  backups, notification of events via e-mail. Also, using SQLyog, you can create databases, edit them, clean up and copy, even on another host. Especially noteworthy is interesting option - export database schema in HTML, CSV import / export.

In SQLyog Enterprise you can also display the privileges for different users. Moreover, it is worth noting the possibility of SQLyog Enterprise, as a  HTTP tunneling - this means that if your hoster restricts access to the database from outside, ie, connect to local MySQL can only scripts, you will have to manage the database using phpMyAdmin, which is not very convenient.

HTTP Tunneling provides an interface through a special PHP-script to the local host-based management using SQLyog! In addition to this SQLyog Enterprise can connect to the database is not directly via some gateway using multiple files, you pumped into your website, simulating, thus, treatment of the site to the MySQL database.   Download SQLyog: | Download SQLyog Documentation


SQLyog MySQL GUI is the most popular MySQL Manager and MySQL Admin Tool,combining the features of MySQL Query Browser, phpMyAdmin and various other MySQL Front Ends and MySQL Clients in a single intuitive interface. Working with MySQL can sometimes be painful. SQLyog has the ability to take even the most difficult and time consuming tasks and make them a breeze.

Main features of SQLyog:


Complete Unicode/UTF8 Support

DBA Productivity

Developer / User Productivity



Nag Screen and Text Links

Optimizing Tools


Advanced Connectivity Options

  • HTTP/HTTPs Tunneling
  • SSH Tunneling
  • SSL Connections

Visual Tools

  • SQL Formatter
  • Visual Query Builder
  • Visual Schema Designer

Enhanced Services

  • Priority access to BETAs, new versions and patches
  • Installation support for 1 month
  • Unlimited Priority Support (Optional)

Enhanced Productivity

  • Smart Autocomplete
  • Intelligent Code Completion

Migration Tools

  • Wizard Driven Migration Toolkit
  • Import tasks can be scheduled

Synchronization Tools

  • Schema Synchronization
  • Data Synchronization
  • Data Synchronization can be scheduled

Other Power Tools

  • Compressed Scheduled Backups New!
  • Notification Services
  • Job Manager

Query Profiling Tools

  • Query Profiler

SQLyog Schema Designer

The Schema Designer (introduced in SQLyog version 6.1) is a visual interface where tables and table structures can be defined, displayed and manipulated. The Schema Designer provides a convenient graphical way to perform common operations as an alternative to the menu-based way of operation that was always supported. Also the Schema Designer provides a graphical overview of (complete or only parts of) your databases.



SQLyog Query Builder

SQLyog provides you with a powerful GUI (graphical) Query Builder. The Query Builder is a 'special TAB in the SQL editor area of the program. When the program opens it will display one such tab. You can add more from the 'file' and the 'powertools' menu.




SQL Formatter


P.S. ... please do not accept this post as an advertisement of the product (I understand perfectly well that nobody will buy it;)) - it is really just software that worth a try ...

More Screenshots:




We do not publish: