Docs / Keyboard shortcuts
Keyboard shortcuts
On macOS use Cmd instead of Ctrl. Every shortcut can be changed in Settings › Keyboard shortcuts.
On keyboards that type a character with Shift (/ is Shift+7 on Italian and German ones) the shortcut takes Shift too: Ctrl+/ is Ctrl+Shift+7 there. AltGr always types its character: Windows reports it as Ctrl+Alt, so Ctrl+Alt with a symbol ([, @, {, \...) is never a shortcut outside macOS.
| Keys | Action |
|---|---|
Ctrl+Enter | Run the statement under the cursor (or the selection) |
Alt+X, Ctrl+Shift+Enter | Run the script |
Ctrl+. | Cancel the running statement (also in the command palette) |
Ctrl+\ | Run into a new result tab |
Ctrl+Space | Autocomplete |
Ctrl+/ | Comment / uncomment |
Ctrl+Shift+F | Format the script (or the selection) |
Ctrl+Shift+A | Select the statement under the cursor |
Ctrl+Shift+E | Explain the statement under the cursor |
Ctrl+Shift+M | Query manager |
Shift+Alt+Down, Shift+Alt+Up | Duplicate the line |
Alt+Up, Alt+Down | Move the line |
Ctrl+Shift+K | Delete the line |
Ctrl+Alt+Up, Ctrl+Alt+Down | Add a cursor above / below |
Ctrl+Alt+F, Ctrl+Alt+Shift+F (macOS: ⌘⌥[, ⌘⌥]) | Fold / unfold everything |
Ctrl+D, Ctrl+Shift+L | Select the next / every occurrence |
Alt+drag | Rectangular selection |
Ctrl+F | Find and replace |
Ctrl+S, Ctrl+O | Save / open a .sql file |
Ctrl+K, Ctrl+Shift+P | Command palette |
Ctrl+B | Hide / show the navigator |
Ctrl+T, Ctrl+W, Ctrl+Shift+T | New tab / close tab / reopen the closed tab |
Ctrl+Tab, Ctrl+Shift+Tab | Next / previous tab |
Ctrl+Shift+D | Split the editor / close the split |
Ctrl+=, Ctrl+-, Ctrl+0 | Bigger / smaller / normal interface |
Ctrl+1, Ctrl+2… Ctrl+9 | All connections / the projects in rail order |
Ctrl+Alt+PageDown, Ctrl+Alt+PageUp | Next / previous project |
Ctrl+, | Settings |
F2, Enter, typing | Edit the cell (data viewer, one-table queries) |
Insert, Ctrl+D, Delete | Add, duplicate, delete rows |
Shift+Delete | Set the selected cells to NULL |
Ctrl+Alt+D (macOS: ⌃⇧D) | Fill the selected cells down from the first row |
Ctrl+V, Ctrl+Shift+V | Paste over the cells / as new rows |
Ctrl+S, Ctrl+Z | Save / undo data changes (grid focused) |
Ctrl+Shift+C | Copy the selection with headers |
Ctrl+F, F7 | Find in the results / value panel (grid focused) |
Ctrl+Alt+R | Record view of the focused row; ← → move through the rows |
F5, F2, F4, Delete | Navigator: refresh, rename, edit the table, drop (after its confirmation) |