Docs SQL Client SQL Database Client

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

SectionWhat it does
ContentPaginated table-data browser with column filters and sortable headers.
StructureColumns (name, type, nullable, default, key), indexes, and constraints.
QuerySQL editor with syntax highlight, multi-statement execution, and AI generation.
InfoTable metadata + the full CREATE TABLE DDL.
RelationsForeign-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

ShortcutAction
Cmd+TNew SQL tab
Cmd+WClose tab
Cmd+SSave query
Cmd+EnterExecute query
Cmd+R / F5Refresh content
DeleteDelete selected rows / drop selected table

Last updated 6 days ago

No matches.