Import & Export

Export data in five formats (CSV, JSON, SQL, MQL, XLSX), import SQL files with gzip support, and paste tabular data from the clipboard into the grid.

Export Data

Run a query or open a table
Click Export in the toolbar (Cmd+Shift+E)
Choose a format, select tables, configure options
Click Export

MongoDB: SQL export is not available. Use CSV, JSON, MQL, or XLSX. MQL generates db.collection.insertMany([...]) scripts for mongosh.

Redis: SQL and MQL exports are not available. Use CSV, JSON, or XLSX.

Export Formats

CSV
JSON
SQL
MQL
XLSX

Best for spreadsheets and data analysis tools.

Option	Default
Header row	Yes
Delimiter (comma, semicolon, tab, pipe)	Comma
Quote handling (always, as needed, never)	As needed
NULL to empty strings	Yes
Line breaks in values to spaces	No
Line ending (LF, CRLF, CR)	LF
Decimal separator (period, comma)	Period
Formula sanitization	Yes

Option	Default
Pretty print	Yes
Include NULL values	Yes
Preserve all values as strings	No

Best for migrations, backups, and seeding databases.Global options:

Option	Default
Compress with gzip (`.sql.gz`)	No
Batch size (rows per INSERT)	500

Per-table options (configurable individually for multi-table exports):

Option	Default
Include CREATE TABLE	Yes
Include DROP TABLE IF EXISTS	Yes
Include INSERT data	Yes

MongoDB only. Generates insertMany() scripts that run directly in mongosh.

Option	Default
Batch size (documents per `insertMany`)	500

Output is a .js file:

db.users.insertMany([
  {"_id": {"$oid": "507f1f77bcf86cd799439011"}, "name": "Alice", "age": 30},
  {"_id": {"$oid": "507f1f77bcf86cd799439012"}, "name": "Bob", "age": 25}
]);

XLSX export requires a Pro license.

Best for sharing data with non-technical users and business reports.

Option	Default
Include headers (bold first row)	Yes
NULL as empty cells	Yes

Each table exports as a separate worksheet. Numbers are stored as numeric cells for proper Excel formatting. Handles 175K+ rows.

Exporting Query Results

Right-click the results grid and select Export Results…, or go to File > Export Results…. Choose a format, configure options, and click Export. Only in-memory results are exported.

Use LIMIT in your query to control export size for large tables.

Exporting Entire Tables

Click a table in the sidebar and click Export, or run SELECT * FROM table_name and export.

Export multiple tables at once via the export dialog’s tree view. SQL exports support per-table options for structure, DROP, and data.

Clipboard Paste (CSV/TSV)

Paste tabular data directly into the data grid. Press Cmd+V after selecting a row. Format is auto-detected: tabs parse as TSV, commas as CSV.

Import Data

Import .sql and .sql.gz files. Statements execute directly against your database: backups, migrations, seed data.

MongoDB: SQL import is not available. Use mongoimport or the MQL shell.

Import Workflow

Open Import Dialog

Click File > Import (Cmd+Shift+I), or drag and drop a .sql / .sql.gz file onto the app.

Configure Options

Set encoding, transaction wrapping, and foreign key check options.

Preview and Import

Review the SQL preview, statement count, and file size. Click Import to execute.

Import Options

Option	Description	Default
Encoding	File encoding: UTF-8, UTF-16, Latin1, or ASCII	UTF-8
Wrap in transaction	Execute all statements within a single transaction	Yes
Disable foreign key checks	Temporarily disable FK constraints during import	Yes

Progress and Errors

During import, a progress bar shows statements processed, current statement, and overall completion.

Import stops on the first error. If wrapped in a transaction, all changes roll back automatically.

Getting Started

Database Connections

Features

Customization

Import & Export

Import & Export