Keyboard shortcuts

PostgreSQL
MySQL
MariaDB
MongoDB
Redis / Valkey
Elasticsearch

Querybara’s window-wide shortcuts are key bindings, as in VS Code: each runs a command, some are chords of two keys, and you can change them in the Keyboard Shortcuts editor. The editors and tools also have keys of their own, listed further down. The editors are Monaco editors and keep their usual editing keys, and the Edit and View menus use your system’s standard keys for undo, copy, paste, zoom and full screen.

On macOS, Cmd takes the place of Ctrl where the tables say so. The macOS Option key is Alt, and Control is the Control key itself.

Window and commands

These are the default key bindings. A comma separates the two parts of a chord: for example, press Cmd + K, then Cmd + S within 1.5 seconds. After the first part, the bottom of the window says it is waiting for the second key.

Action	macOS	Windows and Linux
Run a command (command palette)	`Cmd` + `Shift` + `P`	`Ctrl` + `Shift` + `P`
Go to a table, view or collection	`Cmd` + `P`	`Ctrl` + `P`
Open the Keyboard Shortcuts editor	`Cmd` + `K`, `Cmd` + `S`	`Ctrl` + `K`, `Ctrl` + `S`
Switch between the dark and light themes	`Cmd` + `K`, `Cmd` + `T`	`Ctrl` + `K`, `Ctrl` + `T`
New connection	`Cmd` + `Shift` + `N`	`Ctrl` + `Shift` + `N`
Search connections (the side bar’s search)	`Cmd` + `Shift` + `F`	`Ctrl` + `Shift` + `F`
New query tab	`Cmd` + `T`	`Ctrl` + `T`
Show or hide the query history	`Cmd` + `Shift` + `H`	`Ctrl` + `Shift` + `H`
Show the Objects tab	`Cmd` + `Shift` + `O`	`Ctrl` + `Shift` + `O`
Show or hide the jobs panel	`Cmd` + `Shift` + `J`	`Ctrl` + `Shift` + `J`
Close the active tab	`Cmd` + `W`	`Ctrl` + `W`
Next tab	`Control` + `Tab`	—
Previous tab	`Control` + `Shift` + `Tab`	—
Refresh the table data view or the Objects tab	`F5`	`F5`

They work everywhere in the window, also in an editor, except while a dialog is open.
F5 and other keys without Cmd, Ctrl or Alt do nothing while you type in a field or an editor.
Letters, digits and punctuation are read by their place on the keyboard, named as on a US layout, whatever keyboard layout you use.
On Windows and Linux, Ctrl + Shift + W closes the window.

The command palette lists every command, including those without keys.

Change a key binding

The Keyboard Shortcuts editor lists every command with its key binding and where the binding comes from: Default, or User for one you set.

Open the editor: press Cmd + K, then Cmd + S (Ctrl + K, then Ctrl + S on Windows and Linux), or choose View → Keyboard Shortcuts, or run Preferences: Keyboard Shortcuts. It opens as a tab.
Find the command. Search key bindings matches the command’s name, its id or its keys.
Double-click the row, select it and press Enter, or choose its pencil button (Change the key binding of and the command’s name). A dialog asks you to press the keys.
Press the new keys. For a chord, press the second keys after the first.
Press Enter to keep them, or Esc to cancel.

If another command already has the keys, the dialog says so before you keep them, and the editor marks a binding that two commands share with a warning sign.

On a row, the trash button removes the binding, so the command has no keys. On a binding you set, the reset button puts the default back.

Querybara keeps your bindings in its settings; they replace the defaults command by command.

Query editor

In a query tab on PostgreSQL, MySQL or MariaDB.

Action	macOS	Windows and Linux
Run the selection, or the statement at the cursor	`Cmd` + `Enter`	`Ctrl` + `Enter`
Run all	`Cmd` + `Shift` + `Enter`	`Ctrl` + `Shift` + `Enter`
Explain the selection, or the statement at the cursor	`Cmd` + `E`	`Ctrl` + `E`
Explain Analyze	`Cmd` + `Shift` + `E`	`Ctrl` + `Shift` + `E`
Format SQL	`Shift` + `Option` + `F`	`Shift` + `Alt` + `F`

In the SQL pane of the visual query builder, Cmd + Enter (macOS) or the keys Ctrl + Enter run the query.

Table data

Action	macOS	Windows and Linux
Undo the last staged change	`Cmd` + `Z`	`Ctrl` + `Z`
Redo	`Cmd` + `Shift` + `Z` or `Cmd` + `Y`	`Ctrl` + `Shift` + `Z` or `Ctrl` + `Y`
Apply the filter (in the filter bar)	`Enter`	`Enter`
Finish editing a cell	`Enter`	`Enter`
Finish editing a multi-line value	`Cmd` + `Enter`	`Ctrl` + `Enter`
New line in a multi-line value	`Enter` or `Shift` + `Enter`	`Enter` or `Shift` + `Enter`
Cancel the edit (form view)	`Esc`	`Esc`
Go to the page typed in Page	`Enter`	`Enter`

