Docs SQL Client SQL Client Overview

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:

SectionDescription
ContentPaginated 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.
StructureColumn list showing type, nullable, key, default, and extra. Add or edit columns via modals. View indexes.
QuerySQL editor with syntax highlighting. AI-powered SQL generation and query explanation. Results grid. Resizable editor/results split. Cmd+Enter to execute.
InfoTable metadata: engine, row count, data size, auto_increment, collation, create time, and full CREATE TABLE statement.
RelationsForeign key browser. Add, edit, and drop foreign keys. Reference column loading.

Last updated 12 hours ago