Every action in Alcuin is a command, and the ones used most have a key. This list is read from the app itself, so it matches the build it was published with.
In the app, press ⌘/ on macOS or Ctrl+/ on Windows and Linux to see the same list. While the cursor is in the query editor, the same keys toggle a line comment instead: a key bound in the editor wins there. Any command without a key is one search away in the command palette: ⌘⇧P or Ctrl+Shift+P, then type its name. The commands reference lists them all.
The query editor and the result grid also take the usual editing keys: copy, paste, undo, select all, and the arrow keys to move between cells.
Moving around
| Action | macOS | Windows and Linux |
|---|
| Keyboard shortcuts | ⌘/ | Ctrl+/ |
| Home | ⌘⇧H | Ctrl+Shift+H |
| Open pinned table 1 | ⌘1 | Ctrl+1 |
| Open pinned table 2 | ⌘2 | Ctrl+2 |
| Open pinned table 3 | ⌘3 | Ctrl+3 |
| Open pinned table 4 | ⌘4 | Ctrl+4 |
| Commands… | ⌘⇧P | Ctrl+Shift+P |
| Go to… | ⌘P | Ctrl+P |
| Query history | ⌘Y | Ctrl+Y |
| Toggle panel | ⌘J | Ctrl+J |
| Settings | ⌘, | Ctrl+, |
| Show Connections | ⌘⇧D | Ctrl+Shift+D |
| Show Explorer | ⌘⇧E | Ctrl+Shift+E |
| Show Saved queries | ⌘⇧B | Ctrl+Shift+B |
| Show Search | ⌘⌥F | Ctrl+Alt+F |
| Toggle sidebar | ⌘B | Ctrl+B |
| Go back to the previous tab | ⌃Minus | Ctrl+Minus |
| Close tab | ⌘W | Ctrl+W |
| Go forward to the next tab | ⌃⇧Minus | Ctrl+Shift+Minus |
| Go to the tab to the right | ⌃Tab | Ctrl+Tab |
| Go to the tab to the left | ⌃⇧Tab | Ctrl+Shift+Tab |
Connections
| Action | macOS | Windows and Linux |
|---|
| All connections… | ⌘⇧O | Ctrl+Shift+O |
Tables and rows
| Action | macOS | Windows and Linux |
|---|
| Commit or apply staged changes · in a table tab | ⌘S | Ctrl+S |
| Filter rows | ⌘⇧F | Ctrl+Shift+F |
Queries and SQL files
| Action | macOS | Windows and Linux |
|---|
| Open file… | ⌘O | Ctrl+O |
| Save query as file… · in a query tab | ⌘⇧S | Ctrl+Shift+S |
| Cancel query | ⌘. | Ctrl+. |
| Explain this query | ⌘⌥E | Ctrl+Alt+E |
| Format query | ⌥⇧F | Alt+Shift+F |
| New query | ⌘T | Ctrl+T |
| Run | ⌘↵ | Ctrl+Enter |
| Run script | ⌘⇧↵ | Ctrl+Shift+Enter |
| Save query | ⌘S | Ctrl+S |
Editing a query
| Action | macOS | Windows and Linux |
|---|
| Delete line · in an editor | ⌘⇧K | Ctrl+Shift+K |
| Duplicate line · in an editor | ⌥⇧↓ | Alt+Shift+↓ |
| Find · in an editor | ⌘F | Ctrl+F |
| Go to line · in an editor | ⌘⌥G | Ctrl+Alt+G |
| Indent · in an editor | ⌘] | Ctrl+] |
| Move line down · in an editor | ⌥↓ | Alt+↓ |
| Move line up · in an editor | ⌥↑ | Alt+↑ |
| Outdent · in an editor | ⌘[ | Ctrl+[ |
| Redo · in an editor | ⌘⇧Z | Ctrl+Shift+Z |
| Select all matches · in an editor | ⌘⇧L | Ctrl+Shift+L |
| Select next match · in an editor | ⌘D | Ctrl+D |
| Toggle block comment · in an editor | ⌥⇧A | Alt+Shift+A |
| Toggle line comment · in an editor | ⌘/ | Ctrl+/ |
| Undo · in an editor | ⌘Z | Ctrl+Z |
Structure, Sketch and migrations
| Action | macOS | Windows and Linux |
|---|
| Diagram: show or hide the schema as code · in a diagram | ⌘` | Ctrl+` |
| Redo the change undone last · in a sketch | ⌘⇧Z | Ctrl+Shift+Z |
| Undo the last change · in a sketch | ⌘Z | Ctrl+Z |
Postgres views
| Action | macOS | Windows and Linux |
|---|
| Checkpoint… · in a sketch | ⌘⇧S | Ctrl+Shift+S |
Assistant
| Action | macOS | Windows and Linux |
|---|
| Toggle assistant | ⌘I | Ctrl+I |
In lists and trees
| Action | macOS | Windows and Linux |
|---|
| Open the menu of the focused row · in a list or tree | ⇧F10 | Shift+F10 |
Coming from another IDE? In Settings, under Keyboard, Keys from picks a preset: that tool’s keys where they differ from Alcuin’s, with your own changes kept on top. Each table below lists only what a preset changes; every other key stays as above. A command marked No key still runs from the command palette.
VS Code
VS Code’s keys for the palette, tabs and editor.
| Action | macOS | Windows and Linux |
|---|
| New query | ⌘N⌘T | Ctrl+NCtrl+T |
| Format query | ⌥⇧F⌘K ⌘F | Alt+Shift+FCtrl+K Ctrl+F |
| Commands… | ⌘⇧PF1 | Ctrl+Shift+PF1 |
| Keyboard shortcuts settings | ⌘K ⌘S | Ctrl+K Ctrl+S |
| Show Search | ⌘⇧F | Ctrl+Shift+F |
| Filter rows | ⌘⇧F | Ctrl+Shift+F |
| Go to the tab to the right | ⌘⌥→⌘⇧] | Ctrl+PageDown |
| Go to the tab to the left | ⌘⌥←⌘⇧[ | Ctrl+PageUp |
| Go to line | ⌃G | Ctrl+G |
| Replace | ⌘⌥F | Ctrl+H |
| Go back to the previous tab | Alcuin’s key | Alt+← |
| Go forward to the next tab | Alcuin’s key | Alt+→ |
| Close tab | Alcuin’s key | Ctrl+WCtrl+F4 |
DBeaver / Eclipse
DBeaver’s keys, Eclipse’s underneath, with Control for queries on a Mac.
| Action | macOS | Windows and Linux |
|---|
| Run script | ⌥X | Alt+X |
| Explain this query | ⌃⇧E | Ctrl+Shift+E |
| Format query | ⌃⇧F | Ctrl+Shift+F |
| Toggle line comment | ⌃/ | Alcuin’s key |
| Toggle block comment | ⌃⇧/ | Ctrl+Shift+/ |
| New query | ⌃] | Ctrl+] |
| Open file… | ⌃⌥⇧O | Ctrl+Alt+Shift+O |
| Commands… | ⌘3 | Ctrl+3 |
| Go to… | ⌃⇧D | Ctrl+Shift+D |
| Show Search | ⌃H | Ctrl+H |
| Toggle panel | ⌃T | Ctrl+T |
| Go back to the previous tab | ⌘[ | Alt+← |
| Go forward to the next tab | ⌘] | Alt+→ |
| Go to the tab to the right | ⌘F6 | Ctrl+F6 |
| Go to the tab to the left | ⌘⇧F6 | Ctrl+Shift+F6 |
| Commit transaction | ⌃4 | Ctrl+Alt+Shift+K |
| Roll back transaction | ⌃8 | Ctrl+Alt+Shift+R |
| Change to upper case | ⌘⇧X | Ctrl+Shift+X |
| Change to lower case | ⌘⇧Y | Ctrl+Shift+Y |
| Duplicate line | ⌘⌥↓ | Ctrl+Alt+↓ |
| Delete line | ⌘D | Ctrl+D |
| Go to line | ⌘L | Ctrl+L |
| Close tab | Alcuin’s key | Ctrl+F4Ctrl+W |
pgAdmin
pgAdmin’s Query Tool keys: F5 runs the script, F7 explains it.
| Action | macOS | Windows and Linux |
|---|
| Run | ⌥F5⌘↵ | Alt+F5Ctrl+Enter |
| Run script | F5 | F5 |
| Cancel query | ⌥⇧Q | Alt+Shift+Q |
| Explain this query | F7 | F7 |
| Explain this query with Analyze | ⇧F7 | Shift+F7 |
| Format query | ⌘K | Ctrl+K |
| Go to the tab to the right | ⌥⇧] | Alt+Shift+] |
| Go to the tab to the left | ⌥⇧[ | Alt+Shift+[ |
| Toggle sidebar | ⌃⌥B | Ctrl+Alt+B |
| Show Search | ⌥⇧S | Alt+Shift+S |
| Commit transaction | ⌃⇧M | Ctrl+Shift+M |
| Roll back transaction | ⌃⇧R | Ctrl+Shift+R |
| Toggle case | ⌃⇧U | Ctrl+Shift+U |
| Go to line | ⌘L | Ctrl+L |
| Close tab | ⌃⇧W⌘W | Alt+Shift+WCtrl+W |
DataGrip
DataGrip’s keys, from JetBrains’ default keymap.
| Action | macOS | Windows and Linux |
|---|
| Run script | ⌃⇧R | Ctrl+Shift+F10 |
| Cancel query | ⌘F2 | Ctrl+F2 |
| Format query | ⌘⌥L | Ctrl+Alt+L |
| Query history | ⌘⌥E | Ctrl+Alt+E |
| Commit transaction | ⌘⌥⇧↵ | Ctrl+Alt+Shift+Enter |
| Go back to the previous tab | ⌘[ | Ctrl+Alt+← |
| Go forward to the next tab | ⌘] | Ctrl+Alt+→ |
| Go to the tab to the right | ⌘⇧] | Alt+→ |
| Go to the tab to the left | ⌘⇧[ | Alt+← |
| Commands… | ⌘⇧A | Ctrl+Shift+A |
| Go to… | ⌘⇧O | Ctrl+Shift+N |
| Show Explorer | ⌘1 | Alcuin’s key |
| Show Search | ⌘⇧F | Ctrl+Shift+F |
| Filter rows | ⌘⇧F | Ctrl+Shift+F |
| Toggle block comment | ⌘⌥/ | Ctrl+Shift+/ |
| Toggle case | ⌘⇧U | Ctrl+Shift+U |
| Duplicate line | ⌘D | Ctrl+D |
| Delete line | ⌘Backspace | Ctrl+Y |
| Go to line | ⌘L | Ctrl+G |
| Select next match | ⌃G | Alt+J |
| Select all matches | ⌘⌃G | Ctrl+Alt+Shift+J |
| Close tab | Alcuin’s key | Ctrl+F4 |
| Settings | Alcuin’s key | Ctrl+Alt+S |