DataGrip, from JetBrains, is a database IDE that is tailored to suit the specific needs of professional SQL developers.
$9.90
per month per user
MySQL Workbench
Score 6.9 out of 10
N/A
MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, and backup. MySQL Workbench is available on Windows, Linux and Mac OS X. It is available free through its Community edition, and an Enterprise edition is available for a commercial license as well, supported by Oracle.
I think it blows away MySQL Workbench hands down. Workbench does have more functionality when it comes managing the MySQL instance, viewing performance etc. Navicat is ok, it might be better for new database develoopers. I stumbled upon DataGrip cause it came with jetbrains …
One place for all the connections and uniformity of use and interaction
Verified User
Professional
Chose DataGrip
DataGrip provides a single UI for many DBMS platforms, instead of using one for each. Because of that, you can migrate things between platforms using the tool and "look across" all databases at once.
You will like DataGrip; it is the best software to channel and influence data systems and efficiently. It will help you be more efficient and productive in exporting computer data; it is very effective. There are no errors, and you will feel comfortable using them. It promotes data quality and has excellent graphics to represent your information through statistical processes.
It is good software when we have to connect the database of the remote server but it is not as good as phpMyAdmin. When local server is concerned, phpMyAdmin is way better because it has more cleaner UI than Workbench. Workbench is preferred only because phpMyAdmin does not support the connection of remote servers.
There are a lot of menus, some of them aren't needed or users who only need to send queries. I had to watch a videos on youtube to learn how to use workbench. It would be great to have some videos inside software (or links to videos on youtube)
Usability has two aspects, being a complete tool and being easy... DataGrip has a lot of features but it is big, not clear how to use most of the things and most people won't need them. In my opinion, usability is good enough but not friendly.
MySQL Workbench is useful for specifically remote databases. Remote databases generally does not have any UI and we have to connect the server via SSH and on CLI, we write the queries and it shows the data, which is quite tiering and more prone to make mistakes whereas MySQL Workbench provides cleaner way to connect and provides lot of tools, so that we do not have to write queries all the time.
DataGrip provides a single UI for many DBMS platforms, instead of using one for each. Because of that, you can migrate things between platforms using the tool and "look across" all databases at once.
It's like comparing a VW to an performance car like a Ferrari. If you need the performance, bells and whistles you'll want PhpStorm. If you just need to get from one place to another, MySQL Workbench will do just fine.