Back to full roadmap
topicadvanced
Data Analyst Agents (SQL + viz)
Natural language → SQL → execute → generate charts. Answer 'this month's sales trend?' with one prompt.
3 hours1 resources
Pipeline:
- Schema (DDL + sample rows) in context
- NL → SQL generation
- Execute on sandbox DB (SELECT only)
- Result interpretation
- Chart generation (Plotly, Vega-Lite spec)
- Insight summary
Defense: limit SQL injection — agent should have read-only replica only. DROP/DELETE/UPDATE blacklist.
Vendors: Vanna.ai, DataChat, Hex Magic, Mode AI. Power BI / Tableau "Copilot" features follow this pattern.