Undo and redo act on the grid’s staged changes, not while you type in a field.

ER diagrams

Action	macOS	Windows and Linux
Search the tables	`Cmd` + `F`	`Ctrl` + `F`
Clear the search, then the selection	`Esc`	`Esc`
Undo a model edit (Edit model)	`Cmd` + `Z`	`Ctrl` + `Z`
Redo a model edit	`Cmd` + `Shift` + `Z` or `Cmd` + `Y`	`Ctrl` + `Shift` + `Z` or `Ctrl` + `Y`
Drop the selected table or relationship (Edit model)	`Delete`	`Delete` or `Backspace`

MongoDB

Action	macOS	Windows and Linux
Run (console, collection query, aggregation, SQL tab)	`Cmd` + `Enter`	`Ctrl` + `Enter`
Save the document in the document editor	`Cmd` + `Enter`	`Ctrl` + `Enter`
Count the matched documents in a bulk update	`Cmd` + `Enter`	`Ctrl` + `Enter`
Run from the query bar, or from Skip and Limit	`Enter`	`Enter`
Run from a condition of the visual query builder	`Enter` (`Cmd` + `Enter` in a multi-line field)	`Enter` (`Ctrl` + `Enter` in a multi-line field)
Move an aggregation stage or a sort key up or down (on its drag handle)	`Option` + `↑` / `↓`	`Alt` + `↑` / `↓`

Redis

Action	macOS	Windows and Linux
Run the command (CLI)	`Enter`	`Enter`
New line in the command (CLI)	`Shift` + `Enter`	`Shift` + `Enter`
Previous or next command from history (CLI)	`↑` / `↓`	`↑` / `↓`
Show completions (CLI)	`Control` + `Space`	`Ctrl` + `Space`
Accept a completion (CLI)	`Tab`	`Tab`
Close the completion list (CLI)	`Esc`	`Esc`
Open the key or folder (key browser)	`Enter`	`Enter`
Delete the key, after a confirmation (key browser)	`Fn` + `Delete`	`Delete`
Save a string value	`Cmd` + `S`	`Ctrl` + `S`
Run the search (Search indexes, in the Query field)	`Cmd` + `Enter`	`Ctrl` + `Enter`

Elasticsearch

Action	macOS	Windows and Linux
Send request (console)	`Cmd` + `Enter`	`Ctrl` + `Enter`
Run the query (SQL)	`Cmd` + `Enter`	`Ctrl` + `Enter`
Save the document, template, policy or pipeline being edited	`Cmd` + `Enter`	`Ctrl` + `Enter`
Simulate an ingest pipeline (sample documents)	`Cmd` + `Enter`	`Ctrl` + `Enter`
Search from a value of the query builder	`Enter` (`Cmd` + `Enter` in a multi-line field)	`Enter` (`Ctrl` + `Enter` in a multi-line field)
Move a sort key of the query builder up or down (on its drag handle)	`Option` + `↑` / `↓`	`Alt` + `↑` / `↓`

Action	Keys
Move to the previous or next row	`↑` / `↓`
Expand a row	`→`
Collapse a row	`←`
On a connection: connect it, or fold or unfold a connected one	`Enter`
On a table, a view or a collection: open it	`Enter`
On a database, a schema or a folder: expand it and list its objects in the Objects tab	`Enter`
Clear the side bar’s search (in the search box)	`Esc`

The plan tree of a visual explain works the same way. It adds Home for the first node and End for the last. In server tools, ← and → move between the tabs.

Objects tab

Action	macOS	Windows and Linux
Move, or extend the selection with `Shift`	`↑` / `↓`	`↑` / `↓`
First or last object	`Home` / `End`	`Home` / `End`
Select every object shown	`Cmd` + `A`	`Ctrl` + `A`
Open the object, or go into a schema or database	`Enter`	`Enter`
Clear the selection	`Esc`	`Esc`
Open the object’s menu	`Shift` + `F10`	`Shift` + `F10`
Move from Search objects into the list	`↓`	`↓`

See Objects view.

Command palette

Action	Keys
Move through the list	`↑` / `↓`
Move by ten entries	`Page Up` / `Page Down`
Open the object or run the command	`Enter`
Close the palette	`Esc`

Dialogs and tabs

Esc closes a dialog.
In the first step of a new connection, the arrow keys move between the engines, Space picks one, and Enter goes on to the form.
In the connection dialog, Enter in Paste a URI to fill the form fills the form.
Middle-click a tab to close it, or press Cmd + W (Ctrl + W on Windows and Linux) to close the active one.

Documents Querybara 0.1.1 · built frombc9f5aa