SQL Database Client
MySQL/MariaDB and PostgreSQL with SSH-tunnel support, per-tab Content/Structure/Query/Info/Relations sections, AI generation, and streaming import/export.
Drivers
- MySQL / MariaDB — via
mysql2. - PostgreSQL — via
pg. - SQLite — via
better-sqlite3(local file connections). - SSH tunnel — connect to a database through a saved SSH host (no port forwarding required).
Five sections per tab
| Section | What it does |
|---|---|
| Content | Paginated table-data browser with column filters and sortable headers. |
| Structure | Columns (name, type, nullable, default, key), indexes, and constraints. |
| Query | SQL editor with syntax highlight, multi-statement execution, and AI generation. |
| Info | Table metadata + the full CREATE TABLE DDL. |
| Relations | Foreign-key relationships with one-click navigation. |
Schema introspection
- List databases, switch databases, list tables (with search/filter).
- Server info display (version, charset, timezone, uptime).
- Truncate or drop tables (with confirmation).
AI integration
- Natural-language → SQL with full schema context — the agent sees your tables and columns.
- Explain any SQL query in plain English.
- Image attachments — paste a screenshot of an ER diagram and ask for migrations.
Import & export
- Export table as CSV, JSON, or SQL — streamed with a progress indicator.
- Export full database as
.sql(structure + data, structure-only, or data-only). - Import SQL files — streaming parser handles multi-GB dumps without OOM.
- Import CSV — column mapping with type inference, batched inserts.
- Encrypted export — bundle your saved connections as a passphrase-protected file.
Connection management
Saved connections support: name, host, port, driver, username, password, default database, color label. Right-click to Rename · Duplicate · Set as default · Export · Delete.
Keyboard shortcuts
| Shortcut | Action |
|---|---|
| Cmd+T | New SQL tab |
| Cmd+W | Close tab |
| Cmd+S | Save query |
| Cmd+Enter | Execute query |
| Cmd+R / F5 | Refresh content |
| Delete | Delete selected rows / drop selected table |