SQL Gen - Natural Language to SQL VS Code Extension
🤖 Query your databases using natural language - Convert plain English questions into SQL queries with the power of AI, while keeping your data completely private and local.
✨ Features
🔒 Privacy-First: Your data never leaves your machine
🧠 AI-Powered: Convert natural language to SQL using advanced AI
📊 Multiple Formats: Support for SQLite databases and CSV files
⚡ Instant Results: See generated SQL and query results immediately
🎯 Smart Schema: AI understands your database structure automatically
🚀 Quick Start
Install the extension from the VS Code Marketplace
Open the SQL Gen sidebar (database icon in activity bar)
Connect to your SQLite database or CSV file
Ask questions in natural language!
💡 Example Queries
"Show me all employees in the Engineering department"
"What is the average salary by department?"
"List the top 10 customers by revenue"
"Find orders placed in the last 30 days"
"Show me products that are out of stock"
🏗️ Architecture
🔒 Local (Your Machine)
Database connections and data processing
SQL execution and results display
Complete data privacy
☁️ Remote (AI Server)
Natural language processing
SQL generation using LangChain + OpenAI
Only receives database schema (never your data)
📁 Supported File Types
SQLite: .db, .sqlite, .sqlite3
CSV: .csv (auto-converted to queryable tables)
🎯 Free Tier
100 queries per day per user
No signup required
Instant access
For CSV files
"Show me the top 10 rows"
"What's the average value in the price column?"
"Find all records where status is 'active'"
Privacy & Security
Your database remains local and is never uploaded
Queries are processed through our secure hosted service
We use anonymous usage tracking for service improvements
All API communications are encrypted
No personal data is stored or logged by the extension