Run a read-only SELECT against the NFL warehouse (DuckDB). Multiple statements are rejected. See describe_warehouse for tables and gotchas.

List tables/views (no arg) or show one table's columns plus the relevant data-dictionary notes (gotchas, join keys, conventions).

Team record, EPA splits (season-to-date and last 5 games), rest/travel profile, and next scheduled game. through_week=0 means whole season.

Find a player (name substring or gsis_id), return id bridge, bio, and recent season stat lines from the cross-era weekly view.

Model prediction for a matchup: home win probability, predicted margin, feature inputs. Uses schedule rest days if the game is scheduled; attaches the market line when available. Early-season caveat applies (weeks 1-3).

Current model power ratings for all teams (EPA/play units; ratings entering the next game). net = mean(off) - mean(def); lower def is better.

Backtest summary and the honest verdict from the last training run.

Open Kalshi NFL markets. kind: game | spread | total | win_totals | superbowl. Optional team filter (canonical code, e.g. DET). Prices are probabilities in dollars (0.64 = 64c = 64% implied).

One market's full picture: current prices, top-of-book depth, implied probability at bid/mid/ask, spread width, and estimated fee.

Record a price snapshot of ALL open NFL markets into kalshi.duckdb (adds to line-movement history). Also runs on the 6h schedule.

Recorded price history for one market from accumulated snapshots.

Head coach career: records, playoffs, ATS, 4th-down aggressiveness, pass-rate-over-expected, scheme identity (curated), rivalry records.

Head referee tendencies 2015+: penalties/game, home penalty bias, over rate, home win/cover rates. Empty name = all refs ranked.

Upcoming games: Vegas lines vs live Kalshi prices with dislocation flags (market-vs-market, fee-adjusted) and situational angles.

Full-text search over ALL stored news (ESPN, team sites, PFT, Yahoo) ranked by relevance. e.g. 'Gibbs hamstring', 'coaching change Arizona'.

Recent news and injury-report entries for a player (name or gsis_id), from the polled ESPN feeds in news.duckdb.

Latest league headlines (optionally filtered to one team) from the polled ESPN news feed.

Coverage and staleness: latest season/week per core table, last refresh-log lines, and whether a refresh looks needed.

Download latest nflverse data and rebuild the warehouse (~1-2 min). Runs as a subprocess so the server holds no DB handle during rebuild.