SQL Client Overview

Connect to MySQL, PostgreSQL, and SQLite databases with a visual editor, SSH tunnels, ER diagrams, and AI-powered query generation.

Supported Databases

MySQL / MariaDB (badge: MY)
PostgreSQL (badge: PG)
SQLite (badge: SQ) — connect by browsing for a .sqlite / .db file

Connection

Configure connections with:

Host, port, database, username, password, and driver selector (MySQL, PostgreSQL, or SQLite)
SSH Tunnel — Connect through a saved SSH host (including vault-encrypted hosts from your nexus) or a custom tunnel configuration with separate host/port/user/key fields
Color-coded connections — Assign a color to each saved connection for quick visual identification
Saved connections: rename, duplicate, set a default (starred), import/export
Double-click a saved connection to connect instantly
Nexus cloud connections — Access shared database connections from your Infrastructure Nexus (team-shared)

Import / Export Connections

Connections are importable and exportable as encrypted .vxdb files (Vortex DB Export) with a passphrase. Export a single connection or all connections at once. Feature-gated for Pro+ plans.

Tab System

Multiple connection tabs with status indicators. Each tab maintains fully independent state — connection, database, tables, selected section, query, filters, sort, and more. Tabs can be detached into their own window (Pro+).

Database & Table Browser

List all databases and switch the active database
List and search tables within the current database
Multi-select tables for bulk operations (drop, export)
Context menu: Truncate, Drop, Export, Import, Rename, Duplicate Structure

6 Table Sections

Each selected table offers six sections:

Section	Description
Content	Paginated data grid (100 rows/page, configurable). Sortable columns, 21 filter operators per column (=, ≠, LIKE, NOT LIKE, contains, starts with, ends with, RegExp, IN, NOT IN, BETWEEN, IS NULL, IS NOT NULL, is empty, is not empty, Hex, and more). Inline cell editing with auto-type detection, cell modal for long content. Multi-row selection with 8 copy formats (values, with headers, SQL INSERT, INSERT without AI, IDs only, CSV, JSON, Markdown). Add, duplicate, and delete rows. FK navigation with relation peek modal — click a foreign key value to preview the related row and jump to that table.
Structure	Column list showing type, nullable, key, default, extra, and collation. Add, edit, or drop columns via modals. Index management: view, add, and drop indexes.
Query	Full SQL editor with syntax highlighting, line numbers, and gutter. Query history (last 100 queries with database, timestamp, duration, row count, error). Saved queries — save, load, and delete reusable queries. EXPLAIN — run EXPLAIN (MySQL) or EXPLAIN ANALYZE (PostgreSQL) on any query. AI-powered SQL generation and query explanation. Results grid with same copy formats as Content. `Cmd+Enter` to execute. Resizable editor/results split.
Relations	Foreign key browser with table and column references. Add, edit, drop foreign keys. Reference column auto-loading from target table.
Routines	Browse Stored Procedures, Functions, and Triggers with counts and definition viewer. Copy routine definitions to clipboard.
Info	Table metadata: engine, row count, data size, auto_increment, collation, create time, and full `CREATE TABLE` DDL statement.

Database Diagram

A dedicated Diagram section renders an interactive SVG-based Entity-Relationship diagram showing tables, columns, types, and foreign key relationships. See Database Diagram for full details.