---
title: "Cricket (ODI/T20) & Tour de France stats from a Custom GPT connected to 3 live databases."
slug: cricket-odi-t20-tour-de-france-stats-from-a-custom-gpt-connected-to-3-live-databases
date_published: 2025-09-17T09:22:00.650Z
original_url: https://www.tigzig.com/post/cricket-odi-t20-tour-de-france-stats-from-a-custom-gpt-connected-to-3-live-databases
source: migrated
processed_at: 2025-12-03T13:30:00.000Z
---

# Cricket (ODI/T20) & Tour de France stats from a Custom GPT connected to 3 live databases.

Ask it a natural-language question. It queries the right DB and gives you the answer. It's a live connection to three separately hosted Postgres databases - Supabase, Neon & Aiven.

The GPT dynamically shifts connections to analyze 340 MB of data spanning 2.5 million rows in six tables across the 3 databases - 122-year history for Tour de France, and 22 years for Cricket across 7,596 matches.

## The Databases (Live Data)

* **supabase_postgres** → ODI ball-by-ball (2003→2025) / 1.5M rows
* **neon_postgres** → T20 ball-by-ball (2005→2025) / 1M rows
* **aiven_postgres** → Tour de France riders + stages (men 1903→2025; women 2022→2025)

## What it Does

* Computes player stats (runs, strike rate, averages)
* Builds rankings (top scorers, best bowlers, most wins)
* Summarizes Tour history (winners, distance, avg speed)
* Produces charts & run statistical analysis with python

## Try it yourself - sample questions

The GPT has starter prompts. Ask things like:

* **Cricket:** "Top 10 ODI strikers by total runs off the bat, with matches, overs, and run rates per match/over. Add two charts for run rates."
* **Tour de France:** "Show Tour de France winners from 2015–2025 with distance, time, and average speed. Also, chart the riders with 3+ wins in history."

## Custom GPT = practical analytics tool

* UI + agent + Python sandbox out of the box. Efficient + cost effective
* Use for automations, report generators, and database applications
* Live examples: [www.tigzig.com](http://www.tigzig.com) → GPT section (top menu)

## Customize & Deploy

* **FastAPI backend** powers any custom front end, BI tool, or internal app.
* **Open-source** - repo and docs include architecture, action schema, and deployment steps.
* **Auth:** Bearer API key in this GPT. OAuth supported for role-based access and RLS (row level security)

## Links

* SQL AI Apps: [www.tigzig.com](http://www.tigzig.com) → Database AI & SQL Apps
* Database providers: [neon.com](http://neon.com), [aiven.io](http://aiven.io), [supabase.com](http://supabase.com/)


Cricket data from [Cricsheet](https://cricsheet.org), published under the [Open Data Commons Attribution License 1.0 (ODC-BY)](https://opendatacommons.org/licenses/by/1-0/).

<!-- blog-sidebar-related -->
## Related

Tools: [Multi-Database GPT](https://www.tigzig.com/cricket-tour-de-france-gpt), [ChatGPT to Any Database](https://www.tigzig.com/rex2-gpt), [DATS-4 Database AI Suite](https://www.tigzig.com/analyzer)

Explore: [Database AI Apps hub](https://www.tigzig.com/database-landing), [Custom GPTs hub](https://www.tigzig.com/gpts-landing), [API/MCP hub](https://www.tigzig.com/apis)

More posts: [Connect ChatGPT to Multiple Remote Databases](https://www.tigzig.com/post/connect-chatgpt-to-multiple-databases), [ChatGPT connected to your databases. One-click deployment instructions for AI Coders](https://www.tigzig.com/post/chatgpt-connected-databases-ai-coder-deployment), [Connect ChatGPT to Supabase in 10 mins.](https://www.tigzig.com/post/connect-chatgpt-to-supabase-in-10-mins)

---
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-odi-t20-tour-de-france-stats-from-a-custom-gpt-connected-to-3-live-databases
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