IPL MCP Server

# Enhanced IPL Dataset Summary ## 🎯 **What Was Added** Following your request for **"add that data set also in which virat is there and csk and mi match dtasetset also"**, the sample dataset has been enhanced from 12 to **18 IPL matches**. ## ✅ **Enhanced Dataset Includes** ### 🏏 **Virat Kohli Matches** - **4 matches** featuring V Kohli (stored as "V Kohli" in database) - **Total runs**: 99 runs across 4 matches - **Performance**: Average 24.75, Strike Rate 117.86 - **Boundaries**: 4 sixes, 8 fours - **Ranking**: ~16th among all batsmen in dataset **Added match files**: 335982.json, 335985.json, 335992.json ### ⚔️ **CSK vs MI Head-to-Head Matches** - **3 direct encounters** between Chennai Super Kings and Mumbai Indians - **Historical spread**: Matches from 2008-2009 seasons - **Results**: - 2008-05-14: MI beat CSK - 2008-04-23: CSK beat MI - 2009-04-18: MI beat CSK **Added match files**: 335989.json, 336018.json, 392181.json ### 📊 **Complete Team Stats** - **Mumbai Indians**: 8 matches, 5 wins (62.5% win rate) - Most successful team - **Chennai Super Kings**: 3 matches, 1 win (33.33% win rate) - **Total teams**: 10 major IPL franchises represented ## 🔍 **Dataset Verification** ```bash # Test V Kohli queries uv run python -c "from src.mcp_server.query_engine import QueryEngine; print(QueryEngine().process_query('who scored the most runs'))" # Test team performance (shows CSK and MI) uv run python -c "from src.mcp_server.query_engine import QueryEngine; print(QueryEngine().process_query('which team won the most matches'))" # Verify database content uv run python -c " from src.database.database import get_db_session from src.database.models import * session = get_db_session() print('V Kohli:', session.query(PlayerStats).filter(PlayerStats.player_name == 'V Kohli').first().total_runs, 'runs') print('CSK vs MI matches:', session.query(Match).filter(((Match.team1.like('%Chennai%')) & (Match.team2.like('%Mumbai%'))) | ((Match.team1.like('%Mumbai%')) & (Match.team2.like('%Chennai%')))).count()) session.close() " ``` ## 🚀 **Ready For Demo** The enhanced dataset now supports all these sample queries: 1. **Basic**: "How many matches are in the database?" → 18 matches 2. **V Kohli**: "Show me Virat Kohli batting stats" → 99 runs, 4 matches 3. **CSK vs MI**: "Which team won the most matches?" → Shows MI leading with CSK included 4. **Team Stats**: Natural queries about Chennai Super Kings and Mumbai Indians work perfectly ## 📁 **File Structure** ``` data_small/ # Enhanced sample dataset (18 matches) ├── 1082591.json # Original matches (12 files) ├── 1082592.json # ... ├── ... ├── 335982.json # V Kohli matches (3 files) ├── 335985.json ├── 335992.json ├── 335989.json # CSK vs MI matches (3 files) ├── 336018.json └── 392181.json ``` **Total**: 18 JSON files with comprehensive IPL data including the specific matches you requested! 🏏✨