DataGrip keyboard shortcuts for Windows, Linux and Mac

DataGrip 2026.2 shortcuts taken from JetBrains' DataGrip help: the Windows keymap on the left, which the help's XWin keymap follows except for a few keys, and the macOS keymap on the right. Besides general editing, the rows cover the query console, the grid of the data editor and the Database Explorer tree; Emacs, Sublime Text and other optional keymaps are not included. One key does double duty: Ctrl + Enter runs a statement in a console and submits grid edits, and on a Mac it is Cmd + Return.

249 shortcuts in 18 sections. Checked row by row against JetBrains on . Edited by Jay.

Query console 7

ActionWindows / LinuxMac
Execute statementIf the console holds several statements DataGrip shows a chooser; the list always includes an option to run all of them.Ctrl+EnterCmd+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.F4Cmd+Down
New query consoleCreates a further console for the selected data source in one step, without going through the New menu.Ctrl+Shift+QCmd+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+F10Cmd+Shift+F10
Browse Query HistoryThe dialog keeps every statement that has been run in a query console.Ctrl+Alt+ECmd+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+UCmd+Option+Shift+U
Run selected SQL filesWith SQL files selected in the Files tool window, runs them through a temporary run configuration.Ctrl+Shift+F10Ctrl+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.

ActionWindows / LinuxMac
Submit changesSends the edits made in the grid to the database server; until then they are local only.Ctrl+EnterCmd+Return
Submit and CommitManual transaction mode only: submits the edits and commits the current transaction in one step.Ctrl+Alt+Shift+EnterCmd+Option+Shift+Return
Revert SelectedUndoes unsubmitted edits in the selected cell or in a whole range of cells.Ctrl+Alt+ZCmd+Option+Z
Add RowThe new row reaches the database only after Submit.Alt+InsertCmd+N
Delete RowWorks on several rows at once; pick them by clicking their numbers in the gutter.Ctrl+YCmd+Backspace
Clone RowThe copy is appended as the last row of the table.Ctrl+DCmd+D
Edit cell valueDouble-clicking the cell does the same; the command is unavailable for read-only values.EnterReturn
Open in Value EditorShows the content of the cell in an editor of its own, where Enter starts a new line.Shift+EnterShift+Return
Set DEFAULTWrites the default value defined for the column into the current cell.Ctrl+Alt+DCmd+Option+D
Set NULLReplaces the content of the current cell with NULL.Ctrl+Alt+NCmd+Option+N
Copy aggregation resultPuts one summary value for the selected cells on the clipboard; SUM is the default aggregation.Ctrl+Shift+CCmd+Shift+C
Show column listLists every column in a popup, where Space hides or shows the selected one.Ctrl+F12Cmd+F12
Reload PageBrings the grid in line with what the database holds now, and applies a changed page size.Ctrl+F5Cmd+R
Previous PageSteps back one page of a result set that is larger than the page size.Ctrl+Alt+UpCmd+Option+Up
Next PageLoads the following page; by default a query returns at most 500 rows at a time.Ctrl+Alt+DownCmd+Option+Down
Go to RowThe dialog accepts a column:row pair, so one entry can target an exact cell.Ctrl+GCmd+L
Go to related rowsOpens the records the current row references, or the ones that reference it.F4Cmd+Down
Go to related symbolThe data editor menu lists DDL, which opens the object definition, on the same key.Ctrl+Alt+BCmd+Option+B
Show row filterBrings back the filter field of the grid when it is not shown.Ctrl+Alt+Shift+FCmd+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+EnterCmd+Shift+Return
Cancel Running StatementsCtrl+F2Cmd+F2

Database Explorer 21

