Features

This section will give you a brief overview of the features available in DataGrip. It is also relevant for the database plugin used in IntelliJ IDEA Ultimate, PyCharm Professional, PhpStorm, RubyMine, CLion, GoLand, Rider, and WebStorm. For more details, visit the documentation page.

Exploring your databases

DataGrip is a multi-engine database environment. If the DBMS has a JDBC driver, you can connect to it via DataGrip. It provides database introspection and various instruments for creating and modifying objects for the supported engines:

Navigation

Quick navigation takes you to an object independently of whether it has just been created in your code or previously read from a database.

Learn more

Diagrams

Explore your tables and their relationships using an insightful diagram.

Schema diff

Compare schemas to see the difference and generate migration scripts for them.

Working with data

Databases are all about data. Use DataGrip to handle all the data manipulations: edit, search, import and export.

Data editor

The 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 data editor.

Learn more

Import/Export

In addition to the trivial ability to import from CSV files, DataGrip provides a powerful scripting mechanism for export which lets you create any text format you like. CSV, JSON, HTML, Markdown and many others are already bundled – export to Excel is also included.

Learn more

Data compare

Use the diff viewer to compare tables or query results. DataGrip highlights the differences between the two and lets you manage the level of the comparison criteria via a tolerance parameter.

Writing SQL

Just as any decent IDE should do, DataGrip provides smart code completion, code inspections, on-the-fly error highlighting, quick-fixes, and refactoring capabilities. It saves you time by making the process of writing SQL code more efficient.

Smart text editor

Just as with any IntelliJ platform IDE, DataGrip includes a code editor that helps you be more productive. Transform and move blocks of code, use multi-cursors to manage selections, and much more.

Learn more

Code completion

DataGrip provides context-sensitive, schema-aware code completion, helping you write code faster. Completion is aware of the tables structure, foreign keys, and even database objects created in the code you're editing.

Learn more

Code generation

Forget about writing typical code manually: DataGrip will do that for you. It generates code for changing objects like tables, columns, etc., based on the UI. Moreover, it helps you to get a DDL for any object and provides DML queries from result-sets and updates.

Learn more

Code analysis and quick-fixes

DataGrip detects where bugs are likely to occur in your SQL code and suggests the best options to fix them on-the-fly. It will immediately let you know about unresolved objects, the use of keywords as identifiers, and always offers you a way to fix the problem.

Learn more

Refactoring and finding usages

DataGrip correctly resolves all references in your SQL files. When you're renaming database objects from SQL, they will also be renamed in the database. You can quickly find out in which stored procedures, functions and views your tables are used.

Learn more

Code formatter

Since each database developer has their own slightly unique style, the ability to configure each individual option in the code formatter helps ensure that all their individual needs are met.

AI assistance

AI Assistant can easily explain any query and allows you to generate SQL queries directly from natural language requests.

Explain code

Explain code

AI Assistant understands the current schema when invoked from database consoles. The Explain Code gives you context-aware explanations directly within your database environment.

Generate queries from natural language requests

Generate queries from natural language requests

Express your data needs in plain language and watch as AI Assistant transforms your words into precise SQL commands.

Running queries

The query console in DataGrip is a basic necessity for any SQL developer. You can use it to create multiple consoles, each with its own schema context and query options.

Query console

Specify the console’s behavior for running queries by choosing what you want to execute – from the smallest statement to the largest one. Available modes include read-only, results-in-editor, and manual transaction committing.

Query history

Each query you run is saved in the log file. There is also a local history of each file, which means everything you type is saved as soon as you type it so that you don’t lose any work.

User parameters

DataGrip supports running parameterized SQL queries. Add your own parameter patterns using regular expressions and choose the SQL dialects that these patterns will be applied to.

Working with files

Many developers store their queries scripts in files. DataGrip provides many features to handle them.

DDL data source

SQL files that contain DDL statements of the schema can be used as data sources. As a result, you can reference all tables, columns, and other objects defined in such files. You can also map a DDL data source to a real one and migrate both sides.

VCS support

DataGrip provides a unified interface for most of the popular version control systems, ensuring a consistent user experience with Git and other systems. GitHub integration is also available.

Run Configurations

You can run scripts without opening them with the help of run configurations. Each configuration can contain several script files in the required order, several target schemas, and the list of tasks to complete before the actual run.

User Interface

Localized UI

The user interface can be displayed to any of the following languages: Chinese, Japanese, and Korean.

Customizable appearance

DataGrip comes with light and dark themes. Each of them can be fully customized and any color can be changed. The user can even create their own color themes, and our plugin repository provides countless options.

Customizable keymap

The power of DataGrip lies in shortcuts. You can change the ones that are not convenient for you and assign your own to any action within the IDE.