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, Microsoft Azure, Oracle, Amazon Redshift, 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.

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

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

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.

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

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

Renaming 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 learn in which stored procedures, functions or views your table is used.

Learn more

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

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

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

Running 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.

Query console

Specify console behavior for running queries: choose what you want to execute—the smallest statement or the largest one.

Local history

Each console support schema switching and provides local history that keeps track of all your activity and protects you from losing your work.

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.

Import/export options

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

Import CSV

Enjoy a dedicated UI for importing CSV and TSV files to the database. It’s possible to map every column of the file being imported to a table column in your database, which can be either an existing table or a new one created during the import process.

Export as text

Any table or result-set can be exported in a variety of formats including CSV, JSON, XML, and HTML. You can even create your own exporting format.

Export as queries

Any table or result-set can also be presented as a batch of UPDATE or INSERT statements, which can be helpful for modifying data.

Miscellaneous features

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

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.

Execution plan

An execution plan for statements visually represents the operations the database performs in order to return the data required by your query. and helps you optimize the query. Choose to view the plan graphically or in a table format.

Diagrams

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