Beyond Text-to-SQL: An Agentic LLM System for Governed Enterprise Analytics APIs
For enterprise analytics, this work addresses the gap between natural language interfaces and governed APIs, ensuring security and compliance while enabling non-technical users to access data.
The paper presents Analytic Agent, an LLM-based system that translates natural language intents into secure interactions with enterprise analytics APIs, addressing the limitations of Text-to-SQL in governed environments. Evaluated on 90 real enterprise use cases, it reliably interprets user goals, validates permissions, executes queries, and generates compliant visualizations.
Enterprise analytics aims to make organizational data accessible for decision-making, yet non-technical users still face barriers when using traditional business intelligence tools or Text-to-SQL systems. While recent Text-to-SQL approaches based on Large Language Models (LLMs) promise natural language access to structured data, they fall short in enterprise settings where analytics pipelines rely on governed APIs rather than raw databases. In practice, these APIs encapsulate complex business logic to ensure consistency, auditability, and security. However, delegating mathematical or aggregation logic to an LLM introduces reliability and compliance risks. To this end, we present Analytic Agent, an LLM-based agentic system that translates natural language intents into secure interactions with enterprise analytics APIs. Evaluated on 90 real enterprise use cases constructed by domain experts, it reliably interprets user goals, validates permissions, executes governed queries, and generates compliant visualizations through multi-step reasoning and policy-aware orchestration.