ActionWindows / LinuxMac
New data source or objectThe New menu creates a data source or, with one selected, items such as a query console.Alt+InsertCmd+N
Data Source PropertiesOpens the dialog where data sources and drivers are managed; the macOS key is Cmd with semicolon.Ctrl+Alt+Shift+SCmd+;
RefreshRe-reads the selected element from the database so the tree matches its actual state.Ctrl+F5Cmd+R
Force RefreshThrows away what is cached for the data source and loads it afresh; offered on data source nodes only.Ctrl+Shift+F5Cmd+Option+Shift+R
Deactivate data sourceDisconnects the selected data sources; offered only while they have an active connection.Ctrl+F2Cmd+F2
Edit DataOpens a table, view or materialized view in the data editor; it works on a table name inside a statement too.F4Cmd+Down
Modify ObjectOpens the Modify dialog for the selected object; Modify Table in the data editor uses the same key.Ctrl+F6Cmd+F6
Select in Database ExplorerFrom a statement or a data editor, highlights the object at the caret in the Database Explorer tree.Alt+Shift+BOption+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+FCmd+Option+Shift+F
SQL GeneratorProduces DDL for the selected objects, from a single table up to all tables of a schema.Ctrl+Alt+GCmd+Option+G
DDL to clipboardCopies the DDL of the selected object straight to the clipboard, without opening the generator.Ctrl+Alt+Shift+GCmd+Option+Shift+G
DDL to query consoleWrites the DDL of the selected object into a query console instead of the clipboard.Ctrl+Alt+Shift+BCmd+Option+Shift+B
Copy Data SourcePlaces the connection settings of the data source on the clipboard as an XML snippet.Ctrl+CCmd+C
Duplicate data sourceThe Data Sources and Drivers dialog opens so the properties of the copy can be set.Ctrl+DCmd+D
Move to folderGroups data sources; if no folder exists yet, the first one is created in the popup.F6F6
Copy Table toThe copy can go to another schema or data source, for example from MySQL to PostgreSQL.F5F5
Drop object or remove data sourceDrops the selected database object; on a data source node it removes the data source.DeleteDelete
Show DiagramOpens a diagram of the chosen table or whole data source in an editor tab of its own.Ctrl+Alt+Shift+UCmd+Option+Shift+U
Show Diagram PopupShows the same diagram in a popup instead of an editor tab.Ctrl+Alt+UCmd+Option+U
Expand all nodesCtrl+Num +Cmd+Num +
Collapse all nodesCtrl+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.

ActionWindows / LinuxMac
Search EverywhereA double tap of Shift opens one box that finds files, actions, symbols, tool windows and settings.ShiftthenShiftShiftthenShift
Find ActionRuns a command, opens a tool window or looks up a setting once you type part of its name.Ctrl+Shift+ACmd+Shift+A
Open SettingsThe Keymap page of this dialog lists every binding and is where any of them can be changed.Ctrl+Alt+SCmd+,
Run AnythingA double tap of Ctrl in both keymaps, not a chord.CtrlthenCtrlCtrlthenCtrl
Save AllCtrl+SCmd+S
New scratch fileCtrl+Alt+Shift+InsertCmd+Shift+N
SwitcherStays on Ctrl with Tab in the macOS keymap instead of moving to Cmd.Ctrl+TabCtrl+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.

ActionWindows / LinuxMac
CutCtrl+XCmd+X
CopyWith nothing selected, the whole line under the caret goes to the clipboard.Ctrl+CCmd+C
PasteCtrl+VCmd+V
Paste as Plain TextSkips the smart paste that would otherwise adjust the inserted lines, for example by adding comment markers.Ctrl+Alt+Shift+VCmd+Option+Shift+V
Paste from HistoryOpens a dialog of earlier clipboard entries so an older copy can be inserted.Ctrl+Shift+VCmd+Shift+V
Copy PathsCtrl+Shift+CCmd+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+CCmd+Option+Shift+C
UndoCtrl+ZCmd+Z
RedoCtrl+Shift+ZCmd+Shift+Z
Indent SelectionTabTab
Unindent Line or SelectionShift+TabShift+Tab
Auto-Indent LinesCtrl+Alt+ICtrl+Option+I
Start New LineAdds a line below the current one and puts the caret on it, wherever the caret was.Shift+EnterShift+Return
Start new line aboveAdds a line above the current one and puts the caret there.Ctrl+Alt+EnterCmd+Option+Return
Delete LineOn Windows the first press shows a dialog asking whether this key should delete a line or redo.Ctrl+YCmd+Backspace
Join LinesAppends the following line to the one holding the caret; repeat until everything needed is on one line.Ctrl+Shift+JCtrl+Shift+J
Duplicate Line or SelectionCtrl+DCmd+D
Toggle CaseFlips the selected fragment between upper and lower case; a CamelCase name comes out in lower case.Ctrl+Shift+UCmd+Shift+U
Move Statement UpCarries the statement at the caret above the previous one and checks the syntax while doing it.Ctrl+Shift+UpCmd+Shift+Up
Move Statement DownCarries the statement at the caret below the following one, again with a syntax check.Ctrl+Shift+DownCmd+Shift+Down
Move Element LeftCtrl+Alt+Shift+LeftCmd+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+RightCmd+Option+Shift+Right
Move Line UpShifts just the caret's line; the statement version uses Ctrl or Cmd with Shift instead.Alt+Shift+UpOption+Shift+Up
Move Line DownAlt+Shift+DownOption+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

