SQL AI & Operations

AI SQL Generation

In the Query tab, click the AI button and describe what you want in natural language:

Show me all orders placed in the last 7 days
with the customer name and total amount,
sorted by total descending

VortexHQ generates the correct SQL for your database engine (MySQL, PostgreSQL, or SQLite), including table and column names from your schema.

AI Query Explain

Select a query and click Explain to get:

• Plain-English explanation of what the query does
• Performance analysis and optimization suggestions
• Index recommendations

EXPLAIN / EXPLAIN ANALYZE

Beyond AI explanations, the Query tab has a native EXPLAIN button that executes EXPLAIN (MySQL) or EXPLAIN ANALYZE (PostgreSQL) to show the actual query execution plan from the database engine.

Table Operations

Right-click any table for:

• Truncate — Empty all rows
• Drop — Delete the table
• Export — As SQL dump, CSV, or JSON with streaming progress and optional compression
• Import — From SQL or CSV with progress indicator and row count tracking
• Rename — Change table name
• Duplicate Structure — Create a copy of the table schema (structure only, no data)

Bulk Operations

Select multiple tables and perform bulk drop with confirmation dialog.

Database Operations

Right-click on the database list for:

• Create Database
• Drop Database
• Export — Full SQL dump with streaming progress (handles large databases without memory issues)
• Import SQL — Upload and execute SQL files with statement-by-statement progress

Import from Other Host

Migrate data between database servers without leaving VortexHQ:

1. Right-click a database → Import from Other Host
2. A modal opens showing all your saved connections as source candidates
3. Select the source connection and database
4. Choose which tables to import (select all or pick individually)
5. Choose the merge mode: Merge (add to existing) or Replace (drop and recreate)
6. VortexHQ exports from the source host to a temporary SQL file, then imports into the current database with full progress tracking

Export Formats