The League Office
A fantasy football headquarters for drafting, managing, and researching your leagues. Sync your Sleeper, ESPN, or Yahoo leagues, or run a league natively, and get draft tools, trade and waiver analysis, weekly research, and league history in one place. Half-PPR is the default scoring format.
Features
- Draft: War Room for live drafts and a Mock Draft Simulator with configurable teams, rounds, and roster positions.
- Playbook: League dashboard with My Team, Matchup, Standings, Rosters, Transactions, Power Rankings, and the Press Room.
- Trade: Trade Desk analyzer and Trade Market Values, using player Value/Trend metrics.
- Waivers: The Wire and Top Available, with add/drop suggestions that respect roster requirements.
- Research: Injury Reports, Are They Playing?, Matchups Guide, Strength of Schedule analysis, weekly and season projections, Fantasy Leaders, Fantasy Points Allowed, Most Targeted Players, and Red Zone Stats.
- League Sync: Connect Sleeper, ESPN, and Yahoo leagues from the account menu.
- Hall of Fame: Championship history and single-week and season records.
- Mobile: A dedicated mobile experience under
/m.
- Live ticker: NFL scores running across the top of every page.
Tech stack
- TanStack Start (React 19, TanStack Router, TanStack Query) with server-side rendering
- Vite, Tailwind CSS v4, and Radix UI components
- Supabase for auth and native league ops:
- Database A: users, profiles, leagues, rosters, lineups, transactions, articles, and Hall of Fame records
- TiDB Cloud Serverless (
DATABASE_URL) for player_warehouse, synced league snapshots, and research aggregates (CDN-cached /api/data/* routes)
- Deployed on Vercel with GitHub Actions for tiered background sync
Getting started
You need Node.js and npm — install with nvm.
git clone <this-repository-url>
cd TheLeagueOffice
npm i
npm run dev
Environment variables
Create a .env file in the project root:
# Database A (primary — auth, profiles, site)
VITE_SUPABASE_URL=
VITE_SUPABASE_PUBLISHABLE_KEY=
# Server-only (Database A)
SUPABASE_URL=
SUPABASE_PUBLISHABLE_KEY=
SUPABASE_SERVICE_ROLE_KEY=
# TiDB Serverless (player warehouse + synced snapshots + research aggs)
DATABASE_URL=mysql://USER:PASS@GATEWAY/league-office-native
# Cron / webhook auth
CRON_SECRET=
# Yahoo league sync
YAHOO_CLIENT_ID=
YAHOO_CLIENT_SECRET=
# Press Room + weekly Front Office desks (optional — templates when unset)
GROQ_API_KEY=
# Optional failover / model overrides
GEMINI_API_KEY=
# GROQ_PRESS_ROOM_MODEL=openai/gpt-oss-120b
# GEMINI_PRESS_ROOM_MODEL=gemini-2.0-flash
Set the same variables in your Vercel project settings for deployments.
Retired: Supabase project league-office-brain (Database B) and env vars
VITE_SUPABASE_URL_B / VITE_SUPABASE_ANON_KEY_B. Warehouse + brain hydration
are TiDB + snap-cdn only — see scripts/tidb/CUTOVER.md.
TiDB warehouse (seed / verify)
Full guide: scripts/tidb/CUTOVER.md.
- Set
DATABASE_URL on Vercel (Production + Preview). Prefer a URL ending in /league-office-native.
- Seed (live harvest → TiDB) via Actions → TiDB Warehouse Migrate, or:
export APP_URL="https://www.theleagueoffice.app"
export CRON_SECRET="from-vercel"
curl -X POST "$APP_URL/api/admin/tidb-migrate" \
-H "Authorization: Bearer $CRON_SECRET" \
-H "Content-Type: application/json" \
-d '{"action":"migrate"}'
- Verify:
GET /api/admin/tidb-migrate shows playerWarehouseCount ≈ 4000+, and curl -s "$APP_URL/api/data/players-export" | head -c 200 starts with {"ok":true,"v":7.
- Background sync uses
/api/webhooks/sync and /api/cron/* — never wire host events to repository_dispatch.
Scripts
| Command | Description |
|---|
npm run dev | Start the dev server |
npm run build | Production build |
npm run preview | Preview the production build |
npm run lint | Run ESLint |
npm run format | Format with Prettier |
Database
Supabase migrations live in supabase/migrations. Admin access is granted through profiles.role = 'admin'.