ActionWindows / LinuxMac
Show Intention ActionsLists fixes for the problem highlighted at the caret, along with other context actions.Alt+EnterOption+Return
Basic CompletionKeeps Ctrl with Space on macOS; in a data editor cell it opens the list of values to pick from.Ctrl+SpaceCtrl+Space
Type-Matching CompletionCtrl+Shift+SpaceCtrl+Shift+Space
Second Basic CompletionCtrl+Alt+SpaceCtrl+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+EnterCmd+Shift+Return
Reformat CodeCtrl+Alt+LCmd+Option+L
Parameter InfoCtrl+PCmd+P
Quick DocumentationOn a table name in a statement it previews the table structure; the macOS key is plain F1.Ctrl+QF1
Surround WithThe popup includes the comment pairs that turn the selected fragment into a custom folding region.Ctrl+Alt+TCmd+Option+T
GenerateOffers database entities to create, for example a table, schema, function or procedure.Alt+InsertCmd+N

Caret navigation 15

ActionWindows / LinuxMac
Caret to previous wordCtrl+LeftOption+Left
Caret to next wordCtrl+RightOption+Right
Caret to line startHome on a PC keyboard; the macOS keymap uses Cmd with the Left arrow.HomeCmd+Left
Caret to line endEnd on a PC keyboard; the macOS keymap uses Cmd with the Right arrow.EndCmd+Right
Caret to matching braceThe macOS keymap drops Shift here and uses Ctrl with M.Ctrl+Shift+MCtrl+M
Jump to code block startCtrl+[Cmd+Option+[
Jump to code block endCtrl+]Cmd+Option+]
Next MethodAlt+DownCtrl+Shift+Down
Previous MethodAlt+UpCtrl+Shift+Up
Caret to page topCtrl+Page UpCmd+Page Up
Caret to page bottomCtrl+Page DownCmd+Page Down
Page UpPage UpPage Up
Page DownPage DownPage Down
Caret to start of fileCtrl+HomeCmd+Home
Caret to end of fileCtrl+EndCmd+End

Select text 19

ActionWindows / LinuxMac
Select AllCtrl+ACmd+A
Extend selection leftShift+LeftShift+Left
Extend selection rightShift+RightShift+Right
Select to previous wordCtrl+Shift+LeftOption+Shift+Left
Select to next wordCtrl+Shift+RightOption+Shift+Right
Select to line startShift+HomeCmd+Shift+Left
Select to line endShift+EndCmd+Shift+Right
Extend selection upShift+UpShift+Up
Extend selection downShift+DownShift+Down
Select to code block startCtrl+Shift+[Cmd+Option+Shift+[
Select to code block endCtrl+Shift+]Cmd+Option+Shift+]
Select to page topCtrl+Shift+Page UpCmd+Shift+Page Up
Select to page bottomCtrl+Shift+Page DownCmd+Shift+Page Down
Select a page upShift+Page UpShift+Page Up
Select a page downShift+Page DownShift+Page Down
Select to start of fileCtrl+Shift+HomeCmd+Shift+Home
Select to end of fileCtrl+Shift+EndCmd+Shift+End
Extend SelectionEach press widens the selection to the next larger construct; in plain text from word to sentence to paragraph.Ctrl+WOption+Up
Shrink SelectionTakes back one step of Extend Selection, narrowing toward where the caret started.Ctrl+Shift+WOption+Down

Code folding 10

ActionWindows / LinuxMac
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-5Cmd+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-5Cmd+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.

ActionWindows / LinuxMac
Add or remove a caretAlt+Shift+ClickOption+Shift+Click
Toggle Column Selection ModeAlt+Shift+InsertCmd+Shift+8
Clone Caret AbovePress the modifier twice, keep it down the second time, then press Up.CtrlthenCtrl+UpOptionthenOption+Up
Clone Caret BelowPress the modifier twice, keep it down the second time, then press Down.CtrlthenCtrl+DownOptionthenOption+Down
Carets on every selected lineAlt+Shift+GOption+Shift+G
Select next occurrenceAlt+JCtrl+G
Select All OccurrencesCtrl+Alt+Shift+JCmd+Ctrl+G
Deselect last occurrenceRemoves the occurrence that Select next occurrence added most recently.Alt+Shift+JCtrl+Shift+G
Rectangular selection to clickA middle-click with these modifiers, not a drag.Alt+Shift+Middle-clickOption+Shift+Middle-click
Rectangular selection by draggingHold the modifier and drag with the primary mouse button.Alt+ClickOption+Click
Add another rectangular selectionDragging with all three modifiers adds a block and keeps the ones already made.Ctrl+Alt+Shift+ClickCmd+Option+Shift+Click

