Tools
The Tools menu (in the toolbar) gathers database-wide utilities.
Data Transfer
!!! info "Requires Premium"
Copy tables — schema and rows — from one database to another, even across connections and engines (ElyraSQL ↔ SQLite).
- Tools → Data transfer…
- Pick a Source (connection + database) and a Target (connection + database). The target connects automatically if needed.
- Choose All tables or Selected (tick the tables you want).
- Options:
- Create tables if missing — builds each target table from the source's columns and primary key.
- Empty target tables first — clears existing rows before copying.
- Transfer — a per-table report shows rows copied (and any errors).
!!! note Secondary indexes and foreign keys are not reproduced (columns + primary key only). Rows are streamed in batches.
Data Generation
!!! info "Requires Pro"
Fill a table with plausible test data.
- Tools → Data generation…
- Pick the connection, database and table, and a row count.
- Generate.
A generator is inferred per column from its type and name — names, emails, country codes, dates, booleans, numbers — and a single integer primary key gets sequential values continuing after the current maximum. If you generate into the table you're browsing, the grid refreshes automatically.
Other tools
| Tool | What it does |
|---|---|
| Data dictionary… | Dumps every object's CREATE statement into a new query tab (Pro) |
| Console | Opens a new query tab |
| Find in database… | Opens the command palette to jump to any table |
| Server monitor… | The live process list (Premium, ElyraSQL only) |
| History log | Your query history |