Essential Shortcuts
| Windows Shortcut | macOS Shortcut | Name | Description |
|---|---|---|---|
| Query & Data Operations | |||
| Ctrl + ⏎Enter | ⌘Cmd + ⏎Enter | Execute Statement (Console) | Execute the statement in the query console. Run the selected statement. |
| Ctrl + ⏎Enter | ⌘Cmd + ⏎Enter | Submit Changes (Data Editor) | Submit changes to the database (in the data editor). |
| Ctrl + F12 | ⌘Cmd + F12 | Column List | In data editor: open the full list of columns. |
| ⇧Shift + ⏎Enter | ⇧Shift + ⏎Enter | Open in Value Editor | In data editor: open and edit data in the selected cell. |
| Code & Object Generation | |||
| Ctrl + Alt + G | ⌘Cmd + ⌥Option + G | Generate SQL for object | Generate DDL definitions for database objects via SQL Generator. |
| Alt + Insert | ⌘Cmd + ⌥Option + ⏎Enter | Generate code | Generate code for database entities (function, procedure, schema, database, table, etc.). |
| Navigation | |||
| Ctrl + B | ⌘Cmd + B | Go to DDL | Open the DDL for the selected object. For example, pressing on a table name in SELECT will show CREATE TABLE. |
| Ctrl + F6 | ⌘Cmd + F6 | Modify Object | Open the modify dialog for the selected object. |
| F4 | F4 | Jump to Source / Edit Data | Open the object data. For example, pressing on a table name in SELECT will show the table contents. |
| Alt + ⇧Shift + B | ⌥Option + ⇧Shift + B | Select in Database Explorer | Navigate to the object in Database Explorer. |
| Ctrl + Alt + ⇧Shift + F | ⌘Cmd + ⌥Option + ⇧Shift + F | Full-Text Search in a Database | Full-text search across data in the database. |
| Double ⇧Shift | Double ⇧Shift | Search Everywhere | Quickly search for any file, action, setting window, or configuration in DataGrip and Git repository. |
Navigation & Search Shortcuts
| Windows Shortcut | macOS Shortcut | Name | Description |
|---|---|---|---|
| Search | |||
| Double ⇧Shift | Double ⇧Shift | Search Everywhere | Find any file, action, symbol, tool window, or setting. |
| Ctrl + ⇧Shift + A | ⌘Cmd + ⇧Shift + A | Find Action | Find and execute a command, open a tool window, or find a setting. |
| Alt + ⏎Enter | ⌥Option + ⏎Enter | Show Context Actions | Quick fixes for errors and warnings, intention actions for code improvement. |
| F2 | F2 | Navigate to next error | Go to the next highlighted error/warning. |
| ⇧Shift + F2 | ⇧Shift + F2 | Navigate to previous error | Go to the previous highlighted error/warning. |
| Ctrl + E | ⌘Cmd + E | View recent files and consoles | Select a recently opened file or console from the list. |
| Selection Editing | |||
| Ctrl + W | ⌘Cmd + W | Extend selection | Expand the selection area (select larger code constructs). |
| Ctrl + ⇧Shift + W | ⌘Cmd + ⇧Shift + W | Shrink selection | Reduce the selection area. |
| Alt + F7 | ⌥Option + F7 | Find Usages | Show all locations where the code element is used in the project. |
Code Editing Shortcuts
| Windows Shortcut | macOS Shortcut | Name | Description |
|---|---|---|---|
| Ctrl + / | ⌘Cmd + / | Toggle line comment | Add/remove a comment for the current line of code. |
| Ctrl + ⇧Shift + / | ⌘Cmd + ⇧Shift + / | Toggle block comment | Add/remove a block comment for a code fragment. |
| Ctrl + NumPad - | ⌘Cmd + NumPad - | Fold big numbers | Fold large numbers (improve readability). |
| Ctrl + NumPad + | ⌘Cmd + NumPad + | Unfold big numbers | Unfold large numbers (restore original format). |
| Ctrl + Y | ⌘Cmd + Y | Delete line / Redo | Delete the current line or perform Redo (from version 2019.2: can be assigned to Delete Line or Redo). |