lohitkolluri/NLP2SQL — 32 Stars

NLP2SQL

Python

Transform natural language into SQL queries using Azure OpenAI. Visualize database results with interactive charts and explore data effortlessly.

Last updated Jun 8, 2026

Stars

Forks

Issues

Stars/day

Attention Score

View on GitHub ↗ Open in github.dev

Topics

#azure-openai-api #data-analysis #data-visualizations #database-explorer #nlp-to-sql

Language breakdown

Python 100.0%

▸ Files click to expand

README

Banner

🎯 Transform natural language into powerful SQL queries with ease!

Turn your words into SQL magic Visualize your data dynamically Multi-database support

✨ Features

🎯 Core Features

Natural Language to SQL 🗣️ → 📝

- Convert text queries into SQL commands using Azure OpenAI or Gemini models - Intelligent query interpretation with detailed decision logs - Step-by-step reasoning for query generation

Multimodal Interaction 🎥

- Process both textual and visual inputs for richer query context - Combine image data with text to enhance query generation

Multi-Database Support 🗄️

- SQLite compatibility with file upload - PostgreSQL integration with secure connection - Dynamic schema exploration

Interactive Data Explorer 🔍

- Real-time data filtering and exploration - Comprehensive query results with summary statistics - Advanced table views with sorting and filtering

📊 Visualization & Analytics

Dynamic Visualizations 📈

- Multiple chart types (Bar, Line, Scatter, Area, Histogram) - Interactive chart configuration - AI-powered visualization recommendations

Summary Statistics 📋

- Detailed numeric analysis - Categorical data insights - Distribution analysis - Statistical measures (mean, median, mode, skewness, kurtosis)

🛡️ Security & Management

Safe SQL Execution 🔒

- Strict query validation - SQL injection prevention - Comprehensive error handling and feedback

Query History 📚

- Searchable query log - Query reusability - Multiple export formats (CSV, Excel, JSON)

🚀 Getting Started

graph LR
    A[User Input] --> B[LLM Processing]
    B --> C[SQL Generator]
    C --> D[Database]
    D --> E[Results]
    E --> F[Visualization]

Installation

1️⃣ Clone the Repository

git clone https://github.com/lohitkolluri/NLP2SQLL.git
cd NLP2SQL

2️⃣ Set Up Environment

# Create .env file
cat << EOF > .env
2a: Azure Configuration
LLM_PROVIDER=AZURE
OPENAIENDPOINT="https://[ENDPOINTNAME].openai.azure.com"
OPENAIAPIVERSION="2024-08-01-preview"
OPENAIAPIKEY="YOUR AZURE OPENAI API KEY"
MODEL_NAME="YOUR AZURE OPENAI MODEL NAME"
2b: Gemini Configuration
LLM_PROVIDER=GEMINI
GEMINIAPIKEY="YOUR GEMINI API KEY"
EOF

3️⃣ Install Dependencies

pip install -r requirements.txt

4️⃣ Launch the App

streamlit run app/NLP2SQL.py

🎨 Built With

🌟 Key Features

mindmap
  root((NLP2SQL))
    Query Processing
      Natural Language Input
      Decision Logging
      Detailed Reasoning
    Visualization
      Interactive Charts
      Summary Statistics
      Data Distribution
    Database
      PostgreSQL
      SQLite
      Schema Analysis
    Security
      Query Validation
      Error Handling
      Safe Execution