GenAI Data Explorer
Chat with your CSVs: multi-file upload, automatic join detection, safe SQL guardrails, interactive charts, and query history.
📖 Overview
GenAI Data Explorer lets analysts and founders ask questions in plain English and get DuckDB-safe SQL plus interactive visuals. Upload multiple CSVs—shared columns are detected to suggest JOINs automatically. PNG/SVG export, query history, and reset-safe UX are built in.
Multi-file Upload
Auto JOIN Hints
LLM → SQL (Guarded)
Charts & Export
✨ Features
- Each CSV becomes a table automatically
- Detects shared keys (e.g., CustomerID) for JOINs
- Few-shot prompts tuned for DuckDB (no dangerous statements)
- Bar/Line/Area/Scatter/Pie with multi-series support
- PNG/SVG chart download
- Query history: re-run & export
🧭 How to use
- Upload one or more CSVs in the sidebar
- Ask a question (e.g., “Monthly trend broken down by segment”)
- Review generated SQL, results, and chart
- Download as PNG/SVG or re-run from history
Registered tables & schema preview.
Monthly trend with one line per category/segment.
Top-N line chart with quick sort and aggregation.
Query history with re-run & CSV export.
🚀 Try It
Test it with your own CSVs or the sample files in the repo.