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
Section titled “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 |
| 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.
Change a key binding
Section titled “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. 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.
Query editor
Section titled “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
Section titled “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
Section titled “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
Section titled “MongoDB”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 |
Elasticsearch
Section titled “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 + ↑ / ↓ |
Side bar and trees
Section titled “Side bar and trees”| 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.
Objects tab
Section titled “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 |
| 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.
Command palette
Section titled “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
Section titled “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.
Related
Section titled “Related”Documents Querybara 0.1.19 · built from89dc752