Unfortunately they are not available in the Community Edition and need to be purchased separately.Īlthough it is designed for power users and developers SQLyog can also be used by beginners. SQLyog includes multiple tools that can be used to increase your productivity such as the Database Synchronization Wizard and the ability to schedule backups or other jobs. You can also change the colors of the Object Browser to personalize each connection. The editor colors and the fonts can be changed in order to make the code more visible. The menus are intuitive and allow you to quickly access the most frequently used commands. The interface of the program is easy to understand and all its functions are easy to access. You can also take advantage of the templates available in the application to create queries, functions or tables. You can also run multiple queries at the same time and stop the execution of the ones that run for a longer time. The program is able to connect multiple servers at the same time allowing you to transfer data between them. This allows you to shorten the time required to perform certain actions and to increase your productivity. To back up a database or to transfer the data and the structure from one database to another are tasks that can be performed with just a few clicks.

You need to write code only in the Query Editor that allows you to create new queries that can be saved as SQL files. Every element of the database can be edited using the visual interface. The program stores all the commands in the history tab in order to review the code lines later. You can create new databases, tables and queries by using the menus and the buttons from the main window. After you have completed these tasks and you are connected to the server you can get to work.

In order to use this software you need to install the MySQL server and to provide the application with the connection settings. If you are not used to the command line interface, this tool turns the MySQL database management into an easier job. SQLyog Community Edition is a powerful program that enables you to work with MySQL databases using a visual interface.

Navicat community edition download