SQL Client Overview
Connect to MySQL and PostgreSQL databases with a visual editor, SSH tunnels, and AI-powered query generation.
Supported Databases
- MySQL / MariaDB (displayed as MY)
- PostgreSQL (displayed as PG)
Connection
Configure connections with:
- Host, port, database, username, password, and driver selector (MySQL or PostgreSQL)
- SSH Tunnel — Connect through a saved SSH host or a custom tunnel (password or key auth, with separate host/port/user/key fields)
- Saved connections: rename, duplicate, set a default connection (starred), import/export
- Double-click a saved connection to connect instantly
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.
Tab System
Multiple connection tabs with status indicators. Each tab maintains fully independent state — connection, database, tables, selected section, query, filters, 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
5 Table Views
Each selected table offers five sections:
| Section | Description |
|---|---|
| Content | Paginated data grid (100 rows/page). Sortable columns, column filters with operators (=, !=, LIKE, etc.), inline cell editing, cell modal for long content, row selection, add/delete rows, copy row as JSON/CSV/SQL INSERT. |
| Structure | Column list showing type, nullable, key, default, and extra. Add or edit columns via modals. View indexes. |
| Query | SQL editor with syntax highlighting. AI-powered SQL generation and query explanation. Results grid. Resizable editor/results split. Cmd+Enter to execute. |
| Info | Table metadata: engine, row count, data size, auto_increment, collation, create time, and full CREATE TABLE statement. |
| Relations | Foreign key browser. Add, edit, and drop foreign keys. Reference column loading. |