Skip to main content

​
Table Operations

Right-click tables in the sidebar to drop, truncate, run maintenance, or manage views. Switch between databases on the same connection with Cmd+K.

​
Create Table or View

Click the plus button in the bottom-left of the sidebar and choose New Table or New View. New Table opens the visual structure editor (see Table Structure). New View opens a SQL editor tab with a CREATE VIEW template for your database type. The button is disabled while safe mode blocks writes.

​
Drop and Truncate

Right-click a table and choose Delete to drop it, or Truncate to remove all rows while keeping the structure. Hold Cmd and click to select multiple tables; the same options apply to all of them. A confirmation dialog shows two checkboxes: Click Drop or Truncate to execute, or Cancel.
Drop table dialog

Drop table confirmation with options

Dropping is irreversible. On MySQL and MariaDB, truncate also resets the auto-increment counter. Back up important data first.

​
Maintenance

Right-click a table > Maintenance and pick an operation. A sheet shows the operation’s options and a SQL preview before executing. PostgreSQL VACUUM has FULL (rewrites the table, blocks access), ANALYZE (updates statistics), and VERBOSE (prints progress) toggles. MySQL CHECK TABLE offers QUICK, FAST, MEDIUM, EXTENDED, and CHANGED modes.
The Maintenance submenu is hidden in read-only safe mode and on databases with no maintenance operations.

​
Views

Views appear in the sidebar with an eye icon in your accent color. Materialized views and foreign tables get their own icons. All three are read-only kinds: their context menus hide Truncate and Import, and the drop item is labeled Drop View, Drop Materialized View, or Drop Foreign Table.
  • Create: right-click in the sidebar > Create New View… (or File > New View…). A SQL editor opens with a CREATE VIEW template; edit the name and SELECT, then execute.
  • Edit: right-click a view > Edit View Definition. The current definition opens in a SQL editor tab; modify and execute to update.
  • Drop: right-click a view > Drop View. Only the definition is removed; underlying table data stays intact.

​
Database Operations

​
Switch Databases

Click the database name in the toolbar or press Cmd+K. Type to filter, move with the arrow keys, then press Return or double-click to switch. Cmd+R refreshes the list. The switcher adapts to the engine’s vocabulary: Schema on Oracle, Keyspace on Cassandra, Dataset on BigQuery, Namespace on SurrealDB. SQLite is file-based, so the switcher points you to the Welcome window to open a different file.
Database switcher popover

Database switcher with search

​
Create Database

Click New Database… at the bottom of the switcher. The form fields come from the driver: MySQL/MariaDB ask for a name, character set, and collation; PostgreSQL, ClickHouse, MongoDB, and others show their own fields. The button only appears on engines that support creating databases.

​
Drop Database

Right-click a database in the switcher and choose Drop Database…. The item is hidden for system databases and for the database you are currently connected to; switch to another one first. A confirmation dialog shows the database name in its title with a red Drop Database button.
Dropping a database permanently deletes all its tables and data. The server rejects the drop if your account lacks the required privilege.