Question
Ticket: "Make the analytics dashboard faster." It's a Python/SQL app where a few queries against a 200M-row Postgres table feel slow. You want to use an AI agent but the ticket has no clear shape. Break it into agent-sized steps with checkpoints, and identify which step is actually a human-led investigation the agent can only assist with, not own.
Treat the AI’s output as a draft to verify, not an answer to trust. Name the specific flaw and the input that triggers it, say how you’d catch it — tests, edge cases, reading critically — and how you’d re-prompt or decompose to get it right.
Vibe coding: describe the solution in plain language (or narrate it) and the coach grades your approach. Generating runnable code from your description is coming next.