Commands

Open the command palette with ⌘⇧P on macOS or Ctrl+Shift+P on Windows and Linux, then type part of a command’s name. A command that does not apply to what is on screen, such as Commit transaction with no transaction open, is left out of the palette until it does.

This list is read from the app itself, so it matches the build it was published with.

Moving around

Command	Shortcut
Save a diagnostics bundle…	none
Open the logs folder	none
Keyboard shortcuts	⌘/ / Ctrl+/
Home	⌘⇧H / Ctrl+Shift+H
Commands…	⌘⇧P / Ctrl+Shift+P
Go to…	⌘P / Ctrl+P
Query history	⌘Y / Ctrl+Y
Messages	none
Toggle panel	⌘J / Ctrl+J
Keyboard shortcuts settings	none
Settings	⌘, / Ctrl+,
Show Connections	⌘⇧D / Ctrl+Shift+D
Show Explorer	⌘⇧E / Ctrl+Shift+E
Show Migrations	none
Show Performance	none
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

Command	Shortcut
Add environment…	none
Connect your app…	none
Disconnect	none
Export project…	none
Import project…	none
Save the database you are in as this connection’s database	none
Lock editing	none
Open another database on this server…	none
All connections…	⌘⇧O / Ctrl+Shift+O
Unlock editing…	none

Tables and rows

Command	Shortcut
Find value in data…	none
Row panel: back along the trail	none
Copy value as WHERE clause	none
Filter to this value	none
Find this value in other tables	none
Row panel: forward along the trail	none
Pin or unpin this field	none
Commit or apply staged changes	⌘S / Ctrl+S
Copy table rows as CSV	none
Copy table rows as INSERT statements	none
Copy table rows as JSON	none
Delete selected row	none
Discard staged changes	none
Export table as CSV…	none
Export table as INSERT statements…	none
Export table as JSON…	none
Import CSV into this table…	none
Insert row	none
Pin or unpin this table on Home	none
Review the query for staged changes	none
Filter rows	⌘⇧F / Ctrl+Shift+F

Queries and SQL files

Command	Shortcut
Open file…	⌘O / Ctrl+O
Save query as file…	⌘⇧S / Ctrl+Shift+S
Cancel query	⌘. / Ctrl+.
Commit transaction	none
Copy results as CSV	none
Copy results as INSERT	none
Copy results as JSON	none
Delete saved query	none
Toggle dry run	none
Explain this query	⌘⌥E / Ctrl+Alt+E
Explain this query with Analyze	none
Export results as CSV…	none
Export results as INSERT statements…	none
Export results as JSON…	none
Format query	⌥⇧F / Alt+Shift+F
New query	⌘T / Ctrl+T
Open the result in its own window	none
Read the rest of the result	none
Rename query…	none
Rename saved query…	none
Revert to saved query	none
Review this query	none
Roll back transaction	none
Run	⌘↵ / Ctrl+Enter
Run script	⌘⇧↵ / Ctrl+Shift+Enter
Run statement	none
Save query	⌘S / Ctrl+S
Save as new query…	none
Fill the tab with the result	none

Editing a query

Command	Shortcut
Delete line	⌘⇧K / Ctrl+Shift+K
Duplicate line	⌥⇧↓ / Alt+Shift+↓
Find	⌘F / Ctrl+F
Go to line	⌘⌥G / Ctrl+Alt+G
Indent	⌘] / Ctrl+]
Change to lower case	none
Move line down	⌥↓ / Alt+↓
Move line up	⌥↑ / Alt+↑
Outdent	⌘[ / Ctrl+[
Redo	⌘⇧Z / Ctrl+Shift+Z
Replace	none
Select all matches	⌘⇧L / Ctrl+Shift+L
Select next match	⌘D / Ctrl+D
Toggle block comment	⌥⇧A / Alt+Shift+A
Toggle case	none
Toggle line comment	⌘/ / Ctrl+/
Undo	⌘Z / Ctrl+Z
Change to upper case	none

Structure, Sketch and migrations

Command	Shortcut
Promote…	none
Diagram: show or hide the schema as code	⌘` / Ctrl+`
Save schema as schema.sql…	none
Show the next migration	none
Bring in new migrations…	none
Save as migration…	none
From a recipe…	none
Compare with…	none
Swap the migration’s direction	none
Copy as migration	none
Seed data…	none
Reset to seed	none
Show Sketch changes	none
Sketch this database	none
This is real now	none
Redo the change undone last	⌘⇧Z / Ctrl+Shift+Z
Undo the last change	⌘Z / Ctrl+Z

Project folder

Command	Shortcut
Start from a project's migrations…	none
Locate project folder…	none
Open project folder…	none
What Alcuin read in the project folder	none
Rescan project folder	none
Show project folder	none
Unlink project folder	none

Postgres views

Command	Shortcut
Show activity	none
Checkpoint…	none
Show checkpoints	none
Show health	none
New database…	none
Show roles and grants	none
Show schema diagram	none
Show seed data	none
Show top statements	none

Assistant

Command	Shortcut
Describe a schema with the assistant	none
Explain this plan with the assistant	none
Fix this error with the assistant	none
Toggle assistant	⌘I / Ctrl+I

Appearance and updates

Command	Shortcut
Toggle quiet highlighting	none
Colorway: Charcoal	none
Colorway: Columns	none
Colorway: Dolphin	none
Colorway: Duckling	none
Colorway: Elephant	none
Colorway: Ember	none
Colorway: Feather	none
Colorway: Glacier	none
Colorway: Lattice	none
Colorway: Leaf	none
Colorway: Night	none
Colorway: Day	none
Receive pre-release builds (toggle)	none