Agent Engineering Bootcamp Capstone Project – Data Analyst Agent

Github: https://www.twine.net/signin
● Shipped a conversational CSV analytics web app (Next.js 15, Vercel AI SDK 5, Supabase/Postgres, Vega-Lite) that plans analyses, runs SQL, generates charts, and outputs editable/exportable Markdown reports.
● Built an agentic loop with two modes—Focused Q&A and Deep-Dive—that executes a multi-step, tool-calling plan with prompt customisation; returns a concise summary plus expandable detailed analysis.
● Designed a reference-based tool chain (executeSQLQuery → queryId → createChart) to minimise tokens and keep results traceable; a Charts tab stores visuals linked to the exact SQL, with side-by-side chart/SQL inspection.
● Added reliability & safety: SELECT-only with auto-LIMIT, timeouts, retries/fix suggestions, clear error surfacing; CSV→Postgres pipeline with type inference, parameterised queries, and transaction-wrapped batch loads.