Novartis
Natural-language analytics agent
Agentic text-to-SQL assistant that lets business users query governed compliance data in plain English, with per-user access guardrails.
- Problem
- Business users needed answers from governed compliance data whose question sets vary by country, time period and activity type.
- Built
- A multi-stage agent pipeline (categorise → clarify → plan → run SQL) that corrects its own SQL from execution errors, splits multi-part questions into sub-queries, and enforces per-user data access in the query layer.
- Outcome
- Self-service, SQL-grounded answers with charts. Extended from one data domain to three through a pluggable data-source layer, with request tracing and user feedback built in.
- Stack
- Python · FastAPI · React/TypeScript · Azure OpenAI · Snowflake
