Master DataGrip: A Complete Guide to Database Management and Advanced Features

Introduction

DataGrip is a database client developed by JetBrains, the makers of IntelliJ IDEA. It supports connecting to various database servers, executing SQL, creating tables and indexes, and exporting data.

Installation and UI

The installer runs with a simple wizard; after installation you can choose a theme (e.g., Darcula). The main window resembles other JetBrains IDEs, making it familiar to IDEA users.

DataGrip lists existing connections in the left panel and shows connection details on the right.

Managing Data Sources

Open File->DataSource or click the green + icon in the Database view to add a new data source. Choose the database type, then fill in host, username, password, or provide a full JDBC URL.

If a driver is missing, DataGrip displays a warning and offers a download link. Drivers can also be added manually by selecting a local JAR file and moving it to the top of the list.

After configuring, click Test Connection to verify settings.

Settings

Access File->Settings to adjust general options. The Database section lets you change the theme, keymap, and editor fonts (e.g., set Editor->Color & Fonts->Font to Consolas 14). Save the theme under a new name and apply it.

Using the SQL Console

Right‑click a connection and select Open Console to open a SQL editor. DataGrip provides intelligent code completion for keywords, tables, columns, and database‑specific objects.

Execute statements by selecting them and clicking the green arrow or pressing Ctrl+Enter. You can change the execution mode to “smallest statement” so Ctrl+Enter runs the statement under the cursor without prompting.

Results appear in a bottom pane; column widths can be adjusted with Ctrl+Shift+←/→. Rows can be added or deleted using the +/‑ buttons, and values can be edited directly in the grid. Right‑click a column and choose Set Null to assign NULL values.

Table Creation

Click the green + next to a connection and choose Table. In the dialog you can set the table name, comment, add columns (with type auto‑completion), define indexes and foreign keys. The generated DDL is shown at the bottom.

After creation, click the table icon to open a data view where you can browse rows and view the DDL.

Export and Import

To export data, right‑click a table and select Dump Data To File. DataGrip can generate INSERT/UPDATE statements or export as HTML, CSV, or JSON. The export dialog also lets you customize CSV formatting.

Imported data is handled via Right‑click->Import from File. Ensure header options match between export and import to avoid column‑count mismatches.

Navigation Features

Keyword navigation: Hold Ctrl and hover over a table, column, or function name; the cursor changes to a hand, the keyword turns blue and underlined, and clicking jumps to the object in the tree.

Quick navigation: Press Ctrl+N, type the object name, and press Enter to jump.

Global search: Double‑press Shift or click the search icon to open a universal search dialog.

Result‑set search: In the result view, press Ctrl+F to search with regex support.

Related data navigation: Right‑click a foreign‑key column and choose Go to → Referencing Data to view linked rows, or the opposite to see parent data.

Result‑set filtering: Use the filter box or right‑click a column and select Filter By to apply WHERE conditions.

Result‑Set Transformations

Switch between row and column view with Ctrl+Q for wide tables. Use Shift+F6 to rename variables, Alt+Enter to create missing tables/columns, and Alt+Enter on unqualified column names to add table prefixes.

Expand * selections by placing the cursor after the asterisk and pressing Alt+Enter. Convert identifiers to uppercase with Ctrl+Shift+U and format SQL with Ctrl+Alt+L.

Editor Enhancements

Multi‑cursor mode: Press Alt+Shift and click multiple locations to edit simultaneously.

Commenting: Select code and press Ctrl+/ or Ctrl+Shift+/ to toggle line/block comments.

Column editing: Hold Alt and drag the mouse to select rectangular blocks for copy/paste.

History: Access local history and command history from the editor’s context menu to review past queries.