DataGrip 2019.2 Help

Getting started with DataGrip

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.

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

First steps with DataGrip

Install and runConnect to a databaseRun a query

Learn how to install DataGrip, run DataGrip for the first time, and get a quick UI reference.

Connect to a database, use the SSH connection, connect to a cloud database.

Open a database console and run a query.

Work with query resultsUse keyboard shortcutsGet help from JetBrains

Review query results, save them to a file or copy to a clipboard, compare two result sets.

Speed up your performance in DataGrip with keyboard shortcuts.

Still feeling puzzled, let us know, and we will help.


Improve your skills

Share your data sourcesSource code navigationWorking with a source code

Share your data source settings between different projects, different computers, and IDE installations.

Navigate to newly-created or already-existed objects in your code. Use the Navigate to a symbol action to find objects by their name.

Generate and complete your code, quickly find usages, analyze received results.

Smart editorSearch for everythingLanguage injections

Transform and move blocks of code, use multi-cursors, format code according to a specific style, and much more.

Search for a usage of any object in DataGrip, replace object names with the help of regular expressions, and exclude and include found items in your refactoring.

Inject HTML, CSS, XML, RegExp, and other XML-like languages into your SQL code.


Boost your IDE experience

Extend DataGrip functionalityTutorialsFresh news about DataGrip

Add the HTTP client for REST queries, version control systems (VCS), Upsource, or find a plugin to your liking.

Learn how to use search, export data, or connect to Microsoft SQL Server. Step-by-step instructions cover beginner basics and advanced techniques.

Learn the latest news, master the latest features, and always stay tuned to DataGrip development.

Last modified: 11 November 2019