Make it yours

Keyboard shortcuts

Every default shortcut on macOS, Windows and Linux, and how to change them.

TableGrip is built to be driven from the keyboard. Press ⇧ ⌘ / in the app to see this list, and change any shortcut in Settings → Keymap.

#General

ActionmacOSWindows / Linux
Go to anything⌘ P, or ⇧ ⇧Ctrl P, or Shift Shift
New console for the current connection⌘ TCtrl T
Close tab⌘ WCtrl W
Next / previous tab⇧ ⌘ ] / ⇧ ⌘ [, or ⌃ Tab / ⌃ ⇧ TabCtrl PgDn / Ctrl PgUp, or Ctrl Tab / Ctrl Shift Tab
Connections⌘ 1Alt 1
Query History⌘ 2Alt 2
Agent⌘ 3Alt 3
Saved Queries⌘ 4Alt 4
Mention the selection in the agent chat⌘ LCtrl L
Show / hide the sidebar⌘ BCtrl B
Zoom in · out · reset⌘ = · ⌘ - · ⌘ 0Ctrl = · Ctrl - · Ctrl 0
Activity: sessions and locks⌥ ⌘ ACtrl Alt A
Settings⌘ ,Ctrl Alt S
Keyboard shortcuts⇧ ⌘ /Ctrl Shift /

#Console

ActionmacOSWindows / Linux
Run the statement at the caret, or the selection⌘ ↩Ctrl Enter
Run the script⇧ ⌘ ↩Ctrl Shift Enter
Cancel the running query⌘ .Ctrl F2
Explain plan⇧ ⌘ ECtrl Shift E
Save query⌘ SCtrl S
Save script to a file⇧ ⌘ SCtrl Shift S

#SQL editor

ActionmacOSWindows / Linux
Completion⌃ SpaceCtrl Space
Comment / uncomment lines⌘ /Ctrl /
Duplicate line or selection⌘ DCtrl D
Delete line⌘ ⌫Ctrl Y
Move line up / down⌥ ⇧ ↑ / ↓Alt Shift ↑ / ↓
Reformat SQL⌥ ⌘ LCtrl Alt L
Find · replace⌘ F · ⌘ RCtrl F · Ctrl R
Indent / outdentTab / ⇧ TabTab / Shift Tab

#Data grid

ActionmacOSWindows / Linux
Copy · copy with header⌘ C · ⇧ ⌘ CCtrl C · Ctrl Shift C
Select all⌘ ACtrl A
Edit cell↩ or F2Enter or F2
Open a larger cell editor⇧ ↩Shift Enter
Set cell to NULL⌥ ⌘ NCtrl Alt N
Add row⌘ NCtrl N
Delete rows⌘ ⌫Ctrl Backspace
Undo · redo⌘ Z · ⇧ ⌘ Z or ⌘ YCtrl Z · Ctrl Shift Z or Ctrl Y
Revert rows⌥ ⌘ ZCtrl Alt Z
Submit changes⌘ ↩ or ⌘ SCtrl Enter or Ctrl S
Reload table⌘ RCtrl R
Go to the row a foreign key points at⌘ BCtrl B

#Table filter

ActionmacOSWindows / Linux
Focus the filter⌘ FCtrl F
Filter by the selected cell's value⌥ ⌘ FCtrl Alt F
Exclude the selected cell's value⌥ ⇧ ⌘ FCtrl Alt Shift F
Switch between Builder and SQL⇧ ⌘ FCtrl Shift F
Clear the filter⇧ ⌘ ⌫Ctrl Shift Backspace
Back to the gridEscEsc

#Inside the filter builder

ActionmacOSWindows / Linux
Apply↩ or ⌘ ↩Enter or Ctrl Enter
Add a condition below⌘ NCtrl N
Add a group below⇧ ⌘ NCtrl Shift N
Add a SQL condition below⌥ ⌘ NCtrl Alt N
Choose the column · the operator⌥ ⌘ C · ⌥ ⌘ OCtrl Alt C · Ctrl Alt O
Switch the group between all / any⇧ ⌘ ACtrl Shift A
Match case⌥ CAlt C
Previous / next condition↑ / ↓↑ / ↓

#MongoDB documents

ActionmacOSWindows / Linux
Show / hide the query builder⇧ ⌘ FCtrl Shift F
Add document⌘ NCtrl N
Submit changes⌘ ↩ or ⌘ SCtrl Enter or Ctrl S

#Keymap presets

Coming from another tool? Settings → Keymap → Preset switches a set of shortcuts at once:

PresetChanges
TableGripThe defaults above
DataGrip / IntelliJCancel query: ⌘ F2 · Go to anything: ⌘ O
VS CodeAgent: ⌃ ⌘ I · Next / previous tab: ⌥ ⌘ → / ← · Duplicate: ⌥ ⇧ ↓ · Delete line: ⇧ ⌘ K · Move line: ⌥ ↑ / ↓ · Reformat: ⌥ ⇧ F · Replace: ⌥ ⌘ F (Ctrl H on Windows / Linux)

#Change a shortcut

In Settings → Keymap, search for an action or a key, click its shortcut and press the new one. TableGrip warns when the new shortcut clashes with another action, and each action can be reset on its own. Your changes are saved as keyBindings in settings.json.