Skip to content

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.

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
Show or hide the side bar Cmd + B Ctrl + B
Show or hide the connection toolbar Cmd + Option + B Ctrl + Alt + B
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.

Objects in the side bar and the Objects tab

Section titled “Objects in the side bar and the Objects tab”

These key bindings act on the row you selected in the side bar, the objects you selected in the Objects tab, or the menu open on either. Elsewhere in the window they do nothing, or what another tool binds to the same keys.

Action macOS Windows and Linux
Open a table’s data, a view’s rows or a collection’s documents Cmd + O Ctrl + O
Design the table Cmd + D Ctrl + D
New table in the database, schema, Tables folder or the table’s schema Cmd + N Ctrl + N
  • The menus show these keys beside Open data, Design table and New table…. From an open menu, the keys close it and do the same as the item.
  • On PostgreSQL, a new table goes in a schema: press the keys on a schema or its Tables folder.
  • On MongoDB, Cmd + O opens a collection tab and Cmd + N on a database, its Collections folder or a collection opens Add Collection…. A collection has no design key: in a collection tab, Cmd +D (Ctrl
    • D) still inserts a document.
  • In the Keyboard Shortcuts editor they are Explorer: Open Selected Object, Explorer: Design Selected Table and Explorer: New Table in Selected Database. Their keys may be the same as a window-wide command’s: when the selected object has that action, the explorer command runs.

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

  1. 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.
  2. Find the command. Search key bindings matches the command’s name, its id or its keys.
  3. 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.
  4. Press the new keys. For a chord, press the second keys after the first.
  5. 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. The explorer commands above share keys with window-wide commands without a warning, because they only act on a selected object.

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.

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.

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.

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

These are key bindings, like those above: change them in the Keyboard Shortcuts editor. They act on the MongoDB connection, database and collection in view; see MongoDB toolbar and keys.

Action macOS Windows and Linux
Open IntelliShell Cmd + L Ctrl + L
Open a SQL tab Cmd + Shift + L Ctrl + Shift + L
Open the aggregation editor F4 F4
Tree View, Table View or JSON View Cmd + Option + 1, 2 or 3 Ctrl + Alt + 1, 2 or 3
Insert a document (collection tab) Cmd + D Ctrl + D
Bulk update (collection tab) Cmd + U Ctrl + U
Bulk delete (collection tab) F8 F8
Show the Query Code section (collection tab) Cmd + G Ctrl + G

The keys F4 and F8 do nothing while you type in a field or an editor.

In the editors and tools:

Action macOS Windows and Linux
Run the entire script (IntelliShell) F5 F5
Run the statement at the cursor (IntelliShell) F6 F6
Run the selection (IntelliShell) F9 F9
Run the selection, or the entire script (IntelliShell) Shift + Enter Shift + Enter
Run the selection, or the statement at the cursor (IntelliShell) Cmd + Enter Ctrl + Enter
Show completions (IntelliShell) Control + Space Ctrl + Space
Run (find() text of a collection tab, aggregation editor, 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)
Save a value edited in place (Table View, Tree View) Enter Enter
Cancel a value edited in place Esc Esc
Move an aggregation stage or a sort key up or down (on its drag handle) Option + ↑ / ↓ Alt + ↑ / ↓
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
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
Open, design, or start a new table (see above) Cmd/Ctrl + O, D, N
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.

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
Open, design, or start a new table Cmd + O, D, N Ctrl + O, D, N
Move from Search objects into the list ↓ ↓
Go to Search objects, its text selected Cmd + F Ctrl + F

Cmd + F is a key binding, View: Search Objects: it works while the Objects tab is in front, also from the side bar, and you can change it in the Keyboard Shortcuts editor. In other tabs the key keeps its own use, such as find in an editor or the search of an ER diagram.

See Objects view.

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
  • 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.19 · built from89dc752