How satheeshkumar147/ai_agent_for_ipl works
This repository is an IPL cricket-data question-answering app. A user submits a question in the Streamlit interface; the compiled LangGraph workflow turns it into SQL, runs that SQL against MySQL, and uses the result to produce a displayed answer. A second, separate ReAct agent offers tool-based SQL analysis, while load_data.py imports the deliveries CSV into MySQL. The README is empty, so capabilities and links here are based on the sampled source; the tool agent’s runtime flow is only partly visible.
Main entry points: agent.py SQL generation · graph_agent.py Tool-based agent · app.py Streamlit chat · load_data.py CSV loader
Components 12
Chat interface
- Streamlit chat
app.py
Question answering
- Compiled workflow
agent.py - SQL generation
agent.py - SQL execution
agent.py - Answer generation
agent.py - Tool-based agent
graph_agent.py - SQL tools
graph_agent.py
IPL data
- MySQL database
- CSV loader
load_data.py - Deliveries CSV
deliveries.csv
Other components
- User
- Gemini model
Connections 17
- User → Streamlit chat: asks question
app.py - Streamlit chat → Compiled workflow: invokes
app.py - Compiled workflow → SQL generation: starts at
agent.py - SQL generation → SQL execution: passes SQL
agent.py - SQL execution → Answer generation: passes result
agent.py - Answer generation → Compiled workflow: returns answer
agent.py - Streamlit chat → User: displays answer
app.py - SQL generation → MySQL database: reads schema
agent.py - SQL execution → MySQL database: runs SQL
agent.py - SQL generation → Gemini model: requests SQL
agent.py - Answer generation → Gemini model: requests answer
agent.py - Tool-based agent → MySQL database: builds database connection
graph_agent.py - Tool-based agent → Gemini model: configures model
graph_agent.py - Tool-based agent → SQL tools: gets tools
graph_agent.py - SQL tools → MySQL database: creates database tools
graph_agent.py - CSV loader → Deliveries CSV: reads
load_data.py - CSV loader → MySQL database: loads deliveries
load_data.py