Made with Azure OpenAI Made with Gemini Built with Streamlit Database
π― Transform natural language into powerful SQL queries with ease!
Magnifying Glass Turn your words into SQL magic Chart Visualize your data dynamically Tabs Multi-database support
π― 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)
graph LR
A[User Input] --> B[LLM Processing]
B --> C[SQL Generator]
C --> D[Database]
D --> E[Results]
E --> F[Visualization]
1οΈβ£ Clone the Repository
git clone https://github.com/lohitkolluri/NLP2SQLL.git
cd NLP2SQL2οΈβ£ 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
| Technology | Purpose |
|---|---|
| Streamlit | Web Interface |
| Azure OpenAI | NLP Processing |
| Gemini | NLP Processing |
| PostgreSQL | PostgreSQL DB |
| SQLite | SQLite DB |
| Plotly | Visualizations |
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
- 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
- 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
- Strict SQL query validation
- Prevention of harmful SQL operations
- Secure database connections
- Protected sensitive information
- Input sanitization
- Comprehensive summary statistics
- Distribution analysis
- Correlation detection
- Trend identification
- Outlier detection
License Β© Lohit Kolluri