Connect your own AI assistant to your club data
How to plug Claude, ChatGPT or Copilot into your owned data — and what it unlocks.
The assistant never gets a data dump — it asks the connector for exactly what it needs.
- 1
You ask
"Who are our best PK forwards this month?"
- 2
Assistant plans
Writes the query it needs
- 3
Calls the tool
Read-only, via the connector
- 4
Reads gold + validates
Grounded in your data
- 5
Grounded answer
Numbers + a shareable summary
Every answer is grounded in your data and traceable to a query — and you can swap AI providers anytime without touching the data underneath.
The 30-second version
- Expose your gold data through a read-only connector — never paste data into a chat.
- A swappable AI assistant calls that connector to answer questions, grounded in your data.
- You get plain-language answers, scouting reports, opponent prep and post-game summaries.
Start from the architecture you own
This builds directly on the [club-owned data architecture](/explainers/how-a-club-owns-its-hockey-data): the club owns the gold data and models, and everything else is a swappable consumer. An AI assistant is just another consumer — a very powerful one — so it plugs in the same way, with read-only access and no special privileges.
The connector is the whole trick
Do not paste rows of stats into a chat window. Instead, expose your gold tables through a **connector** — a read-only SQL tool or an [MCP server](/explainers/what-is-mcp-and-why-it-matters-for-analytics). Now the assistant can request exactly the data it needs, and the connector is the only way in — and it can only read. Your data never leaves the infrastructure you control.
How a question becomes an answer
When you ask "who are our best penalty-kill forwards this month?", the assistant plans a query, calls the connector, reads the gold tables, sanity-checks the result, and returns a grounded answer with the numbers and a short summary. Because it is reading real data — [expected goals](/glossary/expected-goals), [possession](/glossary/possession), shot rates — the answer is traceable back to a query, not invented.
Keep a guardrail
Let the assistant plan and draft, but wrap it: log the generated SQL, check the output against a known total, and keep a human in the loop for anything that drives a real decision. Speed on the boring parts, judgement where it matters.
What you actually get
- **Answers in plain language** — ask like you'd ask an analyst, no SQL or spreadsheets. - **Instant scouting reports** built from your own player profiles. - **Opponent prep in minutes** — tendencies and matchups on demand. - **Post-game summaries** every night, automatically.
And because the gold layer is the contract, you can switch from one assistant to another whenever a better one appears — without changing anything underneath.
Build it yourself
- 1Expose your gold tables through a read-only SQL tool or MCP server (the connector).
- 2Share the table schema with the assistant so it knows the shape of your data.
- 3Ask a question; inspect the query it writes before trusting the answer.
- 4Add a guardrail: log every query, sanity-check totals, keep a human on real decisions.
- 5Save the working prompt + tools as a named skill for next time.
Key terms
Newsletter
Weekly hockey analytics
Data-driven takes on performance, scouting, and team strategy. No fluff — just the numbers that matter.
No spam. Unsubscribe anytime.
Related explainers
How a club can own its hockey data
A reference architecture where the club owns the data and models — and any AI is just a swappable consumer.
Using Claude to analyze your hockey data
How an LLM turns your data stack into a question-and-answer machine — safely.
What is MCP, and why it matters for hockey analytics
The open protocol that lets an AI safely query your data — explained in one diagram.