Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing MySQL Workbench vs DataGrip, the Slant community recommends MySQL Workbench for most people. In the question“What are the best MySQL GUI clients for OS X?” MySQL Workbench is ranked 5th while DataGrip is ranked 7th. The most important reason people chose MySQL Workbench is:
Actions can be directly carried out on tables. The software prepares the relevant query for approval before execution.
Specs
Question Ranking
Pros
Pro Easy to use
Actions can be directly carried out on tables. The software prepares the relevant query for approval before execution.
Pro Community version
There is a community edition available that is free and open source; licensed under GPL.
Pro EER diagramming
MySQL Workbench has enhanced entity–relationship modeling support.
Pro Cross-platform
Works on Windows, Linux, OS X.
Pro Database synchronization
Forward & reverse engeneering
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 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.
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 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 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 Powerful data editor
A powerful data 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 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 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 Cross-platform
Cons
Con Mixed experience
Doesn't support HiDPi mode on Windows, everything looks blurry. On Linux it has missing features. On Mac seems to be working just fine. But overall a mixed experience.
Con Unintuitive UI
Workbench's user interface is regarded by a lot of users as unintuitive and hard to use.
It seems cluttered and hard to get used to. The left side of the application has several sections (which you get to choose which to open) with several tools for each. A lot of features are hidden behind menus and need some getting used to find them.
Con Freezes constantly
Running any kind of query with more than a thousand records or even just opening a file and other actions crashes the application. You are unable to actually stop a query. You have to kill from Windows Task Manager every single time.
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.
Con Not user friendly
For incompetent users that do not have any idea what they are doing this, and any similar product will not seem user friendly. For nearly everyone else this is yet another amazing IDE from the JetBrains family; a must have!
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.
