Skip to content
| Marketplace
Sign in
Visual Studio Code>Programming Languages>SQL GenNew to Visual Studio Code? Get it now.
SQL Gen

SQL Gen

Nunya Klah

|
15 installs
| (0) | Free
Query SQL databases and CSV files using natural language with LangChain and AI
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

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.

SQL Gen Extension

✨ 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

  1. Install the extension from the VS Code Marketplace
  2. Open the SQL Gen sidebar (database icon in activity bar)
  3. Connect to your SQLite database or CSV file
  4. 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

Contributing

We welcome contributions! Please see our contributing guidelines for details.

License

This project is licensed under the MIT License - see the LICENSE file for details.

Support

If you encounter any issues or have questions:

  1. Check our FAQ
  2. Open an issue on our GitHub repository

Credits

This extension uses:

  • LangChain for AI integration
  • OpenAI for natural language processing
  • SQLite for database operations
  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
© 2025 Microsoft