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.
The following table lists some of the most useful shortcuts to learn:
In a data editor, open full list of columns.
In a data editor, open and edit the data that is stored in the selected cell.
Use SQL generator to generate DDL definitions for database objects.
Generate database entities, for example: function, procedure, schema, database, table.
Open the DDL of the selected object. For example, if you press this shortcut on a table's name in the
Open the Modify dialog to edit the selected object.
Jump to Source, Edit Data
Open the object data. For example, if you press this shortcut on a table's name in the
Select in Database Explorer
Navigate to the object in the Database Explorer.
Search for text occurrences in data.
Quickly find any file, action, symbol, tool window, or setting in DataGrip, in your project, and in the current Git repository.
Find a command and execute it, open a tool window, or search for a setting.
Quick-fixes for highlighted errors and warnings, intention actions for improving and optimizing your code.
Jump to the next or previous highlighted error.
Select a recently opened file or console from the list.
Increase or decrease the scope of selection according to specific code constructs.
Comment out a line or block of code.
Show all places where a code element is used across your project.
(For Windows) Delete a line or redo (customizable).
(For Windows) Starting from 2019.2, when you use Control+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 .
Control+NumPad-- and Control+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 Control+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 Control+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 Control+Shift+A and start typing to get a list of suggested actions. Then select the necessary action and press Enter to execute it.
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 .
To print a non-default or customized keymap, use the Keymap exporter plugin.