SQLyog Features

Features of SQLyog

Compare between the editions of SQLyog MySQL Visual Editor
The following table shows the features included in the different editions of SQLyog.

Core Features (See list below)
Optimizing Tools
Redundant Index Analyzer New!--
Schema Optimizer--
Query Profiling Tools
Query Profiler--
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-

SQLyog Core Features:


  • Complete Unicode/UTF8 Support

DBA Productivity

  • Restoring/Importing large SQL dumps
  • MySQL 5.x objects support
  • User Management
  • Managing hosted MySQL
  • Connection Manager
  • Index Management
  • Relationship/Foreign Key Manager
  • Reorder Columns
  • Copy objects to another Host with single click
  • Table diagnostics
  • Flush Tools
  • Object Browser
  • Creating/dropping database
  • Optimized for managing Hosted MySQL
  • Multiple database connections
  • Table duplication with two clicks

Developer / User Productivity

  • Favorites Manager
  • HTML Schema Documentation
  • Shortcuts to generate SQL DML statements from schema definition
  • Creating/Dropping/Altering tables
  • Multi-tab Query Editor and Result-set Editor
  • Multiple Query Execution
  • Multi-threaded Query execution - Ability to stop long running queries
  • SQL Templates
  • Excel-style grid interface to view/update resultsets
  • Multi-format Blob editor
  • View data in Grid/Text Mode
  • ResultSet/Data Export to CSV/XML/HTML/Excel
  • Full Support from 3.23.38 to the latest 5.x
  • Support for all MySQL table handlers
  • Excel friendly resultsets/table-data export to clipboard/file
  • Dialog-less table and resultset editor


  • Turbo Speed MySQL Management. Uses native MySQL C API - the fastest way
  • to communicate with MySQL server
  • 100% keyboard friendly
  • Small compact binary
  • Minimal use of Registry
  • Easy migration of User Preferences by dragging and dropping config files.
  • Non-cluttered look and feel, ability to show/hide panes