Skip to main content

Keyboard shortcuts

On Windows and Linux, Cmd is Ctrl and Option is Alt. The menus and the command palette show each shortcut as your system writes it. Panel and window shortcuts can be changed.

Files, connections and tabs​

ActionmacOSWindows / Linux
New query tab (File > New SQL Tab)Cmd+TCtrl+T
New QueryCmd+NCtrl+N
Open...Cmd+OCtrl+O
Quick Open...Cmd+PCtrl+P
Save (file tab)Cmd+SCtrl+S
New Connection...Shift+Cmd+NShift+Ctrl+N
Edit Connection...Cmd+ECtrl+E
Connect / DisconnectCmd+DCtrl+D
Switch Tab...Ctrl+TabCtrl+Tab
Settings...Cmd+,Ctrl+,
Quit LumeCmd+QCtrl+Q

Editing​

ActionmacOSWindows / Linux
Undo / RedoCmd+Z / Shift+Cmd+ZCtrl+Z / Shift+Ctrl+Z
Cut / Copy / Paste / Select AllCmd+X / C / V / ACtrl+X / C / V / A
CompleteCtrl+SpaceCtrl+Space
Ask Lume Intelligence about the query tabCmd+KCtrl+K

Running SQL​

ActionmacOSWindows / Linux
Run StatementCmd+ReturnCtrl+Enter
Run AllShift+Cmd+ReturnShift+Ctrl+Enter
Run in New TabOption+Cmd+ReturnAlt+Ctrl+Enter
Explain PlanOption+Cmd+EAlt+Ctrl+E
Cancel ExecutionCmd+.Ctrl+.
Show Execution OutputShift+Cmd+OShift+Ctrl+O
Execution History...Cmd+YCtrl+Y

Results​

ActionmacOSWindows / Linux
Find in ResultsCmd+FCtrl+F
Export Results...Shift+Cmd+EShift+Ctrl+E
Fetch More RowsShift+Cmd+MShift+Ctrl+M
Columns...Shift+Cmd+CShift+Ctrl+C
Next / Previous Result TabOption+Cmd+] / Option+Cmd+[Alt+Ctrl+] / Alt+Ctrl+[
Close Result TabCmd+WCtrl+W
Edit cellEnter or F2Enter or F2
Delete / undelete row (editable preview)Cmd+DeleteCtrl+Delete
Cell menuShift+F10Shift+F10

View and panels​

ActionmacOSWindows / Linux
Show / hide ExplorerCmd+BCtrl+B
Show / hide ResultsCmd+JCtrl+J
Refresh ExplorerCmd+RCtrl+R
Explorer / Results / Output / InspectorCmd+1 / 2 / 3 / 4Ctrl+1 / 2 / 3 / 4
Back to Last Panel / EditorF12F12
Command Palette...Shift+Cmd+PShift+Ctrl+P
Panels...Option+Cmd+PAlt+Ctrl+P
Focus ModeShift+Cmd+F12Shift+Ctrl+F12
Maximize / Restore panelOption+Cmd+MAlt+Ctrl+M
Collapse / Expand panelOption+Cmd+JAlt+Ctrl+J
Hide panelShift+EscShift+Esc
Grow / Shrink panelCtrl+Option+Right / LeftCtrl+Alt+Right / Left
Undo Layout ChangeOption+Shift+Cmd+ZAlt+Shift+Ctrl+Z
Split Editor Right / DownCmd+\ / Shift+Cmd+\Ctrl+\ / Shift+Ctrl+\
Zoom In / Out / ResetCmd+= / Cmd+- / Cmd+0Ctrl+= / Ctrl+- / Ctrl+0
Focus ToolbarCtrl+F5Ctrl+F5

Output panel​

ActionKeys
SearchCmd+F
Next / previous matchEnter / Shift+Enter in the field; Cmd+G / Shift+Cmd+G or F3 in the list
Copy messages / detailsCmd+C / Shift+Cmd+C

Object editor​

ActionKeys
Go to DefinitionF12
Next / previous problemF8 / Shift+F8

ER diagrams​

ActionmacOS
FindCmd+F, then Enter / Shift+Enter (or F3 / Shift+F3)
Fit / Fit SelectionCmd+1 / Cmd+2
Zoom in / out / 100 %Cmd+= / Cmd+- / Cmd+0
Back / ForwardCmd+[ / Cmd+]
Auto layoutShift+Cmd+L
Copy as ImageShift+Cmd+C
Undo / Redo a moveCmd+Z / Shift+Cmd+Z
Move between cardsarrow keys, Tab / Shift+Tab
Remove from the diagramDelete

Inside a diagram or report tab, these take precedence over the global shortcuts with the same keys.