A season-aware NFL and FBS college football schedule and playoff bracket builder. Follow preseason and regular-season games, then create predictions, share them with friends, and track picks through the playoffs.
Disclaimer: This project is not affiliated with, endorsed by, or connected to the National Football League (NFL), NCAA, College Football Playoff, or any of their member teams. All team names, logos, and related marks are trademarks of their respective owners.
- 🗓️ Current and prior-season schedules with week dates, live details, and final scores
- 🖥️ Wide-screen schedule sidebar with inline, auto-refreshing live game details
- 🔒 Postseason picks unlock only after that season's playoff schedule is posted
- ⏭️ Phase and week navigation for upcoming games
- 🏈 Full playoff bracket with Wild Card, Divisional, Championship, and Super Bowl rounds
- 💾 Automatic progress saving with localStorage
- 📱 Mobile-first responsive design
- 🖼️ Export bracket as shareable image
- 🎨 Dark mode with team colors
- 👤 Clerk sign-in, sign-up, and profile controls
Choose College football to browse FBS schedules and live or final game details. The league, season, phase, week, and selected game are deep-linkable. Bowls / CFP includes both bowl games and the dedicated CFP schedule. The published 12-team CFP field unlocks picks with four first-round byes and fixed paths (no reseeding). Changing an earlier pick clears dependent picks that are no longer possible.
CFP picks save in this browser separately for each season. Account saves, share links, image export, and NFL historical insights remain NFL-only. CFP picks require a complete, consistent field in ESPN's playoff feed; ordinary rankings never unlock a bracket. The 2025 field is available by selecting the prior season. Current-season picks wait for the published field, and partial feeds show an explicit unavailable state.
First, install dependencies:
bun installLink the Clerk development application and pull its local configuration:
clerk auth login
clerk init --app app_3JIG7yUoXrPnpfQD5YLkhamcC00
clerk doctorSelect the personal Clerk workspace containing bracket.build when authorizing the CLI.
Clerk writes development keys to the ignored .env.local file. Never commit secret keys.
For an already configured checkout, use clerk env pull after linking instead of repeating initialization.
Then run the development server:
bun devOpen http://localhost:3000 with your browser to see the result.
Sign in from the header and open My brackets to create, save, and reopen private brackets across devices. Guest brackets remain in browser storage. Use Import browser brackets to copy those saves into your account; the originals remain on this device.
Saved brackets can publish a read-only snapshot with Create share link. Links expose the bracket name, display name, subtitle, and picks to anyone holding the link. Further edits stay private until published again. Stop sharing to permanently revoke that link. Friends can compare their account brackets on the shared page. Correct-pick counts are informal because predictions remain editable. Account saves currently support the 2025 postseason.
For CI and deployment, configure NEXT_PUBLIC_CLERK_PUBLISHABLE_KEY and
CLERK_SECRET_KEY in the environment. Use development keys for local testing and configure
a Clerk production instance and its production keys before deploying authentication publicly.
- Next.js 16 with App Router
- React 19
- Tailwind CSS 4
- Radix UI primitives
- html-to-image for bracket export
Account brackets use Postgres, Drizzle migrations, and Clerk user IDs. Set DATABASE_URL
to a pooled connection for the app and DATABASE_URL_UNPOOLED to a direct connection
for migrations. Keep both in your environment manager; never commit connection strings.
Vercel Production and Preview builds automatically apply committed migrations before building the app.
Configure both variables in Vercel's Production environment using the Neon main branch.
For Preview, let the Neon integration supply both URLs for that preview's branch.
The migration and runtime URLs must target the same database branch.
Missing migration credentials or a failed migration stops deployment. A direct-connection
advisory lock serializes concurrent builds; Drizzle records applied migrations for safe retries.
Local builds skip this step; run bun run db:migrate to update your local development database.
Migrations run before traffic switches, so schema changes must remain compatible with the currently deployed app. Use additive changes first; remove old columns in a later release. Rolling back an app deployment does not roll back the database schema.
bun run db:migrate
bun run test:unitTest schema changes on an isolated Neon development branch before applying them to production.
CI runs migrations and ownership/conflict/sharing tests against an ephemeral Postgres service.
Local storage integration tests run when TEST_DATABASE_URL points to a migrated test database.
Authenticated browser tests require Clerk development keys. They create temporary
users with +clerk_test email addresses (no email delivery) and delete them after
each worker finishes. Settings responses are mocked in browser tests; persistence
and account isolation are checked against the test database.
Sign in, open Settings, and enable Ridiculous stats (BETA). The setting defaults to off and is saved to your account across devices. Guests and accounts that have not opted in do not see the feature; its API also requires opt-in. Settings and insight responses are private and never cached by the CDN.
Then open a game's Stats tab and choose Generate ridiculous stat. Both the setting and insight card carry a BETA badge. The feature searches 20 team metrics across opponent nickname categories, month, weekday, and home/away/neutral location, plus the exact opponent and overall team history. Every claim starts with a measured total from the selected game. Football-context comparisons take priority, with first-since claims ahead of records and ties, including rare low totals in completed games. Letter-count categories share at most one result per game, shown after the other comparisons. There is no standalone historical-trivia fallback or LLM. Before kickoff or without a supported comparison, the feature shows an empty state. Show the receipts lists every earlier comparison game, with pagination, metric values, dates, and ESPN links.
Historical data comes from nflverse team stats and nflverse schedules. The two small CSV test fixtures are excerpts of those sources for the 2025 Arizona–New Orleans game. The ESPN JSON fixture contains team totals from the live Seattle–Arizona game on September 20, 2026. The archive covers regular-season and postseason games from 1999; preseason is not included. Source data remain subject to their owners' terms.
Apply the migration and load the archive into your development or preview
database before testing. The importer uses DATABASE_URL; Bun reads .env.local.
bun run db:migrate
bun run stats:import --dry-run
bun run stats:import
# Refresh a specific range, including historical corrections:
bun run stats:import --from 2003 --to 2025Without a range, the importer backfills missing seasons and refreshes the latest two seasons. Each season is validated and replaced atomically; reruns are safe. Missing box scores and measurements stay null. Unsupported comparisons, gaps in imported seasons, and cohorts smaller than ten games never produce a record. Regular-season and playoff comparisons are separate. Historical games never use later games as evidence. Team history follows franchise relocations, while nickname classifications and display names use the season's identity. "Animal" means the team nickname, not the costumed mascot; Buffalo's Bills are not included.
ESPN supplies live context. Its missing values stay null in the comparison engine, and live claims say "so far" and compare against completed games. Missing current values cannot trigger claims, and low-total claims wait until the game is final. Generated insights stay at their labeled snapshot time while the box score polls; choose Another ridiculous stat to fetch a new snapshot. The existing insight stays visible while that request loads. Touchdowns, field goals, and punts come from ESPN's explicit team totals in the player-stat groups; missing totals are never inferred as zero. First-since claims require a complete comparison set of at least ten games and at least five intervening qualifying games. They can describe recent occurrences within the same season. After import, completed games use the same corrected nflverse metrics as their historical comparison games. Games on the current Eastern date stay provisional until a later import. Archive updates also pick up nflverse's subsequent stat corrections.
For production, set a random CRON_SECRET of at least 32 characters in Vercel.
The daily 10:00 UTC cron authenticates with that secret, backfills the archive on
its first run, and subsequently refreshes the latest two seasons. Vercel cron jobs
run only on production deployments. Preview databases must be seeded with the
CLI; an unseeded preview displays an archive-unavailable message. To populate a
new production database immediately after deployment, run bun run stats:import
with that environment's database connection. An interrupted import resumes at
the remaining seasons on the next run. Upstream or database failures preserve
previously committed season snapshots and leave ordinary game stats usable.
Use GitHub native stacks via the official gh stack extension and ordinary Git commits.
Start with gh stack init, add dependent layers with gh stack add, and publish with
gh stack submit. See GitHub's stacked PR guide.
Licensed under the Apache License 2.0. See LICENSE for details.