Skip to content

Command palette

  • PostgreSQL
  • MySQL
  • MariaDB
  • MongoDB
  • Redis / Valkey
  • Elasticsearch

The command palette opens at the top of the window, as VS Code’s does. It has two modes: Go to Table or Collection, which opens an object of a connected database by a few letters of its name, and the command list, which runs any command by name.

Go to Object open over a query tab: the letters "or" are typed and the list shows orders, order_items, inventory, customers and the customer_lifetime_value view, each with its database and schema and the matched letters highlighted.Go to Object open over a query tab: the letters "or" are typed and the list shows orders, order_items, inventory, customers and the customer_lifetime_value view, each with its database and schema and the matched letters highlighted.
Press Ctrl+P (⌘P on a Mac) and type a few letters to open any table or view.

Press Cmd + P (Ctrl + P on Windows and Linux), or click the search box in the middle of the title bar. You can also choose View → Go to Table or Collection….

Type a few letters of the name, then press Enter. The letters only have to appear in order: mtea finds manager_teams. The matched letters show in colour. Each entry shows where the object lives and on which connection.

The object opens as a click on it in the side bar does: a table’s rows in the data view, a view’s rows in a query tab, a collection in a collection tab.

What the palette searches:

  • the tables and views of each connected PostgreSQL, MySQL and MariaDB connection, from the same schema information that autocomplete reads;
  • every table, view and collection the side bar has loaded;
  • on MongoDB, the collections of the first eight databases (other than admin, config and local), loaded when the palette opens.

With nothing typed, the objects you opened from the palette recently come first, under recently opened. With no connection open, the palette says “Connect to a database to search its tables and collections.”

Press Cmd + Shift + P (Ctrl + Shift + P on Windows and Linux), or choose View → Command Palette…. In Go to Table or Collection, typing > switches to the commands.

Each command shows its group and name, such as Query: New Query Tab, and its keys when it has any. Commands you ran recently come first, under recently used. Type part of the name and press Enter. Commands that cannot run now, such as Disconnect… with no connection open, are not listed.

Some commands ask for a choice in the same list: Connect…, Disconnect…, Edit Connection… and New Database… ask which connection, Create Table… asks where the table goes, and Create Collection… asks which database. The commands of each engine ask for the connection, database, schema, table, collection or index when none is in front; see What a tool acts on.

In the palette, ↑ and ↓ move, Page Up and Page Down move by ten, Enter runs the entry, and Esc closes the palette.

Every command, with its default keys. A comma separates the two parts of a chord. The commands of each engine follow in Commands of each engine.

Command macOS Windows and Linux
View: Show All Commands Cmd + Shift + P Ctrl + Shift + P
Go: Go to Table or Collection… Cmd + P Ctrl + P
Preferences: Keyboard Shortcuts Cmd + K, Cmd + S Ctrl + K, Ctrl + S
Preferences: Toggle Light/Dark Theme Cmd + K, Cmd + T Ctrl + K, Ctrl + T
Connection: New Connection… Cmd + Shift + N Ctrl + Shift + N
Connection: Import Connections…
Connection: Export Connections…
Connection: New Folder
Connection: Connect…
Connection: Disconnect…
Connection: Close All Connections
Connection: Edit Connection…
Connection: Search Connections Cmd + Shift + F Ctrl + Shift + F
Query: New Query Tab Cmd + T Ctrl + T
Query: Show History Cmd + Shift + H Ctrl + Shift + H
Database: New Database…
Table: Create Table…
Collection: Create Collection…
Explorer: Open Selected Object Cmd + O Ctrl + O
Explorer: Design Selected Table Cmd + D Ctrl + D
Explorer: New Table in Selected Database Cmd + N Ctrl + N
View: Show Objects Cmd + Shift + O Ctrl + Shift + O
View: Search Objects Cmd + F Ctrl + F
View: Toggle Side Bar Cmd + B Ctrl + B
View: Toggle Toolbar Cmd + Option + B Ctrl + Alt + B
View: Close Tab Cmd + W Ctrl + W
View: Next Tab Control + Tab
View: Previous Tab Control + Shift + Tab
View: Refresh F5 F5
Tools: Schedules
Compare: Compare Structure…
Compare: Compare Data…
Compare: Saved Comparisons…
Tools: Toggle Jobs Cmd + Shift + J Ctrl + Shift + J
Help: About Querybara
Help: Check for Updates…
Help: Release Notes

The three Explorer commands act on the object selected in the side bar or the Objects tab, so the palette, which takes the focus, never lists them; use their keys, or change them in the Keyboard Shortcuts editor. See Objects in the side bar and the Objects tab. View: Search Objects puts the cursor in the Objects tab’s search while that tab is in front. View: Refresh reloads the active table data view or Objects tab. Connection: Search Connections puts the cursor in the side bar’s search. Database: New Database… creates a database on a PostgreSQL, MySQL, MariaDB or MongoDB connection; see Create a database. View: Toggle Toolbar shows or hides the connection toolbar. Compare: Compare Structure… and Compare: Compare Data… open a blank structure sync or data compare, and Compare: Saved Comparisons… the saved comparisons; all three work with no connection open.

To change a command’s keys, or give keys to one without, use the Keyboard Shortcuts editor.

The tools of each engine are commands too, in a group named after it. The connection toolbar runs the main ones, and the rest are here and in the side bar’s menus. They act on the connection in front, and ask for what is missing.

Group Commands
SQL New SQL Query, Open Query Builder, Run SQL File…, Open Table…, New Table…, New Database…, ER Diagram, Import Data…, Export Tables…, Transfer Data To…, Back Up…, Restore…, Compare Structure With…, Compare Data With…, Server Monitor, Sessions, Top Queries, Users and Roles, Maintenance
MongoDB See MongoDB toolbar and keys, with their default keys
Redis Keys, CLI, Pub/Sub, Search indexes, INFO dashboard, Slow log, Clients, Latency, Monitor, Big keys, Configuration, ACL users, Topology, Transfer Data To…, Back Up Keys…, Restore Keys…, Dump Analysis
Elasticsearch Open Console, Browse Documents…, Open SQL, Open Index…, Create Index…, Cluster, Templates and Pipelines, Snapshots

The SQL commands work on PostgreSQL, MySQL and MariaDB connections. A command that writes, such as SQL: Import Data… or Elasticsearch: Create Index…, needs an open connection that is not read-only. Redis: Dump Analysis reads a dump file and needs no connection.

Documents Querybara 0.1.19 · built from89dc752