Text-to-BI
An agentic BI assistant that turns business questions into checked SQL, then streams answers with tables and visualizations.
- Role
- Associate AI developer
- Year
- 2024 — 25
- Status
- In production
- Stack
- LlamaIndexPydanticAISQL
The mess
Non-technical users needed to explore business data without writing SQL or waiting for a new dashboard. The assistant needed to work with the right schema context, handle invalid queries, and make the result understandable.
The system
I worked on an agentic BI assistant that selects schema context, generates SQL, checks and rewrites failed queries, and returns analysis as tables or visualizations. My contributions included SQL rewrite and validation, input validators, model-call retries, error handling, and FastAPI/SSE streaming so the interface could receive results as the workflow progressed.
The result
Business questions become inspectable queries and streamed analysis, without requiring the user to write SQL.