About This Project
Project Overview
This project demonstrates the application of natural language processing and machine learning to convert English questions about Premier League soccer data into SQL queries. The system leverages Google's Gemini AI model to understand natural language and generate appropriate database queries.
How It Works
- Users enter questions in plain English about Premier League soccer data
- The system uses Gemini AI to convert the question into an SQL query
- The query is executed against a MariaDB database containing Premier League statistics
- Results are displayed in a table format
- Optional visualizations can be generated to better understand the data
Technology Stack
- Backend: Python, Flask
- Database: MariaDB
- AI Model: Google Gemini
- Frontend: HTML, CSS, JavaScript
- Data Source: Fantasy Premier League API
Example Questions
- "Who are the top 5 goal scorers this season?"
- "Which team has the most clean sheets?"
- "Show me players with more than 5 assists"
- "What is the average goals per game for each team?"