--- title: SQLyog Reviews meta_title: 'SQLyog Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 48 reviews by the users' company size, role or industry to find out how SQLyog works for a business like yours. aggregate_rating: rating_value: 4.5 review_count: 48 scale: '5' date_modified: '2026-06-15' parent_category: name: Database Software url: https://www.g2.com/categories/database-software --- # SQLyog Reviews **Vendor:** Webyog **Category:** [Database Management Systems (DBMS)](https://www.g2.com/categories/database-management-systems-dbms) **Average Rating:** 4.5/5.0 **Total Reviews:** 48 ## About SQLyog SQLyog helps developers and database administrators (DBAs) to create and manage MySQL databases with ease. SQLyog is the most complete & easy MySQL GUI tool that helps save time & increase productivity through numerous powerful features such as autocomplete, query building, query profiler, Visual Schema designer and much more. →How developers & DBAs benefit : Making databases from scratch or refining existing databases can be a tedious task. SQLyog MySQL GUI tool simplifies the entire process for a developer or DBA, thus saving time in the effective management of MySQL databases. Creating tables and build relationships between the tables in a database gets as simple as a drag-n-drop. Developers can enable the drag-n-drop feature using the Visual Schema designer and determine the optimal column types, redundant indexes which will fit more data into memory thereby improving response time. → Makes it simple to manage MySQL databases: SQLyog MySQL GUI tool helps developers search data across large databases with tables having numerous columns without worrying about the underlying schema. It is simple and fast to schedule backup of the data as a precautionary measure in case of a server breakdown at regular intervals and easily restores any previous sessions along with all queries and history tab. ## SQLyog Reviews ### 1. Free and easy to use and understand **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** October 31, 2023 **What do you like best about SQLyog?** Filter data in sqlyog is very easy and make queries in minimal time **What do you dislike about SQLyog?** nothing , all are perfect and fine to me **What problems is SQLyog solving and how is that benefiting you?** findout the data from single or multiple tables in short time... number of queries run in a single run ### 2. Easy to use RDBMS DB tool **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** May 12, 2023 **What do you like best about SQLyog?** Easy to use interface Simple DB connection process **What do you dislike about SQLyog?** Few mandatory options can be given in community edition as well **What problems is SQLyog solving and how is that benefiting you?** Use of DB to connect and process and monitor daily transactions, for creating reports etc. ### 3. SQLyog review **Rating:** 4.5/5.0 stars **Reviewed by:** Shahnoor B. | Senior Analyst, Mid-Market (51-1000 emp.) **Reviewed Date:** August 31, 2022 **What do you like best about SQLyog?** Its clean UI and its powerful features along with user-friendly functionality **What do you dislike about SQLyog?** Some more features could be added which are there provided by competitors. Security features are better in other competing companies. **What problems is SQLyog solving and how is that benefiting you?** Our all databases are being used in SQlyog and it has always been our first choice. Though now we have started using workbench also due to security issues ### 4. Light Weight User Interface for SQL **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** January 02, 2022 **What do you like best about SQLyog?** SQL yog is very simple to use and intuitive. Best part is community edition is free for use. **What do you dislike about SQLyog?** No, as such but, We need to pay the additional cost for advanced premium features. **Recommendations to others considering SQLyog:** Consider SQLyog if you are using MySQL as your RDBMS and need a lightweight UI for it. **What problems is SQLyog solving and how is that benefiting you?** I am connecting to remotely installed MySQL databases from my system. We can restore our not-saved work. The community edition is free for use. ### 5. A light weight Tool **Rating:** 2.5/5.0 stars **Reviewed by:** AMAL P. | Software Engineer, Small-Business (50 or fewer emp.) **Reviewed Date:** November 26, 2021 **What do you like best about SQLyog?** Minimal UI, easily accessible Configurations. Faster Connection and smaller in size **What do you dislike about SQLyog?** Nothing so far, Querying is not that smooth just like SSMS **Recommendations to others considering SQLyog:** Interactive minimal UI for accessing MysQL **What problems is SQLyog solving and how is that benefiting you?** There are variety of logs that we need to store , like SMS log email log, login log. We use SQL Yog for querying and other operations ### 6. High performance database management system. **Rating:** 4.5/5.0 stars **Reviewed by:** Damith L. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** December 21, 2021 **What do you like best about SQLyog?** Very large database support. CA IDMS / DB 18.5 introduces new database options to increase database capacity. Expanded access to CA IDMS and SQL ODBC / JDBC technology. SQL Web. **What do you dislike about SQLyog?** I am a new user of this great database software, it offers great features for high performance. **Recommendations to others considering SQLyog:** It is suitable for software developers and engineers as it provides the ability to use complex Java code within the platform. **What problems is SQLyog solving and how is that benefiting you?** Reliable, modernized, cost-effective DBMS platform. Performance and profitable performance. flexibility. ### 7. SQLyog is the best platform for database management **Rating:** 5.0/5.0 stars **Reviewed by:** Dr. Jayant J. | Assistant Professor, Mid-Market (51-1000 emp.) **Reviewed Date:** December 21, 2021 **What do you like best about SQLyog?** SQL you provide a user-friendly interface for database management **What do you dislike about SQLyog?** There is no such thing that I dislike for SQLyog. **What problems is SQLyog solving and how is that benefiting you?** I use SQLyog for handling the database. ### 8. SQL Yog is a brilliant software for Data Extraction using SQL & Migration activities **Rating:** 4.0/5.0 stars **Reviewed by:** Sunny H. | Software Consultant, Mid-Market (51-1000 emp.) **Reviewed Date:** September 09, 2021 **What do you like best about SQLyog?** 1. Checkbox to allow write into database, this helps developers by being careful with live data. 2. Very quick response 3. Very clean and responsive UI **What do you dislike about SQLyog?** 1. Some paid features should be open to community users. **What problems is SQLyog solving and how is that benefiting you?** 1. Creating & Running migration queries. 2. Extract user data from different set of databases. SQL Yog benefit is that it supportes multiple formats for data extraction like SQL, CSV, TXT etc. ### 9. SQLyog is a powerful tool to connect different MySQL databases simultaneously **Rating:** 4.5/5.0 stars **Reviewed by:** Alberto D. | Web Developer, Mid-Market (51-1000 emp.) **Reviewed Date:** July 30, 2020 **What do you like best about SQLyog?** I like SQLyog because it has a simple GUI to connect databases and view their tables. It is possible to save the access data to connect again at another time. Both the structure or the data can be backed up with SQLyog, separately or on their own. It is easy to install and upgrade. **What do you dislike about SQLyog?** It is a program that offers only a trial version, so if you want to use it for a long time you will have to buy the product in its professional version. **Recommendations to others considering SQLyog:** A powerful tool but it is not free. If you frequently have to manage MySQL databases I recommend its use. **What problems is SQLyog solving and how is that benefiting you?** I use SQLyog every time I need to do full queries to the databases of our development environments and also to import large databases, as well as to schedule backups of the databases of our apps. My work with this software is more efficient, since it can make simple the tasks that are complex in the command console. ### 10. SQLyog is a tool for managing large databases **Rating:** 4.5/5.0 stars **Reviewed by:** Carlos R. | Small-Business (50 or fewer emp.) **Reviewed Date:** May 20, 2020 **What do you like best about SQLyog?** This tool makes database creation a completely simple task. The feature I like most about this software is that it allows you to import and export large amounts of data without problems. The GUI is simple and easy to use. Also, the software is completely lightweight. **What do you dislike about SQLyog?** The only thing I dislike is that it doesn't have a free version, they only offer a free trial for 14 days. **Recommendations to others considering SQLyog:** I really recommend using SQLyog to export and import large amounts of data. It is a tool that will have no limitations when loading your databases. In addition, it has an affordable cost. **What problems is SQLyog solving and how is that benefiting you?** We had a problem when migrating the database of our website from one hosting to another, since it weighed more than 1.5 GB and unfortunately the database manager of our new hosting only supported a maximum of 500 MB for file uploads, so we turned to SQLyog to connect remotely and we managed to import the database without inconveniences. Currently, we also perform the maintenance of the database with this software, since it has a really easy to use GUI. ### 11. The best MySql manager! **Rating:** 5.0/5.0 stars **Reviewed by:** Rafael H. | Consultant Marketing, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** August 14, 2020 **What do you like best about SQLyog?** Easy to use but powerful. You can manage your databases without any problem **What do you dislike about SQLyog?** Nothing bad to say about this great software. **Recommendations to others considering SQLyog:** You can use it with confidence. It is easy, powerful and stable **What problems is SQLyog solving and how is that benefiting you?** We manage all our databases ### 12. Program for the total control of your database **Rating:** 4.0/5.0 stars **Reviewed by:** Cristian P. | Arquitecto de software, Mid-Market (51-1000 emp.) **Reviewed Date:** July 16, 2019 **What do you like best about SQLyog?** SQLyog is easy to use and does not need to be an expert user to manage it. It has a very easy navigating scheme at different levels. I like that I have the ability to delete, edit entries in the database. You can also add tables or columns. Your history tool can display all the codes you enter in the database. **What do you dislike about SQLyog?** I would like the query console to be more intuitive. Sometimes I find myself looking for some questions and it is really confusing to visualize them. **Recommendations to others considering SQLyog:** SQLyog is a program that will be very useful to people who do not have much experience with databases. It has features and functions that will help you enter the database environment in a not-so-strong environment. I recommend it, especially for novice database administrators. **What problems is SQLyog solving and how is that benefiting you?** SQLyog is a database manager that is compatible with several database platforms. It allows me to reduce database development times, using processes without the need to insert code and working more efficiently. I can carry out all the management of the database from this software without using the console. ### 13. Good UI for MySql **Rating:** 4.0/5.0 stars **Reviewed by:** Saurabh K. | Software Engineer, Mid-Market (51-1000 emp.) **Reviewed Date:** August 08, 2019 **What do you like best about SQLyog?** I love to use SQLyog for writing or executing the MySQL queries. The good thing about SQLyog is that if you have closed the SQLyog then the next session automatically gets maintained. It's a user-friendly UI. Biggerners can easily understand SQLyog. **What do you dislike about SQLyog?** Sometimes the SQLyog get crashed if you have written the wrong table name in the table search box. If you are using SQLyog after doing port forward then next time you should need to do port forward otherwise SQLyog will get crashed. **Recommendations to others considering SQLyog:** Nice UI for SQL queries.Easy to find the options present in SQLyog. **What problems is SQLyog solving and how is that benefiting you?** SQLyog has made life so easy if you want to do SQL query. We can easily set up a connection in it. You can easily find out the table information without writing the SQL queries. ### 14. SQLyog is the tool for MySQL and MariaDB **Rating:** 4.0/5.0 stars **Reviewed by:** Juan F. | Ingeniero de sistemas, Mid-Market (51-1000 emp.) **Reviewed Date:** June 24, 2019 **What do you like best about SQLyog?** The best thing about SQLyog is that it allows MySQL databases to work through a visual interface, allowing the most basic users to enter data, modify tables, among other things. On the other hand, it also works with MariaDB, which is the improved version of MySQL and the most complete nowadays. Finally, this tool has a database diagnosis to analyze and repair databases quickly, leaving behind the tedious process. **What do you dislike about SQLyog?** At the moment this manager is only available for Windows and it is a big inconvenience, since we are wasting their utility because our servers are under the Linux platform. **Recommendations to others considering SQLyog:** SQLyog makes life easier when managing MySQL and MariaDB databases. It allows to carry out consultations, user management, diagnostics and many other very useful things to make the administration of your database pleasant. **What problems is SQLyog solving and how is that benefiting you?** SQLyog allows us to carry out visual queries and user management, which previously was a tedious job from the Windows command prompt and also allows us to diagnose the databases to make repairs quickly. ### 15. Avoid a mess with your MySQL DDBB Connections **Rating:** 4.5/5.0 stars **Reviewed by:** Aitor A. | Mr, Small-Business (50 or fewer emp.) **Reviewed Date:** January 24, 2019 **What do you like best about SQLyog?** SQLYog is a great tool to make easy your life during the daily basis operations with MySQL databases. The best points in favor of this tools are the following: - Data and schema synchronisation in a few steps - Scheduled Backups - Export query results to diferent file types (.sql, .csv, html, xml...) - Import external data - Scheduled jobs - User-friendly graphical interface - Smart autocomplete and code completion - SSL connection supported and SSH/HTTP/HTTPS tunneling **What do you dislike about SQLyog?** Although the tool offer a trial period (14 days) if you want to have a full license (with standard support) you will have to purchase a license and the price is 299$. I think the price is a little bit high due the tool has the following limitations: - Only available for Windows (you can install on some Linux distros but is not official supported) - Only available for MySQL DDBB. **Recommendations to others considering SQLyog:** Check your own needs and if SQLyog cover them, spend a few days to test it, I'm sure that you will love it. **What problems is SQLyog solving and how is that benefiting you?** MySQL DDBB management solutions. Time and efforts savings Automatizations of some tasks ### 16. Admin your databases like a boss **Rating:** 4.5/5.0 stars **Reviewed by:** Juan Carlos G. | software developer, Mid-Market (51-1000 emp.) **Reviewed Date:** November 14, 2018 **What do you like best about SQLyog?** Best features of SQLYog: - I can synchronize all my databases without executing a SQL dump, just using "Schema synchronization tool". - You can sync and copy data from other databases with the "Visual data comparison wizard", share your data between all your databases without any problem, just click on the source database and the destination database, and the SQLYog will do the job. - The "User Manager" tool helps with your database users and the roles of each, you can create, update and remove users just from that view, without writing a command in the console. **What do you dislike about SQLyog?** The visual data comparison not working if you have differences between the schemas, it will be nice if before to compare both databases you would make the synchronization between schemas without close the window. Also, sometimes the program closes suddenly and you can copy your SQL sentences, so you will lose the job. **What problems is SQLyog solving and how is that benefiting you?** Like I say before, it helps me a lot with the synchronization between data and schemas in all my databases. I don't need to make a dump of my database to import in another one, with that tool I can make it simple and fast. ### 17. Connect and Control multiple SQL databases **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Gambling & Casinos | Small-Business (50 or fewer emp.) **Reviewed Date:** September 06, 2019 **What do you like best about SQLyog?** SQLyog is a powerful and easy to use database management and monitoring software. I like that is it simple enough for an average user to begin and learn with, but powerful enough that advanced users can also benefit from it. **What do you dislike about SQLyog?** The problem has been clunky sometimes with the later updates. I hope they can improve the performance on Windows soon. **What problems is SQLyog solving and how is that benefiting you?** Managing multiple databases was difficult. SQLyog has tools where you can sync data and db structure to and from databases. ### 18. Popular open source database engine **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** July 09, 2019 **What do you like best about SQLyog?** I like the most is full graphical interface, simple even for beginners. **What do you dislike about SQLyog?** Administrate using its text-based tools and Per-user licencing can get costly **Recommendations to others considering SQLyog:** Administrate MySQL Databases With Ease Using a Graphical Interface so it is must use **What problems is SQLyog solving and how is that benefiting you?** Predefined tools and queries and visual interface ### 19. Efficient and Powerful Mysql Database Client **Rating:** 5.0/5.0 stars **Reviewed by:** Dinesh J. | Mid-Market (51-1000 emp.) **Reviewed Date:** October 02, 2018 **What do you like best about SQLyog?** SQLyog is a very powerful and efficient Mysql Database Client. You can connect to Local as well as Remote Mysql Databases. You cab create Databases, tables, edit them and insert data to them. Its makes database administration a seamless experience, helping you to utilize your more time and effort. **What do you dislike about SQLyog?** It needs to be installed on system, unlike phpmyadmin which runs in browser as a web application. **What problems is SQLyog solving and how is that benefiting you?** Ww use SQLyog for administering Mysql Databases. ### 20. KEEPS SAFELY **Rating:** 4.5/5.0 stars **Reviewed by:** JAYA S. | Software Engineer, Information Technology and Services, Mid-Market (51-1000 emp.) **Reviewed Date:** May 09, 2018 **What do you like best about SQLyog?** It stores data in a very simple format rather than complexing it and data can be easily found in it at the time of need.You can store a number of data of different projects but still it stores it in a convenient nested folder format which makes searching easy.Even if you have done easily tick and create table operation it gives you the DDL information **What do you dislike about SQLyog?** UI is not attracting and you cannot make tables in many designs. **Recommendations to others considering SQLyog:** Should be made attractive with design templates as many application provide **What problems is SQLyog solving and how is that benefiting you?** Data is being kept safe and in tabular form in simple tables.It gives option of manually code in SQL or simply tick your requirements.Even after the table is created with the help of info feature you can know which is primary key which is foreign key ### 21. Best Database Management Tool **Rating:** 4.0/5.0 stars **Reviewed by:** soma s. | Trainee, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** December 27, 2017 **What do you like best about SQLyog?** I feel SQLyog is the best application I have seen ever to manage the mysql databases.It is simple to download and install. The databases are arranged in the treeview control, by expanding the tree we can get the collection of nodes which shows the names of the tables. It is easy to use and backups are very fast. We can transfer the data from one DB to another with ease. **What do you dislike about SQLyog?** I don't find any major problems regarding SQLyog, but for some people it seems to be confusing in some of the cases(when we talk about the freshers). And also when we try to open some tables, it crashes suddenly. And the root connection, sometimes this creates a problem a lot. Other than these things, there are no much problems with this tool. **Recommendations to others considering SQLyog:** I would like to recommend this tool to the freshers. Though it is confusing in some cases, but it becomes easy if we have the grip of using this tool from beginning, as I feel that SQLyog is the best tool when compared to another tools. And also it is easy to create databases in this, we can easily dump the tables, alter the tables, execute the queries easily and read the errors easily. I love to use this tool in my projects. **What problems is SQLyog solving and how is that benefiting you?** I have been using this tool from many years, then I realized the benefits of this tool. First thing it is very fast, and we can manually execute the queries. Also it is easy to read errors and fix them. When others sent the new database, it is easy to dump without any problem. ### 22. best mysql tool used so far **Rating:** 5.0/5.0 stars **Reviewed by:** Ignacio M. | Technical Director, Enterprise (> 1000 emp.) **Reviewed Date:** November 27, 2017 **What do you like best about SQLyog?** the amount of options you get to customize your experience are great. the way that the data grids display is super simple but also very convenient and easy to visualize, which might sound obvious for a data base management tool, but it doesn't happen in all of the cases. The connections import tool works in a great and fast way. the data search feature is also very useful and adds a great value to a tool like this. The tool gives you the option to format query, which becomes extremely helpful, especially when you need to bring code from html or xml codes **What do you dislike about SQLyog?** UI is not the most good looking, but it keeps is simple. If you look visual customization, there are options to change the object browser color schema, which is not great, but it does allow some customization **Recommendations to others considering SQLyog:** definitely worth it if you are mysql data base user. **What problems is SQLyog solving and how is that benefiting you?** connect to mysql databases becomes easy with sqlyog. Having the formatting tool allows you to properly format queries without having to use other tools like toad or notepad + + , ### 23. The best tool I've ever used for database management. **Rating:** 5.0/5.0 stars **Reviewed by:** George B. | Web Development Director, Marketing and Advertising, Small-Business (50 or fewer emp.) **Reviewed Date:** November 09, 2017 **What do you like best about SQLyog?** The schema sync tool. It makes the work so much easier. I also love the fact that is has SSH connection, and of course, data sync tool in that order. This tool is so much better than any other tool out there for when you need to connect to a MySQL or Aurora database. Also, I haven't had the chance to experiment with all of the features available in there. **What do you dislike about SQLyog?** Sometimes it still crashes when trying to sync between servers. Not available on a Mac, or Linux, but that's fine since I develop on Windows. You guys need to make more tools like these. Maybe an IDE in the future? If you guys made it available on a Mac, and Notepad++ became available on the mac, I might have to move to a Mac since my whole company is on the Mac. **Recommendations to others considering SQLyog:** If you have Windows and develop on MySQL or Aurora, do NOT miss this product. Well worth the money!!! Most developers I know usually implement Laravel because of the database stuff it can do. With this product, we don't need to do that. It's a couple of clicks, removing the need for additional components to be run. **What problems is SQLyog solving and how is that benefiting you?** Time saver! The sync tool allows me to not try to write additional code when doing database management. I don't need to run additional scripts to backup databases, or keep schemas in sync. It has saved me countless hours by making things easier and quicker. ### 24. SQLyog is the Sql Manager of choice if you are doing any MySQL development **Rating:** 5.0/5.0 stars **Reviewed by:** Richard S. | CTO, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** November 07, 2017 **What do you like best about SQLyog?** I have been working with Sql Server since it’s first introduction. About a year ago, for various business reasons, we decided to port about 100,000 lines of Sql stored procedures to MySQl. We chose the Aurora MySQl version offered by Amazon. At first glance the SQL workbench should have provided all of the necessary functionality. But unfortunately this was not the case. So I started looking for alternatives, the recommended MySql manager did not appear to offer any advantages. Then I came across SQLyog, Hard to pronounce but definitely a better choice. I downloaded the free version to try it out and was instantly sold on the product. After about a week of trying it out we purchased the license to the product. What did it offer: 1.High reliability. The MySQL Workbench would crash for unknown reasons and was not supported on Windows Server, my development environment. 2. More functionality. As you can imagine converting a thousand of stored procedures from Sql Server to MySQL is no small task. After analyzing the code differences I was able to do a general conversion fairly quickly and then tweaking as I debugged the code with my web site code. 3. Backup functionality. Easy to make one file per object backups. This was useful to give me the ability to store my work in SVN so I can track and preserver changes over time, as well as off site backup. 4. Saving the open work files when closing and reopening the program. This is a great handy feature, one I wish Sql Server Manager had. **What do you dislike about SQLyog?** Improvements needed: the product is great as it stands but I would like to see the following improvements. 1. When opening a stored procedure for alterations position the cursor at the top of the file instead of the bottom of the file, as I seem to always need to go back to the top to start working. 2. Add the standard Cut and paste keystroke functionality every other windows based program has namely Ctrt-X to cut the current line. As well as any other keyboard shortcuts you are missing 3. I know there were a couple of other improvements I would like to see but it slips my mind right now. **Recommendations to others considering SQLyog:** Just Do It. **What problems is SQLyog solving and how is that benefiting you?** By using SQLyog we were able to do our conversion much faster especially due to not randomly crashing like MySQL Workbench does. ### 25. Good product, poor support **Rating:** 2.0/5.0 stars **Reviewed by:** George G. | Senior Technical Business Analyst, Information Services, Small-Business (50 or fewer emp.) **Reviewed Date:** July 24, 2018 **What do you like best about SQLyog?** UI and UX Export / backup features Its better than standard mysql **What do you dislike about SQLyog?** Poor customer service and support Disabling product downloads (even though you've paid for a lifetime product). Constant marketing emails **What problems is SQLyog solving and how is that benefiting you?** Ui for mySQL for development ### 26. Good Experience on SQLyog **Rating:** 4.5/5.0 stars **Reviewed by:** Vijay R. | Developer, Internet, Mid-Market (51-1000 emp.) **Reviewed Date:** October 20, 2017 **What do you like best about SQLyog?** I love this program.I have used it for past 6 months.If we use SQLyog no need to use command promt for showing databases and records.It shows everything on the pannel. Software stability, size, CPU and memory usage, auto complete feature for queries, data import export and visual data synchronization. **What do you dislike about SQLyog?** we cannot download the older versions on web.This a bit of an inconvenience. **Recommendations to others considering SQLyog:** I recommend to my collegue in my office.It very useful to every on. **What problems is SQLyog solving and how is that benefiting you?** We used SQL databases very well.we can use sql yog for time saving and we can see the records here what we executing the programs in sql. SQLyog is being really lightweight and easy to use MYSQL client provide to be very useful to my work. ### 27. A great complete solution for MySQL administration. **Rating:** 4.0/5.0 stars **Reviewed by:** Gema Aji W. | Programmer, Computer Software, Small-Business (50 or fewer emp.) **Reviewed Date:** December 20, 2017 **What do you like best about SQLyog?** Easy to use user interface, HTTP and SSL tunnelling support with SSL encryption capability, great WINE compatibility for Linux, built-in schema designer, easy to use database synchronization tool. **What do you dislike about SQLyog?** Support for database other than MySQL, native Linux or Mac client, drag and drop support between multiple tabs. **Recommendations to others considering SQLyog:** If you need a simple to use application for just managing MySQL databases, give this a try. **What problems is SQLyog solving and how is that benefiting you?** I'm using SQLYog as a primary tool to managing database directly to the server for development or implementation directly to client server. ### 28. Easy to use SQL editor, even for a designer like me **Rating:** 5.0/5.0 stars **Reviewed by:** Sebastian H. | Lead UI Designer, Computer Games, Small-Business (50 or fewer emp.) **Reviewed Date:** October 24, 2017 **What do you like best about SQLyog?** I love how I am able to quickly write and batch run multiple queries, edit data from within a search result and see the history of queries so I can reuse my work later. Before, I was using straight up MySQL to perform my queries and it was a headache. With SQLyog, I could duplicate the client's database and run my queries in a safe test environment with really quick, visually accessible results. Also, adding indexing to existing tables. So easy. Just a couple of clicks instead of lengthy queries. **What do you dislike about SQLyog?** I suppose the only thing I could say that I disliked about SQLyog was ... that you have to be somewhat familiar with SQL to use it? But then again, why are you editing an SQL database if you don't know anything about SQL? Having said that, the GUI is really helpful. It helps you with a bunch of niceties, like formatting your text so its easier to read and auto-completing suggestions as you type, like a traditional code editor. So, in short, I haven't really got anything against it. :/ **Recommendations to others considering SQLyog:** If you're not using an SQL editor yet, give this a try. It's easy to set up and I found it very useful while working with large amounts of data. **What problems is SQLyog solving and how is that benefiting you?** While working on a statistic analysis package for Southampton FC, the engineers on my team had to parse all of the player football statistics for every player in the Premier League. They managed to refine it into a subsection of stats that were most useful and it was up to me to write the queries that would investigate those statistics and represent them as histograms, donut charts and spider graphs within a bespoke piece of software that we were writing. As a designer, I wasn't the most suited to writing complex SQL queries, but nevertheless it was my job. So I used MySQL to help visualise the queries I was writing, to test their results and to see where things were going astray. For example, if my query was supposed to return an image of a player and that image wasn't showing up in the editor, I would debug and find out exactly what was being returned. It helped me find the bugs quicker than if I used a traditional editor. On top of that, since a lot of these bugs stemmed from similar origins, I was able to make great use of saved queries and also to mimic the data ingestion process by running batches of more complicated queries, thereby simulating the running environment. This saved me hours upon hours of mind numbing repetition. Life saver. ### 29. Best Product For SQL injections **Rating:** 5.0/5.0 stars **Reviewed by:** Nagaraju K. | Product Engineer, Internet, Mid-Market (51-1000 emp.) **Reviewed Date:** October 26, 2017 **What do you like best about SQLyog?** I like user interface very much,because no need to use command prompt for sql queries.It shows all the databases in UI.Query execution is also very fast in Yog. **What do you dislike about SQLyog?** Need to improve SQL Formatter. We didn't get new versions of this product. **What problems is SQLyog solving and how is that benefiting you?** We can easily manipulate the data using SQL yog. We can Execute as many as queries at a time,because It will reduce time for us. We can dump our database to any system easily. ### 30. Great **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Real Estate | Small-Business (50 or fewer emp.) **Reviewed Date:** November 06, 2017 **What do you like best about SQLyog?** SQLyog has great scheduling tools. It will sync up databases using checksums and update / add rows that do not exist into the target db. Migrations would be tedious and time consuming without this tool **What do you dislike about SQLyog?** There is nothing to dislike. It does everything it states it does. It is perfect. **Recommendations to others considering SQLyog:** If you are heavy into data migrations, imports, exports, and synchronizing databases this too is for you! **What problems is SQLyog solving and how is that benefiting you?** We need to migrate data daily. We migrate internal, marry data with internal changes to another database,. then sync that back up external. It literally saves us hours each day. ### 31. Great for synchronization **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 06, 2017 **What do you like best about SQLyog?** I heavily use two features: - Database synchronization, which allows me to make a local copy of a cloud database for debugging - User management, which makes it easy to understand permissions **What do you dislike about SQLyog?** Arrangement of menu system is a little clumsy, things are always easy to find, or named in a way that doesn't always communicate the purpose of the feature. **Recommendations to others considering SQLyog:** Good product. Just works! **What problems is SQLyog solving and how is that benefiting you?** I was able to migrate very large databases. Running mysql_dump was not possible. Also allows me to connect through an ssh tunnel, to keep the database safe and secure. ### 32. Great Tool for getting the job done **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 06, 2017 **What do you like best about SQLyog?** The Tools section is the best for me. Database Schema syncing. Then the ability to add functions, triggers, events, is much easier than other tools. **What do you dislike about SQLyog?** Not sure yet - I bought this for the features I needed. I use 3 different apps, but that is because I am used to doing tasks in each one and did not want to relearn. **Recommendations to others considering SQLyog:** Just get the trial - it will prove itself out to you. **What problems is SQLyog solving and how is that benefiting you?** Standing up new sites and replicating the set up of DBs. ### 33. online website tool **Rating:** 5.0/5.0 stars **Reviewed by:** Jena G. | Research Project Specialist, Public Policy, Enterprise (> 1000 emp.) **Reviewed Date:** November 06, 2017 **What do you like best about SQLyog?** It's easy to use! I like that it is easy to enter information. **What do you dislike about SQLyog?** I haven't found anything that I dislike about it! **What problems is SQLyog solving and how is that benefiting you?** I am solving the ability to manage large sets of text that are able to populate reports from other areas of our website ### 34. Essential MySQL Tool **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Telecommunications | Small-Business (50 or fewer emp.) **Reviewed Date:** November 06, 2017 **What do you like best about SQLyog?** Very easy to use, much better than Workbench. Support and development have been very responsive to requests for improvements over the years. **What do you dislike about SQLyog?** Only 1 query execution is allowed for a machine at a time, locking the interface. Maintaining more than 1000 DBs is slow with the tool, no lazy loading. **Recommendations to others considering SQLyog:** Just buy it. There's no reason to use phpMyAdmin to do real work **What problems is SQLyog solving and how is that benefiting you?** When connecting to multiple mysql servers and wanting to perform queries, it's a very good tool. ### 35. SQLyog Usability **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Small-Business (50 or fewer emp.) **Reviewed Date:** December 28, 2017 **What do you like best about SQLyog?** SQLyog has the best tools ( Schema Synchronization, Data Synchronization, Import Data, Export Data) for managing and using MySQL Database **What do you dislike about SQLyog?** the only drawback is crashes when it can not connect to the Database **What problems is SQLyog solving and how is that benefiting you?** multiple server data management. this product makes it really easy to work with multiple servers that should have same data ### 36. Powerfull and easy to use tool for managing MySQL databases **Rating:** 5.0/5.0 stars **Reviewed by:** Areg V. | Senior System Administrator, Semiconductors, Enterprise (> 1000 emp.) **Reviewed Date:** November 06, 2017 **What do you like best about SQLyog?** Easy and intuitive interface Ability to compare schema and sync if needed User management much more easier **What do you dislike about SQLyog?** Not sure that I can recall any global problems as most of minor issues were addressed by support team quite well. Possibly cross platform lack but that is resolvable by using VM. **Recommendations to others considering SQLyog:** Very easy to use and very powerful on options MySQL Manager. **What problems is SQLyog solving and how is that benefiting you?** Simplifies MySQL management and usage quite a lot. Easy to manage multiple different MySQL instances ### 37. Good and fast to my work **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Program Development | Small-Business (50 or fewer emp.) **Reviewed Date:** November 06, 2017 **What do you like best about SQLyog?** Simply options, powerfull syncronize schema tool and others options. **What do you dislike about SQLyog?** The Powertool sync schema, not is possible sync one database with multiple database in a simple task. I have a MASTER DB and a few OWNER DB, and when i update a MASTER DB, is necessary update schema, procedures and functions to all OWNER DB, and only runs of one to one. **Recommendations to others considering SQLyog:** Create sync schema tool one to multiple database. **What problems is SQLyog solving and how is that benefiting you?** Create tables, sync databases ### 38. Easy to use tool for SQL development **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Management Consulting | Enterprise (> 1000 emp.) **Reviewed Date:** November 06, 2017 **What do you like best about SQLyog?** There are a lot of features I like, but the following are most important to me: SSH Connection / tunnel Ability to copy a database from one MySQL server to another **What do you dislike about SQLyog?** The only thing I dislike is that this is Windows only. However, it does run under Wine. **What problems is SQLyog solving and how is that benefiting you?** Allows secure access to MySQL through an SSH connection. Ability to work with SQL files in an IDE type setting. ### 39. SQLYOG review **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Consumer Goods | Enterprise (> 1000 emp.) **Reviewed Date:** October 30, 2017 **What do you like best about SQLyog?** SQLYOG is an easy to use, fully functional query and administration tool for my mySQL database. This tool does what other tools do for bigger power house databases. **What do you dislike about SQLyog?** It does everything I need, there isn't much to dislike. I would like it to be able to run a query with a hotkey as opposed to having to highlight and execute, but the some other tools don't do that too. **Recommendations to others considering SQLyog:** If you're looking for a powerful tool to administer your mysql database, SQLYog is a great product **What problems is SQLyog solving and how is that benefiting you?** db administration and data analysis ### 40. Undoubtedly the best MySQL Client **Rating:** 5.0/5.0 stars **Reviewed by:** Krishna M. | Founder/Director, Computer Software, Mid-Market (51-1000 emp.) **Reviewed Date:** January 09, 2017 **What do you like best about SQLyog?** Software stability, size, CPU and memory usage, auto complete feature for queries, data import export and visual data synchronization. I started using SQL-yog with the community version then upgraded to professional and finally to ultimate. **What do you dislike about SQLyog?** There is no mac version available. Recently I started using mac and I have to switch to windows(on mac) in order to use SQL yog. This is a bit of an inconvenience. **Recommendations to others considering SQLyog:** Buy it with confidence. You will not regret it. The only minor disadvantage(apart from it being windows only software) is that you cannot download the older versions from SQL Yog website. They only host the latest versions of the software and so long as you have their support and upgrade plan you can download it from their website. If your upgrades eligibility expires, you need to make sure you have your version safely uploaded somewhere(e.g. google drive). **What problems is SQLyog solving and how is that benefiting you?** I initially bought this software for simple data base related tasks for my personal website's MySQL database. Soon I started using this at work and had advanced use cases to work with. I had requirements to write advanced tasks such as complex joins, aggregation operations, schema comparison and huge data import/export tasks from different environments. I have used professional version for some time only to upgrade it to ultimate later given that ultimate version supports many advanced features such as schema sync, data import from external formats, ssh tunneling, scheduled backups etc. SQL yog being really lightweight and easy to use MySQL client proved to be very useful for my work. ### 41. Excellent MySQL client **Rating:** 4.0/5.0 stars **Reviewed by:** Daniel J. | Lead System Engineer, Enterprise (> 1000 emp.) **Reviewed Date:** November 06, 2017 **What do you like best about SQLyog?** Ease of use with plenty of options and advanced tools **What do you dislike about SQLyog?** Issues with limited bandwidth as SQLyog will appear to have frozen. **What problems is SQLyog solving and how is that benefiting you?** Administration of our MySQL instances. Easier use than using mysql command line clients and mysql workbench GUI tools ### 42. Works Great **Rating:** 4.0/5.0 stars **Reviewed by:** Eileen L. | Mid-Market (51-1000 emp.) **Reviewed Date:** November 08, 2017 **What do you like best about SQLyog?** There is a minimal amount of time needed to learn the basics. **What do you dislike about SQLyog?** It might be helpful if there was a tutorial. **Recommendations to others considering SQLyog:** Don't hesitate to try! **What problems is SQLyog solving and how is that benefiting you?** I'm a data analyst and this works great for me. ### 43. Best graphical interface for Sql Database **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Internet | Mid-Market (51-1000 emp.) **Reviewed Date:** October 20, 2017 **What do you like best about SQLyog?** querying and database import and exports and procedures creation auto filling queries **What do you dislike about SQLyog?** if result not found it'll show table structure instead of no data found **What problems is SQLyog solving and how is that benefiting you?** fast querying and auto filling of queries error correction ### 44. Invaluable for working with MySQL servers **Rating:** 5.0/5.0 stars **Reviewed by:** Richard L. | Senior Digital Developer, Small-Business (50 or fewer emp.) **Reviewed Date:** November 30, 2016 **What do you like best about SQLyog?** It's fast and feature packed. The ability to simply and quickly synchronise schemas and data between servers is amazing. Previously we'd used phpMyAdman but SQLyog blows it out of the water. The visual comparison tool available in the Ultimate edition is very useful too. It allows you to diff different version of the database. They also have regular updates where they continue to add new features and improve the overall experience of the software. It feels very stable and solid, I tried MySQL Workbench in the past but it didn't feel as polished as SQLyog. I can not recommend this product highly enough as it's transformed how we work with our databases. **What do you dislike about SQLyog?** There is very little to dislike about this product, the one complaint I can think of is when printing a schema builder diagram the resolution is a bit low. I'd like to be able to export a 'profile' of my settings or have them saved to the cloud as I lost all my favourited SQL snippets when reinstalling my computer, but it was my fault for not backing them up. **Recommendations to others considering SQLyog:** Download the trial and you'll be hooked, it really is that good! There are free alternatives but they do not compare. **What problems is SQLyog solving and how is that benefiting you?** Managing databases, from designing and creating, to editing content, backing up and synchronising. It makes all of these tasks simpler and more efficient than any tool we'd previously used. ### 45. Feature rich tool making the job of DB admin and developer easier **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Utilities | Enterprise (> 1000 emp.) **Reviewed Date:** November 07, 2017 **What do you like best about SQLyog?** Ease of use, history feature, ease in user management **What do you dislike about SQLyog?** Still have to use with wine on linux. so an initialization overhead. **What problems is SQLyog solving and how is that benefiting you?** Scheduling jobs, process management, user management, accessing multiple connections, backups, copying and replicating, storing queries etc ### 46. avid user of SQLyog **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Small-Business (50 or fewer emp.) **Reviewed Date:** November 06, 2017 **What do you like best about SQLyog?** Pretty much every thing great program easy to use **What do you dislike about SQLyog?** the way it handles Explain to optimize queries **Recommendations to others considering SQLyog:** very good program, easy to use, great support **What problems is SQLyog solving and how is that benefiting you?** Use it for all my SQL functions (design, document, optimizing). ### 47. Great DB Tool for MySQL **Rating:** 4.5/5.0 stars **Reviewed by:** Aspen O. | Assistant Professor and Graduate Program Director of Computer Science, Computer Software, Enterprise (> 1000 emp.) **Reviewed Date:** November 04, 2016 **What do you like best about SQLyog?** Great for situations when the connection between you and the MySQL Server is not reliable. Tools like MySQL workbench lookup but SQLyog keeps working great. **What do you dislike about SQLyog?** Nothing. Love the tool for MySQL when client is a windows machine **Recommendations to others considering SQLyog:** Great solution for mysql **What problems is SQLyog solving and how is that benefiting you?** Writing SQL code on client machine ### 48. Good open source MySQL amdin tool **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Games | Enterprise (> 1000 emp.) **Reviewed Date:** August 30, 2016 **What do you like best about SQLyog?** Easy organization of all your MySQL databases you need to administer. Able to save specific queries as Favorites. Free and open source version available with it's Community Edition. **What do you dislike about SQLyog?** The UI is a little outdated compared to a lot of other MySQL tools. **Recommendations to others considering SQLyog:** If you need a free easy to use MySQL administration tool I would recommend the Community edition. If you have the budget to pay for a tool I would compare with the other tools that are available also. **What problems is SQLyog solving and how is that benefiting you?** We needed a light MySQL tool so that we can make minor changes in our Build System and Dashboard MySQL db's when needed and this is achieve with the use of SQLyog. ## SQLyog Discussions - [What is SQLyog used for?](https://www.g2.com/discussions/sqlyog-what-is-sqlyog-used-for) - [How do I download SQLyog?](https://www.g2.com/discussions/how-do-i-download-sqlyog) - [Is SQLyog open source?](https://www.g2.com/discussions/is-sqlyog-open-source) - [What is the difference between MySQL and SQLyog?](https://www.g2.com/discussions/what-is-the-difference-between-mysql-and-sqlyog) - [What is SQLyog used for?](https://www.g2.com/discussions/what-is-sqlyog-used-for) - [View SQLyog pricing details and edition comparison](https://www.g2.com/products/sqlyog/reviews?section=pricing&secure%5Bexpires_at%5D=2026-06-28+22%3A27%3A10+-0500&secure%5Bsession_id%5D=6f151869-237d-4d4e-870c-b51f0e325cb5&secure%5Btoken%5D=50e063dbc8d6dd99369cdc031e5614d15954d3e678009fc399b3ec02791294b4&format=llm_user) ## SQLyog Features **Management** - Data dictionary - Data Replication - Query Language - Data Modeling - Performance Analysis **Maintenance** - Data Migration - Backup and Recovery - Multi-User Environment **Security** - Data Encryption - User Access Control ## Top SQLyog Alternatives - [Microsoft SQL Server](https://www.g2.com/products/microsoft-sql-server/reviews) - 4.4/5.0 (2,127 reviews) - [Navicat Premium](https://www.g2.com/products/navicat-premium/reviews) - 4.5/5.0 (60 reviews) - [DBeaver](https://www.g2.com/products/dbeaver/reviews) - 4.4/5.0 (168 reviews)