System Walkthrough
How AiBS Works
An end-to-end walkthrough of the product: ingest, database, models, public routes, AI surfaces, and audit workflow.
ByColby Reichenbach
Overview
AiBS is an end-to-end baseball product, not just a frontend over raw feeds.
The system starts with MLB and related public baseball data, moves through ETL and database transforms, resolves ABS-specific geometry, computes model outputs and summary marts, and then feeds those results into purpose-built public routes.
That same system also supports model audits, usage tracking, admin analytics, and controlled AI surfaces. The product layer and the operational layer are part of the same application, which is why smoke checks, audit runs, alerting, and release verification sit alongside frontend work instead of after it.
The result is a site where the baseball-facing experience and the engineering workflow are tightly coupled instead of being treated as separate worlds.
Flow
From ingest to page render.
The ingest layer pulls baseball data, challenge events, and related profile information into Postgres. Database views and summary marts then normalize that data into the shapes used by the public routes, model audits, and AI explanation tools.
The public loaders in the app then compose those pieces route by route. Some pages use streaming and Suspense so the shell appears quickly while lower-priority sections continue to load.
Public scope
The public product is intentionally narrower than the full system.
The public site exposes the core baseball product, published editorial, and bounded AI explanation on selected analytics and game-context surfaces. Broader AI tools and admin workflows still exist in the system, but they remain gated behind launch configuration and role checks.
That is a product decision as much as an engineering one. Stability matters more than exposing every internal surface at once.
- •Public: home, teams, umpires, games, articles, About, and bounded AI explanation on selected pages.
- •Gated: Copilot, Query Lab, and internal/admin workflows.