Cricklytics is a MySQL-based Database Management System project designed to manage and analyze cricket league data efficiently. The project addresses the challenges of traditional league management — including manual player registration, inefficient scheduling, and lack of real-time data — by implementing a structured relational database solution.

The database is built around five normalized schemas: player, team, match, venue, and coaches. Each schema contains multiple interrelated tables designed using entity-relationship modeling and normalization principles to eliminate data redundancy and ensure data integrity. Key entities include player profiles, team information, coach assignments, stadium details, and match outcomes, all linked through primary and foreign key relationships.

On the application side, the project demonstrates several SQL queries including identifying the list of winning teams, finding the most and least winning teams by frequency, ranking players by win contributions across schemas using JOIN operations, analyzing role frequency distribution among players, and calculating total stadium revenue assuming a ticket price of ₹750. Key insights from the data reveal that Mumbai Indians emerged as the most successful team with 3 wins, Shreyas Iyer led individual win contributions with 3, and the Narendra Modi Stadium in Ahmedabad holds the highest revenue potential at ₹9.9 crore given its capacity of 1,32,000.

The project was developed using MySQL Workbench, with error handling addressed through iterative refinement of SQL scripts