story: Marcus asks Claude any data question from his phone
User Story
As Marcus, operating Westside Basketball day-to-day from my iPhone,
I want to ask Claude natural-language questions about our players, teams, schedules, registrations, and payments,
so that I can answer parent/player questions on the spot without logging into an admin panel, DMing Lucas, or waiting for someone to pull data.
Examples of questions Marcus should be able to ask
- "How many players haven't paid their jersey fees yet?"
- "Which teams have no coach assigned?"
- "What's the total registration revenue for this tournament?"
- "Who signed up for the April 10-11 tryout but hasn't signed the contract?"
- "How many sessions did we book at SchoolSpace this month?"
- "Which players are on more than one team?"
- "What's the average age of players in the 5th-grade division?"
- "Who are the contacts for team X?"
- "What's the most recent payment from parent Y?"
- "How many active vs inactive players do we have?"
These 10 questions become the Stage-0 sample corpus and the Stage-2 validation gate.
Success Metric
Marcus can ask any of the 10 sample questions from the Claude iOS app on his phone, and Claude returns a correct answer derived from live Postgres data — without Marcus needing to know the schema, SQL, or which table to look in.
Out of Scope
- Writes (any kind). This is read-only.
- Questions spanning databases other than basketball-api's CNPG cluster (v1).
- Self-service admin UIs — Marcus interacts via natural language in Claude, not custom screens.