lohitkolluri/NLP2SQL

🎯 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
OPENAI_ENDPOINT="https://[ENDPOINT_NAME].openai.azure.com"
OPENAI_API_VERSION="2024-08-01-preview"
OPENAI_API_KEY="YOUR AZURE OPENAI API KEY"
MODEL_NAME="YOUR AZURE OPENAI MODEL NAME"

### 2b: Gemini Configuration
LLM_PROVIDER=GEMINI
GEMINI_API_KEY="YOUR GEMINI API KEY"
EOF

3️⃣ Install Dependencies

pip install -r requirements.txt

4️⃣ Launch the App

streamlit run app/NLP2SQL.py

🎨 Built With

Technology	Purpose
	Web Interface
	NLP Processing
	NLP Processing
	PostgreSQL DB
	SQLite DB
	Visualizations

🌟 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

💡 How It Works

Query Input ➡️ User enters natural language query
Processing ➡️ Azure OpenAI analyzes and generates SQL with reasoning
Validation ➡️ Query is validated for safety and correctness
Execution ➡️ Query runs against selected database
Analysis ➡️ Results are processed with summary statistics
Visualization ➡️ Data is presented with AI-recommended charts
Export ➡️ Results can be downloaded in multiple formats

📊 Supported Visualizations

Bar Chart: Comparing categorical data
Line Chart: Time-series and trend analysis
Scatter Plot: Relationship between variables
Area Chart: Cumulative totals and trends
Histogram: Distribution analysis

🔒 Security Features

Strict SQL query validation
Prevention of harmful SQL operations
Secure database connections
Protected sensitive information
Input sanitization

📈 Data Analysis

Comprehensive summary statistics
Distribution analysis
Correlation detection
Trend identification
Outlier detection