Table Operations

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

Drop Table

Permanently deletes a table and all its data. Right-click the table (or select multiple) > Delete, confirm in the dialog, click OK. Irreversible - back up first.

Dropping a table is irreversible. Always backup important data before dropping tables.

Truncate Table

Removes all rows while keeping the table structure.

Right-click the table (or select multiple tables)
Select Truncate
Configure options in the confirmation dialog
Click OK to execute

Truncate is faster than DELETE FROM table because it skips per-row delete logs. It also resets auto-increment counters.

Truncate table confirmation with options

Maintenance

Right-click a table > Maintenance to run database maintenance operations. A confirmation sheet shows operation options and a SQL preview before executing.

Database	Operations
PostgreSQL	VACUUM, ANALYZE, REINDEX, CLUSTER
MySQL/MariaDB	OPTIMIZE TABLE, ANALYZE TABLE, CHECK TABLE, REPAIR TABLE
SQLite	VACUUM, ANALYZE, REINDEX, Integrity Check

PostgreSQL VACUUM has options for FULL (rewrites the table, blocks access), ANALYZE (updates statistics), and VERBOSE (prints progress). MySQL CHECK TABLE supports check modes: QUICK, FAST, MEDIUM, EXTENDED, CHANGED.

Maintenance is disabled in Read-Only Safe Mode. Databases without maintenance support (Redis, MongoDB, etc.) do not show this submenu.

Batch Operations

Hold Cmd and click to select multiple tables, then right-click and choose Delete or Truncate. The same options apply to all selected tables.

View Management

Views appear in the sidebar with an eye icon and purple color.

Create View

Right-click in the sidebar > Create New View… (or File > New View…)
A SQL editor tab opens with a CREATE VIEW template adapted to your database type
Modify the view name and SELECT query
Execute to create

Edit View Definition

Modify an existing view’s SQL definition:

Right-click the view in the sidebar
Select Edit View Definition
The current view definition opens in a new SQL editor tab
Modify the query and execute to update the view

For MySQL/MariaDB, use ALTER VIEW to modify a view. For PostgreSQL, use CREATE OR REPLACE VIEW. SQLite does not support ALTER VIEW. Drop and recreate the view instead.

Drop View

Right-click the view > Drop View > confirm. Dropping a view only removes the definition; underlying table data stays intact.

Action	Tables	Views
Show Structure	Yes	Yes
Export	Yes	Yes
Import	Yes	No
Truncate	Yes	No
Edit Definition	No	Yes
Delete / Drop	Yes	Yes

Database Operations

Create a new database (MySQL/MariaDB): click the database name in the toolbar or press Cmd+K, click Create, enter a name, character set, and collation.

Database Switcher

Click the database name in the toolbar to browse databases on the current connection. Search by name, view recent databases, or double-click to switch.

Drop Database

Drop a database from the database switcher (shipped v0.33.0). Three entry points:

Right-click a database and select Drop Database
Select a database and click the trash icon in the switcher toolbar
Select a database and press Delete

A confirmation dialog appears with a destructive (red) action button and the database name typed in the prompt. The current database cannot be dropped: switch to another one first.

Dropping a database is irreversible. Whether the action succeeds depends on the connected user’s privileges (DROP on MySQL/MariaDB, DROPDB or owner on PostgreSQL). Permission errors surface inline.

MongoDB Collections

Create Collection

Use the MQL editor. For collections with specific options (capped, validator):

db.createCollection("myCollection", {
  capped: true,
  size: 1048576,
  max: 1000
})

Drop Collection

Right-click a collection in the sidebar and select Drop Table. This executes db.collection.drop() and removes all documents and indexes.

Show All Collections

Select Show All Tables from the sidebar to list all collections in the current database.

Truncate is not available for MongoDB. To remove all documents while keeping the collection, use db.collection.deleteMany({}) in the MQL editor.

Getting Started

Database Connections

Features

Customization

External API

Table Operations

Table Operations

Drop Table

Truncate Table

Maintenance

Batch Operations