INTRODUCTION - SQL Assistant is an AI-powered web application built with Streamlit that allows users to query any SQLite database using natural language — either by typing or speaking. The app uses Groq LLMs to convert plain English (or Hindi, Telugu, and 50+ other languages) into accurate SQL queries, executes them securely, and presents results with interactive charts, downloadable CSVs, and AI-generated summaries. Users can also bring their own database by uploading a .db file or CSV files directly from the sidebar. FEATURES - 1. Natural Language to SQL - Converts user questions into valid SQLite queries using Groq LLMs - Supports three models: Llama 3.3 70B Versatile, Llama 3.1 8B Instant, and Gemma 2 9B - Auto error correction with configurable reflection loop (0-10 retries) when the generated SQL is invalid 2. Voice Input with Multilingual Support - Built-in microphone recording using audio-recorder-streamlit - Speech-to-text powered by Groq Whisper (whisper-large-v3) - Automatically detects and transcribes 50+ languages including English, Hindi, and Telugu 3. Dynamic Database Management - Comes with a pre-built ecommerce SQLite database (customers, products, orders) - Upload any SQLite .db file from the sidebar to query it instantly - Upload one or more CSV files — each file automatically becomes a table in a new database - Schema is auto-detected from any database and passed dynamically to the LLM prompt - Sidebar schema viewer shows all tables, columns, types, and row counts 4. Interactive Plotly Visualizations - Four chart types: Bar Chart, Pie Chart, Line Chart, and Scatter Plot - Auto-selects appropriate columns (numeric vs categorical) for axes - Dark theme styled charts that match the app UI 5. SQL Security - SELECT-only enforcement — blocks INSERT, UPDATE, DELETE, DROP, ALTER, CREATE, TRUNCATE, and EXECUTE queries before they reach the database - Validation runs on every query before execution 6. CSV Export - One-click download button to export any query result as a .csv file 7. Performance Dashboard - Real-time tracking of total queries, successful queries, and failed queries - Success rate percentage with visual progress bar in the sidebar 8. AI-Powered Summarization - After every successful query, the LLM generates a natural language summary of the results - Users can add custom context (e.g., "write it in Hindi", "explain it simply") to control the summary style TECH STACK - - Frontend: Streamlit - Database: SQLite - LLM API: Groq (Llama 3.3 70B, Llama 3.1 8B, Gemma 2 9B) - Voice Transcription: Groq Whisper (whisper-large-v3) - Visualizations: Plotly Express - Audio Recording: audio-recorder-streamlit - SQL Formatting: sqlparse - Data Processing: pandas --> Response : 0.2 seconds --> Accuracy : 98.2%