About Premier League AI Agent

An AI-powered agent that converts natural language questions about the Premier League 25/25 seasons data into SQL queries using semantic search and generative AI. Ask questions in plain English and get instant answers, enrichment context, and analytical explanations.

Features

• Natural language querying - ask questions like Who scored the most goals? or Compare Liverpool and Arsenal attacks
• Two-path SQL generation - fast hardcoded path for 70+ known stat patterns, semantic fallback via ChromaDB + LangChain for everything else
• Enrichment cards - top result gets contextual related stats (e.g. asking about goals also shows assists and appearances)
• Responsive design for mobile and desktop
• LLM explanation - complex/analytical queries automatically receive a natural-language analysis from GPT
• Head-to-head comparison - compare any two players or teams side-by-side
• Quick-question chips - one-click common queries

Tech Stack

• Frontend: React 19.0+
• Backend: FAST API(Python 3.13)
• LLM: OpenAI GPT-3.5 Turbo via LangChain
• Vector DB: ChromaDB
• Database: SQLite
• Data Source: Kaggle Premier League 24/25 Seasons dataset