Keyboard shortcuts

DataGrip has keyboard shortcuts for most of its commands related to editing, navigation, refactoring, debugging, and other tasks. Memorizing these hotkeys can help you stay more productive by keeping your hands on the keyboard.

All default shortcuts are configurable and you can also assign shortcuts to any action that does not have them by default.

For the predefined keymaps, refer to Predefined macOS keymap and Predefined Windows keymap.

The following table lists some of the most useful shortcuts to learn:

Shortcut	Action
`Ctrl+Enter`	In a query console: Execute Statement. Run the selected statement. If you have several statements, select whether you want to execute all statements or a single statement. The suggestion list always contains an item for running all the statements. In a data editor: Submit Changes. Submit changes to database.
`Ctrl+F12`	Column List In a data editor, open full list of columns.
`Shift+Enter`	Open in Value Editor In a data editor, open and edit the data that is stored in the selected cell.
`Ctrl+Alt+G`	Generate SQL for object Use SQL generator to generate DDL definitions for database objects.
`Alt+Insert`	Generate code Generate database entities, for example: function, procedure, schema, database, table.
`Ctrl+B`	Go to DDL Open the DDL of the selected object. For example, if you press this shortcut on a table's name in the `SELECT` statement, you will see the DDL of this table (the `CREATE TABLE` statement).
`Ctrl+F6`	Modify Object Open the Modify dialog to edit the selected object.
`F4`	Jump to Source, Edit Data Open the object data. For example, if you press this shortcut on a table's name in the `SELECT` statement, you will see the contents of the table.
`Alt+Shift+B`	Select in Database Explorer Navigate to the object in the Database Explorer.
`Ctrl+Alt+Shift+F`	Full-Text Search in a Database Search for text occurrences in data.
Double `Shift`	Search Everywhere Quickly find any file, action, symbol, tool window, or setting in DataGrip, in your project, and in the current Git repository.
`Ctrl+Shift+A`	Find Action Find a command and execute it, open a tool window, or search for a setting.
`Alt+Enter`	Show Context Actions Quick-fixes for highlighted errors and warnings, intention actions for improving and optimizing your code.
`F2` `Shift+F2`	Navigate between code issues Jump to the next or previous highlighted error.
`Ctrl+E`	View recent files and consoles Select a recently opened file or console from the list.
`Ctrl+W` `Ctrl+Shift+W`	Extend or shrink selection Increase or decrease the scope of selection according to specific code constructs.
`Ctrl+/` `Ctrl+Shift+/`	Add/remove line or block comment Comment out a line or block of code.
`Alt+F7`	Find Usages Show all places where a code element is used across your project.
`Ctrl+Y`	(For Windows) Delete a line or redo (customizable). (For Windows) Starting from 2019.2, when you use `Ctrl+Y` for the first time, you will see a dialog in which you can assign the shortcut to the Delete Line or the Redo action. You can change the selected behavior in Settings \| Keymap.
`Ctrl+NumPad -` and `Ctrl+NumPad +`	Fold and unfold big numbers Improve the readability of big numbers.

Shortcut

Action

Ctrl+Enter

In a query console: Execute Statement.
Run the selected statement. If you have several statements, select whether you want to execute all statements or a single statement. The suggestion list always contains an item for running all the statements.
In a data editor: Submit Changes.
Submit changes to database.

Ctrl+F12

Column List

In a data editor, open full list of columns.

Shift+Enter

Open in Value Editor

In a data editor, open and edit the data that is stored in the selected cell.

Ctrl+Alt+G

Generate SQL for object

Use SQL generator to generate DDL definitions for database objects.

Alt+Insert

Generate code

Generate database entities, for example: function, procedure, schema, database, table.

Ctrl+B

Go to DDL

Open the DDL of the selected object. For example, if you press this shortcut on a table's name in the SELECT statement, you will see the DDL of this table (the CREATE TABLE statement).

Ctrl+F6

Modify Object

Open the Modify dialog to edit the selected object.

F4

Jump to Source, Edit Data

Open the object data. For example, if you press this shortcut on a table's name in the SELECT statement, you will see the contents of the table.

Alt+Shift+B

Select in Database Explorer

Navigate to the object in the Database Explorer.

Ctrl+Alt+Shift+F

Full-Text Search in a Database

Search for text occurrences in data.

Double Shift

Search Everywhere

Quickly find any file, action, symbol, tool window, or setting in DataGrip, in your project, and in the current Git repository.

Ctrl+Shift+A

Find Action

Find a command and execute it, open a tool window, or search for a setting.

Alt+Enter

Show Context Actions

Quick-fixes for highlighted errors and warnings, intention actions for improving and optimizing your code.

F2

Shift+F2

Navigate between code issues

Jump to the next or previous highlighted error.

Ctrl+E

View recent files and consoles

Select a recently opened file or console from the list.

Ctrl+W

Ctrl+Shift+W

Extend or shrink selection

Increase or decrease the scope of selection according to specific code constructs.

Ctrl+/

Ctrl+Shift+/

Add/remove line or block comment

Comment out a line or block of code.

Alt+F7

Find Usages

Show all places where a code element is used across your project.

Ctrl+Y

(For Windows) Delete a line or redo (customizable).

(For Windows) Starting from 2019.2, when you use Ctrl+Y for the first time, you will see a dialog in which you can assign the shortcut to the Delete Line or the Redo action. You can change the selected behavior in Settings | Keymap.

Ctrl+NumPad - and Ctrl+NumPad +

Fold and unfold big numbers

Improve the readability of big numbers.

Choose the right keymap

To view the keymap configuration, open the Settings dialog Ctrl+Alt+S and select Keymap.

Use a predefined keymap

DataGrip automatically suggests a predefined keymap based on your environment. Make sure that it matches the OS you are using or select the one that matches shortcuts from another IDE or editor you are used to (for example, Eclipse or NetBeans).

When consulting this page and other pages in DataGrip documentation, you can see keyboard shortcuts for the keymap that you use in the IDE — choose it using the selector at the top of a page.

Install a keymap from a plugin

Besides the default set of keymaps, you can install keymaps from plugins (such as, keymaps for GNOME and KDE): open the Settings dialog Ctrl+Alt+S, select Plugins, switch to the Marketplace tab and search for keymap.

Tune your keymap

You can modify a copy of any predefined keymap to assign your own shortcuts for commands that you use frequently.

Import custom keymap

If you have a customized keymap that you are used to, you can transfer it to your installation.

Learn shortcuts as you work

DataGrip provides several possibilities to learn shortcuts:

The Find Action lets you search for commands and settings across all menus and tools.
Press Ctrl+Shift+A and start typing to get a list of suggested actions. Then select the necessary action and press Enter to execute it.
To add or change the shortcut for any action, press Alt+Enter when it is selected in the list.
Key Promoter X is a plugin that shows a popup notification with the corresponding keyboard shortcut whenever a command is executed using the mouse. It also suggests creating a shortcut for commands that are executed frequently.
If you are using one of the predefined keymaps, you can print the default keymap reference card and keep it on your desk to consult it if necessary. This cheat sheet is also available under Help | Keyboard Shortcuts PDF.
To print a non-default or customized keymap, use the Keymap exporter plugin.

Last modified: 06 November 2024