🧠 Natural Language to SQL Query

🔎 Project Overview

This project is a Streamlit-powered web app that allows users to ask questions in plain English, which are then converted into executable SQL queries using OpenAI's GPT model via LangChain. The results are executed on a connected SQL database and displayed in a conversational chat interface.

📽️ Demo

🎥 Watch the app in action: View Demo

🚀 Features

• 🔐 Secure login to your own SQL database
• 💬 Ask questions in natural language
• 🧠 LLM (GPT-3.5 Turbo via LangChain) generates SQL queries
• 📋 Dynamically fetches relevant table and column names
• ✅ Executes SQL queries and returns results instantly
• 🕒 Chat history with question, generated SQL, and result
• 🎨 Custom styled UI with a smooth user experience

🛠️ Tech Stack

🔧 Setup Instructions

1. Clone the Repository:

   git clone https://github.com/yourusername/nl-to-sql-streamlit.git
   cd nl-to-sql-streamlit

2. Create and Activate a Virtual Environment:

   python -m venv venv
   source venv/bin/activate  # On Windows: venv\Scripts\activate

3. Install Dependencies:

   pip install -r requirements.txt

4. Set Environment Variables:

   Create a .env file in the project root:

   OPENAI_API_KEY=your_openai_key
   LANGSMITH_API_KEY=your_langsmith_key
   LANGSMITH_PROJECT=your_project_name

5. Run the App:

   streamlit run app.py

🧾 File Structure

.
├── app.py                # Main Streamlit app
├── sql.py                # SQL connection utility
├── .env                  # API keys (not included in repo)
├── requirements.txt      # Python dependencies
└── README.md             # You're reading it