--- title: "T20 and ODI Ball by Ball Are Now on Both Engines, Postgres and DuckDB. Run Your SQL Directly on My Server." slug: db-mcp-both-formats-both-engines-aug2026 date_published: 2026-08-19T06:30:00.000Z original_url: https://www.tigzig.com/post/db-mcp-both-formats-both-engines-aug2026 source: fresh processed_at: 2026-08-19T06:30:00.000Z --- # T20 and ODI Ball by Ball Are Now on Both Engines, Postgres and DuckDB. Run Your SQL Directly on My Server. Both T20 & ODI cricket ball by ball now there on both engines - Postgres & DuckDB. Run your SQL directly on my server. Free, no auth, no key. Calculate strike rates by batter against pace and against spin, over by over run rates through the death overs, head to head records between two teams across a decade, dismissal patterns by bowler type, home and away splits by venue... etc .. etc Auto-refreshes twice a day. Tip: most calls come in over GET, and the commonest error is still the URL rather than the SQL, so if a query comes back looking mangled, send it as a POST with a JSON body instead. Docs - for humans: [db-mcp.tigzig.com/v1/redoc](https://db-mcp.tigzig.com/v1/redoc) - for your AI: [db-mcp.tigzig.com/v1/openapi.json](https://db-mcp.tigzig.com/v1/openapi.json) Credit: data sourced from [Cricsheet](https://cricsheet.org), [ODC-BY 1.0](https://opendatacommons.org/licenses/by/1-0/). ## No MCP required, just ask your AI worker If you have a ChatGPT or Claude subscription - both come with a Cowork app - you can simply share the message / link above and ask it to explore the data for you. Also with a Gemini subscription which comes with Antigravity .. which is actually a full fledged AI Coder. Comes with the $20 / Rs. 1,950 subscription also. No MCP required.. just ask like in a regular chat bot ... they will go and fetch the data directly via API .. copy it to your local drive, create excel, deck, reports for you also if you'd like. Just download their desktop app and login .. that's it .. For more on using AI Workers, Tigzig AI Worker hub at [tigzig.com/claude-for-analytics](https://www.tigzig.com/claude-for-analytics) ## What is allowed, and what gets refused It is read only. Writes, DDL, and anything that reads a file or a URL are refused. There are caps on functions that can generate rows from nothing or spin CPU without limit, and the refusal names the specific function so you can drop that one and retry rather than rewriting the query. Schema discovery is deliberately open. `information_schema` works, `SHOW TABLES` and `DESCRIBE` work, so you or your agent can find the columns without me publishing them anywhere. A couple of the guards were tighter than they needed to be in the first week and got loosened once I realized I was refusing many regular queries. The Postgres now runs on my self hosted box, so way faster than earlier which was on a managed instance. [db-mcp.tigzig.com/redoc](https://db-mcp.tigzig.com/redoc) ## Related Tools: [DATS-4 Database AI Suite](https://www.tigzig.com/analyzer), [BRIQ](https://www.tigzig.com/briq), [QRep - Security Reports](https://www.tigzig.com/qrep) Explore: [API and MCP catalog](https://www.tigzig.com/apis), [Claude for Analytics hub](https://www.tigzig.com/claude-for-analytics), [Database AI apps](https://www.tigzig.com/database-landing) More posts: [Getting Errors Running SQL Against the Tigzig Cricket Database? The Most Common Failure Is the URL, Not Your SQL.](https://www.tigzig.com/post/db-mcp-url-encoding-errors-aug2026), [Run Your Own SQL on My Cricket Database. T20 and ODI Ball by Ball Since 2002, Free, No Signup and No Key.](https://www.tigzig.com/post/db-mcp-cricket-sql-queries-aug2026), [A Database Server With API and MCP You Can Point an AI Agent At, With Ball-by-Ball Cricket Behind It.](https://www.tigzig.com/post/db-mcp-cricket-ball-by-ball-api-aug2026), [Four Days of an Open SQL Endpoint. What Real Cricket Queries Needed, and the SSRF Someone Found in the First Couple of Hours.](https://www.tigzig.com/post/db-mcp-four-days-ssrf-query-guards-aug2026) --- Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar Source: https://www.tigzig.com/post/db-mcp-both-formats-both-engines-aug2026 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