QueryPilot is an AI-powered natural language database assistant for VS Code. Users can describe their data needs in plain English, and the extension generates appropriate SQL queries, validates them, executes them against connected databases, and displays results.
Features
Natural Language to SQL: Ask for data in plain English and get SQL instantly.
AI Providers: Supports multiple AI providers, including Groq and Google Gemini.
Secure Credentials: Utilizes VS Code SecretStorage to securely store your database and API credentials.
PostgreSQL Support: Out-of-the-box support for PostgreSQL databases.
Usage
Open the command palette (Ctrl+Shift+P / Cmd+Shift+P).
Type QueryPilot: Show Sidebar to open the webview panel.
Configure your Database connection (e.g. PostgreSQL credentials).
Configure your preferred AI provider (Groq or Gemini) and enter your API Key.
In the Natural Language Query section, type your request (e.g. "Show me all active users from last week") and click Generate Query.
Review the generated SQL and its explanation, and click Run Query to execute it securely.
Configuration
QueryPilot supports configuring different AI models to suit your needs:
Groq: Models like Llama 3 (8B/70B), Mixtral, Gemma.
Gemini: Models like Gemini 1.5 Pro, 1.5 Flash.
Security
QueryPilot implements strict read-only validation. Any attempt to execute INSERT, UPDATE, DELETE, DROP, or ALTER queries through the extension will be automatically blocked to protect your database.
Requirements
VS Code version 1.125.0 or higher.
A supported database (currently PostgreSQL).
An API Key for your preferred AI provider (Groq or Google Gemini).
Extension Settings
(No specific user settings; configuration is done via the QueryPilot Sidebar.)
Known Issues
Currently supports PostgreSQL only. Support for other databases is planned for future releases.
