ChatGPT connected to Supabase, Neon and Aiven databases

ChatGPT connected to multiple databases simultaneously for data analysis and visualization

ChatGPT connected to multiple databases simultaneously for data analysis and visualization. Built on a fixed FastAPI connector + Custom GPT actions.

How This Gpt Works

Direct connection to three databases:

• supabase_postgres: ODI cricket ball-by-ball (~2003-2025)
• neon_postgres: T20 cricket ball-by-ball (~2005-2025)
• aiven_postgres: Tour de France riders & stages (men: 1903-2025, women: 2022-2025)

Semantic layers are pre-mapped. GPT translates your question into SQL, executes silently, and explains results in plain language. Supports charts, aggregations, rankings, and detail lookups.

What It Can Do

• Compute player stats: runs, strike rates, averages (ODI/T20)
• Generate rankings: top scorers, best bowlers, most wins
• Analyze Tour de France history: winners, distances, average speeds, jersey holders
• Create visualizations: bar charts, line charts, comparisons
• Always contextualizes answers by dataset coverage (e.g., ODI 2003-2025)

Important Note

ODI/T20 data = ball-by-ball but not every match globally. Tour de France = complete for men (1903-2025), women (2022-2025).

How To Use It

• Click Chat Link (Custom GPT)
• Ask natural language questions:
• "Top 10 ODI strikers by runs off the bat?"
• "Tour de France winners 2015-2025 with avg speed?"
• Get results in tables + charts
• The GPT itself will guide you if the requested data is out of scope

SETUP (FOR YOUR OWN DEPLOYMENT):

For full steps, see README file in the GitHub Repo link below.

Quick Overview:

• Deploy FastAPI server (app:app)
• Set .env with your DB URLs + API Key
• Update CUSTOM_GPT_ACTION_SCHEMA.json with server URL + API Key
• Upload semantic layer files:
• CRICKET_ODI_T20_DATA_SCHEMA.yaml
• CYCLING_TOUR_DE_FRANCE_SCHEMA.yaml
• Apply CUSTOM_GPT_SYSTEM_INSTRUCTIONS.md as system prompt
• Connect action schema + knowledge files inside Custom GPT builder

Resources

Complete Source Code:

https://github.com/amararun/shared-fastapi-fixed-databases

FastAPI server code with schemas and system instructions for Cricket & Tour de France data analysis

Built On

OpenAI's GPT Platform - This custom GPT transforms ChatGPT into a powerful sports data analysis tool, enabling natural language interaction with cricket and cycling databases. It simplifies data analysis by combining ChatGPT's language understanding with direct database access.

Source: tigzig.com | Open source AI tools for analytics, databases & automation | Amar Harolikar