MLB Desk — Data Inventory

Updated: 2026-04-03 | 43 dashboard sources | 7 groups


Edge Detection (7 sources)

Source Freshness Key Table(s) Rows Schedule
Edge Scanner — Totals edge-scanner-mlb-totals sports_edges (sport=mlb, market_type=total) 1,679 4x daily
Edge Scanner — Spreads edge-scanner-mlb-spreads sports_edges (spread) 432 4x daily
Edge Scanner — Moneylines edge-scanner-mlb-ml sports_edges (ml) 88 4x daily
Edge Scanner — First 5 edge-scanner-mlb-f5 sports_edges (F5 tickers) 4x daily
Edge Scanner — Team Totals edge-scanner-mlb-teamtotal sports_edges (teamTotal) 244 4x daily
Edge Scanner — All edge-scanner-mlb sports_edges + sports_edge_summary 2,443 total 4x daily
Implied Curves implied-curves-mlb market_implied_curves (sport=mlb) 4x daily

Odds & Prices (16 sources)

Source Freshness Key Table(s) Rows Schedule
Kalshi game lines kalshi-mlb kalshi_mlb_prices 1,481,940 Every 30min
Kalshi F5 kalshi-mlb-f5 kalshi_mlb_prices (f5) Every 30min
Kalshi team totals kalshi-mlb-teamtotal kalshi_mlb_prices (team_total) Every 30min
Kalshi futures kalshi-mlb-futures kalshi_mlb_futures 1,056,852 Every 30min
Kalshi awards kalshi-mlb-awards kalshi_mlb_futures (awards) Every 30min
Kalshi series kalshi-mlb-series kalshi_mlb_futures (series) Every 30min
Kalshi other kalshi-mlb-other kalshi_mlb_futures (other) Every 30min
Pinnacle MLB pinnacle-mlb pinnacle_mlb_odds 9,005 Adaptive
Pinnacle F5 pinnacle-mlb-f5 pinnacle_mlb_f5 8,242 Adaptive
SBR Spreads scrape-sbr-mlb-spreads sbr_book_odds (mlb, spread) 4x daily
SBR Totals scrape-sbr-mlb-totals sbr_book_odds (mlb, total) 4x daily
SBR Moneylines scrape-sbr-mlb-ml sbr_book_odds (mlb, ml) 4x daily
SBR All scrape-sbr-mlb sbr_book_odds (mlb) 9,083 4x daily
DK Opening odds-collector Daily
Pregame sharp scrape-pregame-mlb pregame_consensus (MLB) 457 3x daily
Live Scores live-game-scores-mlb live_game_scores (mlb) 38,696 Every 60s

Ratings & Predictions (4 sources)

Source Freshness Key Table(s) Rows Schedule
DRatings scrape-dratings-mlb dratings_ratings + dratings_predictions (mlb) 45 Daily 11 AM
Sagarin scrape-sagarin sagarin_ratings + sagarin_predictions 73 Daily 11 AM
Dimers scrape-dimers-mlb dimers_predictions (mlb) 80 Daily 11 AM
GameSim scrape-gamesim-mlb gamesim_predictions (mlb) 85 Daily 12 PM

Pitching (4 sources)

Source Freshness Key Table(s) Rows Schedule
SP Game Logs mlb-sp-game-logs mlb_sp_game_logs 167 Daily 11 AM
SP Baselines & EWMA mlb-sp-baselines mlb_sp_baselines 127 Daily 11 AM
Bullpen Status scrape-mlb-bullpen mlb_bullpen_status + mlb_bullpen_usage 1,373 Daily 11 AM
Bullpen Usage Log mlb-bullpen-log mlb_bullpen_log 2,240 Daily 11 AM

Batting & Matchups (6 sources)

Source Freshness Key Table(s) Rows Schedule
Platoon Splits mlb-platoon-splits mlb_team_platoon_splits 30 Daily 11 AM
Baseball Reference scrape-baseball-reference br_team_batting + br_team_pitching 60 Daily 11 AM
Baseball Savant scrape-baseball-savant savant_team_batting 29 Daily 11 AM
MLB Stats API scrape-mlb-statsapi mlb_schedule + mlb_standings + mlb_pitchers 325 Daily 11 AM
Lineups mlb-lineups mlb_lineups 222 Game day
Transactions mlb-transactions mlb_transactions 1,076 Daily 11 AM

Game Context (4 sources)

Source Freshness Key Table(s) Rows Schedule
Park Factors (all 30) mlb-park-factors-full mlb_park_factors_full 30 Weekly
Park Factors (per-game) mlb-park-factors mlb_park_factors 4 Daily
Weather scrape-mlb-weather mlb_game_weather 0 (needs trigger) Daily pre-game
Ump Scorecards scrape-umpscorecards umpire_stats + umpire_daily_assignments 226 Daily 11 AM

Computed Analytics (4 sources)

Source Freshness Key Table(s) Rows Schedule
Derived Metrics mlb-derived-metrics mlb_derived_metrics 30 Game day
Team Variance mlb-team-variance mlb_team_variance 30 Daily 11 AM
Inning Scoring mlb-inning-scoring mlb_inning_scoring + mlb_game_innings 156 Daily 11 AM
Fatigue & Travel mlb-fatigue-metrics mlb_fatigue_metrics 156 Daily 11 AM

Kalshi Series (92 total)

Game-Day (7): KXMLBGAME, KXMLBSPREAD, KXMLBTOTAL, KXMLBF5, KXMLBF5SPREAD, KXMLBF5TOTAL, KXMLBTEAMTOTAL

Futures (45): KXMLB (WS), KXMLBWS, KXMLBAL/NL, division winners (6), team wins (30), KXMLB500, KXMLBBESTRECORD, KXMLBWORSTRECORD, KXMLBPLAYOFFS

Awards (17): MVP (2), Cy Young (2), ROY (2), MOY (2), CPOTY (2), Reliever (2), Hank Aaron (2), Silver Slugger, WS MVP, Executive

Props (10): KXMLBHR, KXMLBHIT, KXMLBKS, KXMLBTB, KXMLBHRR, KXMLBSTAT, KXMLBSTATCOUNT, KXMLBSEASONHR, KXMLBHRDERBY

Series (3): Playoff series winner, exact, total games

Other (10): All-Star, spring training, trades, streaks, misc


Key Parameters

Parameter Value
NB dispersion ratio 1.15
Walk-off correction -2.5%
F5 scoring fraction 0.57
EWMA alphas 0.10, 0.12, 0.15
Min net edge 4 cents
Kalshi fee 7%
SPQC weights 0.6 FIP + 0.2 ERA + 0.2 EWMA
BAI scoring closer(30) + setup(20) + stress(30) + workload(20)
Temp adjustment +0.01 runs/degree above 72F
Altitude adjustment +0.05 runs/1000ft above 500ft
Source: ~/.claude/projects/-home-ubuntu-edgeclaw/memory/mlb-desk-data-inventory.md