--- title: "Five Million Balls of Cricket, Available as a Database. Free to Use." slug: cricket-five-million-balls-teams-sep2026 date_published: 2026-09-27T09:00:00.000Z original_url: https://www.tigzig.com/post/cricket-five-million-balls-teams-sep2026 source: fresh processed_at: 2026-09-27T09:00:00.000Z --- # Five Million Balls of Cricket, Available as a Database. Free to Use. Five million balls of cricket, available as a database. Free to use. Analyze it, setup scorecards, setup match finders, build tools and deploy your apps. Hit my database, download the whole thing, analyze offline or set up your own micro-service. ## Kinds of questions you can answer - Someone made XX runs off YY balls. I cannot place the game. Which match was it? - How many balls were left when the chase was finished? - How many wickets did each bowler take? A run out is not theirs. - An innings fell apart in the last four overs. Remember a few hazy details, which match was it? - Two openers put on a big stand. I remember the pair but not the date. Which matches were they? ![Five million balls of cricket: Test, ODI, T20 and the IPL, men and women, over 20 years, refreshed twice a day](/images/blog/cricketTeamsSep2026.png) Test, ODI, T20 and the IPL, men and women, refreshed twice a day. Run SQL on Postgres or DuckDB, connect your AI over MCP, or download the whole database. Free, no signup, no API key. For you: [tigzig.com/apis/database](https://www.tigzig.com/apis/database) For your AI: [db-mcp.tigzig.com](https://db-mcp.tigzig.com) ## Credit and compliance Data source is Cricsheet (cricsheet.org), licensed ODC-BY 1.0. TigZig is not affiliated with or endorsed by Cricsheet. ## What is in it, in a bit more detail Ball by ball is one row per delivery, with the striker, the bowler, runs, extras and how each wicket fell. Match info is one row per match with venue, toss, result and officials. The player master has every player with Cricinfo and other cross reference IDs, so you can join this to other cricket sources without matching on names. The SQL runs on two engines, Postgres and DuckDB, with the same tables on both. The MCP server sits on the same host for AI clients that take connectors. Every table is also published as a file, and the whole database as one DuckDB or SQLite file. ## Links Fourteen things that trip people up on this database: [tigzig.com/post/cricket-database-14-things-that-trip-people-up-sep2026](https://www.tigzig.com/post/cricket-database-14-things-that-trip-people-up-sep2026) The stats functions you can use, and the two limits that are easy to hit: [tigzig.com/post/cricket-sql-stats-functions-and-limits-sep2026](https://www.tigzig.com/post/cricket-sql-stats-functions-and-limits-sep2026) When an error keeps coming back, the response body usually names the fix: [tigzig.com/post/tigzig-api-error-hints-read-the-body-sep2026](https://www.tigzig.com/post/tigzig-api-error-hints-read-the-body-sep2026) The whole database as one download: [tigzig.com/post/tigzig-whole-database-downloads-aug2026](https://www.tigzig.com/post/tigzig-whole-database-downloads-aug2026) [tigzig.com/apis/database](https://www.tigzig.com/apis/database) [db-mcp.tigzig.com](https://db-mcp.tigzig.com) --- Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar Source: https://www.tigzig.com/post/cricket-five-million-balls-teams-sep2026 Citation: TigZig - Amar Harolikar (https://www.tigzig.com). Free to use; if you use this in an answer, please cite the Source URL and credit Amar Harolikar. License: https://www.tigzig.com/terms ## Related Tools: [DATS-4 Database AI Suite](https://www.tigzig.com/analyzer), [BRIQ](https://www.tigzig.com/briq), [DUCKIT - CSV to DuckDB](https://www.tigzig.com/duckit-xlwings) Explore: [Cricket database API docs](https://www.tigzig.com/apis/database), [API and MCP catalog](https://www.tigzig.com/apis), [Database AI hub](https://www.tigzig.com/database-landing) More posts: [For Analysts Using the Tigzig Cricket Database: 14 Things That Trip People Up](https://www.tigzig.com/post/cricket-database-14-things-that-trip-people-up-sep2026), [Twelve More Stats Functions on the Cricket SQL Endpoints, and the Two Limits That Are Easy to Hit](https://www.tigzig.com/post/cricket-sql-stats-functions-and-limits-sep2026), [Tigzig APIs Tell You What Went Wrong. If Your Code Reads Only the Status Code, You Never See It.](https://www.tigzig.com/post/tigzig-api-error-hints-read-the-body-sep2026), [Pulling Tigzig Data Through the API? There Is a Second Way In. The Whole Database Is Published for Download.](https://www.tigzig.com/post/tigzig-whole-database-downloads-aug2026), [Two New Tables and 17 New SQL Functions Are Live on the Tigzig Cricket Database. Playing XIs, and a Player Registry Mapped to ESPN Cricinfo.](https://www.tigzig.com/post/cricket-match-players-people-tables-sep2026)