DataGrip – a smart MySQL GUI tool for Windows, Mac and Linux

JetBrains DataGrip is a cross-platform IDE for working with SQL and databases. Among many other databases, DataGrip has first-class support for MySQL, from version 5.1 to the latest ones, and works on Windows, Mac, and Linux.

DataGrip provides various benefits to MySQL developers such as saving their time on automating routine tasks, locating and fixing errors, taking advantage of intelligent support from the IDE, and increasing their overall productivity.

DataGrip provides accurate MySQL syntax highlighting and supports all the important types of objects in your MySQL database.

Let’s look closer at how DataGrip helps you.

Connect to the database

DataGrip uses a JDBC driver to connect to your MySQL database, which will be downloaded automatically when testing the connection. In addition to the main credentials you’ll need to connect, such as port, user, and password, you can set several options for the new MySQL data source:

  • Mark data source as read-only. In this mode, every DDL or DML query will be underlined. If you execute it, there will be a warning.
  • Transaction control is an option that lets you decide whether you want all transactions to be committed automatically or not.
  • Run keep-alive query and auto-disconnect help you manage connection behavior.
  • Startup script is an SQL query which will be run each time you establish a connection.
  • Auto-sync determines if the database tree should be updated automatically after running DDL queries.
  • SSH/SSL options are also available if you need them.

If you run into any troubles connecting to the database, please see the troubleshooting page.

Database tree view

Once you’re connected to your MySQL database, you’ll see the list of objects in the left pane called Database. Here you can filter objects and choose what schemas should be shown.

Writing SQL

Coding is what most developers spend the most time doing in an IDE. DataGrip’s smart features like auto-completion, code snippets, formatter, refactorings, and various intention actions help you do this faster. Concentrate on the logic, not on what you need to type!

Code analysis

DataGrip can help you detect probable bugs and problems in your SQL before you compile and run it. Here are just a few examples of DataGrip understanding what’s going on in your SQL and saving you from mistakes.

Data editor

DataGrip provides a smart data editor with the ability to add, delete, and change data. All the queries DataGrip runs during data updating can later be found in its SQL log, so that you can perform the same changes against another database.

You can filter data, in two different ways:

  • Write an SQL query in the filter field.
  • Use text search to filter by value across all fields.

Another strong feature of DataGrip is its data extractor. It supports many formats includingSQL INSERTS, SQL UPDATES, CSV, JSON, XML, and others. The mechanism is customizable, so that you can create their own formats like Markdown or just Text.

Working with files

If you work with SQL files stored on your computer then you might already have a working directory with tons of scripts. DataGrip provides a handy interface for that. Attach folders from your computer, associate them with data sources, run scripts against several databases, or even use built-in Git integration!

Search

In DataGrip, you can jump to any object at any time, wherever you are. All you need to know is its name! Want to look at the table’s DDL or data? Just type its name (or just a beginning) in the GoTo pop-up. If you have many similar data sources like test, staging, production, and so on, use the filter in the top right-hand corner.

Fully customizable IDE

Select one of the default color schemes or customize them to match your personal preferences. Adopt the keyboard-centric approach and select a keymap you prefer the most, or create your own easily.

That's it! If you have any questions about DataGrip in general or MySQL support in particular, please drop a line at datagrip@jetbrains.com