DataGrip 2021.2 Help


DataGrip is a database management environment for developers. It is designed to query, create, and manage databases. Databases can work locally, on a server, or in the cloud. Supports MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and more. If you have a JDBC driver, add it to DataGrip, connect to your DBMS, and start working.

Video introduction to DataGrip

To get a quick tour of basic DataGrip features, see the following introduction video (40 minutes).

Alternatively, open this video on YouTube and use time codes in the description section to watch the topic that you are interested in.

First steps with DataGrip

These set of topics are focused on describing features, functionality, the application interface, and might help you to get started quickly.

Quick startA quick overview of basic DataGrip features. From creating a connection to a data source to working with extractors and installing plugins.
ConnectStart working with your data source by creating a connection to it.
Run a queryConnect an SQL file to a data source and run your code.
View resultsConnect an SQL file to a data source and run your code.
Export/ImportImport and export your data to and from various formats with or without special tools like mysqldump, pg_dump, pg_restore, or psql. Also, you can have a look at the Export data in DataGrip tutorial in the Tutorials section.
LocalDBStep-by-step tutorial how to create, connect, and start working with your SQL Server Express LocalDB instance.
Microsoft SQL serverAnother tutorial that shows you how to start working with Microsoft SQL server and connect to its instance with Windows domain or SQL Server authentication.
TroubleshootingConnectivity issue is a very common definition and might include many problems. This troubleshooting article will guide you through the most common steps to identify and fix the issue. If you could not find the answer, try to contact JetBrains and we can try to help you.
SetupLearn how to install DataGrip and run it for the first time.
DiagramsGenerate diagrams for database objects, build query and execution plans, generate flame graphs for EXPLAIN statements.
ShortcutsSpeed up your performance in DataGrip with keyboard shortcuts.
FAQ about DataGripFrequently asked questions about DataGrip.
Last modified: 13 September 2021