InsightAgent is an AI SQL agent that lets you ask questions about your database in plain English — and automatically:
✔️ Generates SQL
✔️ Executes it
✔️ Fixes mistakes
✔️ Visualizes results
All locally, powered by Llama-3 via Ollama — so your data never leaves your machine.
- 🧾 Converts natural language → SQL
- 🔁 Self-corrects using agentic feedback loops
- 📊 Auto-visualizes results (Plotly)
- 🧪 Includes benchmarking + accuracy evaluation
- 🔐 100% private — no external APIs
| Layer | Tools |
|---|---|
| LLM | Ollama + Llama-3 (local inference) |
| SQL Engine | SQLite (Chinook DB) |
| Agent Framework | Custom prompt + error-aware correction |
| UI | Streamlit + Plotly |
| Evaluation | Python, Pandas, Numpy |
| Storage | Local database only |
| Difficulty | Accuracy | Validity | Avg. Latency |
|---|---|---|---|
| Easy | 90.0% | 100% | ~3.8s |
| Medium | 70.0% | 90% | ~4.5s |
