--- title: "Back From Sunday Cricket? Some Cricket SQL Now: A Free Ball-by-Ball Database on DuckDB, Postgres or One Download" slug: cricket-back-from-sunday-sql-oct2026 date_published: 2026-10-25T09:40:00.000Z original_url: https://www.tigzig.com/post/cricket-back-from-sunday-sql-oct2026 source: fresh processed_at: 2026-10-25T09:40:00.000Z --- # Back From Sunday Cricket? Some Cricket SQL Now: A Free Ball-by-Ball Database on DuckDB, Postgres or One Download Paste this into your AI agent: "Go to tigzig.com and let me know what cricket data is available and how to access it." It will find a ball by ball cricket database that takes your SQL on DuckDB or Postgres, or comes down in one download. What can you run? Death overs, how chases went, the tight bowling spells, opening stands, and screens that stack several conditions together. Free, no signup, no API key. For you: [tigzig.com/apis/database](https://www.tigzig.com/apis/database) ## What is in the database, in short - ball_by_ball: one row per delivery, with the batter, the bowler, the runs, the extras and how each wicket fell. - match_info: one row per match, with the venue, the toss, the result and the margin. - match_players: the playing XI and the officials for each match. - people: the player registry, with ESPN Cricinfo IDs for joining to other sources. One thing to note. team1 and team2 follow the order the sides are listed in, and they do not tell you who batted first. For batting order use the margin columns: winner_runs is filled when the side batting first won, and winner_wickets when the side batting second won. Rain-adjusted D/L results can break that, so check the method column too. ## Earlier posts that save time on this database - The 14 things that trip people up: [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 SQL functions you can use, and the limits to know about: [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) ## Credit and compliance Data source is Cricsheet ([cricsheet.org](https://cricsheet.org)), licensed [ODC-BY 1.0](https://opendatacommons.org/licenses/by/1-0/). TigZig is not affiliated with or endorsed by Cricsheet. ![Back from Sunday cricket? Some cricket SQL now: a free ball-by-ball cricket database on DuckDB, Postgres or one download](/images/blog/cricketBackFromSundayOnepagerOct2026.png) --- 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-back-from-sunday-sql-oct2026 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), [Download hub](https://www.tigzig.com/downloads) More posts: [Point Your AI at a Free Ball-by-Ball Cricket Database. Five Million Deliveries, One Paste.](https://www.tigzig.com/post/cricket-point-your-ai-ball-by-ball-sep2026), [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), [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), [The Full Cricket Database Is Now Downloadable. Test, ODI and T20 Ball by Ball, in Parquet, CSV, DuckDB or SQLite.](https://www.tigzig.com/post/cricket-full-data-download-live-aug2026)