---
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: [app.tigzig.com](http://app.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: [app.tigzig.com](http://app.tigzig.com) → Database AI & SQL Apps
* Database providers: [neon.com](http://neon.com), [aiven.io](http://aiven.io), [supabase.com](http://supabase.com/)