The Interface

Each open connection has its own workspace window. The window has no toolbar: the title bar is transparent, with the window buttons over the sidebar, so most of the space goes to your data.

Window layout

From left to right, the window has three columns:

• Sidebar — the connection card, your tables, saved queries and history.
• Center column — the top bar, tabs, filter bar, the data grid or SQL editor, and the bottom bar. You can split it into two panes.
• Inspector — details of the selected row, or the AI assistant.

Toggle the sidebar with ⌘0 (View ▸ Toggle Left Sidebar) and the inspector with ⌥⌘0 (View ▸ Toggle Row Details). Both can be resized by dragging their edge.

The window remembers its size for each connection. For connections tagged anything other than Local, a thin stripe in the status color runs across the top of the window.

Sidebar

The card at the top shows the connection's status dot, name, engine version, tag and safe mode. Click it to switch to another open connection, open a new one, or change the safe mode. See Switching connections.

Below the card are three tabs: Tables, Queries and History.

Tables

Lists the objects in the current schema: tables first, then Views, Materialized views and Functions (shown as name()). An estimated row count appears on the right, abbreviated as 48k or 1.9M.

• Click an object to open it in the preview tab.
• Double-click it to open it in a new tab that stays open.
• When the schema has more than 15 objects, a Filter field appears at the top.

Right-click an object for:

Plugins can add their own actions at the end of the menu. Right-click empty space in the list to create a New Table…. See Structure & Table Actions.

Clicking a function in the sidebar doesn't open it. Use ⌘K instead: it opens a new query tab with SELECT fn(); ready to run.

Queries

Your saved queries, organized in folders. See Favorites & History.

History

The 200 most recent queries run on this connection, newest first. Each entry shows the first lines of the SQL, the date and time, and how long it took. Right-click an entry to Open in Query Tab or Copy SQL.

Schema footer

The footer at the bottom of the sidebar shows schema · <name>. Click it to switch to another schema. It's disabled when the database has only one schema.

Top bar

• Breadcrumb — schema / table for a table tab, or connection / Query N for a query tab.
• Search or run a command — opens Open Anything (⌘K).
• SQL — opens a new query tab (⌘T).
• Icons for the ER diagram (⌥⌘E), the split pane (⌘\) and the inspector.

Tabs

Tables and queries open as tabs above the grid.

Preview tabs

When you click a table in the sidebar, it opens in a preview tab, shown with an italic title. Clicking another table replaces it, so browsing doesn't fill the window with tabs.

To keep a preview tab open, double-click the tab (or double-click the table in the sidebar).

Back and forward

The Back and Forward buttons at the left of the tab bar move between the tables you've visited, including the ones you reached through a foreign key.

Query tabs

Query tabs are named Query 1, Query 2… or after their .sql file or favorite. A • in the title means the linked file has unsaved edits.

To close a tab, click its × button, which appears on hover and on the active tab.

There's no shortcut to close a tab. ⌘W closes the whole window.

Bottom bar

The bottom bar changes with the tab you're on.

• Data, Structure and Indexes switch the table view. They're disabled in a query tab.
• ↓ ↑ shows the bytes per second the connection receives and sends, updated every second. It's hidden for SQLite.
• No primary key · rows matched by ctid (or rowid) warns you when the table has no primary key. See Tables without a primary key.

When you have unsaved edits, it also shows:

• The number of changes, in amber.
• Preview — the exact SQL that will run.
• Discard — throws away every pending change.
• + Row (⌘I) — adds a row. When it's disabled, hover over it to see why.
• Commit (⌘S) — saves the changes.

In the Structure and Indexes views, the bar shows the pending count, Discard, and + Column or + Index.

Row inspector

The inspector's Details tab shows the selected row, one field per line, with the column name, its declared type and the value. The header reads Row followed by the primary key value.

• When the table is editable, you can edit values here. Changes become pending edits, shown in amber, just like in the grid.
• The … menu next to a field has Set NULL and, for JSON columns, Format JSON.
• Invalid JSON is flagged in red with the line and column of the error, and isn't applied.

The Assistant tab opens the AI assistant. Mantidb remembers which tab you used last.