What is SQLyog?
The most complete and easy-to-use MySQL GUI
Power tools to save a lot of time daily.
- Data schema and synchronization
Apply schema and data changes visually as you pass the test to production. Replicate data periodically at scheduled intervals using the super fast scan-based algorithm.
Direct access to Blocked MySQL? Forced to use the clumsy phpMyAdmin? You've already covered SQLyog.
Powerful backup wizard with a one-click backup option and ability to schedule with ease.
Simplify data transfer/migration from any ODBC-compliant data source to MySQL.
SQLyog provides powerful means to manage your MySQL databases.
- Runs on all versions of Windows from Vista / 2008 and higher
- Works with MySQL servers from 4.1 and higher and all MariaDB servers.
- Create/Release/Change Tables, Stored Procedures, Functions, Views, Triggers, and Events.
- HTTP and SSH Tunneling - intelligently manage your MySQL server, even if the MySQL port is blocked or remote access to MySQL is not allowed!
- Protect your data with SSL encryption.
- Auto Complete Smart.
- Formats SQL statements.
- Profactive Query Profiler.
- Bookmark manager to carefully organize your favorite SQL instructions.
- Very fast data recovery.
- Advanced GUI query builder. Supports JOINs, aggregate and 'common' functions, sorting (ORDER BY) and filtering (WHERE and HAVING) and ALIAS.
- SQLyog external data import wizard - use the GUI or specify a query.
- Schema and data synchronization tools.
- Powerful scheduled backup compressed with email notification.
- Schedule several jobs.
- SQL scheduler and reporting tool - Run standalone queries for data verification database maintenance with the flexible e-mail option.
- Full support for Oracle/ MySQL and MariaDB virtual columns
- GUI transaction support
- Transparent LDAP/PAM support for connection to Oracle/MySQL and MariaDB. No configuration is required
- Result of the update returned from the query - also supports queries with JOINs. No dialogues - just edit!
- Manages foreign key relationships.
- Fully Compatible with InnoDB.
- Supports mysql pluggable storage engine architecture.
- Multi-threaded query execution with option to allow multiple queries to run simultaneously.
- See your results in GRID /TEXT mode.
- Filter data and result sets directly from the context menu of a displayed value.
- Run SQL scripts (very large) as batch files.
- Run multiple queries returning more than 1000s of rows per result set. It's very efficient in memory.
- Very compact torque.
- Written entirely on C/C++/Win32 APIs using native MySQL C APIs. No wrapper class used.
- Connection manager.
- Tabbed interface to create/change tables.
- View and edit advanced table properties, such as Comment, Key Length, etc.
- Make table diagnostics (check, optimize, repair, analyze)
- Duplicate tables for new table names.
- Excel as grid interface to edit data supported for Enum / Set.
- Create/drop databases.
- Manage indexes.
- Comprehensive user/security manager. Control all available privileges at which level you like (server/ database / table / column).
- Reorder the columns in the table.
- Copy the database between two MySQL hosts.
- Drop all tables from a database with a single click.
- Edit BLOBs in TEXT or GRAPICHS mode. All common (non-proprietary) graphics formats (including "high resolution" TIFFs and PNGs) are supported.
- Export the table structure and data to SQL dumps.
- Direct export to Microsoft Excel.
- Export/import data in/from CSV files.
- Export the schema from the database in HTML.
- Record all queries for one session.
- Syntax highlighting.
- Save the result set in CSV, HTML, and XML.
- Copy your result as CSV to the clipboard.
- It's very keyboard friendly. You can work with 99% SQLyog keyboard features.
- View and delete other user processes.
- Release Host / Logs / Privileges / Tables.
- Quick access to the list of processes, statuses, variables, etc.
System requirements
Win7 x32, Win7 x64, WinServer, WinVista, WinVista x64, WinXP
