5d→1h Intent-doc + SQL prep, team-reported
Delivered - Snowflake
- Python
- Claude API
A SQL-support agent's knowledge base, re-engineered.
- Situation
- A team at a major financial institution built an agent to turn analyst requests into SQL, but its knowledge design re-read 1,000+ SQL files for every prompt and answered inconsistently.
- Role
- Re-engineered the knowledge base around structured Snowflake retrieval, replacing 1,000+ file reads with two to four governed queries. Contributed to the Python bridge exposing approved read functions, and tested the request-to-SQL workflow.
- Outcome
- The project lead reported the team's automation cut intent-document and SQL preparation from about five days of human dependency to roughly an hour. The retrieval redesign was my contribution: repeated large file reads replaced by targeted database queries.