What this project is, why it exists, and how it works.
The Ashes Hub is a demonstration of Agentic AI applied to structured sports data. It puts an AI-powered natural language interface on top of a comprehensive Ashes database - so you can ask questions in plain English instead of writing SQL.
The Ashes is cricket's most storied rivalry - rich in history, statistics, and legendary performances spanning 140+ years. It's deep enough to be interesting, structured enough for a database, and beloved enough that people want to query it.
When you ask a question, the AI agent interprets your intent (fixing typos and resolving names), generates a SQL query, executes it safely, and narrates the result in natural language. Every step is logged and auditable.
Frontend: Astro with vanilla JS - fast and lightweight.
Backend: Python FastAPI - async and typed.
Database: PostgreSQL - 384+ matches, 829+ players, 73+ series.
AI Agent: LLM-powered text-to-SQL with 3-layer pipeline.
Ashes Hub is an independent project and is not officially associated with the ICC, Cricket Australia, or the ECB. We strive for accuracy, but some historical records may be incomplete. We welcome feedback to help improve the data.