Tour of the interface
- PostgreSQL
- MySQL
- MariaDB
- MongoDB
- Redis / Valkey
- Elasticsearch
The Querybara window has a title bar across the top with the connection toolbar under it, the Connections side bar on the left, the tabs in the middle, and optional panels on the right. It follows the layout of VS Code’s workbench.


Title bar
Section titled “Title bar”Querybara draws its own title bar. On macOS the window’s traffic lights sit at its left; on Windows and Linux the window controls sit at its right, and the application menu (File, Edit, View, Window, Help) sits at its left.
In the middle, a search box shows the active tab’s title. Click it to open Go to Table or Collection. When the active tab belongs to a connection marked Production, the middle shows a red Production banner with the connection’s name instead, and a red frame surrounds the whole window.
At the right are three buttons with tooltips: the toggles of the panels either side of the tabs, then the theme.
| Button | What it does |
|---|---|
| Side bar | Shows or hides the Connections side bar. See Resize and hide it. |
| History | Shows or hides the query history panel on the right. Its icon is the side bar’s, mirrored. |
| Switch theme | Switches between the dark theme (Tenmoku) and the light theme (Bisque). See Themes. |
A new query tab, a compare, the schedules and the jobs open from the connection toolbar, the command palette and keys:
| To open | Choose |
|---|---|
| A query tab | Ctrl + T (Cmd + T on macOS) or Query: New Query Tab; or Query in the toolbar (Console on Elasticsearch) |
| A compare | Structure, Data or Saved in the toolbar’s Compare group; or Compare: Compare Structure…, Compare: Compare Data… or Compare: Saved Comparisons… |
| The schedules | Tasks in the toolbar, or Tools: Schedules |
| The jobs panel | It opens by itself when an import, export, SQL file, transfer, backup or restore starts. Ctrl + Shift + J (Cmd + Shift + J on macOS) or Tools: Toggle Jobs shows or hides it |
Query: New Query Tab and its keys open the tab on the active tab’s connection, or on the first connected one: a query tab on PostgreSQL, MySQL and MariaDB, IntelliShell on MongoDB, the CLI on Redis and the console on Elasticsearch. The palette’s Compare commands work with no connection open: they open a blank compare, or the saved comparisons.
Connection toolbar
Section titled “Connection toolbar”Under the title bar, while a connection is open, a toolbar holds the essential tools of the connection in front, in labelled groups: Query, Objects, Data, Compare and Tools for PostgreSQL, MySQL and MariaDB, and groups of their own for MongoDB, Redis and Elasticsearch. It follows the active tab, so it changes as you move between connections. Each tool acts on the database, schema, table, collection or index in front, and asks for the rest. To hide it, press Ctrl + Alt + B (Cmd + Option + B on macOS). See Connection toolbar.
Connections side bar
Section titled “Connections side bar”The side bar lists your connections, at the top level or in folders. Each connection shows:
- its engine’s icon, dimmed until the connection is open;
- its own colour, as a dot before the icon, when you set one;
- an environment badge: Dev, Test, Staging or Production;
- RO when the connection is read-only;
- a warning sign when it crosses a network with TLS off or not fully verified (see TLS modes);
- a red dot when the connection failed or was lost. Hover the dot to read the error.
A connection or folder name too long for the side bar ends in “…”; hover it to read it in full.
Errors do not show inside the side bar. When a connection fails to open, or a database or folder fails to load, a notice at the bottom right of the window says why, titled with the connection’s name. A node that failed to load folds back; expand it again to try again. A notice closes after 8 seconds, but not while the pointer or the focus is on it, and F8 moves the focus to the notices. A failed connection keeps its red dot until you close its notice or it connects.
A click selects a connection. A double-click, or Enter, connects it. While it connects, a small spinner takes the place of the row’s Actions button. Only a connected connection has a chevron; the chevron, a double-click or Enter folds and unfolds its tree.
The header’s menu (Connection actions, at the right of Connections) has New connection, New folder and Close all connections, with the number of open connections. A new folder is named in place: type the name and press Enter.
Resize and hide it
Section titled “Resize and hide it”- Drag the side bar’s right edge to make it wider or narrower, from 180 to 640 pixels. Double-click the edge to put back the default width.
- With the edge focused (press Tab until it is), Left and Right resize it, in bigger steps with Shift; Home and End make it as narrow or as wide as it goes.
- Drag the edge past half the narrowest width to hide the side bar. Drag back out, without letting go, to show it again.
- Press Cmd + B on macOS or Ctrl + B on Windows and Linux, choose Side bar in the title bar, or run View: Toggle Side Bar from the command palette to hide or show it. Connection: Search Connections shows it too.
Querybara remembers the width, and whether the side bar is hidden, the next time it starts. A hidden side bar keeps its search, filter and open folders.
Search and filter
Section titled “Search and filter”The bottom of the side bar holds the search and the filter:
- Search matches connection and folder names, ignoring case. The match shows in bold, and every folder that shows is open while you search. Esc clears the search.
- Filter connections narrows the list by engine, by environment, and to Connected only. A dot marks the button while a filter is on. Clear the filter removes it.
When nothing matches, the side bar says “No connection matches.” and offers Show all connections. The search and the filter last until Querybara quits.
The object tree
Section titled “The object tree”Under a connected connection, the tree loads as you expand it: databases, schemas and tables for SQL engines, and each engine’s own objects for MongoDB, Redis and Elasticsearch.
On PostgreSQL, MySQL, MariaDB and MongoDB connections:
- A click on a table, a view or a collection opens it: a table’s rows in the data view, a view’s rows in a query tab, a collection in a collection tab. An open one comes forward. Its chevron expands its columns and indexes.
- A click on a database, a schema or a folder expands it and lists what it holds in the Objects tab. Its chevron only expands it.
A PostgreSQL connection lists every database on the server, but browses only the one it is connected to. The others are dimmed and have no chevron, and a click or Enter does nothing; hover one to read which connection to open instead. Their menu still opens. The Objects tab dims them too.
Right-click a row, or hover it and choose the Actions button, to open its menu.
- A connected SQL connection offers, among others, New query tab, New database…, Run SQL file…, New query builder, ER diagram, Server tools, Transfer data to…, Refresh objects and Disconnect. A connection that is not open offers Connect.
- Every connection offers Edit…, Duplicate…, Move to folder and Delete. Move to folder lists Top level, each folder (the current one ticked) and New folder, which makes a folder and moves the connection into it.
- A folder offers New connection here, Rename and Delete folder.
- A table offers Open data, Design table, Import data…, Export… and more.
The tree works with the keyboard: arrow keys move, expand and collapse, Enter opens. See Keyboard shortcuts.
Create a database
Section titled “Create a database”On an open PostgreSQL, MySQL, MariaDB or MongoDB connection, choose New database… in the connection’s menu, or run Database: New Database… from the command palette and pick the connection. A read-only connection does not offer it.
On PostgreSQL, MySQL and MariaDB, the dialog asks for the database’s Name and these fields:
| Engine | Fields |
|---|---|
| MySQL, MariaDB | Character set (the server default to start with) and Collation, from the collations of that character set |
| PostgreSQL | Owner (Default (you)), Encoding (Template’s) and Template (Default (template1)). An encoding picked on the default template switches it to template0, which takes any encoding. |
The CREATE DATABASE statement shows under the form as you fill it in. The dialog refuses a name
the server already has, or would refuse or cut: more than 63 bytes on PostgreSQL, or more than 64
characters on MySQL and MariaDB. Create runs the statement with the connection’s write checks,
so a production connection asks first, and the side bar lists the new database.
MongoDB makes a database with its first collection, so its dialog asks for both: see Create a database in the MongoDB explorer.
Query tabs, table data views, table designers, query builders, ER diagrams, the Objects tab and the MongoDB, Redis and Elasticsearch tools all open as tabs. A tab on a connection carries its engine’s icon. Drag a tab to rearrange it or to split the area. Middle-click a tab, or choose its close button, to close it.
Tab headers carry small markers:
| Marker | Meaning |
|---|---|
| a pulsing dot | A query or operation is running. |
| TX | A transaction is open in this query tab. |
| a filled circle | Unsaved changes: staged edits, an unsaved design or value. |
| restored | The tab was reopened from its autosave. Click the marker to dismiss it. |
Querybara asks before it closes a tab with an open transaction or with unsaved changes.
With no tabs open, the area shows “No query tabs open”.
A query tab
Section titled “A query tab”A query tab has a toolbar (Run, Run all, Explain, Explain Analyze, Cancel, Format, Open in query builder, Auto-commit, Commit, Rollback), the editor, and the results below it. Drag the bar between editor and results to resize them. Results appear as one tab per result set, a Plan tab after an explain, and Messages. The status bar at the bottom shows the connection’s environment, name, server version and status.
See Query editor for the details.
Panels
Section titled “Panels”History opens on the right with the runs of your queries and a search box. Jobs opens there too, with the progress of imports, exports, transfers, backups and other jobs. See Jobs.
Themes
Section titled “Themes”Querybara has two themes from the Kiln design system: Tenmoku, the dark one, and Bisque, the light one. It starts in Tenmoku. To switch, choose the theme button at the right of the title bar (its tooltip says “Switch to Bisque (light)” or “Switch to Tenmoku (dark)”), run Preferences: Toggle Light/Dark Theme from the command palette, or press Cmd + K then Cmd + T (Ctrl + K then Ctrl + T on Windows and Linux). Querybara keeps the choice. The editors, grids and tabs follow the theme, and code is set in Rec Mono Duotone.
The application menu has the standard Edit, View and Window menus. View holds Command Palette…, Go to Table or Collection… and Keyboard Shortcuts, then zoom and full screen. The Help menu has Release Notes, Check for Updates… and About Querybara; on macOS the last two are in the Querybara menu.
On Windows and Linux, the window’s Close is Ctrl + Shift + W, so that Ctrl + W closes the active tab.
Related
Section titled “Related”Documents Querybara 0.1.19 · built from89dc752