Context navigation 24

ActionWindows / LinuxMac
Go to Line or ColumnIn a data editor the same key opens Go to Row, which takes a column:row pattern.Ctrl+GCmd+L
Select InFrom a console, an object definition or a file, pops up the views in which the current item can be shown.Alt+F1Option+F1
Recent FilesThe list covers recently opened query consoles as well as files.Ctrl+ECmd+E
Recent ChangesAlt+Shift+COption+Shift+C
Last Edit LocationCtrl+Shift+BackspaceCmd+Shift+Backspace
Navigate backCtrl+Alt+LeftCmd+[
Navigate forwardCtrl+Alt+RightCmd+]
Next editor tabAlt+RightCmd+Shift+]
Previous editor tabAlt+LeftCmd+Shift+[
Open file in new windowShift+F4Shift+F4
Toggle anonymous bookmarkAlso bookmarks the item selected in the Database Explorer; the macOS keymap uses F3.F11F3
Toggle bookmark with digitHold the modifiers and press the digit, 0 to 9, that the bookmark should carry.Ctrl+Shift+0-9Ctrl+Shift+0-9
Toggle mnemonic bookmarkCtrl+F11Option+F3
Show all bookmarksShift+F11Cmd+F3
Go to numbered bookmarkHold Ctrl and press the bookmark's digit; the modifier is Ctrl in the macOS keymap too.Ctrl+0-9Ctrl+0-9
Show Mnemonic BookmarksCtrl+Shift+F11Cmd+Option+F3
Next OccurrenceIn a data editor this key moves to the following page of the result set instead.Ctrl+Alt+DownCmd+Option+Down
Previous OccurrenceIn a data editor this key moves back one page of the result set instead.Ctrl+Alt+UpCmd+Option+Up
Find UsagesCollects every place in the project where the element at the caret is used.Alt+F7Option+F7
Go to DeclarationOn a table name in a statement it opens that table's DDL; DataGrip's own pages call it Go to DDL.Ctrl+BCmd+B
Show UsagesCtrl+Alt+F7Cmd+Option+F7
Highlight Usages in FileCtrl+Shift+F7Cmd+Shift+F7
Jump to Navigation BarThen move with the arrow keys and press Enter to open the chosen database object or file.Alt+HomeCmd+Up
Show file pathPops up the directories on the path of the file being edited, so any of them can be opened.Ctrl+Alt+F12Cmd+Option+F12

Find everything 10

ActionWindows / LinuxMac
FindSearches the open file; in a data editor it searches the current page of results.Ctrl+FCmd+F
Find NextF3 on Windows; the macOS keymap uses Cmd with G.F3Cmd+G
Find PreviousShift+F3Cmd+Shift+G
ReplaceCtrl+RCmd+R
Find in FilesCtrl+Shift+FCmd+Shift+F
Replace in FilesCtrl+Shift+RCmd+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 FileCtrl+Shift+NCmd+Shift+O
File StructureIn a data editor this key opens the full column list instead.Ctrl+F12Cmd+F12
Go to SymbolCtrl+Alt+Shift+NCmd+Option+O

Code analysis 4

ActionWindows / LinuxMac
Error DescriptionCtrl+F1Cmd+F1
Next Highlighted ErrorJumps forward to the nearest problem highlighted in the SQL file.F2F2
Previous Highlighted ErrorJumps back to the problem highlighted before the caret.Shift+F2Shift+F2
Run Inspection by NameCtrl+Alt+Shift+ICmd+Option+Shift+I

Run and debug 23

ActionWindows / LinuxMac
RunThe macOS keymap puts Run on Ctrl with R; the vendor table names it the context configuration.Shift+F10Ctrl+R
Choose configuration and runPressing 0 in the popup that appears opens the Run/Debug Configurations dialog.Alt+Shift+F10Ctrl+Option+R
DebugShift+F9Ctrl+D
Choose configuration and debugAlt+Shift+F9Ctrl+Option+D
Attach to ProcessCtrl+Alt+F5Option+Shift+F5
StopIn the Run tool window it asks which process to end; in a data editor it cancels the running statements.Ctrl+F2Cmd+F2
Resume ProgramF9Cmd+Option+R
Stop Background ProcessesCtrl+Shift+F2Cmd+Shift+F2
Step OverF8F8
Force Step OverAlt+Shift+F8Option+Shift+F8
Step IntoF7F7
Smart Step IntoShift+F7Shift+F7
Force Step IntoAlt+Shift+F7Option+Shift+F7
Step OutShift+F8Shift+F8
Run to CursorAlt+F9Option+F9
Force Run to CursorCtrl+Alt+F9Cmd+Option+F9
Show Execution PointAlt+F10Option+F10
Evaluate ExpressionAlt+F8Option+F8
Quick Evaluate ExpressionCtrl+Alt+F8Cmd+Option+F8
Toggle Line BreakpointCtrl+F8Cmd+F8
Toggle temporary breakpointCtrl+Alt+Shift+F8Cmd+Option+Shift+F8
View BreakpointsCtrl+Shift+F8Cmd+Shift+F8
Edit BreakpointListed by the vendor on the same key as View Breakpoints.Ctrl+Shift+F8Cmd+Shift+F8

Refactorings 6

ActionWindows / LinuxMac
Refactor ThisCtrl+Alt+Shift+TCtrl+T
RenameAlso renames the item selected in the Database Explorer, or a query console in the Files tool window.Shift+F6Shift+F6
Change SignatureShares its key with Modify Object, which opens the Modify dialog for a table or other database object.Ctrl+F6Cmd+F6
MoveIn the Database Explorer the same key moves a data source into a folder.F6F6
Introduce ParameterCtrl+Alt+PCmd+Option+P
Introduce VariableCtrl+Alt+VCmd+Option+V

Version control 7

ActionWindows / LinuxMac
VCS Operations PopupAlt+`Ctrl+V
CommitThe help also shows this key next to Submit when the source code of a database object is being edited.Ctrl+KCmd+K
Update ProjectCtrl+TCmd+T
RollbackIn a data editor the same key reverts cell changes that have not been submitted yet.Ctrl+Alt+ZCmd+Option+Z
PushCtrl+Shift+KCmd+Shift+K
Next ChangeCtrl+Alt+Shift+DownCtrl+Option+Shift+Down
Previous ChangeCtrl+Alt+Shift+UpCtrl+Option+Shift+Up

Diff viewer 8

ActionWindows / LinuxMac
Show DiffWith two objects of the same kind selected in the Database Explorer, it compares their structure.Ctrl+DCmd+D
Compare FilesCtrl+DCmd+D
Next DifferenceF7F7
Previous DifferenceShift+F7Shift+F7
Accept Left SideCtrl+Alt+RCmd+Ctrl+Right
Accept Right SideCtrl+Alt+ACmd+Ctrl+Left
Select Opposite Diff PaneCtrl+Shift+TabCtrl+Shift+Tab
Diff viewer settingsCtrl+Shift+DCmd+Shift+D

Tool windows 18

ActionWindows / LinuxMac
Hide Active Tool WindowShift+EscShift+Esc
Hide All Tool WindowsCtrl+Shift+F12Cmd+Shift+F12
Focus last tool windowF12F12
Stretch to LeftThe macOS keymap drops Shift for the four Stretch actions: Ctrl and Option with an arrow.Ctrl+Alt+Shift+LeftCtrl+Option+Left
Stretch to RightCtrl+Alt+Shift+RightCtrl+Option+Right
Stretch to TopCtrl+Alt+Shift+UpCtrl+Option+Up
Stretch to BottomCtrl+Alt+Shift+DownCtrl+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+1Cmd+1
Show Files windowIts Scratches and Consoles node holds the Database Consoles directory with every query console.Alt+2Cmd+2
Show Find windowResults of a full-text search in a database are reviewed in this window.Alt+3Cmd+3
Show Run windowAlt+4Cmd+4
Show Debug windowAlt+5Cmd+5
Show Problems windowAlt+6Cmd+6
Show Structure windowStatements selected in this window can be executed from its context menu.Alt+7Cmd+7
Show Services windowThe Query Plan tab with the tree of an execution plan opens in this window.Alt+8Cmd+8
Show Version Control windowAlt+9Cmd+9
Show Commit windowAlt+0Cmd+0
Show Terminal windowAlt+F12Option+F12

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

11 more source pages

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.