AI-Powered Data Query Application

AI-powered data analysis application that enables users to query datasets using natural language. The system automatically converts user questions into SQL, executes them on uploaded datasets, and returns actionable insights without requiring SQL knowledge.

Tech Stack: Python, Streamlit, DuckDB, Groq API, Pandas, dotenv

Upload and analyze multiple CSV and Excel datasets simultaneously

Natural language to SQL conversion using Groq LLM

Automatic SQL execution through DuckDB's in-memory analytics engine

Multi-query support that processes several analytical questions in a single request

Instant tabular results and dataset previews through an interactive Streamlit interface

Automated data exploration without requiring SQL expertise

LLM-driven query generation for natural language analytics

DuckDB integration for high-performance in-memory SQL execution

Dynamic prompt engineering to generate accurate SQL from user requests

End-to-end analytics pipeline from data ingestion to insight generation

Revenue and sales analysis

Customer and product performance reporting

Trend identification across datasets

Aggregation, filtering, and comparative analytics using natural language queries

Exploratory data analysis without manual SQL writing