Import & Export
Move data in and out of tables — CSV, JSON, SQL INSERTs, Excel, and full database dumps.
Export
Two surfaces share the same format set: toolbar Export dropdown on the data viewer, and right-click → Export submenu on a table in the sidebar.
Formats
| Format | Where it runs |
|---|---|
Excel (.xlsx) | Frontend helper |
| CSV | Backend streaming |
| JSON | Backend streaming |
| SQL | Backend streaming + dialog for options |
SQL export options
A dialog lets you set:
- DROP + CREATE table preceding the INSERTs (optional)
- Transaction wrapping
INSERT IGNORE(MySQL) instead of plainINSERT- Batch size — default 500 rows per multi-row
INSERT
Database dump
Right-click a database → Dump Database for a full dump. Options:
- Pick tables or include all
- Schema only / data only / schema + data
- DROP + CREATE + transactions
- INSERT IGNORE
- Batch size + max rows cap
Import
From a file
Right-click a table → Import, then pick a CSV / JSON file. Map source columns to target columns. Conflict resolution per row:
- Skip — leave the existing row
- Overwrite — apply the change
- Error — stop on the first conflict
From a SQL file
Right-click schema → Import → SQL file. Statements stream line-by-line through import_sql_file.
Connection import (UI)
DBeaver / Navicat connection import is not yet exposed in the UI. The backend connection_import command exists, but no menu or dialog invokes it. If you need it today, copy the connection definitions manually as JSON.