Keyboard Shortcuts
Press ? in the app for a shorter version of this list, with the keys of
the look you are using. It leaves out the keys of the dialogs and of the
lists that open in an editor, which are here.
In this page, Mod is Cmd on macOS and Ctrl on Windows and Linux. Keys written with Ctrl are Ctrl on every system.
The same keys are written out for one system in Tabletist on macOS and The Omarchy Look.
Connections
| Keys | Do |
|---|---|
| Mod+O | Open the connection picker |
| Mod+1 to 9, Ctrl+Tab, Ctrl+Shift+Tab | Switch connection |
| Mod+Shift+W | Close the connection |
| Esc | Cancel connecting |
In the picker:
| Keys | Do |
|---|---|
| Arrows, Enter | Pick a connection |
| Shift+Enter | Open it again |
| Mod+N | New connection |
| Mod+E | Edit |
| Mod+D | Duplicate |
| Backspace | Delete |
In the connection dialog:
| Keys | Do |
|---|---|
| Mod+S | Save |
| Mod+T | Test |
| Mod+Enter | Save and connect |
| Backspace, Delete | In the empty Password field: forget the saved password |
| Up, Down | In Add table…’s or Add column…’s list: move. Enter adds the one chosen, or in Add column…’s puts a table chosen in the field for its columns, and Esc closes the field |
| Esc | Cancel |
The window
| Keys | Do |
|---|---|
| Mod+P | Quick open (Ctrl+P in the Omarchy look too). In it, Up and Down move, Enter opens, Tab searches every open connection and Esc closes. On macOS and Windows, Alt+Enter opens a SQL editor reading the rows, and > typed first lists the commands alone (and, with a word after it, the settings) |
| Mod+B | Show or hide the sidebar |
| Mod+Alt+A | Show the Agents tab |
| Mod+Y | Show the History tab. Not while you type in a text field, where it is redo |
| Mod+W | Close the tab |
| Mod+Shift+[ and ] | Previous and next tab |
| F6, Shift+F6 | Next and previous part of the window |
| Mod+, | Settings |
| Mod+=, Mod+-, Mod+0 | Larger, smaller and default data text, under a dialog too |
| ? | This list |
With no tab open the window shows the start screen, whose search field takes what you type (Mod+P opens the same search from anywhere):
| Keys | Do |
|---|---|
| Up, Down | Move among the matches |
| Return | Open the one picked |
| Alt+Return | Open it in a new SQL editor |
| Esc | Clear the search |
Tables
| Keys | Do |
|---|---|
| Arrows, Home, End, Enter | Move in the sidebar |
| Arrows, Page Up, Page Down, Home, End | Move in the grid |
| Mod+Alt+Left and Right | Previous and next page |
| Mod+F | Filter bar |
| Mod+R | Reload |
| Mod+. | Cancel the running query |
| Mod+I | Open the row panel, with the keyboard on its fields. Esc goes back to the rows |
| Mod+Shift+R | Show or hide the row panel |
| Mod+C | Copy the cell |
| Mod+Shift+C | Copy the row |
In a table’s Structure view:
| Keys | Do |
|---|---|
| Mod+L | Choose the column that labels the table’s rows for foreign keys |
| Up, Down | Move by column |
| Mod+Alt+L | Use the column under the cursor as that label |
The last two work with the keyboard on the view’s columns: click a column’s line, or come to them with Tab or F6.
Editing
These are the keys of the macOS and Windows looks. The Omarchy look has its own.
| Keys | Do |
|---|---|
| Enter, F2 | Edit the cell. Typing on a selected cell starts an edit too, and so does a double-click |
| Mod+N | Add a row, at the top of the grid, while a table’s rows are in front |
| Mod+D | Duplicate the row, as a new row at the top of the grid |
| Backspace, Delete | Delete the row: mark it for deletion, or restore a marked row. A new row that is not saved yet is dropped |
| Shift+Up, Shift+Down | Select the row above or below with the selected rows. Shift with a click selects through to the clicked row. Backspace then deletes them all |
| Enter, Tab, Shift+Tab | Keep the edit and move down, right or left |
| Alt+Enter | Open the large editor. In it, Mod+Enter applies and Esc cancels |
| Esc | Cancel the edit |
| Mod+L | In a foreign key cell’s list: choose the column that labels it. In the chooser, Up and Down move, Enter chooses and Esc closes |
| Mod+Backspace | Set NULL |
| Mod+’ | Set DEFAULT, where the column has a default |
| Space | Flip a boolean cell: true, false, NULL |
| Mod+Z | Revert the cell |
| Mod+S | Save all pending changes |
| Mod+Alt+Backspace | Discard all pending changes |
| Esc | With no cell being edited: discard all pending changes, asking first |
| Mod+Shift+D | Show or hide the SQL of the pending changes |
SQL editor
| Keys | Do |
|---|---|
| Mod+T | New SQL editor |
| Mod+Return | Run the statement at the cursor, the whole script or the selection, as Settings › Editor says |
| Mod+Shift+Return | Run all |
| Mod+. | Cancel the run |
| Mod+Shift+F | Format |
| Mod+Shift+M | Switch between read-only and read-write runs |
| Ctrl+Space, Mod+I | Complete |
| Up, Down | Move in the completion list |
| Tab | Accept the completion |
| Enter | Accept the completion, except when it stays a line break: the SQL Editor guide says when |
| Esc | Close the completion list |
In the History tab:
| Keys | Do |
|---|---|
| Up, Down | Move among the statements |
| Mod+Return | Run the selected read again, in a new SQL editor |
| Mod+C | Copy the selected statement |
| Mod+F | Search the statements |
| Mod+Alt+A | On an agent’s statement: show its call in the Agents Log |
| Esc | Keep the history, when Clear history… asks |
The Omarchy look
The Omarchy look has keys of its own: vim letters, a : prompt, letters
for its dialogs, and other chords where these would take one of vim’s.
All of them are listed in
The Omarchy Look.