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 connection in front
Section titled “The connection in front”The toolbar shows the tools of:
- the active tab’s connection;
- otherwise the connection of the node you last picked in the side bar;
- otherwise the connection last in front, while it stays open;
- 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.
The tools of each engine
Section titled “The tools of each engine”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.
PostgreSQL, MySQL and MariaDB
Section titled “PostgreSQL, MySQL and MariaDB”| 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 |
MongoDB
Section titled “MongoDB”| 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.
Redis and Valkey
Section titled “Redis and Valkey”| 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 |
Elasticsearch
Section titled “Elasticsearch”| 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 |
What a tool acts on
Section titled “What a tool acts on”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 other tools
Section titled “The other tools”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….
Hide the toolbar
Section titled “Hide the toolbar”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.
Related
Section titled “Related”Documents Querybara 0.1.19 · built from89dc752