Table Operations

Right-click tables in the sidebar to drop, truncate, or duplicate them. Create and 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 tables)
Select Delete
Configure options in the confirmation dialog
Click OK to execute

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

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.

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

Table Operations

Table Operations

Drop Table

Truncate Table

Batch Operations