Features

This section will give you a brief overview of the features available in DataGrip. It is also relevant to the database plugin of IntelliJ IDEA, PHPStorm, PyCharm and RubyMine. For more details visit the documentation page.

Exploring your databases

DataGrip is the multi-engine database environment. We support MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase, DB2, SQLite, HyperSQL, Apache Derby and H2. If the DBMS has a JDBC driver you can connect to it via DataGrip. For any of supported engines it provides database introspection and various instruments for creating and modifying objects.

Start your project

Database objects

DataGrip introspects all objects in your databases and displays them grouped in folders by schemas. It also provides UI for adding and editing tables, columns, indexes, constraints etc.

learn more

Navigation & Search

Navigation

Quick navigation brings you to any object no matter if it has just been created in your code, or has already been read from a database. Navigate to symbol action lets you find objects by their name.

learn more

Smart editor

Table editor

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.

learn more

Intelligent coding assistance

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

Start your project

Code completion

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

learn more

Smart editor

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 UI. Moreover, it helps you to get DDL for tables and provides DML queries from result-sets.

learn more

Navigation & Search

Renaming and finding usages

DataGrip correctly resolves all table and column references in your SQL files. If you rename any variable or alias, they are renamed throughout the entire code. When you're renaming database objects from SQL, they will also be renamed in the actual database.

learn more

Code generation & refactorings

Code analysis and quick-fixes

DataGrip detects probable bugs 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 a way to fix the problem.

learn more

Editor customization

Smart text editor

Just as any IntelliJ platform IDE, DataGrip includes the code editor that helps you to be more productive. Transform and move blocks of code, use multi-cursors to manage selection, format code according to specific style, and much more.

learn more

Unit testing

Customize appearance

DataGrip comes with light and dark look and feel themes. Each of them can be fully customized, so you can create the one that suits you best. Same works for more than ten pre-configured keymaps.

learn more

Executing queries

Writing queries is nothing without being able to run them. Query console in DataGrip is the basic instrument for any SQL developer. Create multiple consoles, each with its own schema and query options.

Run and Debug

Query console

Specify console behavior for running queries: choose what you want to execute—the smallest statement or the largest one. Each console support schema switching and provides local history that keeps track of all your activity and protects you from losing your work.

learn more
CMake support

Query result

Result-set is similar to the table editor, so they share many features: result-set is editable and supports text search with regular expressions, DDL generation, navigating over the structure.

CMake support

Diff viewer

Use the diff viewer to compare two console snapshots in local history or two query results DataGrip highlights the differences and lets you manage the comparison criteria via the tolerance parameter.

Miscellaneous features

Among other things, DataGrip comes with user parameters support, CSV editor, diagram builder, version control support and many other features.

Unit testing

User parameters

DataGrip supports running parametrized SQL queries. Add your own parameter patterns using regular expressions and choose SQL dialects to which these patterns will apply.

learn more

CMake support

CSV editor

With DataGrip you can edit CSV files as tables with instant changes preview.

Run and Debug

Diagrams

Also explore your tables and their relationships on an insightful diagram. Database objects can be modified directly from it, too.