§00 foot.io · the verifiable football database private beta · v1

The most complete, unified & verifiable
database of football.

Every league and every season, back to the 1870s — unified under one canonical schema, with source provenance on every fact and cross-source verification behind it. And built to be machine-accessible: query it like Postgres over REST, or in natural language via MCP.

§01 The dataset, in real numbers live count
Competitions
Players
Clubs
Matches
Transfers
Earliest match

Counts read from the production Supabase right now (no caching). Refresh to see them tick. Full source-attribution + per-row provenance is preserved on every entity.

§02 Postgrest-style queries GET /v1/*

Filter, embed, sort. Same Postgres you'd write yourself.

Predicate filters on every column, embed related rows in one round-trip, ordering and pagination via standard headers. The data lives in Postgres; we expose it via PostgREST and a thin custom auth layer.

  • Filter: ?goals=gte.20&season_id=eq.471
  • Embed: ?select=*,club:teams(name,logo_url)
  • OpenAPI 3.1 schema · auto-gen SDKs (TS / Python / Go / Rust)
  • MCP server for Claude / GPT — natural-language queries
~/foot.io · live
connecting to api.foot.io…

↳ live data from the production DB. Nothing fictional, no carousel.

§03 The dataset, in 12 endpoints resource model

Twelve resources. Every aspect of the sport.

§04 Country coverage GET /v1/competitions?country=*

Every country. Live count.

Top-15 by competition count, queried from the live database. Click any name to drill into that country's competitions — every league back to its earliest indexed season.

Counts include cups, regional leagues, women's competitions, junior tiers — anything we have at least one season for.

Loading from API…
§05 Public keys arrive Q3 2026

curl, when keys go live.

foot.io is in private beta. Tiers are indicative — Free 5k req/mo, Pro $49/mo, Commercial $499/mo, OSS $0 with attribution. Waitlist is open; design partners are using the API today.

# Once keys go live, this returns Arsenal's full 2024-25 season: curl 'https://api.foot.io/v1/matches? select=match_date,home_score,away_score, home:teams!matches_home_team_id_fkey(name), away:teams!matches_away_team_id_fkey(name), venue:stadiums(name) &season_id=eq.SEASON_ID &or=(home_team_id.eq.55,away_team_id.eq.55) &order=match_date' \ -H "x-api-key: $FOOTIO_KEY"