Query console 7
| Action | Windows / Linux | Mac |
|---|---|---|
| Execute statementIf the console holds several statements DataGrip shows a chooser; the list always includes an option to run all of them. | Ctrl+Enter | Cmd+Return |
| Open default query consoleSelect the data source in the Database Explorer first; the console is already connected, so you can type and run SQL right away. | F4 | Cmd+Down |
| New query consoleCreates a further console for the selected data source in one step, without going through the New menu. | Ctrl+Shift+Q | Cmd+Shift+L |
| Jump to Query ConsolePops up the consoles that belong to the selected data source, with an entry for creating a new one. | Ctrl+Shift+F10 | Cmd+Shift+F10 |
| Browse Query HistoryThe dialog keeps every statement that has been run in a query console. | Ctrl+Alt+E | Cmd+Option+E |
| Show plan diagramAfter Explain Plan, draws the execution plan as a diagram; by default it appears as a tree in the Services tool window. | Ctrl+Alt+Shift+U | Cmd+Option+Shift+U |
| Run selected SQL filesWith SQL files selected in the Files tool window, runs them through a temporary run configuration. | Ctrl+Shift+F10 | Ctrl+Shift+R |
Data editor 21
The help prints no key for Roll Back or Explain Plan, which are reached from the toolbar; Settings › Keymap lets you bind either one yourself.
| Action | Windows / Linux | Mac |
|---|---|---|
| Submit changesSends the edits made in the grid to the database server; until then they are local only. | Ctrl+Enter | Cmd+Return |
| Submit and CommitManual transaction mode only: submits the edits and commits the current transaction in one step. | Ctrl+Alt+Shift+Enter | Cmd+Option+Shift+Return |
| Revert SelectedUndoes unsubmitted edits in the selected cell or in a whole range of cells. | Ctrl+Alt+Z | Cmd+Option+Z |
| Add RowThe new row reaches the database only after Submit. | Alt+Insert | Cmd+N |
| Delete RowWorks on several rows at once; pick them by clicking their numbers in the gutter. | Ctrl+Y | Cmd+Backspace |
| Clone RowThe copy is appended as the last row of the table. | Ctrl+D | Cmd+D |
| Edit cell valueDouble-clicking the cell does the same; the command is unavailable for read-only values. | Enter | Return |
| Open in Value EditorShows the content of the cell in an editor of its own, where Enter starts a new line. | Shift+Enter | Shift+Return |
| Set DEFAULTWrites the default value defined for the column into the current cell. | Ctrl+Alt+D | Cmd+Option+D |
| Set NULLReplaces the content of the current cell with NULL. | Ctrl+Alt+N | Cmd+Option+N |
| Copy aggregation resultPuts one summary value for the selected cells on the clipboard; SUM is the default aggregation. | Ctrl+Shift+C | Cmd+Shift+C |
| Show column listLists every column in a popup, where Space hides or shows the selected one. | Ctrl+F12 | Cmd+F12 |
| Reload PageBrings the grid in line with what the database holds now, and applies a changed page size. | Ctrl+F5 | Cmd+R |
| Previous PageSteps back one page of a result set that is larger than the page size. | Ctrl+Alt+Up | Cmd+Option+Up |
| Next PageLoads the following page; by default a query returns at most 500 rows at a time. | Ctrl+Alt+Down | Cmd+Option+Down |
| Go to RowThe dialog accepts a column:row pair, so one entry can target an exact cell. | Ctrl+G | Cmd+L |
| Go to related rowsOpens the records the current row references, or the ones that reference it. | F4 | Cmd+Down |
| Go to related symbolThe data editor menu lists DDL, which opens the object definition, on the same key. | Ctrl+Alt+B | Cmd+Option+B |
| Show row filterBrings back the filter field of the grid when it is not shown. | Ctrl+Alt+Shift+F | Cmd+Option+Shift+F |
| Open record viewShows the values of one record in a side panel of the data editor, where they can also be edited. | Ctrl+Shift+Enter | Cmd+Shift+Return |
| Cancel Running Statements | Ctrl+F2 | Cmd+F2 |
Database Explorer 21
| Action | Windows / Linux | Mac |
|---|---|---|
| New data source or objectThe New menu creates a data source or, with one selected, items such as a query console. | Alt+Insert | Cmd+N |
| Data Source PropertiesOpens the dialog where data sources and drivers are managed; the macOS key is Cmd with semicolon. | Ctrl+Alt+Shift+S | Cmd+; |
| RefreshRe-reads the selected element from the database so the tree matches its actual state. | Ctrl+F5 | Cmd+R |
| Force RefreshThrows away what is cached for the data source and loads it afresh; offered on data source nodes only. | Ctrl+Shift+F5 | Cmd+Option+Shift+R |
| Deactivate data sourceDisconnects the selected data sources; offered only while they have an active connection. | Ctrl+F2 | Cmd+F2 |
| Edit DataOpens a table, view or materialized view in the data editor; it works on a table name inside a statement too. | F4 | Cmd+Down |
| Modify ObjectOpens the Modify dialog for the selected object; Modify Table in the data editor uses the same key. | Ctrl+F6 | Cmd+F6 |
| Select in Database ExplorerFrom a statement or a data editor, highlights the object at the caret in the Database Explorer tree. | Alt+Shift+B | Option+Shift+B |
| Full-text searchLooks for a text in the data of the selected data sources when you do not know where it is stored. | Ctrl+Alt+Shift+F | Cmd+Option+Shift+F |
| SQL GeneratorProduces DDL for the selected objects, from a single table up to all tables of a schema. | Ctrl+Alt+G | Cmd+Option+G |
| DDL to clipboardCopies the DDL of the selected object straight to the clipboard, without opening the generator. | Ctrl+Alt+Shift+G | Cmd+Option+Shift+G |
| DDL to query consoleWrites the DDL of the selected object into a query console instead of the clipboard. | Ctrl+Alt+Shift+B | Cmd+Option+Shift+B |
| Copy Data SourcePlaces the connection settings of the data source on the clipboard as an XML snippet. | Ctrl+C | Cmd+C |
| Duplicate data sourceThe Data Sources and Drivers dialog opens so the properties of the copy can be set. | Ctrl+D | Cmd+D |
| Move to folderGroups data sources; if no folder exists yet, the first one is created in the popup. | F6 | F6 |
| Copy Table toThe copy can go to another schema or data source, for example from MySQL to PostgreSQL. | F5 | F5 |
| Drop object or remove data sourceDrops the selected database object; on a data source node it removes the data source. | Delete | Delete |
| Show DiagramOpens a diagram of the chosen table or whole data source in an editor tab of its own. | Ctrl+Alt+Shift+U | Cmd+Option+Shift+U |
| Show Diagram PopupShows the same diagram in a popup instead of an editor tab. | Ctrl+Alt+U | Cmd+Option+U |
| Expand all nodes | Ctrl+Num + | Cmd+Num + |
| Collapse all nodes | Ctrl+Num - | Cmd+Num - |
General 9
This column follows the Windows keymap of the help. Switching the help's selector to XWin changes a few of these keys: the Database Explorer then shows Alt + 1 and Surround With Ctrl + Alt + Shift + B.
| Action | Windows / Linux | Mac |
|---|---|---|
| Search EverywhereA double tap of Shift opens one box that finds files, actions, symbols, tool windows and settings. | ShiftthenShift | ShiftthenShift |
| Find ActionRuns a command, opens a tool window or looks up a setting once you type part of its name. | Ctrl+Shift+A | Cmd+Shift+A |
| Open SettingsThe Keymap page of this dialog lists every binding and is where any of them can be changed. | Ctrl+Alt+S | Cmd+, |
| Run AnythingA double tap of Ctrl in both keymaps, not a chord. | CtrlthenCtrl | CtrlthenCtrl |
| Save All | Ctrl+S | Cmd+S |
| New scratch file | Ctrl+Alt+Shift+Insert | Cmd+Shift+N |
| SwitcherStays on Ctrl with Tab in the macOS keymap instead of moving to Cmd. | Ctrl+Tab | Ctrl+Tab |
| Increase editor font sizeApplies to every open editor, not only the tab that has focus. | Alt+Shift+. | Ctrl+Shift+. |
| Decrease editor font sizeShrinks the text of every open editor in one step. | Alt+Shift+, | Ctrl+Shift+, |
Basic editing 26
On Windows, Ctrl + Y can mean Delete Line or Redo: the first press opens a dialog where you assign it, and Settings › Keymap changes the choice later.
| Action | Windows / Linux | Mac |
|---|---|---|
| Cut | Ctrl+X | Cmd+X |
| CopyWith nothing selected, the whole line under the caret goes to the clipboard. | Ctrl+C | Cmd+C |
| Paste | Ctrl+V | Cmd+V |
| Paste as Plain TextSkips the smart paste that would otherwise adjust the inserted lines, for example by adding comment markers. | Ctrl+Alt+Shift+V | Cmd+Option+Shift+V |
| Paste from HistoryOpens a dialog of earlier clipboard entries so an older copy can be inserted. | Ctrl+Shift+V | Cmd+Shift+V |
| Copy Paths | Ctrl+Shift+C | Cmd+Shift+C |
| Copy ReferenceIn the editor the copied string includes the line number; in the Database Explorer it is the fully qualified object name. | Ctrl+Alt+Shift+C | Cmd+Option+Shift+C |
| Undo | Ctrl+Z | Cmd+Z |
| Redo | Ctrl+Shift+Z | Cmd+Shift+Z |
| Indent Selection | Tab | Tab |
| Unindent Line or Selection | Shift+Tab | Shift+Tab |
| Auto-Indent Lines | Ctrl+Alt+I | Ctrl+Option+I |
| Start New LineAdds a line below the current one and puts the caret on it, wherever the caret was. | Shift+Enter | Shift+Return |
| Start new line aboveAdds a line above the current one and puts the caret there. | Ctrl+Alt+Enter | Cmd+Option+Return |
| Delete LineOn Windows the first press shows a dialog asking whether this key should delete a line or redo. | Ctrl+Y | Cmd+Backspace |
| Join LinesAppends the following line to the one holding the caret; repeat until everything needed is on one line. | Ctrl+Shift+J | Ctrl+Shift+J |
| Duplicate Line or Selection | Ctrl+D | Cmd+D |
| Toggle CaseFlips the selected fragment between upper and lower case; a CamelCase name comes out in lower case. | Ctrl+Shift+U | Cmd+Shift+U |
| Move Statement UpCarries the statement at the caret above the previous one and checks the syntax while doing it. | Ctrl+Shift+Up | Cmd+Shift+Up |
| Move Statement DownCarries the statement at the caret below the following one, again with a syntax check. | Ctrl+Shift+Down | Cmd+Shift+Down |
| Move Element Left | Ctrl+Alt+Shift+Left | Cmd+Option+Shift+Left |
| Move Element RightThe vendor table prints this row as Move Statement Right; it is the counterpart of Move Element Left. | Ctrl+Alt+Shift+Right | Cmd+Option+Shift+Right |
| Move Line UpShifts just the caret's line; the statement version uses Ctrl or Cmd with Shift instead. | Alt+Shift+Up | Option+Shift+Up |
| Move Line Down | Alt+Shift+Down | Option+Shift+Down |
| Toggle line commentPress it a second time on the same line to remove the comment again. | Ctrl+/ | Cmd+/ |
| Toggle block commentComments or uncomments the selected fragment; the macOS keymap uses Option where Windows uses Shift. | Ctrl+Shift+/ | Cmd+Option+/ |
Coding assistance 10
| Action | Windows / Linux | Mac |
|---|---|---|
| Show Intention ActionsLists fixes for the problem highlighted at the caret, along with other context actions. | Alt+Enter | Option+Return |
| Basic CompletionKeeps Ctrl with Space on macOS; in a data editor cell it opens the list of values to pick from. | Ctrl+Space | Ctrl+Space |
| Type-Matching Completion | Ctrl+Shift+Space | Ctrl+Shift+Space |
| Second Basic Completion | Ctrl+Alt+Space | Ctrl+Option+Space |
| Complete Current StatementAdds what the statement still lacks, such as the closing parentheses of a CREATE TABLE or a function call. | Ctrl+Shift+Enter | Cmd+Shift+Return |
| Reformat Code | Ctrl+Alt+L | Cmd+Option+L |
| Parameter Info | Ctrl+P | Cmd+P |
| Quick DocumentationOn a table name in a statement it previews the table structure; the macOS key is plain F1. | Ctrl+Q | F1 |
| Surround WithThe popup includes the comment pairs that turn the selected fragment into a custom folding region. | Ctrl+Alt+T | Cmd+Option+T |
| GenerateOffers database entities to create, for example a table, schema, function or procedure. | Alt+Insert | Cmd+N |
Select text 19
| Action | Windows / Linux | Mac |
|---|---|---|
| Select All | Ctrl+A | Cmd+A |
| Extend selection left | Shift+Left | Shift+Left |
| Extend selection right | Shift+Right | Shift+Right |
| Select to previous word | Ctrl+Shift+Left | Option+Shift+Left |
| Select to next word | Ctrl+Shift+Right | Option+Shift+Right |
| Select to line start | Shift+Home | Cmd+Shift+Left |
| Select to line end | Shift+End | Cmd+Shift+Right |
| Extend selection up | Shift+Up | Shift+Up |
| Extend selection down | Shift+Down | Shift+Down |
| Select to code block start | Ctrl+Shift+[ | Cmd+Option+Shift+[ |
| Select to code block end | Ctrl+Shift+] | Cmd+Option+Shift+] |
| Select to page top | Ctrl+Shift+Page Up | Cmd+Shift+Page Up |
| Select to page bottom | Ctrl+Shift+Page Down | Cmd+Shift+Page Down |
| Select a page up | Shift+Page Up | Shift+Page Up |
| Select a page down | Shift+Page Down | Shift+Page Down |
| Select to start of file | Ctrl+Shift+Home | Cmd+Shift+Home |
| Select to end of file | Ctrl+Shift+End | Cmd+Shift+End |
| Extend SelectionEach press widens the selection to the next larger construct; in plain text from word to sentence to paragraph. | Ctrl+W | Option+Up |
| Shrink SelectionTakes back one step of Extend Selection, narrowing toward where the caret started. | Ctrl+Shift+W | Option+Down |
Code folding 10
| Action | Windows / Linux | Mac |
|---|---|---|
| ExpandUnfolds the fragment at the caret; the plus is the one on the numeric keypad. | Ctrl+Num + | Cmd+Num + |
| CollapseFolds the fragment at the caret; the minus is the numeric keypad key. | Ctrl+Num - | Cmd+Num - |
| Expand RecursivelyUnfolds the current fragment together with the regions nested inside it. | Ctrl+Alt+Num + | Cmd+Option+Num + |
| Collapse RecursivelyFolds the current fragment together with the regions nested inside it. | Ctrl+Alt+Num - | Cmd+Option+Num - |
| Expand AllUnfolds everything inside the selection or, with nothing selected, in the whole file. | Ctrl+Shift+Num + | Cmd+Shift+Num + |
| Collapse AllFolds everything inside the selection or, with nothing selected, in the whole file. | Ctrl+Shift+Num - | Cmd+Shift+Num - |
| Fold SelectionCollapses the lines you selected as a custom fold, and expands them again on a second press. | Ctrl+. | Cmd+. |
| Expand to levelPress the chord, then a digit: it sets how many nesting levels of the current fragment open. | Ctrl+Num *then1-5 | Cmd+Num *then1-5 |
| Expand all to levelOpens every collapsed fragment in the file down to the nesting level of the digit pressed. | Ctrl+Shift+Num *then1-5 | Cmd+Option+Num *then1-5 |
| Go to custom folding regionLists the regions marked with custom folding comments; the Structure tool window shows them too. | Ctrl+Alt+. | Cmd+Option+. |
Multiple carets and selection ranges 11
Clone Caret Above and Below are not three-key chords: Ctrl goes down twice in a row and stays down after the second press, and an arrow then picks the direction. Option takes the place of Ctrl on a Mac.
| Action | Windows / Linux | Mac |
|---|---|---|
| Add or remove a caret | Alt+Shift+Click | Option+Shift+Click |
| Toggle Column Selection Mode | Alt+Shift+Insert | Cmd+Shift+8 |
| Clone Caret AbovePress the modifier twice, keep it down the second time, then press Up. | CtrlthenCtrl+Up | OptionthenOption+Up |
| Clone Caret BelowPress the modifier twice, keep it down the second time, then press Down. | CtrlthenCtrl+Down | OptionthenOption+Down |
| Carets on every selected line | Alt+Shift+G | Option+Shift+G |
| Select next occurrence | Alt+J | Ctrl+G |
| Select All Occurrences | Ctrl+Alt+Shift+J | Cmd+Ctrl+G |
| Deselect last occurrenceRemoves the occurrence that Select next occurrence added most recently. | Alt+Shift+J | Ctrl+Shift+G |
| Rectangular selection to clickA middle-click with these modifiers, not a drag. | Alt+Shift+Middle-click | Option+Shift+Middle-click |
| Rectangular selection by draggingHold the modifier and drag with the primary mouse button. | Alt+Click | Option+Click |
| Add another rectangular selectionDragging with all three modifiers adds a block and keeps the ones already made. | Ctrl+Alt+Shift+Click | Cmd+Option+Shift+Click |
Find everything 10
| Action | Windows / Linux | Mac |
|---|---|---|
| FindSearches the open file; in a data editor it searches the current page of results. | Ctrl+F | Cmd+F |
| Find NextF3 on Windows; the macOS keymap uses Cmd with G. | F3 | Cmd+G |
| Find Previous | Shift+F3 | Cmd+Shift+G |
| Replace | Ctrl+R | Cmd+R |
| Find in Files | Ctrl+Shift+F | Cmd+Shift+F |
| Replace in Files | Ctrl+Shift+R | Cmd+Shift+R |
| Find word at caretThe macOS keymap page prints N/A for this action, so it has a default key on Windows only. | Ctrl+F3 | — |
| Go to File | Ctrl+Shift+N | Cmd+Shift+O |
| File StructureIn a data editor this key opens the full column list instead. | Ctrl+F12 | Cmd+F12 |
| Go to Symbol | Ctrl+Alt+Shift+N | Cmd+Option+O |
Code analysis 4
| Action | Windows / Linux | Mac |
|---|---|---|
| Error Description | Ctrl+F1 | Cmd+F1 |
| Next Highlighted ErrorJumps forward to the nearest problem highlighted in the SQL file. | F2 | F2 |
| Previous Highlighted ErrorJumps back to the problem highlighted before the caret. | Shift+F2 | Shift+F2 |
| Run Inspection by Name | Ctrl+Alt+Shift+I | Cmd+Option+Shift+I |
Run and debug 23
| Action | Windows / Linux | Mac |
|---|---|---|
| RunThe macOS keymap puts Run on Ctrl with R; the vendor table names it the context configuration. | Shift+F10 | Ctrl+R |
| Choose configuration and runPressing 0 in the popup that appears opens the Run/Debug Configurations dialog. | Alt+Shift+F10 | Ctrl+Option+R |
| Debug | Shift+F9 | Ctrl+D |
| Choose configuration and debug | Alt+Shift+F9 | Ctrl+Option+D |
| Attach to Process | Ctrl+Alt+F5 | Option+Shift+F5 |
| StopIn the Run tool window it asks which process to end; in a data editor it cancels the running statements. | Ctrl+F2 | Cmd+F2 |
| Resume Program | F9 | Cmd+Option+R |
| Stop Background Processes | Ctrl+Shift+F2 | Cmd+Shift+F2 |
| Step Over | F8 | F8 |
| Force Step Over | Alt+Shift+F8 | Option+Shift+F8 |
| Step Into | F7 | F7 |
| Smart Step Into | Shift+F7 | Shift+F7 |
| Force Step Into | Alt+Shift+F7 | Option+Shift+F7 |
| Step Out | Shift+F8 | Shift+F8 |
| Run to Cursor | Alt+F9 | Option+F9 |
| Force Run to Cursor | Ctrl+Alt+F9 | Cmd+Option+F9 |
| Show Execution Point | Alt+F10 | Option+F10 |
| Evaluate Expression | Alt+F8 | Option+F8 |
| Quick Evaluate Expression | Ctrl+Alt+F8 | Cmd+Option+F8 |
| Toggle Line Breakpoint | Ctrl+F8 | Cmd+F8 |
| Toggle temporary breakpoint | Ctrl+Alt+Shift+F8 | Cmd+Option+Shift+F8 |
| View Breakpoints | Ctrl+Shift+F8 | Cmd+Shift+F8 |
| Edit BreakpointListed by the vendor on the same key as View Breakpoints. | Ctrl+Shift+F8 | Cmd+Shift+F8 |
Refactorings 6
| Action | Windows / Linux | Mac |
|---|---|---|
| Refactor This | Ctrl+Alt+Shift+T | Ctrl+T |
| RenameAlso renames the item selected in the Database Explorer, or a query console in the Files tool window. | Shift+F6 | Shift+F6 |
| Change SignatureShares its key with Modify Object, which opens the Modify dialog for a table or other database object. | Ctrl+F6 | Cmd+F6 |
| MoveIn the Database Explorer the same key moves a data source into a folder. | F6 | F6 |
| Introduce Parameter | Ctrl+Alt+P | Cmd+Option+P |
| Introduce Variable | Ctrl+Alt+V | Cmd+Option+V |
Version control 7
| Action | Windows / Linux | Mac |
|---|---|---|
| VCS Operations Popup | Alt+` | Ctrl+V |
| CommitThe help also shows this key next to Submit when the source code of a database object is being edited. | Ctrl+K | Cmd+K |
| Update Project | Ctrl+T | Cmd+T |
| RollbackIn a data editor the same key reverts cell changes that have not been submitted yet. | Ctrl+Alt+Z | Cmd+Option+Z |
| Push | Ctrl+Shift+K | Cmd+Shift+K |
| Next Change | Ctrl+Alt+Shift+Down | Ctrl+Option+Shift+Down |
| Previous Change | Ctrl+Alt+Shift+Up | Ctrl+Option+Shift+Up |
Diff viewer 8
| Action | Windows / Linux | Mac |
|---|---|---|
| Show DiffWith two objects of the same kind selected in the Database Explorer, it compares their structure. | Ctrl+D | Cmd+D |
| Compare Files | Ctrl+D | Cmd+D |
| Next Difference | F7 | F7 |
| Previous Difference | Shift+F7 | Shift+F7 |
| Accept Left Side | Ctrl+Alt+R | Cmd+Ctrl+Right |
| Accept Right Side | Ctrl+Alt+A | Cmd+Ctrl+Left |
| Select Opposite Diff Pane | Ctrl+Shift+Tab | Ctrl+Shift+Tab |
| Diff viewer settings | Ctrl+Shift+D | Cmd+Shift+D |
Tool windows 18
| Action | Windows / Linux | Mac |
|---|---|---|
| Hide Active Tool Window | Shift+Esc | Shift+Esc |
| Hide All Tool Windows | Ctrl+Shift+F12 | Cmd+Shift+F12 |
| Focus last tool window | F12 | F12 |
| Stretch to LeftThe macOS keymap drops Shift for the four Stretch actions: Ctrl and Option with an arrow. | Ctrl+Alt+Shift+Left | Ctrl+Option+Left |
| Stretch to Right | Ctrl+Alt+Shift+Right | Ctrl+Option+Right |
| Stretch to Top | Ctrl+Alt+Shift+Up | Ctrl+Option+Up |
| Stretch to Bottom | Ctrl+Alt+Shift+Down | Ctrl+Option+Down |
| Show Database ExplorerAlt + 1 is what the help shows with its XWin (Linux) keymap selected; the Windows keymap page prints N/A for this window. | Alt+1 | Cmd+1 |
| Show Files windowIts Scratches and Consoles node holds the Database Consoles directory with every query console. | Alt+2 | Cmd+2 |
| Show Find windowResults of a full-text search in a database are reviewed in this window. | Alt+3 | Cmd+3 |
| Show Run window | Alt+4 | Cmd+4 |
| Show Debug window | Alt+5 | Cmd+5 |
| Show Problems window | Alt+6 | Cmd+6 |
| Show Structure windowStatements selected in this window can be executed from its context menu. | Alt+7 | Cmd+7 |
| Show Services windowThe Query Plan tab with the tree of an execution plan opens in this window. | Alt+8 | Cmd+8 |
| Show Version Control window | Alt+9 | Cmd+9 |
| Show Commit window | Alt+0 | Cmd+0 |
| Show Terminal window | Alt+F12 | Option+F12 |
No row on this page matches that filter.
Notes
Running SQL in a console
Select a data source in the Database Explorer and press F4 to open its default console, already connected; Ctrl + Shift + Q creates one more console for that source, and Ctrl + Shift + F10 pops up the consoles it already has. Inside a console, Ctrl + Enter runs the statement at the caret or the selected text, and when more than one statement qualifies a chooser appears whose list always offers running them all. Ctrl + Alt + E brings back anything executed earlier from the query history, and once Explain Plan has run, Ctrl + Alt + Shift + U redraws the plan as a diagram. The macOS keymap uses Cmd + Down, Cmd + Shift + L, Cmd + Shift + F10, Cmd + Return, Cmd + Option + E and Cmd + Option + Shift + U. SQL files selected in the Files tool window run with Ctrl + Shift + F10 too, which is Ctrl + Shift + R on a Mac.
Editing rows in the data editor
Table data opens in a grid where nothing reaches the server until you submit. Alt + Insert adds a row, Ctrl + D clones the current one to the end of the table, and Ctrl + Y deletes the selected rows. Enter edits a cell in place, Shift + Enter opens the cell in a value editor of its own, where Enter starts a new line, and Ctrl + Alt + N or Ctrl + Alt + D writes NULL or the column default. Ctrl + Enter sends the edits, Ctrl + Alt + Z takes back those not yet sent, and in manual transaction mode Ctrl + Alt + Shift + Enter submits and commits together. A query returns 500 rows at a time unless you change the limit; Ctrl + Alt + Down and Ctrl + Alt + Up page through the rest, and Ctrl + G takes a column:row pair to land on one cell. F4 on a row jumps to the records it references or that reference it, and Ctrl + Shift + C copies one aggregate of the selected cells, SUM unless you pick another.
Database Explorer tasks
In the tree, Ctrl + F5 re-reads the selected object, while Ctrl + Shift + F5 throws away what is cached for a data source and loads it again. Ctrl + Alt + G opens the SQL Generator for the DDL of anything from one table to all tables of a schema; Ctrl + Alt + Shift + G copies that DDL directly, and Ctrl + Alt + Shift + B writes it into a query console. F5 copies a table into another schema or data source, from MySQL to PostgreSQL for instance, and Ctrl + C on a data source puts its connection settings on the clipboard as XML. Ctrl + Alt + U shows a diagram of a table or a whole source in a popup, Ctrl + F6 opens the Modify dialog, Ctrl + F2 disconnects a data source, and F6 files data sources into folders. From a statement or the grid, Alt + Shift + B highlights the object at the caret in the tree.
Editor keys with a database meaning
Several familiar keys take on a database role here. Ctrl + Q on a table name in a statement previews its structure, and Ctrl + Shift + Enter adds what a CREATE TABLE or a function call still lacks, such as closing parentheses. In a data editor cell Ctrl + Space lists values to choose from, Ctrl + F12 lists the columns, where Space hides or shows one, and Ctrl + F2 cancels the statements still running. Alt + Insert in the code editor offers database objects to create, for example a table, schema, function or procedure, and Shift + F6 renames whatever is selected in the Database Explorer, or a query console in the Files tool window. On a Mac these become F1, Cmd + Shift + Return, Ctrl + Space, Cmd + F12, Cmd + F2, Cmd + N and Shift + F6.
Questions
Which key runs the current statement in DataGrip?
Ctrl + Enter, or Cmd + Return in the macOS keymap. When the console holds more than one statement, a chooser offers the one at the caret or all of them together. In a data editor the same key submits pending edits to the database instead.
Is there a default key for Explain Plan?
The DataGrip 2026.2 help gives none: Explain Plan sits in a dropdown on the code editor toolbar and in the editor's context menu. Once a plan is shown, Ctrl + Alt + Shift + U (Cmd + Option + Shift + U on a Mac) draws it as a diagram. Settings › Keymap can assign a key to any action that lacks one.
How do I commit or roll back from the keyboard?
In manual transaction mode Ctrl + Alt + Shift + Enter (Cmd + Option + Shift + Return on a Mac) submits the pending edits and commits the transaction. The help prints no key for Roll Back, which is a toolbar button. Ctrl + Alt + Z reverts only cell edits that have not been submitted yet.
Why does Ctrl + Y open a dialog the first time?
On Windows the key can mean Delete Line or Redo. Since version 2019.2 the first press asks which of the two it should be, and the choice can be changed later in Settings › Keymap.
How do I copy a table to another database?
Select the table in the Database Explorer and press F5, the same key in both keymaps, to open Copy Table to. The copy can go to a different schema or to another data source, so a MySQL table can be copied into PostgreSQL.
Does DataGrip have a Linux keymap?
The keymap pages of the help cover Windows and macOS. DataGrip itself proposes a predefined keymap that suits the system it runs on; GNOME and KDE keymaps are plugins, found on the Marketplace tab of Plugins by searching for keymap. The help's keymap selector also lists XWin, which matches the Windows column apart from a few keys such as Surround With.
Sources and checks
- JetBrains — DataGrip 2026.2 Help: Predefined Windows keymap Windows / Linux column of the main list
- JetBrains — DataGrip 2026.2 Help: Predefined macOS keymap Mac column of the main list
- JetBrains — DataGrip 2026.2 Help: Keyboard shortcuts (Windows and macOS keymaps) DataGrip-specific top shortcuts; notes on keymaps
- JetBrains — DataGrip 2026.2 Help: Run queries (Windows and macOS keymaps) Executing statements, query history
- JetBrains — DataGrip 2026.2 Help: Query consoles (Windows and macOS keymaps) Creating and opening query consoles
- JetBrains — DataGrip 2026.2 Help: Data editor and viewer (Windows and macOS keymaps) Data editor toolbar and context menu keys
11 more source pages
- JetBrains — DataGrip 2026.2 Help: Database Explorer (Windows and macOS keymaps) Database Explorer toolbar and context menu keys
- JetBrains — DataGrip 2026.2 Help: Work with SQL code (Windows and macOS keymaps) Folding to a level, custom folding regions
- JetBrains — DataGrip 2026.2 Help: Rows (Windows and macOS keymaps) Adding, cloning and deleting rows
- JetBrains — DataGrip 2026.2 Help: View data (Windows and macOS keymaps) Single record view
- JetBrains — DataGrip 2026.2 Help: Query execution plan (Windows and macOS keymaps) Plan diagram
- JetBrains — DataGrip 2026.2 Help: Filter data (Windows and macOS keymaps) Showing the row filter
- JetBrains — DataGrip 2026.2 Help: Database object and file navigation (Windows and macOS keymaps) Navigation bar, file path
- JetBrains — DataGrip 2026.2 Help: Run files (Windows and macOS keymaps) Running SQL files
- JetBrains — DataGrip 2026.2 Help: Multiple cursors and selection ranges (Windows and macOS keymaps) How the double-press caret keys work
- JetBrains — DataGrip 2026.2 Help: Query consoles (XWin keymap selected) Database Explorer key in the Linux (XWin) keymap
- JetBrains — DataGrip 2026.2 Help: Work with SQL code (XWin keymap selected) Where the Linux (XWin) keymap differs
Every row on this page was matched to a line in the documentation above on . A binding that could not be found there is not listed.
Found a wrong or missing key? Tell us and it gets checked against the source. How we verify describes the process and its limits.