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 or PostgreSQL), 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

Table Operations

Right-click any table for:

• Truncate — Empty all rows
• Drop — Delete the table
• Export — As SQL dump or CSV file
• Import — From SQL or CSV with progress indicator
• Rename — Change table name
• Duplicate Structure — Create a copy of the table schema

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
• Import SQL — Upload and execute SQL files