SQL Gen - Query your database withNatural Language

A Visual Studio Code extension that allows you to query SQLite databases using natural language, powered by OpenAI and LangChain.

How to Use

For now this extension works with only SQLite databases.In future I would be adding support for CSVs and other databases.

Follow these instructions to use:

1. Click on Select SQLite Database to select your database file. If you dont have an SQlite database file you can create one
2. Browse to the location of the file and select it
3. You will see the schema of the database after selecting it
4. Write your natural language query in the Ask a Question textfield
5. Click on Generate& Execute SQLto get results.
6. That's all, hope you enjoy

This is still under development so you might or might not experience some bugs

Features

• Natural Language Queries: Ask questions in plain English and get SQL results
• Local Database Support: Works with local SQLite files
• AI-Powered: Uses OpenAI GPT models via LangChain for intelligent SQL generation
• Visual Interface: Clean webview interface for database interaction
• Real-time Results: Execute queries locally and see results instantly

Prerequisites

• Node.js (v18 or higher)
• VS Code (for extension development)