Skip to content

Connection toolbar

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

While a connection is open, a toolbar under the title bar holds the tools of the connection in front, in labelled groups. It changes as you move between tabs, so a PostgreSQL tab shows the SQL tools and a MongoDB tab the MongoDB ones. Each button runs a command, so every tool is also in the command palette, where you can give it keys.

The toolbar shows the tools of:

  1. the active tab’s connection;
  2. otherwise the connection of the node you last picked in the side bar;
  3. otherwise the connection last in front, while it stays open;
  4. otherwise the first open connection.

With no connection open there is no toolbar. A compare, the schedules and the jobs then open from the command palette: see Tour of the interface.

Each group has its name in small capitals above it, between separators. The buttons are all one width, and each icon has its own colour: the same kind of tool has the same colour on every engine. Hover a button to see its command and its keys. A button is dimmed when its command cannot run, for example Import on a read-only connection.

Group Button Opens
Query Query A query tab on the database in front
Query Builder The visual query builder
Objects Table A table’s data
Objects ER Diagram An ER diagram of the database
Data Import The import wizard, into a table you pick or a new one
Data Export The export wizard, for the tables of a database or schema
Compare Structure Structure sync, with the database as the source
Compare Data Data compare, with the database as the source
Compare Saved The saved comparisons
Tools Monitor The monitor of the server tools
Tools Tasks The Schedules tab
Group Button Opens
Query Collection A collection tab
Query IntelliShell IntelliShell
Query Aggregate The aggregation editor
Data Import The Import dialog
Data Export The Export dialog
Compare Structure Structure sync, with the database as the source
Compare Data Data compare, with the database as the source
Compare Saved The saved comparisons
Tools Schema Schema analysis
Tools Monitor The monitor of the server tools
Tools Tasks The Schedules tab

MongoDB toolbar and keys says what each MongoDB tool acts on, and lists the keys of the MongoDB commands.

Group Button Opens
Data Keys The key browser
Data CLI The CLI
Data Pub/Sub Pub/Sub
Server Dashboard The INFO dashboard
Server Slow Log The slow log
Server Clients The client list
Tools Tasks The Schedules tab
Group Button Opens
Query Console The console
Query SQL A SQL tab
Data Documents The documents of an index
Data Index An index
Server Cluster The cluster view
Server Snapshots Snapshots

A tool works on the connection in front. When several connections of its engine are open and none of them is in front, it asks which in the palette, for example Which SQL connection?.

  • PostgreSQL, MySQL and MariaDB: the tools take the database, schema and table from the active tab (a query tab’s database, a table data view’s table), or else from the node last picked in the side bar. What is still missing, they ask for: Which database of the connection, then on PostgreSQL Which schema of the database, then Which table of the schema. For example, Table with a database picked asks for the schema, then the table. Import’s list also offers New table….
  • MongoDB: see What a tool acts on.
  • Redis: Keys and CLI open on the logical database of the Redis tab in front.
  • Elasticsearch: Documents and Index work on the index, alias or data stream of the tab in front, and otherwise ask for one.

Tools that write are off on read-only connections, and a production connection asks before a write, as everywhere else.

The tools that are not on the toolbar, such as Run SQL File, Transfer, Back up, Restore, Sessions and Users, are in the connection’s menu in the side bar and in the command palette, under the SQL, MongoDB, Redis and Elasticsearch groups. See Commands of each engine.

A new connection is in the side bar’s Connection actions menu, and in the palette as Connection: New Connection….

Run View: Toggle Toolbar from the command palette, or press Ctrl + Alt + B (Cmd + Option + B on macOS). The toolbar stays hidden until you show it again the same way. Keys you gave the earlier View: Toggle MongoDB Toolbar still work.

Documents Querybara 0.1.19 · built from89dc752