When comparing SQLyog vs DataGrip, the Slant community recommends DataGrip for most people. In the question“What are the best MySQL client applications for Windows?”DataGrip is ranked 6th while SQLyog is ranked 8th. The most important reason people chose DataGrip is:

DataGrip is not a language-specific IDE. It supports a wide variety of languages by default, such as PostgreSQL, MySQL, Oracle, Microsoft SQL Server, Derby, H2, Sqlite, and many more.
You can also specify your own JDBC drivers to get support for additional platforms.

Pro

Visual design of queries

Pro

Community version

Pro

Power tools

There are very useful power tools to do task like database synchronization, visual data comparison, Schedule backup with email notification. One can also schedule task with scheduler and will get report of task completion or error in email.

Pro

Session restore

User can enable session restore to avoid loss of unsaved work.

Pro

Data visualization

Pro

Store model in project file

Pro

Discounts for multiple users

Pro

Free upgrades for 1 year included

Pro

Unconditional 90-day money back policy

Pro

Premium support option

Pro

Personalized themes

Pro

Fast and stable

Completely written in c/c++ using win32 api gives is edge in performance over other clients.

Pro

Advanced connection options

Pro

Supports multiple languages

DataGrip is not a language-specific IDE. It supports a wide variety of languages by default, such as PostgreSQL, MySQL, Oracle, Microsoft SQL Server, Derby, H2, Sqlite, and many more.

You can also specify your own JDBC drivers to get support for additional platforms.

Pro

Beautiful and customizable UI

DataGrip currently provides two theme options, light and dark. The UI is intuitive to navigate and provides powerful features such as a diagram view of table relationships.

Pro

Refactoring support

You can refactor SQL code with DataGrip — it resolves all references automatically and when an object/variable is renamed, you can choose to update all references to it in your project.

Pro

Helps you avoid mistakes

It can catch SQL bugs and suggest ways to resolve them. It will inform of unresolved objects and the use of keywords as identifiers.

Pro

Version control support

DataGrip supports a wide variety of VCS tools out of the box so that you can edit, test, and commit changes without ever leaving the tool.

Pro

Powerful data editor

A powerful table editor lets you add, remove, edit, and clone data rows. Navigate through the data by foreign keys and use the text search to find anything in the data displayed in the table editor. All your changes are stored locally and can be submitted at once. Multiple fields can also be edited at once.

Pro

Excellent code completion

DataGrip's code completion is context-sensitive and schema-aware code completion. It will take into account tables structure, foreign keys, and even database objects created in your code.

Pro

Much more powerful than its counterparts

DataGrip is a full-featured IDE for working with databases and SQL. It includes commonly found features in database clients, and offers IDE-specific features beyond that — version control, autocompletion, refactoring support, etc.

Cons

Con

Premium support at an additional cost

Con

Cost

Con

Not user friendly

Con

Expensive

This is an annual subscription with tiered pricing that diminishes a small amount year over year. But there are other much cheaper or free alternatives. This is the premium priced product of the bunch.

Con

Performance can be slow/sluggish when working with high-volume databases

As with all other IDEs, DataGrip is powerful and thus requires more resources than usual. It can use up to several GB's of memory when working with high-volume databases, and this has an impact on performance if your system is not equipped to handle it.

Each month, over 1.7 million people use Slant to find the best products and share their knowledge. Pick the tags you’re passionate about to get a personalized feed and begin contributing your knowledge.