03In production — Ujyalo2024 — 25
Text-to-BI
Plain-English questions become business intelligence — validated SQL, charts and answers.
- Role
- Associate AI developer
- Year
- 2024 — 25
- Status
- In production
- Stack
- LlamaIndexPydanticAISQL
The mess
Every data question waited on the one person who could write SQL. Dashboards answered last quarter's questions — never this morning's.
The system
A microservice that turns natural language into schema-aware, validated SQL, runs it, and returns the answer as charts and tables. Typed end-to-end with PydanticAI so a wrong query fails loudly, never silently.
The result
Anyone in the company asks in plain English and gets the number in seconds. The analyst does analysis again.
Ad-hoc questions answered in seconds
No SQL knowledge needed
Validated queries — no silent wrong answers