QueryPilot

Intelligent SQL assistant for PostgreSQL — right inside VS Code.

Features

• NL-to-SQL — describe what you want in plain English and get a working query
• Query Optimization — profile slow queries, get diagnosis and actionable fixes
• Schema Builder — design database schemas through conversation, export as DDL
• Schema Versioning — track schema changes with a Git-like commit history and generate migrations
• RAG-powered context — automatically indexes your schema so suggestions are always accurate

Requirements

• VS Code 1.105 or later
• A running PostgreSQL database
• A Gemini or Groq API key (configured in VS Code Settings under QueryPilot)

Getting Started

1. Install the extension
2. Click the QueryPilot icon in the Activity Bar
3. Add your database connection and API key in Settings
4. Start querying

Commands

• QueryPilot: Open QueryPilot — open the main panel
• QueryPilot: Restart Backend — restart the backend if it becomes unresponsive