Skip to content

feat: cut v0.2.13 — explorer interactivity, knowledge & guide pages (#191)#192

Merged
w7-mgfcode merged 29 commits into
mainfrom
dev
May 18, 2026
Merged

feat: cut v0.2.13 — explorer interactivity, knowledge & guide pages (#191)#192
w7-mgfcode merged 29 commits into
mainfrom
dev

Conversation

@w7-mgfcode
Copy link
Copy Markdown
Owner

Release v0.2.13devmain. Tracking: #191.

What's in this release

PR Change
#190 feat(ui): Explorer interactivity — Model Runs & Jobs detail views, comparison, verify, sorting (PRP-21)
#188 feat(ui): Explorer interactivity — detail views, richer tables, Sales charts, cross-filtering (PRP-20)
#186 feat(ui): Knowledge page + Agent Guide page (PRP-19)
#184 fix(agents): wire FallbackModel so a primary 503 retries the fallback
#182 fix(data): anchor seeded data window to the current date

3 feat + 2 fix → pre-1.0 PATCH bump → v0.2.13.

Release mechanics

  • PR title is feat:-typed so release-please bumps regardless of merge method (avoids the merge-subject trap documented in docs/_base/RUNBOOKS.md).
  • All four main status checks (Lint & Format, Type Check, Test, Migration Check) must be green before merge (branch protection, ci: tighten main branch protection — require status checks at the release boundary #108).
  • After merge, release-please opens the chore(main): release 0.2.13 PR; merging that tags v0.2.13 and runs cd-release.yml.
  • Follow up with a maindev back-merge.

🤖 Generated with Claude Code

w7-mgfcode and others added 29 commits May 14, 2026 06:11
#94) (#127)

Resolves #94 via the heuristic path documented in the issue. No schema
column, no Alembic migration, no FIFO cohort tracking — the trigger
self-reads the existing per-(store, product) on_hand_qty series and
fires when inventory has been "unrefreshed" past
`cfg.age_days_threshold`.

Decision rationale (schema column vs. heuristic):
- The schema column path would add `oldest_unit_age_days` to
  `inventory_snapshot_daily`, plus an Alembic migration, plus FIFO
  cohort tracking in `InventorySnapshotGenerator`. No downstream
  consumer reads this column today — adding it for one generator
  trigger violates the "don't design for hypothetical future
  requirements" rule in CLAUDE.md.
- The heuristic path is self-contained in MarkdownGenerator,
  deterministic (preserves the zero-rng-draw regression invariant),
  and additive (no migration, no model change). 354 LOC net, all
  inside one slice.

Heuristic spec:
- A "refresh" is a day where `on_hand_qty` rose by >=
  `_AGE_DAYS_SPIKE_THRESHOLD` (0.3 = 30% jump) vs the prior day.
- Age at day t = days since most recent refresh (or `dates[0]` if no
  refresh has been observed).
- Firing requires age >= `age_days_threshold` AND on_hand >=
  `markdown_min_units_remaining` — never markdown an empty shelf.
- After firing, refresh anchor resets to the day AFTER the markdown
  window ends, so back-to-back fires can't happen and the next age
  clock starts from a "clear shelf" baseline.

Wiring: `MarkdownGenerator.generate()` gains an optional kwarg
`inventory_records: list[dict[str, Any]] | None = None` which `core.py`
passes through from `InventorySnapshotGenerator`. Disabled-path and
non-age_days-path behavior is byte-identical (kwarg ignored).

Tests: +7 new in `TestAgeDaysTrigger`, -1 obsolete
`NotImplementedError` test. Coverage: no-records defensive, threshold
not-met, threshold met, spike resets age, post-fire reset avoids
back-to-back, low-inventory skip, unknown-product skip, rng
non-consumption.

Validation (local):
- ruff check + format: clean
- mypy --strict: 0 issues, 192 files
- pyright --strict: 0 errors
- pytest -m "not integration": 969 passed (+7 vs pre-PR)

Closes #94.
* docs(docs): add INITIAL-14 + PRP-15 e2e demo pipeline plan (#128)

Adds the planning documents for the end-to-end demo pipeline work tracked
in #128. Implementation commits follow on this branch.

- INITIAL-14.md: PRD for `make demo` (problem, solution, success metrics,
  open questions resolved in the PRP).
- PRPs/PRP-15-e2e-demo-pipeline.md: full execution plan (16 tasks → 6
  commits, additive only — no schema changes, no API edits).

* feat(data): add demo_minimal scenario preset (#128)

Tiny preset that powers the upcoming `make demo` target. Three stores ×
ten products × 92 days (2024-10-01..2024-12-31) — wide enough to satisfy
an expanding backtest with n_splits=3, horizon=14, min_train_size=30
(needs >= 72 days, 92 leaves margin), small enough to keep the demo
loop comfortable on a laptop.

Mirrors the retail_standard tuning (mild linear trend, noise_sigma=0.10,
modest promotion + stockout probabilities) so backtest WAPE stays
non-NaN across all three baseline models.

- app/shared/seeder/config.py: add DEMO_MINIMAL enum + from_scenario branch
- app/features/seeder/service.py: add ScenarioInfo entry in list_scenarios
- tests cover the new preset and the updated scenario count

* feat(api,docs): scripts/run_demo.py end-to-end pipeline driver (#128)

Single-file async driver that walks the published HTTP surface
(precheck -> reset? -> seed -> status -> features -> train x3 ->
backtest x3 -> register -> verify -> agent -> cleanup). Mirrors the
shape of scripts/seed_random.py and scripts/check_db.py.

- HttpClient: thin httpx.AsyncClient wrapper with explicit 60 s
  timeout (default 5 s is too short for /seeder/generate); surfaces
  RFC 7807 problem+json bodies as a typed StepError that echoes
  title / detail / request_id (never the raw body — secrets-safe).
- DemoContext + StepOutcome dataclasses thread cross-step references.
- Reporter renders the output-formatting.md glyphs (verbose by
  default, --quiet collapses to one line per step).
- Per-step error handling converts httpx + StepError into fail
  outcomes; precheck failure exits 2, any other failure exits 1,
  green exits 0.
- Agent step (10/11) skips with ⏭️ when neither OPENAI_API_KEY nor
  ANTHROPIC_API_KEY is set; reads via app.core.config.get_settings()
  to honor the no-os.environ-in-feature-code rule.
- Registry handshake uses the mandatory pending -> running -> success
  transition and the wire alias "model_config" (not "model_config_data");
  artifact_hash is computed client-side via sha256 since we share the
  FS with the API on this single-host system.
- Winner selection: lowest aggregated WAPE, skipping NaN folds.

Also adds scripts/__init__.py so tests can `import scripts.run_demo`
without invoking the file as a script.

* feat(repo): top-level Makefile with demo / demo-quick / demo-clean (#128)

Wraps scripts/run_demo.py so reviewers can run the full end-to-end
demo with one command. Recipes mirror the three modes the script
supports: full run, skip-seed iteration, destructive reset.

Make targets:
- demo        — docker compose up -d + alembic + run_demo
- demo-quick  — run_demo --skip-seed (no compose/migration touch)
- demo-clean  — full reset (--reset) before seeding
- help        — default goal; lists targets + preconditions

Tab-indented recipes and .PHONY declarations per make conventions.
Preconditions (Postgres on :5433, uvicorn on :8123) documented in
the help block; the script itself enforces them via the precheck
step and exits 2 on failure.

* test(api): unit + integration coverage for run_demo (#128)

Unit (`tests/test_run_demo_unit.py`, 32 cases):
- argparse defaults + all-flags variants
- DemoContext defaults (no leaking state across runs)
- _select_winner: lowest-WAPE, NaN-skip, all-NaN -> None, empty -> None
- _model_config_payload: discriminated-union shape per baseline; rejects
  unsupported model_type (defends the "no lightgbm in PRP-15" boundary)
- Reporter: glyph mapping; verbose + quiet output; summary green / failure
  / over-budget soft-warn branches
- StepError formats RFC 7807 (title/detail/request_id) without leaking
  the raw response body
- HttpClient (mocked httpx.AsyncClient): 2xx, 204, non-2xx -> StepError
- Step payload sanity: seed sends demo_minimal+correct dims+ISO dates;
  features sends cutoff_date as ISO; train fires three model_types in
  parallel; agent step skips with ⏭️ when no LLM key

Integration (`tests/test_e2e_demo.py`, @pytest.mark.integration):
- Skips if Postgres on :5433 isn't reachable
- Boots uvicorn on :8124 as a subprocess (avoids the dev :8123 default)
- Runs scripts/run_demo.py --reset against it; asserts exit 0 +
  canonical "runs=3 winner=... alias=demo-production" summary
- Second case asserts a bogus URL exits 2 (no silent success)
- Cleans up uvicorn on teardown with terminate/kill fallback
- Resolves `uv` via shutil.which to keep ruff S607 happy and avoid
  PATH-dependent exec at test time

* ci(repo): nightly e2e demo workflow (#128)

Adds .github/workflows/e2e-nightly.yml — runs scripts/run_demo.py
against a fresh Postgres+pgvector service every night at 07:00 UTC
(plus on-demand via workflow_dispatch). Catches regressions in the
documented end-to-end pipeline before they bleed into the per-PR
gate.

Per PRP-15 + INITIAL-14 risk note: this workflow is intentionally
NOT a required status check on dev or main. Flake-budget lives in
the nightly slot, not in ci.yml.

- pgvector/pgvector:pg16 service container (same as ci.yml `test` job)
- uvicorn started in background; /health polled with a 30 s deadline
- run_demo.py called with --seed 42 (deterministic)
- LLM-key env vars intentionally absent — agent step auto-skips via
  ⏭️, keeping the workflow self-contained
- uvicorn logs uploaded as artifact on failure (7-day retention) so
  postmortems can read what the API was doing when the script broke
- astral-sh/setup-uv pinned by 40-char SHA per security-patterns.md
- permissions: contents: read (least-privilege)

* docs(docs): cross-link make demo from README + RUNBOOKS + REPO_MAP_INDEX (#128)

Discoverability layer for PRP-15.

- README.md: new 'Try it: end-to-end demo' step right after the curl
  /health verification; shows the canonical final-line summary so
  reviewers know what green looks like.
- docs/DAILY-FLOW.md: new 'First-Run Smoke (Demo Pipeline)' section
  documenting all three Make targets.
- docs/_base/RUNBOOKS.md: new 'make demo fails at step X' Common
  Incidents entry with a 7-point diagnosis flow keyed to the script's
  step names + a postmortem-capture recipe.
- docs/_base/REPO_MAP_INDEX.md: Makefile and scripts/run_demo.py rows
  added to the Document Index table.

Pure additive; no existing content removed or renamed.

* fix(data): update /seeder/scenarios route test for demo_minimal preset (#128)

Companion to feat(data): add demo_minimal scenario preset — the
route-level assertion in TestListScenarios.test_returns_scenarios still
expected 6 scenarios; bumping to 7 and adding the demo_minimal name
membership check to match the service-layer + config-layer tests
already updated in 005c189.

* fix(api): harden run_demo for integration test + real DB (#128)

Three real failures surfaced when first running the integration test
against docker-compose Postgres + a freshly booted uvicorn; all three
are now closed:

scripts/run_demo.py:
1. step_status: discover the real (store_id, product_id) from
   /dimensions/stores + /dimensions/products instead of hardcoding 1.
   Postgres auto-increment does NOT reset after delete, so the freshly
   seeded IDs are NOT 1 (they were ~150-260 on this branch after a few
   delete/seed cycles).
2. step_register: copy the trained-model artifact into the registry's
   own root (settings.registry_artifact_root) and record a registry-
   relative URI. The registry verify endpoint resolves artifact_uri
   against its own root, which is separate from where /forecasting/train
   writes (settings.forecast_model_artifacts_dir). Pre-fix, verify
   returned 404 even though the artifact existed on disk.
3. step_agent: skip with the soft-skip glyph on any LLM provider failure
   (invalid key, model unavailable, 5xx), and make _llm_key_present
   provider-aware so it matches the right env var to the configured
   agent_default_model. Pre-fix, an .env with anthropic/openai keys but
   a Gemini default model failed hard at chat-time.
4. Bumped DEFAULT_TIMEOUT_S from 60 to 120 because /seeder/generate
   for demo_minimal can spend 60-90 s on slower laptops once you
   include inventory + prices + promotions inserts.
5. step_seed detail string: GenerateResult.records_created uses 'sales'
   (singular), not 'sales_daily'; cosmetic fix.

tests/test_e2e_demo.py:
- Redirect uvicorn stdout to a temp file rather than subprocess.PIPE.
  The seeder + structlog produce enough INFO log volume to fill a
  64-KB pipe buffer; once full, uvicorn blocks on write and seeder
  requests hang for the full --timeout. Verified locally: integration
  suite now passes in ~6.5 s instead of timing out at 120 s.
- Cleanup leaves the log file on disk only when the test failed
  (postmortem-friendly).

tests/test_run_demo_unit.py:
- Bump test_defaults timeout expectation to match the new 120 s
  default.

End-to-end manual run on this machine: 11 steps, wall_clock=2 s,
exit 0. Integration test: 2 passed in 6.48 s.
… (#131)

Headline:
- authlib  1.6.6  -> 1.7.2  (clears GHSA-wvwj-cvrp-7pv5 — JWS signature
  verification bypass; patched at >= 1.6.9)
- fastmcp  2.14.4 -> 3.2.4  (clears GHSA-vv7q-7jx5-f767 — OpenAPI
  Provider SSRF + path traversal; patched at >= 3.2.0)

Both CVEs were flagged on PR #129 by Socket Security and are
pre-existing on dev (not introduced by #128).

Wider scope — read before merging:
`uv lock --upgrade-package authlib --upgrade-package fastmcp` triggers
a full re-resolve of the dependency graph. Because dev's uv.lock had
drifted from pyproject.toml (the project's constraint envelope had
loosened over time), this single command also brings the lockfile in
sync with current pyproject.toml. Net diff: 243 insertions / 369
deletions on uv.lock; no other files touched.

Transitive cascades worth flagging:
- anthropic    0.77.0 -> 0.102.0 (pydantic-ai-slim extra)
- pydantic-graph 1.51.0 -> 1.96.0
- temporalio   1.20.0 -> 1.27.2
- alembic      1.18.1 -> 1.18.4
- aws-* and cohere transitives bumped along
- griffe 1.15.0 dropped in favor of griffelib 2.0.2 (fastmcp 3.x switched)
- Removed: cloudpickle, diskcache, fakeredis, invoke, lupa, prometheus
  exporter, pydocket, redis, rsa, sortedcontainers — these were
  transitives of fastmcp 2.x that fastmcp 3.x no longer pulls in.

Verification on this host:
- uv sync --extra dev  -> green
- ruff check .         -> clean
- mypy --strict app/   -> 192 files clean
- pyright app/         -> 0 errors (50 warnings, pre-existing)
- pytest -m 'not integration' -> 969 passed

Known install quirk: griffelib 2.0.2 ships a top-level `griffe/`
package whose RECORD files don't always materialize on first install
when uv replaces an older `griffe` dist in the same sync. A clean
venv install (which CI does via `uv sync --frozen`) is unaffected;
local devs who upgrade in place may need a one-shot
`uv pip install --force-reinstall griffelib` if `import griffe` fails.
* feat(api): add demo slice driving the e2e pipeline via /demo endpoints (#132)

New app/features/demo slice exposing POST /demo/run and WS /demo/stream. It
drives the published API surface in-process via httpx.ASGITransport (no
cross-slice imports, satisfying the vertical-slice rule) and streams one
StepEvent per pipeline step: precheck -> reset -> seed -> status -> features
-> train x3 -> backtest x3 -> register -> verify -> agent -> cleanup.

A module-level asyncio.Lock enforces single-flight; concurrent runs get an
RFC 7807 409. The orchestration is a faithful in-process port of
scripts/run_demo.py (PR #129). Implements PRP-17.

* test(api): cover the demo slice pipeline, routes, and e2e integration (#132)

Unit tests mock the in-process HTTP client to exercise step sequencing,
winner selection, and fail-fast; route tests cover POST /demo/run (200 +
409) and the WS /demo/stream handler. The integration test seeds
demo_minimal and asserts an end-to-end green run against real Postgres.

Implements PRP-17.

* feat(ui): add showcase page streaming the live demo pipeline (#132)

New /showcase route and nav entry. The page opens a one-shot WebSocket to
/demo/stream via a use-demo-pipeline hook (wrapping useWebSocket) and renders
the 11 pipeline steps as live status cards: glyph, detail, duration, the
backtest per-model WAPE breakdown with the winner highlighted, and a
pass/fail summary banner.

Also block-scopes a pre-existing no-case-declarations lint error in
chat.tsx so pnpm lint is green for this PR. Implements PRP-17.

* test(ui): add vitest setup and use-demo-pipeline hook coverage (#132)

Adds the frontend test stack (vitest + jsdom + @testing-library/react), a
test script, and vitest.config.ts. use-demo-pipeline.test.ts covers the
pure event reducer (idle -> running -> pass transitions, summary assembly,
error phase) and a renderHook smoke test.

The package.json pnpm.onlyBuiltDependencies entry is the RUNBOOKS-documented
fix for pnpm 11's esbuild build-script gate. Implements PRP-17.

* docs(docs): document the demo slice and showcase page (#132)

Adds the PRP-17 spec; a 'Try it in the browser' pointer in README; the
/demo/run + /demo/stream rows and a WebSocket Events section in
API_CONTRACTS; a 'Showcase pipeline fails' runbook incident; and
REPO_MAP_INDEX rows for the demo slice and showcase page.

Implements PRP-17.
…ts (#136) (#137)

* chore(main): release 0.2.9 (#126)

* feat: release v0.2.10 — demo showcase page + e2e pipeline (#134)

* feat(data): implement MarkdownGenerator age_days trigger via heuristic (#94) (#127)

Resolves #94 via the heuristic path documented in the issue. No schema
column, no Alembic migration, no FIFO cohort tracking — the trigger
self-reads the existing per-(store, product) on_hand_qty series and
fires when inventory has been "unrefreshed" past
`cfg.age_days_threshold`.

Decision rationale (schema column vs. heuristic):
- The schema column path would add `oldest_unit_age_days` to
  `inventory_snapshot_daily`, plus an Alembic migration, plus FIFO
  cohort tracking in `InventorySnapshotGenerator`. No downstream
  consumer reads this column today — adding it for one generator
  trigger violates the "don't design for hypothetical future
  requirements" rule in CLAUDE.md.
- The heuristic path is self-contained in MarkdownGenerator,
  deterministic (preserves the zero-rng-draw regression invariant),
  and additive (no migration, no model change). 354 LOC net, all
  inside one slice.

Heuristic spec:
- A "refresh" is a day where `on_hand_qty` rose by >=
  `_AGE_DAYS_SPIKE_THRESHOLD` (0.3 = 30% jump) vs the prior day.
- Age at day t = days since most recent refresh (or `dates[0]` if no
  refresh has been observed).
- Firing requires age >= `age_days_threshold` AND on_hand >=
  `markdown_min_units_remaining` — never markdown an empty shelf.
- After firing, refresh anchor resets to the day AFTER the markdown
  window ends, so back-to-back fires can't happen and the next age
  clock starts from a "clear shelf" baseline.

Wiring: `MarkdownGenerator.generate()` gains an optional kwarg
`inventory_records: list[dict[str, Any]] | None = None` which `core.py`
passes through from `InventorySnapshotGenerator`. Disabled-path and
non-age_days-path behavior is byte-identical (kwarg ignored).

Tests: +7 new in `TestAgeDaysTrigger`, -1 obsolete
`NotImplementedError` test. Coverage: no-records defensive, threshold
not-met, threshold met, spike resets age, post-fire reset avoids
back-to-back, low-inventory skip, unknown-product skip, rng
non-consumption.

Validation (local):
- ruff check + format: clean
- mypy --strict: 0 issues, 192 files
- pyright --strict: 0 errors
- pytest -m "not integration": 969 passed (+7 vs pre-PR)

Closes #94.

* feat(api,docs): e2e demo pipeline + showcase script (#128) (#129)

* docs(docs): add INITIAL-14 + PRP-15 e2e demo pipeline plan (#128)

Adds the planning documents for the end-to-end demo pipeline work tracked
in #128. Implementation commits follow on this branch.

- INITIAL-14.md: PRD for `make demo` (problem, solution, success metrics,
  open questions resolved in the PRP).
- PRPs/PRP-15-e2e-demo-pipeline.md: full execution plan (16 tasks → 6
  commits, additive only — no schema changes, no API edits).

* feat(data): add demo_minimal scenario preset (#128)

Tiny preset that powers the upcoming `make demo` target. Three stores ×
ten products × 92 days (2024-10-01..2024-12-31) — wide enough to satisfy
an expanding backtest with n_splits=3, horizon=14, min_train_size=30
(needs >= 72 days, 92 leaves margin), small enough to keep the demo
loop comfortable on a laptop.

Mirrors the retail_standard tuning (mild linear trend, noise_sigma=0.10,
modest promotion + stockout probabilities) so backtest WAPE stays
non-NaN across all three baseline models.

- app/shared/seeder/config.py: add DEMO_MINIMAL enum + from_scenario branch
- app/features/seeder/service.py: add ScenarioInfo entry in list_scenarios
- tests cover the new preset and the updated scenario count

* feat(api,docs): scripts/run_demo.py end-to-end pipeline driver (#128)

Single-file async driver that walks the published HTTP surface
(precheck -> reset? -> seed -> status -> features -> train x3 ->
backtest x3 -> register -> verify -> agent -> cleanup). Mirrors the
shape of scripts/seed_random.py and scripts/check_db.py.

- HttpClient: thin httpx.AsyncClient wrapper with explicit 60 s
  timeout (default 5 s is too short for /seeder/generate); surfaces
  RFC 7807 problem+json bodies as a typed StepError that echoes
  title / detail / request_id (never the raw body — secrets-safe).
- DemoContext + StepOutcome dataclasses thread cross-step references.
- Reporter renders the output-formatting.md glyphs (verbose by
  default, --quiet collapses to one line per step).
- Per-step error handling converts httpx + StepError into fail
  outcomes; precheck failure exits 2, any other failure exits 1,
  green exits 0.
- Agent step (10/11) skips with ⏭️ when neither OPENAI_API_KEY nor
  ANTHROPIC_API_KEY is set; reads via app.core.config.get_settings()
  to honor the no-os.environ-in-feature-code rule.
- Registry handshake uses the mandatory pending -> running -> success
  transition and the wire alias "model_config" (not "model_config_data");
  artifact_hash is computed client-side via sha256 since we share the
  FS with the API on this single-host system.
- Winner selection: lowest aggregated WAPE, skipping NaN folds.

Also adds scripts/__init__.py so tests can `import scripts.run_demo`
without invoking the file as a script.

* feat(repo): top-level Makefile with demo / demo-quick / demo-clean (#128)

Wraps scripts/run_demo.py so reviewers can run the full end-to-end
demo with one command. Recipes mirror the three modes the script
supports: full run, skip-seed iteration, destructive reset.

Make targets:
- demo        — docker compose up -d + alembic + run_demo
- demo-quick  — run_demo --skip-seed (no compose/migration touch)
- demo-clean  — full reset (--reset) before seeding
- help        — default goal; lists targets + preconditions

Tab-indented recipes and .PHONY declarations per make conventions.
Preconditions (Postgres on :5433, uvicorn on :8123) documented in
the help block; the script itself enforces them via the precheck
step and exits 2 on failure.

* test(api): unit + integration coverage for run_demo (#128)

Unit (`tests/test_run_demo_unit.py`, 32 cases):
- argparse defaults + all-flags variants
- DemoContext defaults (no leaking state across runs)
- _select_winner: lowest-WAPE, NaN-skip, all-NaN -> None, empty -> None
- _model_config_payload: discriminated-union shape per baseline; rejects
  unsupported model_type (defends the "no lightgbm in PRP-15" boundary)
- Reporter: glyph mapping; verbose + quiet output; summary green / failure
  / over-budget soft-warn branches
- StepError formats RFC 7807 (title/detail/request_id) without leaking
  the raw response body
- HttpClient (mocked httpx.AsyncClient): 2xx, 204, non-2xx -> StepError
- Step payload sanity: seed sends demo_minimal+correct dims+ISO dates;
  features sends cutoff_date as ISO; train fires three model_types in
  parallel; agent step skips with ⏭️ when no LLM key

Integration (`tests/test_e2e_demo.py`, @pytest.mark.integration):
- Skips if Postgres on :5433 isn't reachable
- Boots uvicorn on :8124 as a subprocess (avoids the dev :8123 default)
- Runs scripts/run_demo.py --reset against it; asserts exit 0 +
  canonical "runs=3 winner=... alias=demo-production" summary
- Second case asserts a bogus URL exits 2 (no silent success)
- Cleans up uvicorn on teardown with terminate/kill fallback
- Resolves `uv` via shutil.which to keep ruff S607 happy and avoid
  PATH-dependent exec at test time

* ci(repo): nightly e2e demo workflow (#128)

Adds .github/workflows/e2e-nightly.yml — runs scripts/run_demo.py
against a fresh Postgres+pgvector service every night at 07:00 UTC
(plus on-demand via workflow_dispatch). Catches regressions in the
documented end-to-end pipeline before they bleed into the per-PR
gate.

Per PRP-15 + INITIAL-14 risk note: this workflow is intentionally
NOT a required status check on dev or main. Flake-budget lives in
the nightly slot, not in ci.yml.

- pgvector/pgvector:pg16 service container (same as ci.yml `test` job)
- uvicorn started in background; /health polled with a 30 s deadline
- run_demo.py called with --seed 42 (deterministic)
- LLM-key env vars intentionally absent — agent step auto-skips via
  ⏭️, keeping the workflow self-contained
- uvicorn logs uploaded as artifact on failure (7-day retention) so
  postmortems can read what the API was doing when the script broke
- astral-sh/setup-uv pinned by 40-char SHA per security-patterns.md
- permissions: contents: read (least-privilege)

* docs(docs): cross-link make demo from README + RUNBOOKS + REPO_MAP_INDEX (#128)

Discoverability layer for PRP-15.

- README.md: new 'Try it: end-to-end demo' step right after the curl
  /health verification; shows the canonical final-line summary so
  reviewers know what green looks like.
- docs/DAILY-FLOW.md: new 'First-Run Smoke (Demo Pipeline)' section
  documenting all three Make targets.
- docs/_base/RUNBOOKS.md: new 'make demo fails at step X' Common
  Incidents entry with a 7-point diagnosis flow keyed to the script's
  step names + a postmortem-capture recipe.
- docs/_base/REPO_MAP_INDEX.md: Makefile and scripts/run_demo.py rows
  added to the Document Index table.

Pure additive; no existing content removed or renamed.

* fix(data): update /seeder/scenarios route test for demo_minimal preset (#128)

Companion to feat(data): add demo_minimal scenario preset — the
route-level assertion in TestListScenarios.test_returns_scenarios still
expected 6 scenarios; bumping to 7 and adding the demo_minimal name
membership check to match the service-layer + config-layer tests
already updated in 005c189.

* fix(api): harden run_demo for integration test + real DB (#128)

Three real failures surfaced when first running the integration test
against docker-compose Postgres + a freshly booted uvicorn; all three
are now closed:

scripts/run_demo.py:
1. step_status: discover the real (store_id, product_id) from
   /dimensions/stores + /dimensions/products instead of hardcoding 1.
   Postgres auto-increment does NOT reset after delete, so the freshly
   seeded IDs are NOT 1 (they were ~150-260 on this branch after a few
   delete/seed cycles).
2. step_register: copy the trained-model artifact into the registry's
   own root (settings.registry_artifact_root) and record a registry-
   relative URI. The registry verify endpoint resolves artifact_uri
   against its own root, which is separate from where /forecasting/train
   writes (settings.forecast_model_artifacts_dir). Pre-fix, verify
   returned 404 even though the artifact existed on disk.
3. step_agent: skip with the soft-skip glyph on any LLM provider failure
   (invalid key, model unavailable, 5xx), and make _llm_key_present
   provider-aware so it matches the right env var to the configured
   agent_default_model. Pre-fix, an .env with anthropic/openai keys but
   a Gemini default model failed hard at chat-time.
4. Bumped DEFAULT_TIMEOUT_S from 60 to 120 because /seeder/generate
   for demo_minimal can spend 60-90 s on slower laptops once you
   include inventory + prices + promotions inserts.
5. step_seed detail string: GenerateResult.records_created uses 'sales'
   (singular), not 'sales_daily'; cosmetic fix.

tests/test_e2e_demo.py:
- Redirect uvicorn stdout to a temp file rather than subprocess.PIPE.
  The seeder + structlog produce enough INFO log volume to fill a
  64-KB pipe buffer; once full, uvicorn blocks on write and seeder
  requests hang for the full --timeout. Verified locally: integration
  suite now passes in ~6.5 s instead of timing out at 120 s.
- Cleanup leaves the log file on disk only when the test failed
  (postmortem-friendly).

tests/test_run_demo_unit.py:
- Bump test_defaults timeout expectation to match the new 120 s
  default.

End-to-end manual run on this machine: 11 steps, wall_clock=2 s,
exit 0. Integration test: 2 passed in 6.48 s.

* chore(repo): bump authlib + fastmcp to clear Socket-flagged CVEs (#130) (#131)

Headline:
- authlib  1.6.6  -> 1.7.2  (clears GHSA-wvwj-cvrp-7pv5 — JWS signature
  verification bypass; patched at >= 1.6.9)
- fastmcp  2.14.4 -> 3.2.4  (clears GHSA-vv7q-7jx5-f767 — OpenAPI
  Provider SSRF + path traversal; patched at >= 3.2.0)

Both CVEs were flagged on PR #129 by Socket Security and are
pre-existing on dev (not introduced by #128).

Wider scope — read before merging:
`uv lock --upgrade-package authlib --upgrade-package fastmcp` triggers
a full re-resolve of the dependency graph. Because dev's uv.lock had
drifted from pyproject.toml (the project's constraint envelope had
loosened over time), this single command also brings the lockfile in
sync with current pyproject.toml. Net diff: 243 insertions / 369
deletions on uv.lock; no other files touched.

Transitive cascades worth flagging:
- anthropic    0.77.0 -> 0.102.0 (pydantic-ai-slim extra)
- pydantic-graph 1.51.0 -> 1.96.0
- temporalio   1.20.0 -> 1.27.2
- alembic      1.18.1 -> 1.18.4
- aws-* and cohere transitives bumped along
- griffe 1.15.0 dropped in favor of griffelib 2.0.2 (fastmcp 3.x switched)
- Removed: cloudpickle, diskcache, fakeredis, invoke, lupa, prometheus
  exporter, pydocket, redis, rsa, sortedcontainers — these were
  transitives of fastmcp 2.x that fastmcp 3.x no longer pulls in.

Verification on this host:
- uv sync --extra dev  -> green
- ruff check .         -> clean
- mypy --strict app/   -> 192 files clean
- pyright app/         -> 0 errors (50 warnings, pre-existing)
- pytest -m 'not integration' -> 969 passed

Known install quirk: griffelib 2.0.2 ships a top-level `griffe/`
package whose RECORD files don't always materialize on first install
when uv replaces an older `griffe` dist in the same sync. A clean
venv install (which CI does via `uv sync --frozen`) is unaffected;
local devs who upgrade in place may need a one-shot
`uv pip install --force-reinstall griffelib` if `import griffe` fails.

* feat(api,ui): in-product demo showcase page (#132) (#133)

* feat(api): add demo slice driving the e2e pipeline via /demo endpoints (#132)

New app/features/demo slice exposing POST /demo/run and WS /demo/stream. It
drives the published API surface in-process via httpx.ASGITransport (no
cross-slice imports, satisfying the vertical-slice rule) and streams one
StepEvent per pipeline step: precheck -> reset -> seed -> status -> features
-> train x3 -> backtest x3 -> register -> verify -> agent -> cleanup.

A module-level asyncio.Lock enforces single-flight; concurrent runs get an
RFC 7807 409. The orchestration is a faithful in-process port of
scripts/run_demo.py (PR #129). Implements PRP-17.

* test(api): cover the demo slice pipeline, routes, and e2e integration (#132)

Unit tests mock the in-process HTTP client to exercise step sequencing,
winner selection, and fail-fast; route tests cover POST /demo/run (200 +
409) and the WS /demo/stream handler. The integration test seeds
demo_minimal and asserts an end-to-end green run against real Postgres.

Implements PRP-17.

* feat(ui): add showcase page streaming the live demo pipeline (#132)

New /showcase route and nav entry. The page opens a one-shot WebSocket to
/demo/stream via a use-demo-pipeline hook (wrapping useWebSocket) and renders
the 11 pipeline steps as live status cards: glyph, detail, duration, the
backtest per-model WAPE breakdown with the winner highlighted, and a
pass/fail summary banner.

Also block-scopes a pre-existing no-case-declarations lint error in
chat.tsx so pnpm lint is green for this PR. Implements PRP-17.

* test(ui): add vitest setup and use-demo-pipeline hook coverage (#132)

Adds the frontend test stack (vitest + jsdom + @testing-library/react), a
test script, and vitest.config.ts. use-demo-pipeline.test.ts covers the
pure event reducer (idle -> running -> pass transitions, summary assembly,
error phase) and a renderHook smoke test.

The package.json pnpm.onlyBuiltDependencies entry is the RUNBOOKS-documented
fix for pnpm 11's esbuild build-script gate. Implements PRP-17.

* docs(docs): document the demo slice and showcase page (#132)

Adds the PRP-17 spec; a 'Try it in the browser' pointer in README; the
/demo/run + /demo/stream rows and a WebSocket Events section in
API_CONTRACTS; a 'Showcase pipeline fails' runbook incident; and
REPO_MAP_INDEX rows for the demo slice and showcase page.

Implements PRP-17.

* chore(main): release 0.2.10 (#135)
…t vars (#149) (#153)

index.css defines --chart-N twice: legacy shadcn-v3 HSL triplets and
Tailwind-4 / shadcn-v4 complete oklch() colours. The oklch definitions win
the cascade, so at runtime --chart-N is a full colour. The chart components
still wrapped it as hsl(var(--chart-N)) → hsl(oklch(...)), which is invalid
CSS, so recharts fell back to a black fill/stroke — invisible on the dark
theme.

Reference var(--chart-N) directly in backtest-folds-chart.tsx and
time-series-chart.tsx. Verified in a browser: the backtest per-fold bars
and the forecast line now render in colour.
…lines (#148) (#152)

* fix(jobs): backtest job result keeps fold metrics, stability and baselines (#148)

_execute_backtest ran BacktestingService.run_backtest — which computes
per-fold metrics, stability indices and a naive/seasonal baseline comparison
— but stored only four aggregated values and discarded the rest. The
dashboard (/visualize/backtest) reads aggregated_metrics.{*_mean,
stability_index}, fold_metrics[] and baseline_comparison, so it showed
"0 folds", all-zero metrics and an empty chart.

Add _shape_backtest_result(), which flattens a BacktestResponse into the
contract the dashboard expects, and _finite(), which coerces NaN/inf to 0.0
so the result stays JSONB-safe (stability is NaN with fewer than two folds).

Add app/features/jobs/tests/test_service.py with unit coverage for the
shaping logic: fold metrics, *_mean keys, stability, baseline comparison,
the no-baselines path, and NaN coercion.

* refactor(jobs): centralize backtest metric keys and surface drift (#148)

Addresses review feedback on PR #152.

- Hoist the dashboard's metric set into _BACKTEST_METRICS and the headline
  stability metric into _STABILITY_METRIC, so the hardcoded keys live in one
  documented place instead of being repeated across the shaping logic.
- Log jobs.backtest_metrics_missing when an expected metric is absent from the
  backtest response, so a future rename in the backtesting service fails loud
  instead of silently emitting 0.0.
- Document the WAPE stability convention in the _shape_backtest_result docstring.
- Tests: assert backtest_id / model_type / duration_ms pass through unchanged,
  and add a regression test for the missing-metric default path.
…lt (#147) (#151)

The /visualize/forecast page never rendered the chart for a valid completed
predict job. It read job.result.predictions with field `predicted`, but
POST /jobs (job_type="predict") returns job.result.forecasts with field
`forecast`. forecastData was therefore always undefined and the page fell
through to "No prediction data available in job result".

Read result.forecasts with field `forecast`, and pass predictedKey="forecast"
to TimeSeriesChart (which already supports a configurable data key).

Verified in a browser: entering a completed predict job ID now renders the
14-day forecast line chart with correct tooltip values.
)

Under the default registry_duplicate_policy="detect", duplicate runs are
created intentionally, so multiple non-archived model_run rows can share one
config hash. _find_duplicate used scalar_one_or_none(), which raised
MultipleResultsFound once two duplicates existed — POST /registry/runs then
returned HTTP 500. This made the demo/Showcase register step fail
deterministically on any DB with repeated runs.

Order the lookup by created_at desc, LIMIT 1, and use scalars().first() so it
returns the most recent matching run instead of asserting a single match.

Add an integration regression test that POSTs an identical run three times
under the detect policy and asserts all three return 201.
#157)

TimeSeriesChart builds chartConfig with dynamic keys ([actualKey] /
[predictedKey]), so shadcn's ChartContainer injects --color-<key> CSS
variables. The <Line> elements, however, hardcoded stroke="var(--color-actual)"
and stroke="var(--color-predicted)". The forecast page passes
predictedKey="forecast", so the injected variable is --color-forecast;
var(--color-predicted) was undefined, the stroke was invalid, and SVG fell
back to its initial value `none` — the forecast line was invisible.

Build the stroke from the key: stroke={`var(--color-${actualKey})`} /
stroke={`var(--color-${predictedKey})`}.

Verified in a browser: the forecast line now renders in colour.
…155)

The visualization pages only accepted a job ID typed into a text box, so
users had to already know the ID. Add a JobPicker component: a dropdown of
completed jobs of the relevant type (predict / backtest), newest first, with
each option labelled by short id, model and timestamp.

- New shared component src/components/common/job-picker.tsx, used by both
  forecast.tsx and backtest.tsx.
- The manual job-ID input stays alongside the dropdown for pasting an ID.
- The most recent completed job auto-loads on mount so a chart shows
  immediately without interaction.

No backend change — GET /jobs?job_type=&status=completed already exists.
Verified in a browser on both pages.
* chore(main): release 0.2.9 (#126)

* feat: release v0.2.10 — demo showcase page + e2e pipeline (#134)

* feat(data): implement MarkdownGenerator age_days trigger via heuristic (#94) (#127)

Resolves #94 via the heuristic path documented in the issue. No schema
column, no Alembic migration, no FIFO cohort tracking — the trigger
self-reads the existing per-(store, product) on_hand_qty series and
fires when inventory has been "unrefreshed" past
`cfg.age_days_threshold`.

Decision rationale (schema column vs. heuristic):
- The schema column path would add `oldest_unit_age_days` to
  `inventory_snapshot_daily`, plus an Alembic migration, plus FIFO
  cohort tracking in `InventorySnapshotGenerator`. No downstream
  consumer reads this column today — adding it for one generator
  trigger violates the "don't design for hypothetical future
  requirements" rule in CLAUDE.md.
- The heuristic path is self-contained in MarkdownGenerator,
  deterministic (preserves the zero-rng-draw regression invariant),
  and additive (no migration, no model change). 354 LOC net, all
  inside one slice.

Heuristic spec:
- A "refresh" is a day where `on_hand_qty` rose by >=
  `_AGE_DAYS_SPIKE_THRESHOLD` (0.3 = 30% jump) vs the prior day.
- Age at day t = days since most recent refresh (or `dates[0]` if no
  refresh has been observed).
- Firing requires age >= `age_days_threshold` AND on_hand >=
  `markdown_min_units_remaining` — never markdown an empty shelf.
- After firing, refresh anchor resets to the day AFTER the markdown
  window ends, so back-to-back fires can't happen and the next age
  clock starts from a "clear shelf" baseline.

Wiring: `MarkdownGenerator.generate()` gains an optional kwarg
`inventory_records: list[dict[str, Any]] | None = None` which `core.py`
passes through from `InventorySnapshotGenerator`. Disabled-path and
non-age_days-path behavior is byte-identical (kwarg ignored).

Tests: +7 new in `TestAgeDaysTrigger`, -1 obsolete
`NotImplementedError` test. Coverage: no-records defensive, threshold
not-met, threshold met, spike resets age, post-fire reset avoids
back-to-back, low-inventory skip, unknown-product skip, rng
non-consumption.

Validation (local):
- ruff check + format: clean
- mypy --strict: 0 issues, 192 files
- pyright --strict: 0 errors
- pytest -m "not integration": 969 passed (+7 vs pre-PR)

Closes #94.

* feat(api,docs): e2e demo pipeline + showcase script (#128) (#129)

* docs(docs): add INITIAL-14 + PRP-15 e2e demo pipeline plan (#128)

Adds the planning documents for the end-to-end demo pipeline work tracked
in #128. Implementation commits follow on this branch.

- INITIAL-14.md: PRD for `make demo` (problem, solution, success metrics,
  open questions resolved in the PRP).
- PRPs/PRP-15-e2e-demo-pipeline.md: full execution plan (16 tasks → 6
  commits, additive only — no schema changes, no API edits).

* feat(data): add demo_minimal scenario preset (#128)

Tiny preset that powers the upcoming `make demo` target. Three stores ×
ten products × 92 days (2024-10-01..2024-12-31) — wide enough to satisfy
an expanding backtest with n_splits=3, horizon=14, min_train_size=30
(needs >= 72 days, 92 leaves margin), small enough to keep the demo
loop comfortable on a laptop.

Mirrors the retail_standard tuning (mild linear trend, noise_sigma=0.10,
modest promotion + stockout probabilities) so backtest WAPE stays
non-NaN across all three baseline models.

- app/shared/seeder/config.py: add DEMO_MINIMAL enum + from_scenario branch
- app/features/seeder/service.py: add ScenarioInfo entry in list_scenarios
- tests cover the new preset and the updated scenario count

* feat(api,docs): scripts/run_demo.py end-to-end pipeline driver (#128)

Single-file async driver that walks the published HTTP surface
(precheck -> reset? -> seed -> status -> features -> train x3 ->
backtest x3 -> register -> verify -> agent -> cleanup). Mirrors the
shape of scripts/seed_random.py and scripts/check_db.py.

- HttpClient: thin httpx.AsyncClient wrapper with explicit 60 s
  timeout (default 5 s is too short for /seeder/generate); surfaces
  RFC 7807 problem+json bodies as a typed StepError that echoes
  title / detail / request_id (never the raw body — secrets-safe).
- DemoContext + StepOutcome dataclasses thread cross-step references.
- Reporter renders the output-formatting.md glyphs (verbose by
  default, --quiet collapses to one line per step).
- Per-step error handling converts httpx + StepError into fail
  outcomes; precheck failure exits 2, any other failure exits 1,
  green exits 0.
- Agent step (10/11) skips with ⏭️ when neither OPENAI_API_KEY nor
  ANTHROPIC_API_KEY is set; reads via app.core.config.get_settings()
  to honor the no-os.environ-in-feature-code rule.
- Registry handshake uses the mandatory pending -> running -> success
  transition and the wire alias "model_config" (not "model_config_data");
  artifact_hash is computed client-side via sha256 since we share the
  FS with the API on this single-host system.
- Winner selection: lowest aggregated WAPE, skipping NaN folds.

Also adds scripts/__init__.py so tests can `import scripts.run_demo`
without invoking the file as a script.

* feat(repo): top-level Makefile with demo / demo-quick / demo-clean (#128)

Wraps scripts/run_demo.py so reviewers can run the full end-to-end
demo with one command. Recipes mirror the three modes the script
supports: full run, skip-seed iteration, destructive reset.

Make targets:
- demo        — docker compose up -d + alembic + run_demo
- demo-quick  — run_demo --skip-seed (no compose/migration touch)
- demo-clean  — full reset (--reset) before seeding
- help        — default goal; lists targets + preconditions

Tab-indented recipes and .PHONY declarations per make conventions.
Preconditions (Postgres on :5433, uvicorn on :8123) documented in
the help block; the script itself enforces them via the precheck
step and exits 2 on failure.

* test(api): unit + integration coverage for run_demo (#128)

Unit (`tests/test_run_demo_unit.py`, 32 cases):
- argparse defaults + all-flags variants
- DemoContext defaults (no leaking state across runs)
- _select_winner: lowest-WAPE, NaN-skip, all-NaN -> None, empty -> None
- _model_config_payload: discriminated-union shape per baseline; rejects
  unsupported model_type (defends the "no lightgbm in PRP-15" boundary)
- Reporter: glyph mapping; verbose + quiet output; summary green / failure
  / over-budget soft-warn branches
- StepError formats RFC 7807 (title/detail/request_id) without leaking
  the raw response body
- HttpClient (mocked httpx.AsyncClient): 2xx, 204, non-2xx -> StepError
- Step payload sanity: seed sends demo_minimal+correct dims+ISO dates;
  features sends cutoff_date as ISO; train fires three model_types in
  parallel; agent step skips with ⏭️ when no LLM key

Integration (`tests/test_e2e_demo.py`, @pytest.mark.integration):
- Skips if Postgres on :5433 isn't reachable
- Boots uvicorn on :8124 as a subprocess (avoids the dev :8123 default)
- Runs scripts/run_demo.py --reset against it; asserts exit 0 +
  canonical "runs=3 winner=... alias=demo-production" summary
- Second case asserts a bogus URL exits 2 (no silent success)
- Cleans up uvicorn on teardown with terminate/kill fallback
- Resolves `uv` via shutil.which to keep ruff S607 happy and avoid
  PATH-dependent exec at test time

* ci(repo): nightly e2e demo workflow (#128)

Adds .github/workflows/e2e-nightly.yml — runs scripts/run_demo.py
against a fresh Postgres+pgvector service every night at 07:00 UTC
(plus on-demand via workflow_dispatch). Catches regressions in the
documented end-to-end pipeline before they bleed into the per-PR
gate.

Per PRP-15 + INITIAL-14 risk note: this workflow is intentionally
NOT a required status check on dev or main. Flake-budget lives in
the nightly slot, not in ci.yml.

- pgvector/pgvector:pg16 service container (same as ci.yml `test` job)
- uvicorn started in background; /health polled with a 30 s deadline
- run_demo.py called with --seed 42 (deterministic)
- LLM-key env vars intentionally absent — agent step auto-skips via
  ⏭️, keeping the workflow self-contained
- uvicorn logs uploaded as artifact on failure (7-day retention) so
  postmortems can read what the API was doing when the script broke
- astral-sh/setup-uv pinned by 40-char SHA per security-patterns.md
- permissions: contents: read (least-privilege)

* docs(docs): cross-link make demo from README + RUNBOOKS + REPO_MAP_INDEX (#128)

Discoverability layer for PRP-15.

- README.md: new 'Try it: end-to-end demo' step right after the curl
  /health verification; shows the canonical final-line summary so
  reviewers know what green looks like.
- docs/DAILY-FLOW.md: new 'First-Run Smoke (Demo Pipeline)' section
  documenting all three Make targets.
- docs/_base/RUNBOOKS.md: new 'make demo fails at step X' Common
  Incidents entry with a 7-point diagnosis flow keyed to the script's
  step names + a postmortem-capture recipe.
- docs/_base/REPO_MAP_INDEX.md: Makefile and scripts/run_demo.py rows
  added to the Document Index table.

Pure additive; no existing content removed or renamed.

* fix(data): update /seeder/scenarios route test for demo_minimal preset (#128)

Companion to feat(data): add demo_minimal scenario preset — the
route-level assertion in TestListScenarios.test_returns_scenarios still
expected 6 scenarios; bumping to 7 and adding the demo_minimal name
membership check to match the service-layer + config-layer tests
already updated in 005c189.

* fix(api): harden run_demo for integration test + real DB (#128)

Three real failures surfaced when first running the integration test
against docker-compose Postgres + a freshly booted uvicorn; all three
are now closed:

scripts/run_demo.py:
1. step_status: discover the real (store_id, product_id) from
   /dimensions/stores + /dimensions/products instead of hardcoding 1.
   Postgres auto-increment does NOT reset after delete, so the freshly
   seeded IDs are NOT 1 (they were ~150-260 on this branch after a few
   delete/seed cycles).
2. step_register: copy the trained-model artifact into the registry's
   own root (settings.registry_artifact_root) and record a registry-
   relative URI. The registry verify endpoint resolves artifact_uri
   against its own root, which is separate from where /forecasting/train
   writes (settings.forecast_model_artifacts_dir). Pre-fix, verify
   returned 404 even though the artifact existed on disk.
3. step_agent: skip with the soft-skip glyph on any LLM provider failure
   (invalid key, model unavailable, 5xx), and make _llm_key_present
   provider-aware so it matches the right env var to the configured
   agent_default_model. Pre-fix, an .env with anthropic/openai keys but
   a Gemini default model failed hard at chat-time.
4. Bumped DEFAULT_TIMEOUT_S from 60 to 120 because /seeder/generate
   for demo_minimal can spend 60-90 s on slower laptops once you
   include inventory + prices + promotions inserts.
5. step_seed detail string: GenerateResult.records_created uses 'sales'
   (singular), not 'sales_daily'; cosmetic fix.

tests/test_e2e_demo.py:
- Redirect uvicorn stdout to a temp file rather than subprocess.PIPE.
  The seeder + structlog produce enough INFO log volume to fill a
  64-KB pipe buffer; once full, uvicorn blocks on write and seeder
  requests hang for the full --timeout. Verified locally: integration
  suite now passes in ~6.5 s instead of timing out at 120 s.
- Cleanup leaves the log file on disk only when the test failed
  (postmortem-friendly).

tests/test_run_demo_unit.py:
- Bump test_defaults timeout expectation to match the new 120 s
  default.

End-to-end manual run on this machine: 11 steps, wall_clock=2 s,
exit 0. Integration test: 2 passed in 6.48 s.

* chore(repo): bump authlib + fastmcp to clear Socket-flagged CVEs (#130) (#131)

Headline:
- authlib  1.6.6  -> 1.7.2  (clears GHSA-wvwj-cvrp-7pv5 — JWS signature
  verification bypass; patched at >= 1.6.9)
- fastmcp  2.14.4 -> 3.2.4  (clears GHSA-vv7q-7jx5-f767 — OpenAPI
  Provider SSRF + path traversal; patched at >= 3.2.0)

Both CVEs were flagged on PR #129 by Socket Security and are
pre-existing on dev (not introduced by #128).

Wider scope — read before merging:
`uv lock --upgrade-package authlib --upgrade-package fastmcp` triggers
a full re-resolve of the dependency graph. Because dev's uv.lock had
drifted from pyproject.toml (the project's constraint envelope had
loosened over time), this single command also brings the lockfile in
sync with current pyproject.toml. Net diff: 243 insertions / 369
deletions on uv.lock; no other files touched.

Transitive cascades worth flagging:
- anthropic    0.77.0 -> 0.102.0 (pydantic-ai-slim extra)
- pydantic-graph 1.51.0 -> 1.96.0
- temporalio   1.20.0 -> 1.27.2
- alembic      1.18.1 -> 1.18.4
- aws-* and cohere transitives bumped along
- griffe 1.15.0 dropped in favor of griffelib 2.0.2 (fastmcp 3.x switched)
- Removed: cloudpickle, diskcache, fakeredis, invoke, lupa, prometheus
  exporter, pydocket, redis, rsa, sortedcontainers — these were
  transitives of fastmcp 2.x that fastmcp 3.x no longer pulls in.

Verification on this host:
- uv sync --extra dev  -> green
- ruff check .         -> clean
- mypy --strict app/   -> 192 files clean
- pyright app/         -> 0 errors (50 warnings, pre-existing)
- pytest -m 'not integration' -> 969 passed

Known install quirk: griffelib 2.0.2 ships a top-level `griffe/`
package whose RECORD files don't always materialize on first install
when uv replaces an older `griffe` dist in the same sync. A clean
venv install (which CI does via `uv sync --frozen`) is unaffected;
local devs who upgrade in place may need a one-shot
`uv pip install --force-reinstall griffelib` if `import griffe` fails.

* feat(api,ui): in-product demo showcase page (#132) (#133)

* feat(api): add demo slice driving the e2e pipeline via /demo endpoints (#132)

New app/features/demo slice exposing POST /demo/run and WS /demo/stream. It
drives the published API surface in-process via httpx.ASGITransport (no
cross-slice imports, satisfying the vertical-slice rule) and streams one
StepEvent per pipeline step: precheck -> reset -> seed -> status -> features
-> train x3 -> backtest x3 -> register -> verify -> agent -> cleanup.

A module-level asyncio.Lock enforces single-flight; concurrent runs get an
RFC 7807 409. The orchestration is a faithful in-process port of
scripts/run_demo.py (PR #129). Implements PRP-17.

* test(api): cover the demo slice pipeline, routes, and e2e integration (#132)

Unit tests mock the in-process HTTP client to exercise step sequencing,
winner selection, and fail-fast; route tests cover POST /demo/run (200 +
409) and the WS /demo/stream handler. The integration test seeds
demo_minimal and asserts an end-to-end green run against real Postgres.

Implements PRP-17.

* feat(ui): add showcase page streaming the live demo pipeline (#132)

New /showcase route and nav entry. The page opens a one-shot WebSocket to
/demo/stream via a use-demo-pipeline hook (wrapping useWebSocket) and renders
the 11 pipeline steps as live status cards: glyph, detail, duration, the
backtest per-model WAPE breakdown with the winner highlighted, and a
pass/fail summary banner.

Also block-scopes a pre-existing no-case-declarations lint error in
chat.tsx so pnpm lint is green for this PR. Implements PRP-17.

* test(ui): add vitest setup and use-demo-pipeline hook coverage (#132)

Adds the frontend test stack (vitest + jsdom + @testing-library/react), a
test script, and vitest.config.ts. use-demo-pipeline.test.ts covers the
pure event reducer (idle -> running -> pass transitions, summary assembly,
error phase) and a renderHook smoke test.

The package.json pnpm.onlyBuiltDependencies entry is the RUNBOOKS-documented
fix for pnpm 11's esbuild build-script gate. Implements PRP-17.

* docs(docs): document the demo slice and showcase page (#132)

Adds the PRP-17 spec; a 'Try it in the browser' pointer in README; the
/demo/run + /demo/stream rows and a WebSocket Events section in
API_CONTRACTS; a 'Showcase pipeline fails' runbook incident; and
REPO_MAP_INDEX rows for the demo slice and showcase page.

Implements PRP-17.

* chore(main): release 0.2.10 (#135)

* feat: release v0.2.11 — visualization fixes, job picker, demo showcase (#158)

* feat(data): implement MarkdownGenerator age_days trigger via heuristic (#94) (#127)

Resolves #94 via the heuristic path documented in the issue. No schema
column, no Alembic migration, no FIFO cohort tracking — the trigger
self-reads the existing per-(store, product) on_hand_qty series and
fires when inventory has been "unrefreshed" past
`cfg.age_days_threshold`.

Decision rationale (schema column vs. heuristic):
- The schema column path would add `oldest_unit_age_days` to
  `inventory_snapshot_daily`, plus an Alembic migration, plus FIFO
  cohort tracking in `InventorySnapshotGenerator`. No downstream
  consumer reads this column today — adding it for one generator
  trigger violates the "don't design for hypothetical future
  requirements" rule in CLAUDE.md.
- The heuristic path is self-contained in MarkdownGenerator,
  deterministic (preserves the zero-rng-draw regression invariant),
  and additive (no migration, no model change). 354 LOC net, all
  inside one slice.

Heuristic spec:
- A "refresh" is a day where `on_hand_qty` rose by >=
  `_AGE_DAYS_SPIKE_THRESHOLD` (0.3 = 30% jump) vs the prior day.
- Age at day t = days since most recent refresh (or `dates[0]` if no
  refresh has been observed).
- Firing requires age >= `age_days_threshold` AND on_hand >=
  `markdown_min_units_remaining` — never markdown an empty shelf.
- After firing, refresh anchor resets to the day AFTER the markdown
  window ends, so back-to-back fires can't happen and the next age
  clock starts from a "clear shelf" baseline.

Wiring: `MarkdownGenerator.generate()` gains an optional kwarg
`inventory_records: list[dict[str, Any]] | None = None` which `core.py`
passes through from `InventorySnapshotGenerator`. Disabled-path and
non-age_days-path behavior is byte-identical (kwarg ignored).

Tests: +7 new in `TestAgeDaysTrigger`, -1 obsolete
`NotImplementedError` test. Coverage: no-records defensive, threshold
not-met, threshold met, spike resets age, post-fire reset avoids
back-to-back, low-inventory skip, unknown-product skip, rng
non-consumption.

Validation (local):
- ruff check + format: clean
- mypy --strict: 0 issues, 192 files
- pyright --strict: 0 errors
- pytest -m "not integration": 969 passed (+7 vs pre-PR)

Closes #94.

* feat(api,docs): e2e demo pipeline + showcase script (#128) (#129)

* docs(docs): add INITIAL-14 + PRP-15 e2e demo pipeline plan (#128)

Adds the planning documents for the end-to-end demo pipeline work tracked
in #128. Implementation commits follow on this branch.

- INITIAL-14.md: PRD for `make demo` (problem, solution, success metrics,
  open questions resolved in the PRP).
- PRPs/PRP-15-e2e-demo-pipeline.md: full execution plan (16 tasks → 6
  commits, additive only — no schema changes, no API edits).

* feat(data): add demo_minimal scenario preset (#128)

Tiny preset that powers the upcoming `make demo` target. Three stores ×
ten products × 92 days (2024-10-01..2024-12-31) — wide enough to satisfy
an expanding backtest with n_splits=3, horizon=14, min_train_size=30
(needs >= 72 days, 92 leaves margin), small enough to keep the demo
loop comfortable on a laptop.

Mirrors the retail_standard tuning (mild linear trend, noise_sigma=0.10,
modest promotion + stockout probabilities) so backtest WAPE stays
non-NaN across all three baseline models.

- app/shared/seeder/config.py: add DEMO_MINIMAL enum + from_scenario branch
- app/features/seeder/service.py: add ScenarioInfo entry in list_scenarios
- tests cover the new preset and the updated scenario count

* feat(api,docs): scripts/run_demo.py end-to-end pipeline driver (#128)

Single-file async driver that walks the published HTTP surface
(precheck -> reset? -> seed -> status -> features -> train x3 ->
backtest x3 -> register -> verify -> agent -> cleanup). Mirrors the
shape of scripts/seed_random.py and scripts/check_db.py.

- HttpClient: thin httpx.AsyncClient wrapper with explicit 60 s
  timeout (default 5 s is too short for /seeder/generate); surfaces
  RFC 7807 problem+json bodies as a typed StepError that echoes
  title / detail / request_id (never the raw body — secrets-safe).
- DemoContext + StepOutcome dataclasses thread cross-step references.
- Reporter renders the output-formatting.md glyphs (verbose by
  default, --quiet collapses to one line per step).
- Per-step error handling converts httpx + StepError into fail
  outcomes; precheck failure exits 2, any other failure exits 1,
  green exits 0.
- Agent step (10/11) skips with ⏭️ when neither OPENAI_API_KEY nor
  ANTHROPIC_API_KEY is set; reads via app.core.config.get_settings()
  to honor the no-os.environ-in-feature-code rule.
- Registry handshake uses the mandatory pending -> running -> success
  transition and the wire alias "model_config" (not "model_config_data");
  artifact_hash is computed client-side via sha256 since we share the
  FS with the API on this single-host system.
- Winner selection: lowest aggregated WAPE, skipping NaN folds.

Also adds scripts/__init__.py so tests can `import scripts.run_demo`
without invoking the file as a script.

* feat(repo): top-level Makefile with demo / demo-quick / demo-clean (#128)

Wraps scripts/run_demo.py so reviewers can run the full end-to-end
demo with one command. Recipes mirror the three modes the script
supports: full run, skip-seed iteration, destructive reset.

Make targets:
- demo        — docker compose up -d + alembic + run_demo
- demo-quick  — run_demo --skip-seed (no compose/migration touch)
- demo-clean  — full reset (--reset) before seeding
- help        — default goal; lists targets + preconditions

Tab-indented recipes and .PHONY declarations per make conventions.
Preconditions (Postgres on :5433, uvicorn on :8123) documented in
the help block; the script itself enforces them via the precheck
step and exits 2 on failure.

* test(api): unit + integration coverage for run_demo (#128)

Unit (`tests/test_run_demo_unit.py`, 32 cases):
- argparse defaults + all-flags variants
- DemoContext defaults (no leaking state across runs)
- _select_winner: lowest-WAPE, NaN-skip, all-NaN -> None, empty -> None
- _model_config_payload: discriminated-union shape per baseline; rejects
  unsupported model_type (defends the "no lightgbm in PRP-15" boundary)
- Reporter: glyph mapping; verbose + quiet output; summary green / failure
  / over-budget soft-warn branches
- StepError formats RFC 7807 (title/detail/request_id) without leaking
  the raw response body
- HttpClient (mocked httpx.AsyncClient): 2xx, 204, non-2xx -> StepError
- Step payload sanity: seed sends demo_minimal+correct dims+ISO dates;
  features sends cutoff_date as ISO; train fires three model_types in
  parallel; agent step skips with ⏭️ when no LLM key

Integration (`tests/test_e2e_demo.py`, @pytest.mark.integration):
- Skips if Postgres on :5433 isn't reachable
- Boots uvicorn on :8124 as a subprocess (avoids the dev :8123 default)
- Runs scripts/run_demo.py --reset against it; asserts exit 0 +
  canonical "runs=3 winner=... alias=demo-production" summary
- Second case asserts a bogus URL exits 2 (no silent success)
- Cleans up uvicorn on teardown with terminate/kill fallback
- Resolves `uv` via shutil.which to keep ruff S607 happy and avoid
  PATH-dependent exec at test time

* ci(repo): nightly e2e demo workflow (#128)

Adds .github/workflows/e2e-nightly.yml — runs scripts/run_demo.py
against a fresh Postgres+pgvector service every night at 07:00 UTC
(plus on-demand via workflow_dispatch). Catches regressions in the
documented end-to-end pipeline before they bleed into the per-PR
gate.

Per PRP-15 + INITIAL-14 risk note: this workflow is intentionally
NOT a required status check on dev or main. Flake-budget lives in
the nightly slot, not in ci.yml.

- pgvector/pgvector:pg16 service container (same as ci.yml `test` job)
- uvicorn started in background; /health polled with a 30 s deadline
- run_demo.py called with --seed 42 (deterministic)
- LLM-key env vars intentionally absent — agent step auto-skips via
  ⏭️, keeping the workflow self-contained
- uvicorn logs uploaded as artifact on failure (7-day retention) so
  postmortems can read what the API was doing when the script broke
- astral-sh/setup-uv pinned by 40-char SHA per security-patterns.md
- permissions: contents: read (least-privilege)

* docs(docs): cross-link make demo from README + RUNBOOKS + REPO_MAP_INDEX (#128)

Discoverability layer for PRP-15.

- README.md: new 'Try it: end-to-end demo' step right after the curl
  /health verification; shows the canonical final-line summary so
  reviewers know what green looks like.
- docs/DAILY-FLOW.md: new 'First-Run Smoke (Demo Pipeline)' section
  documenting all three Make targets.
- docs/_base/RUNBOOKS.md: new 'make demo fails at step X' Common
  Incidents entry with a 7-point diagnosis flow keyed to the script's
  step names + a postmortem-capture recipe.
- docs/_base/REPO_MAP_INDEX.md: Makefile and scripts/run_demo.py rows
  added to the Document Index table.

Pure additive; no existing content removed or renamed.

* fix(data): update /seeder/scenarios route test for demo_minimal preset (#128)

Companion to feat(data): add demo_minimal scenario preset — the
route-level assertion in TestListScenarios.test_returns_scenarios still
expected 6 scenarios; bumping to 7 and adding the demo_minimal name
membership check to match the service-layer + config-layer tests
already updated in 005c189.

* fix(api): harden run_demo for integration test + real DB (#128)

Three real failures surfaced when first running the integration test
against docker-compose Postgres + a freshly booted uvicorn; all three
are now closed:

scripts/run_demo.py:
1. step_status: discover the real (store_id, product_id) from
   /dimensions/stores + /dimensions/products instead of hardcoding 1.
   Postgres auto-increment does NOT reset after delete, so the freshly
   seeded IDs are NOT 1 (they were ~150-260 on this branch after a few
   delete/seed cycles).
2. step_register: copy the trained-model artifact into the registry's
   own root (settings.registry_artifact_root) and record a registry-
   relative URI. The registry verify endpoint resolves artifact_uri
   against its own root, which is separate from where /forecasting/train
   writes (settings.forecast_model_artifacts_dir). Pre-fix, verify
   returned 404 even though the artifact existed on disk.
3. step_agent: skip with the soft-skip glyph on any LLM provider failure
   (invalid key, model unavailable, 5xx), and make _llm_key_present
   provider-aware so it matches the right env var to the configured
   agent_default_model. Pre-fix, an .env with anthropic/openai keys but
   a Gemini default model failed hard at chat-time.
4. Bumped DEFAULT_TIMEOUT_S from 60 to 120 because /seeder/generate
   for demo_minimal can spend 60-90 s on slower laptops once you
   include inventory + prices + promotions inserts.
5. step_seed detail string: GenerateResult.records_created uses 'sales'
   (singular), not 'sales_daily'; cosmetic fix.

tests/test_e2e_demo.py:
- Redirect uvicorn stdout to a temp file rather than subprocess.PIPE.
  The seeder + structlog produce enough INFO log volume to fill a
  64-KB pipe buffer; once full, uvicorn blocks on write and seeder
  requests hang for the full --timeout. Verified locally: integration
  suite now passes in ~6.5 s instead of timing out at 120 s.
- Cleanup leaves the log file on disk only when the test failed
  (postmortem-friendly).

tests/test_run_demo_unit.py:
- Bump test_defaults timeout expectation to match the new 120 s
  default.

End-to-end manual run on this machine: 11 steps, wall_clock=2 s,
exit 0. Integration test: 2 passed in 6.48 s.

* chore(repo): bump authlib + fastmcp to clear Socket-flagged CVEs (#130) (#131)

Headline:
- authlib  1.6.6  -> 1.7.2  (clears GHSA-wvwj-cvrp-7pv5 — JWS signature
  verification bypass; patched at >= 1.6.9)
- fastmcp  2.14.4 -> 3.2.4  (clears GHSA-vv7q-7jx5-f767 — OpenAPI
  Provider SSRF + path traversal; patched at >= 3.2.0)

Both CVEs were flagged on PR #129 by Socket Security and are
pre-existing on dev (not introduced by #128).

Wider scope — read before merging:
`uv lock --upgrade-package authlib --upgrade-package fastmcp` triggers
a full re-resolve of the dependency graph. Because dev's uv.lock had
drifted from pyproject.toml (the project's constraint envelope had
loosened over time), this single command also brings the lockfile in
sync with current pyproject.toml. Net diff: 243 insertions / 369
deletions on uv.lock; no other files touched.

Transitive cascades worth flagging:
- anthropic    0.77.0 -> 0.102.0 (pydantic-ai-slim extra)
- pydantic-graph 1.51.0 -> 1.96.0
- temporalio   1.20.0 -> 1.27.2
- alembic      1.18.1 -> 1.18.4
- aws-* and cohere transitives bumped along
- griffe 1.15.0 dropped in favor of griffelib 2.0.2 (fastmcp 3.x switched)
- Removed: cloudpickle, diskcache, fakeredis, invoke, lupa, prometheus
  exporter, pydocket, redis, rsa, sortedcontainers — these were
  transitives of fastmcp 2.x that fastmcp 3.x no longer pulls in.

Verification on this host:
- uv sync --extra dev  -> green
- ruff check .         -> clean
- mypy --strict app/   -> 192 files clean
- pyright app/         -> 0 errors (50 warnings, pre-existing)
- pytest -m 'not integration' -> 969 passed

Known install quirk: griffelib 2.0.2 ships a top-level `griffe/`
package whose RECORD files don't always materialize on first install
when uv replaces an older `griffe` dist in the same sync. A clean
venv install (which CI does via `uv sync --frozen`) is unaffected;
local devs who upgrade in place may need a one-shot
`uv pip install --force-reinstall griffelib` if `import griffe` fails.

* feat(api,ui): in-product demo showcase page (#132) (#133)

* feat(api): add demo slice driving the e2e pipeline via /demo endpoints (#132)

New app/features/demo slice exposing POST /demo/run and WS /demo/stream. It
drives the published API surface in-process via httpx.ASGITransport (no
cross-slice imports, satisfying the vertical-slice rule) and streams one
StepEvent per pipeline step: precheck -> reset -> seed -> status -> features
-> train x3 -> backtest x3 -> register -> verify -> agent -> cleanup.

A module-level asyncio.Lock enforces single-flight; concurrent runs get an
RFC 7807 409. The orchestration is a faithful in-process port of
scripts/run_demo.py (PR #129). Implements PRP-17.

* test(api): cover the demo slice pipeline, routes, and e2e integration (#132)

Unit tests mock the in-process HTTP client to exercise step sequencing,
winner selection, and fail-fast; route tests cover POST /demo/run (200 +
409) and the WS /demo/stream handler. The integration test seeds
demo_minimal and asserts an end-to-end green run against real Postgres.

Implements PRP-17.

* feat(ui): add showcase page streaming the live demo pipeline (#132)

New /showcase route and nav entry. The page opens a one-shot WebSocket to
/demo/stream via a use-demo-pipeline hook (wrapping useWebSocket) and renders
the 11 pipeline steps as live status cards: glyph, detail, duration, the
backtest per-model WAPE breakdown with the winner highlighted, and a
pass/fail summary banner.

Also block-scopes a pre-existing no-case-declarations lint error in
chat.tsx so pnpm lint is green for this PR. Implements PRP-17.

* test(ui): add vitest setup and use-demo-pipeline hook coverage (#132)

Adds the frontend test stack (vitest + jsdom + @testing-library/react), a
test script, and vitest.config.ts. use-demo-pipeline.test.ts covers the
pure event reducer (idle -> running -> pass transitions, summary assembly,
error phase) and a renderHook smoke test.

The package.json pnpm.onlyBuiltDependencies entry is the RUNBOOKS-documented
fix for pnpm 11's esbuild build-script gate. Implements PRP-17.

* docs(docs): document the demo slice and showcase page (#132)

Adds the PRP-17 spec; a 'Try it in the browser' pointer in README; the
/demo/run + /demo/stream rows and a WebSocket Events section in
API_CONTRACTS; a 'Showcase pipeline fails' runbook incident; and
REPO_MAP_INDEX rows for the demo slice and showcase page.

Implements PRP-17.

* chore(repo): back-merge main into dev to absorb v0.2.10 release commits (#136) (#137)

* chore(main): release 0.2.9 (#126)

* feat: release v0.2.10 — demo showcase page + e2e pipeline (#134)

* feat(data): implement MarkdownGenerator age_days trigger via heuristic (#94) (#127)

Resolves #94 via the heuristic path documented in the issue. No schema
column, no Alembic migration, no FIFO cohort tracking — the trigger
self-reads the existing per-(store, product) on_hand_qty series and
fires when inventory has been "unrefreshed" past
`cfg.age_days_threshold`.

Decision rationale (schema column vs. heuristic):
- The schema column path would add `oldest_unit_age_days` to
  `inventory_snapshot_daily`, plus an Alembic migration, plus FIFO
  cohort tracking in `InventorySnapshotGenerator`. No downstream
  consumer reads this column today — adding it for one generator
  trigger violates the "don't design for hypothetical future
  requirements" rule in CLAUDE.md.
- The heuristic path is self-contained in MarkdownGenerator,
  deterministic (preserves the zero-rng-draw regression invariant),
  and additive (no migration, no model change). 354 LOC net, all
  inside one slice.

Heuristic spec:
- A "refresh" is a day where `on_hand_qty` rose by >=
  `_AGE_DAYS_SPIKE_THRESHOLD` (0.3 = 30% jump) vs the prior day.
- Age at day t = days since most recent refresh (or `dates[0]` if no
  refresh has been observed).
- Firing requires age >= `age_days_threshold` AND on_hand >=
  `markdown_min_units_remaining` — never markdown an empty shelf.
- After firing, refresh anchor resets to the day AFTER the markdown
  window ends, so back-to-back fires can't happen and the next age
  clock starts from a "clear shelf" baseline.

Wiring: `MarkdownGenerator.generate()` gains an optional kwarg
`inventory_records: list[dict[str, Any]] | None = None` which `core.py`
passes through from `InventorySnapshotGenerator`. Disabled-path and
non-age_days-path behavior is byte-identical (kwarg ignored).

Tests: +7 new in `TestAgeDaysTrigger`, -1 obsolete
`NotImplementedError` test. Coverage: no-records defensive, threshold
not-met, threshold met, spike resets age, post-fire reset avoids
back-to-back, low-inventory skip, unknown-product skip, rng
non-consumption.

Validation (local):
- ruff check + format: clean
- mypy --strict: 0 issues, 192 files
- pyright --strict: 0 errors
- pytest -m "not integration": 969 passed (+7 vs pre-PR)

Closes #94.

* feat(api,docs): e2e demo pipeline + showcase script (#128) (#129)

* docs(docs): add INITIAL-14 + PRP-15 e2e demo pipeline plan (#128)

Adds the planning documents for the end-to-end demo pipeline work tracked
in #128. Implementation commits follow on this branch.

- INITIAL-14.md: PRD for `make demo` (problem, solution, success metrics,
  open questions resolved in the PRP).
- PRPs/PRP-15-e2e-demo-pipeline.md: full execution plan (16 tasks → 6
  commits, additive only — no schema changes, no API edits).

* feat(data): add demo_minimal scenario preset (#128)

Tiny preset that powers the upcoming `make demo` target. Three stores ×
ten products × 92 days (2024-10-01..2024-12-31) — wide enough to satisfy
an expanding backtest with n_splits=3, horizon=14, min_train_size=30
(needs >= 72 days, 92 leaves margin), small enough to keep the demo
loop comfortable on a laptop.

Mirrors the retail_standard tuning (mild linear trend, noise_sigma=0.10,
modest promotion + stockout probabilities) so backtest WAPE stays
non-NaN across all three baseline models.

- app/shared/seeder/config.py: add DEMO_MINIMAL enum + from_scenario branch
- app/features/seeder/service.py: add ScenarioInfo entry in list_scenarios
- tests cover the new preset and the updated scenario count

* feat(api,docs): scripts/run_demo.py end-to-end pipeline driver (#128)

Single-file async driver that walks the published HTTP surface
(precheck -> reset? -> seed -> status -> features -> train x3 ->
backtest x3 -> register -> verify -> agent -> cleanup). Mirrors the
shape of scripts/seed_random.py and scripts/check_db.py.

- HttpClient: thin httpx.AsyncClient wrapper with explicit 60 s
  timeout (default 5 s is too short for /seeder/generate); surfaces
  RFC 7807 problem+json bodies as a typed StepError that echoes
  title / detail / request_id (never the raw body — secrets-safe).
- DemoContext + StepOutcome dataclasses thread cross-step references.
- Reporter renders the output-formatting.md glyphs (verbose by
  default, --quiet collapses to one line per step).
- Per-step error handling converts httpx + StepError into fail
  outcomes; precheck failure exits 2, any other failure exits 1,
  green exits 0.
- Agent step (10/11) skips with ⏭️ when neither OPENAI_API_KEY nor
  ANTHROPIC_API_KEY is set; reads via app.core.config.get_settings()
  to honor the no-os.environ-in-feature-code rule.
- Registry handshake uses the mandatory pending -> running -> success
  transition and the wire alias "model_config" (not "model_config_data");
  artifact_hash is computed client-side via sha256 since we share the
  FS with the API on this single-host system.
- Winner selection: lowest aggregated WAPE, skipping NaN folds.

Also adds scripts/__init__.py so tests can `import scripts.run_demo`
without invoking the file as a script.

* feat(repo): top-level Makefile with demo / demo-quick / demo-clean (#128)

Wraps scripts/run_demo.py so reviewers can run the full end-to-end
demo with one command. Recipes mirror the three modes the script
supports: full run, skip-seed iteration, destructive reset.

Make targets:
- demo        — docker compose up -d + alembic + run_demo
- demo-quick  — run_demo --skip-seed (no compose/migration touch)
- demo-clean  — full reset (--reset) before seeding
- help        — default goal; lists targets + preconditions

Tab-indented recipes and .PHONY declarations per make conventions.
Preconditions (Postgres on :5433, uvicorn on :8123) documented in
the help block; the script itself enforces them via the precheck
step and exits 2 on failure.

* test(api): unit + integration coverage for run_demo (#128)

Unit (`tests/test_run_demo_unit.py`, 32 cases):
- argparse defaults + all-flags variants
- DemoContext defaults (no leaking state across runs)
- _select_winner: lowest-WAPE, NaN-skip, all-NaN -> None, empty -> None
- _model_config_payload: discriminated-union shape per baseline; rejects
  unsupported model_type (defends the "no lightgbm in PRP-15" boundary)
- Reporter: glyph mapping; verbose + quiet output; summary green / failure
  / over-budget soft-warn branches
- StepError formats RFC 7807 (title/detail/request_id) without leaking
  the raw response body
- HttpClient (mocked httpx.AsyncClient): 2xx, 204, non-2xx -> StepError
- Step payload sanity: seed sends demo_minimal+correct dims+ISO dates;
  features sends cutoff_date as ISO; train fires three model_types in
  parallel; agent step skips with ⏭️ when no LLM key

Integration (`tests/test_e2e_demo.py`, @pytest.mark.integration):
- Skips if Postgres on :5433 isn't reachable
- Boots uvicorn on :8124 as a subprocess (avoids the dev :8123 default)
- Runs scripts/run_demo.py --reset against it; asserts exit 0 +
  canonical "runs=3 winner=... alias=demo-production" summary
- Second case asserts a bogus URL exits 2 (no silent success)
- Cleans up uvicorn on teardown with terminate/kill fallback
- Resolves `uv` via shutil.which to keep ruff S607 happy and avoid
  PATH-dependent exec at test time

* ci(repo): nightly e2e demo workflow (#128)

Adds .github/workflows/e2e-nightly.yml — runs scripts/run_demo.py
against a fresh Postgres+pgvector service every night at 07:00 UTC
(plus on-demand via workflow_dispatch). Catches regressions in the
documented end-to-end pipeline before they bleed into the per-PR
gate.

Per PRP-15 + INITIAL-14 risk note: this workflow is intentionally
NOT a required status check on dev or main. Flake-budget lives in
the nightly slot, not in ci.yml.

- pgvector/pgvector:pg16 service container (same as ci.yml `test` job)
- uvicorn started in background; /health polled with a 30 s deadline
- run_demo.py called with --seed 42 (deterministic)
- LLM-key env vars intentionally absent — agent step auto-skips via
  ⏭️, keeping the workflow self-contained
- uvicorn logs uploaded as artifact on failure (7-day retention) so
  postmortems can read what the API was doing when the script broke
- astral-sh/setup-uv pinned by 40-char SHA per security-patterns.md
- permissions: contents: read (least-privilege)

* docs(docs): cross-link make demo from README + RUNBOOKS + REPO_MAP_INDEX (#128)

Discoverability layer for PRP-15.

- README.md: new 'Try it: end-to-end demo' step right after the curl
  /health verification; shows the canonical final-line summary so
  reviewers know what green looks like.
- docs/DAILY-FLOW.md: new 'First-Run Smoke (Demo Pipeline)' section
  documenting all three Make targets.
- docs/_base/RUNBOOKS.md: new 'make demo fails at step X' Common
  Incidents entry with a 7-point diagnosis flow keyed to the script's
  step names + a postmortem-capture recipe.
- docs/_base/REPO_MAP_INDEX.md: Makefile and scripts/run_demo.py rows
  added to the Document Index table.

Pure additive; no existing content removed or renamed.

* fix(data): update /seeder/scenarios route test for demo_minimal preset (#128)

Companion to feat(data): add demo_minimal scenario preset — the
route-level assertion in TestListScenarios.test_returns_scenarios still
expected 6 scenarios; bumping to 7 and adding the demo_minimal name
membership check to match the service-layer + config-layer tests
already updated in 005c189.

* fix(api): harden run_demo for integration test + real DB (#128)

Three real failures surfaced when first running the integration test
against docker-compose Postgres + a freshly booted uvicorn; all three
are now closed:

scripts/run_demo.py:
1. step_status: discover the real (store_id, product_id) from
   /dimensions/stores + /dimensions/products instead of hardcoding 1.
   Postgres auto-increment does NOT reset after delete, so the freshly
   seeded IDs are NOT 1 (they were ~150-260 on this branch after a few
   delete/seed cycles).
2. step_register: copy the trained-model artifact into the registry's
   own root (settings.registry_artifact_root) and record a registry-
   relative URI. The registry verify endpoint resolves artifact_uri
   against its own root, which is separate from where /forecasting/train
   writes (settings.forecast_model_artifacts_dir). Pre-fix, verify
   returned 404 even though the artifact existed on disk.
3. step_agent: skip with the soft-skip glyph on any LLM provider failure
   (invalid key, model unavailable, 5xx), and make _llm_key_present
   provider-aware so it matches the right env var to the configured
   agent_default_model. Pre-fix, an .env with anthropic/openai keys but
   a Gemini default model failed hard at chat-time.
4. Bumped DEFAULT_TIMEOUT_S from 60 to 120 because /seeder/generate
   for demo_minimal can spend 60-90 s on slower laptops once you
   include inventory + prices + promotions inserts.
5. step_seed detail string: GenerateResult.records_created uses 'sales'
   (singular), not 'sales_daily'; cosmetic fix.

tests/test_e2e_demo.py:
- Redirect uvicorn stdout to a temp file rather than subprocess.PIPE.
  The seeder + structlog produce enough INFO log volume to fill a
  64-KB pipe buffer; once full, uvicorn blocks on write and seeder
  requests hang for the full --timeout. Verified locally: integration
  suite now passes in ~6.5 s instead of timing out at 120 s.
- Cleanup leaves the log file on disk only when the test failed
  (postmortem-friendly).

tests/test_run_demo_unit.py:
- Bump test_defaults timeout expectation to match the new 120 s
  default.

End-to-end manual run on this machine: 11 steps, wall_clock=2 s,
exit 0. Integration test: 2 passed in 6.48 s.

* chore(repo): bump authlib + fastmcp to clear Socket-flagged CVEs (#130) (#131)

Headline:
- authlib  1.6.6  -> 1.7.2  (clears GHSA-wvwj-cvrp-7pv5 — JWS signature
  verification bypass; patched at >= 1.6.9)
- fastmcp  2.14.4 -> 3.2.4  (clears GHSA-vv7q-7jx5-f767 — OpenAPI
  Provider SSRF + path traversal; patched at >= 3.2.0)

Both CVEs were flagged on PR #129 by Socket Security and are
pre-existing on dev (not introduced by #128).

Wider scope — read before merging:
`uv lock --upgrade-package authlib --upgrade-package fastmcp` triggers
a full re-resolve of the dependency graph. Because dev's uv.lock had
drifted from pyproject.toml (the project's constraint envelope had
loosened over time), this single command also brings the lockfile in
sync with current pyproject.toml. Net diff: 243 insertions / 369
deletions on uv.lock; no other files touched.

Transitive cascades worth flagging:
- anthropic    0.77.0 -> 0.102.0 (pydantic-ai-slim extra)
- pydantic-graph 1.51.0 -> 1.96.0
- temporalio   1.20.0 -> 1.27.2
- alembic      1.18.1 -> 1.18.4
- aws-* and cohere transitives bumped along
- griffe 1.15.0 dropped in favor of griffelib 2.0.2 (fastmcp 3.x switched)
- Removed: cloudpickle, diskcache, fakeredis, invoke, lupa, prometheus
  exporter, pydocket, redis, rsa, sortedcontainers — these were
  transitives of fastmcp 2.x that fastmcp 3.x no longer pulls in.

Verification on this host:
- uv sync --extra dev  -> green
- ruff check .         -> clean
- mypy --strict app/   -> 192 files clean
- pyright app/         -> 0 errors (50 warnings, pre-existing)
- pytest -m 'not integration' -> 969 passed

Known install quirk: griffelib 2.0.2 ships a top-level `griffe/`
package whose RECORD files don't always materialize on first install
when uv replaces an older `griffe` dist in the same sync. A clean
venv install (which CI does via `uv sync --frozen`) is unaffected;
local devs who upgrade in place may need a one-shot
`uv pip install --force-reinstall griffelib` if `import griffe` fails.

* feat(api,ui): in-product demo showcase page (#132) (#133)

* feat(api): add demo slice driving the e2e pipeline via /demo endpoints (#132)

New app/features/demo slice exposing POST /demo/run and WS /demo/stream. It
drives the published API surface in-process via httpx.ASGITransport (no
cross-slice imports, satisfying the vertical-slice rule) and streams one
StepEvent per pipeline step: precheck -> reset -> seed -> status -> features
-> train x3 -> backtest x3 -> register -> verify -> agent -> cleanup.

A module-level asyncio.Lock enforces single-flight; concurrent runs get an
RFC 7807 409. The orchestration is a faithful in-process port of
scripts/run_demo.py (PR #129). Implements PRP-17.

* test(api): cover the demo slice pipeline, routes, and e2e integration (#132)

Unit tests mock the in-process HTTP client to exercise step sequencing,
winner selection, and fail-fast; route tests cover POST /demo/run (200 +
409) and the WS /demo/stream handler. The integration test seeds
demo_minimal and asserts an end-to-end green run against real Postgres.

Implements PRP-17.

* feat(ui): add showcase page streaming the live demo pipeline (#132)

New /showcase route and nav entry. The page opens a one-shot WebSocket to
/demo/stream via a use-demo-pipeline hook (wrapping useWebSocket) and renders
the 11 pipeline steps as live status cards: glyph, detail, duration, the
backtest per-model WAPE breakdown with the winner highlighted, and a
pass/fail summary banner.

Also block-scopes a pre-existing no-case-declarations lint error in
chat.tsx so pnpm lint is green for this PR. Implements PRP-17.

* test(ui): add vitest setup and use-demo-pipeline hook coverage (#132)

Adds the frontend test stack (vitest + jsdom + @testing-library/react), a
test script, and vitest.config.ts. use-demo-pipeline.test.ts covers the
pure event reducer (idle -> running -> pass transitions, summary assembly,
error phase) and a renderHook smoke test.

The package.json pnpm.onlyBuiltDependencies entry is the RUNBOOKS-documented
fix for pnpm 11's esbuild build-script gate. Implements PRP-17.

* docs(docs): document the demo slice and showcase page (#132)

Adds the PRP-17 spec; a 'Try it in the browser' pointer in README; the
/demo/run + /demo/stream rows and a WebSocket Events section in
API_CONTRACTS; a 'Showcase pipeline fails' runbook incident; and
REPO_MAP_INDEX rows for the demo slice and showcase page.

Implements PRP-17.

* chore(main): release 0.2.10 (#135)

* docs(docs): fix broken PRP-0/INITIAL-0 relative links in phase 0 doc (#138) (#139)

* docs(repo): fix readme dev-deps command and stale .github template placeholders (#140) (#141)

* docs(docs): fill DEV_GUIDE.md onboarding stub sections (#142) (#143)

* docs(repo): refresh stale CLAUDE.md note, document /demo API, align PR template (#144) (#145)

* fix(ui): chart series render black — drop hsl() wrapper on oklch chart vars (#149) (#153)

index.css defines --chart-N twice: legacy shadcn-v3 HSL triplets and
Tailwind-4 / shadcn-v4 complete oklch() colours. The oklch definitions win
the cascade, so at runtime --chart-N is a full colour. The chart components
still wrapped it as hsl(var(--chart-N)) → hsl(oklch(...)), which is invalid
CSS, so recharts fell back to a black fill/stroke — invisible on the dark
theme.

Reference var(--chart-N) directly in backtest-folds-chart.tsx and
time-series-chart.tsx. Verified in a browser: the backtest per-fold bars
and the forecast line now render in colour.

* fix(jobs): backtest job result keeps fold metrics, stability and baselines (#148) (#152)

* fix(jobs): backtest job result keeps fold metrics, stability and baselines (#148)

_execute_backtest ran BacktestingService.run_backtest — which computes
per-fold metrics, stability indices and a naive/seasonal baseline comparison
— but stored only four aggregated values and discarded the rest. The
dashboard (/visualize/backtest) reads aggregated_metrics.{*_mean,
stability_index}, fold_metrics[] and baseline_comparison, so it showed
"0 folds", all-zero metrics and an empty chart.

Add _shape_backtest_result(), which flattens a BacktestResponse into the
contract the dashboard expects, and _finite(), which coerces NaN/inf to 0.0
so the result stays JSONB-safe (stability is NaN with fewer than two folds).

Add app/features/jobs/tests/test_service.py with unit coverage for the
shaping logic: fold metrics, *_mean keys, stability, baseline comparison,
the no-baselines path, and NaN coercion.

* refactor(jobs): centralize backtest metric keys and surface drift (#148)

Addresses review feedback on PR #152.

- Hoist the dashboard's metric set into _BACKTEST_METRICS and the headline
  stability metric into _STABILITY_METRIC, so the hardcoded keys live in one
  documented place instead of being repeated across the shaping logic.
- Log jobs.backtest_metrics_missing when an expected metric is absent from the
  backtest response, so a future rename in the backtesting service fails loud
  instead of silently emitting 0.0.
- Document the WAPE stability convention in the _shape_backtest_result docstring.
- Tests: assert backtest_id / model_type / duration_ms pass through unchanged,
  and add a regression test for the missing-metric default path.

* fix(ui): forecast page reads forecasts/forecast from predict job result (#147) (#151)

The /visualize/forecast page never rendered the chart for a valid completed
predict job. It read job.result.predictions with field `predicted`, but
POST /jobs (job_type="predict") returns job.result.forecasts with field
`forecast`. forecastData was therefore always undefined and the page fell
through to "No prediction data available in job result".

Read result.forecasts with field `forecast`, and pass predictedKey="forecast"
to TimeSeriesChart (which already supports a configurable data key).

Verified in a browser: entering a completed predict job ID now renders the
14-day forecast line chart with correct tooltip values.

* fix(registry): tolerate multiple matches in _find_duplicate (#146) (#150)

Under the default registry_duplicate_policy="detect", duplicate runs are
created intentionally, so multiple non-archived model_run rows can share one
config hash. _find_duplicate used scalar_one_or_none(), which raised
MultipleResultsFound once two duplicates existed — POST /registry/runs then
returned HTTP 500. This made the demo/Showcase register step fail
deterministically on any DB with repeated runs.

Order the lookup by created_at desc, LIMIT 1, and use scalars().first() so it
returns the most recent matching run instead of asserting a single match.

Add an integration regression test that POSTs an identical run three times
under the detect policy and asserts all three return 201.

* fix(ui): derive TimeSeriesChart line stroke from the config key (#156) (#157)

TimeSeriesChart builds chartConfig with dynamic keys ([actualKey] /
[predictedKey]), so shadcn's ChartContainer injects --color-<key> CSS
variables. The <Line> elements, however, hardcoded stroke="var(--color-actual)"
and stroke="var(--color-predicted)". The forecast page passes
predictedKey="forecast", so the injected variable is --color-forecast;
var(--color-predicted) was undefined, the stroke was invalid, and SVG fell
back to its initial value `none` — the forecast line was invisible.

Build the stroke from the key: stroke={`var(--color-${actualKey})`} /
stroke={`var(--color-${predictedKey})`}.

Verified in a browser: the forecast line now renders in colour.

* feat(ui): job picker dropdown on forecast and backtest pages (#154) (#155)

The visualization pages only accepted a job ID typed into a text box, so
users had to already know the ID. Add a JobPicker component: a dropdown of
completed jobs of the relevant type (predict / backtest), newest first, with
each option labelled by short id, model and timestamp.

- New shared component src/components/common/job-picker.tsx, used by both
  forecast.tsx and backtest.tsx.
- The manual job-ID input stays alongside the dropdown for pasting an ID.
- The most recent completed job auto-loads on mount so a chart shows
  immediately without interaction.

No backend change — GET /jobs?job_type=&status=completed already exists.
Verified in a browser on both pages.

* chore(main): release 0.2.11 (#159)
…163)

* feat(api,ui): add AI model admin console with Ollama support (#162)

* fix(db): register AppConfig model in alembic env for schema-drift check (#162)
A casual message to the Experiment agent could crash the WebSocket
stream with a raw 'Tool ... exceeded max retries count of 1' error
when the model produced an invalid tool call.

- Catch PydanticAI's UnexpectedModelBehavior in stream_chat and chat;
  surface a clean, recoverable error event / message instead of
  leaking the internal exception string.
- Make tool_compare_backtest_results tolerant of missing/empty args
  (return a self-correcting hint) so a malformed call no longer burns
  the retry budget and crashes the run.
- Add a conversational-fallback line to the experiment system prompt
  so greetings are answered without invoking workflow tools.
- Add regression tests for both the chat and stream-chat paths.
…e adapter (#166) (#167)

* fix(agents): round-trip agent message history through pydantic-ai type adapter (#166)

Multi-turn agent chat crashed with a dict-has-no-attribute-conversation_id
error: _deserialize_messages returned the raw stored dicts unchanged, but
PydanticAI 1.96 requires real ModelMessage objects (it accesses
msg.conversation_id on every history item).

- _serialize_messages now uses ModelMessagesTypeAdapter.dump_python
  (mode=json), so stored history can be round-tripped.
- _deserialize_messages uses ModelMessagesTypeAdapter.validate_python,
  degrading to an empty history (with a warning) when stored data
  predates this format instead of crashing the run.
- Replace the serialization tests with a real round-trip test and a
  legacy-format fallback test.

* fix(agents): broaden deserialize-failure handling and log session id (#166)

Address code-review feedback on the message-history round-trip fix:

- _deserialize_messages now catches any Exception, not only
  ValidationError, so a malformed stored record (wrong shape, type
  errors) can never crash an otherwise-valid agent run.
- The warning logs exc_info (full type, message, traceback) instead of
  just str(e), and includes session_id so a failure can be correlated
  with the specific stored record.
- Add a regression test that a non-ValidationError adapter failure also
  degrades to an empty history.
… (#171)

Settings.agent_retry_attempts (default 3, set in .env) was never passed
to the PydanticAI Agent constructor, so both agents silently used the
framework default of 1. Agent runs failed with "Exceeded maximum output
retries (1)" — a weaker model got only one attempt to emit a valid
structured ExperimentReport / RAGAnswer.

- Add get_agent_retries() helper in agents/base.py.
- Pass output_retries and tool_retries to the experiment and
  rag_assistant Agent constructors (PydanticAI 1.96 deprecated the
  combined retries kwarg in favour of the two explicit ones).
- Add tests asserting both agents are built with the configured budget.
…ptedOutput (#172, #173) (#174)

* fix(agents): run agent tool calls sequentially over the shared session (#172)

When the model emitted multiple DB-touching tool calls in one turn,
PydanticAI executed them concurrently. Every agent tool shares the
single AgentDeps.db AsyncSession, and SQLAlchemy forbids concurrent
operations on one session, so the run failed intermittently with
"InvalidRequestError: concurrent operations are not permitted".

- Wrap agent.run() (chat) and agent.run_stream() (stream_chat) in
  Agent.parallel_tool_call_execution_mode("sequential").
- Add a regression test asserting chat() runs under sequential mode.

* fix(agents): use PromptedOutput so weaker models can produce structured output (#173)

Both agents declared output_type as a plain model, which PydanticAI
serves via its default ToolOutput mode (the model must call a hidden
final_result tool). Weaker/local models answer in plain prose instead,
PydanticAI rejects it as json_invalid, and the run fails with
"Exceeded maximum output retries".

- Wrap the experiment and rag_assistant output_type in PromptedOutput,
  which places the JSON schema in the prompt and parses the model's
  text reply. Works for local and cloud models alike.
- Add tests asserting both agents build with a PromptedOutputSchema.

* refactor(agents): centralize sequential-tool-execution policy and harden agent tests (#173)

Addresses code-review feedback on PR #174:

- Extract the duplicated Agent.parallel_tool_call_execution_mode("sequential")
  wrapping from chat() and stream_chat() into a _sequential_tool_execution()
  helper, so the issue-#172 execution-mode policy lives in one place.
- Replace test reliance on private internals. test_base.py no longer asserts
  agent._output_schema's class-name string; it now verifies PromptedOutput
  behaviorally via the public FunctionModel test double (no final_result
  output tool registered, plain-text JSON reply parsed into the schema).
- test_service.py drops the private _parallel_execution_mode_ctx_var import
  and asserts the public Agent.parallel_tool_call_execution_mode API instead.
- Add test_stream_chat_runs_tools_sequentially mirroring the chat() test so
  the streaming path is covered against issue #172 regressions.
…175) (#177)

Two coupled robustness fixes for the agent layer, both surfaced by a
capture_run_messages diagnostic. The changes share base.py and
experiment.py, so they land in one commit.

#175 — the experiment prompt named tools as run_backtest / list_runs /
compare_backtest_results, but the registered tools are tool_-prefixed
(tool_run_backtest, ...). Weaker models trusted the prompt and called
unknown tool names. TOOL_USAGE_INSTRUCTIONS and the EXPERIMENT_SYSTEM_PROMPT
workflow now use the exact registered names.

#176 — a tool raising a plain exception aborted the whole run (observed:
ValueError "No data found for store=..."). New recoverable() decorator
wraps every async DB-touching tool so an expected ValueError becomes a
ModelRetry the model can correct from; other exceptions still propagate.

- Add recoverable() to agents/base.py; decorate the 6 experiment tools
  and the 2 rag_assistant tools (tool_plain pure tools left alone).
- Tests: prompt names use tool_* ; recoverable converts ValueError to
  ModelRetry, passes other exceptions through, is transparent on success.
Absorb the v0.2.11 release commits and the Dependabot CI bumps (#168
setup-uv 8.1.0, #169 codeql-action 4.35.5) that landed on main.

Conflicts resolved (all add/add — dev added the #162/#163 config slice
that main lacked, plus the setup-uv pin):
- app/main.py — keep dev's config_router wiring + apply_overrides_on_startup
- docs/_base/API_CONTRACTS.md — keep dev's /config/* endpoint rows
- frontend/src/types/api.ts — keep dev's AI-model config types
- .github/workflows/e2e-nightly.yml — take main's setup-uv v8.1.0 pin

Clears the conflict on PR #178 (dev → main).
Absorb the release-please v0.2.12 version bump (.release-please-manifest.json,
pyproject.toml, CHANGELOG.md) so dev tracks main. Clean merge, no conflicts.
…#183) (#184)

* fix(agents): wire FallbackModel so a primary 503 retries the fallback (#183)

* test(agents): assert FallbackModel wiring order and primary fail-fast (#183)
* feat(api): expose agent session limits on GET /config/ai (#185)

* feat(ui): add knowledge and agent guide pages with nav (#185)

* test(ui): cover knowledge-utils pure helpers (#185)

* docs(docs): document the knowledge and agent guide pages (#185)
… charts, cross-filtering (PRP-20) (#188)

* feat(analytics): add GET /analytics/timeseries aggregated sales endpoint (#187)

* feat(dimensions): add sort_by/sort_order to store and product listings (#187)

* feat(ui): add explorer detail pages, sortable tables, and sales charts (#187)

* test(ui): cover the csv-export pure helper (#187)

* docs(docs): document the explorer interactivity extension (#187)
…mparison, verify, sorting (PRP-21) (#190)

* feat(registry): add sort_by/sort_order to model-run listing (#189)

* feat(jobs): add sort_by/sort_order to job listing (#189)

* test(registry,jobs): cover list-endpoint sorting (#189)

* feat(ui): add run/job detail and run-comparison pages (#189)

* feat(ui): make Runs and Jobs tables interactive (#189)

* docs(docs): document explorer runs/jobs interactivity (#189)
Copy link
Copy Markdown

@sourcery-ai sourcery-ai Bot left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Sorry @w7-mgfcode, your pull request is larger than the review limit of 150000 diff characters

@coderabbitai
Copy link
Copy Markdown

coderabbitai Bot commented May 18, 2026

Warning

Rate limit exceeded

@w7-mgfcode has exceeded the limit for the number of commits that can be reviewed per hour. Please wait 27 minutes and 9 seconds before requesting another review.

You’ve run out of usage credits. Purchase more in the billing tab.

⌛ How to resolve this issue?

After the wait time has elapsed, a review can be triggered using the @coderabbitai review command as a PR comment. Alternatively, push new commits to this PR.

We recommend that you space out your commits to avoid hitting the rate limit.

🚦 How do rate limits work?

CodeRabbit enforces hourly rate limits for each developer per organization.

Our paid plans have higher rate limits than the trial, open-source and free plans. In all cases, we re-allow further reviews after a brief timeout.

Please see our FAQ for further information.

ℹ️ Review info
⚙️ Run configuration

Configuration used: defaults

Review profile: CHILL

Plan: Pro

Run ID: 316334e3-9ad8-4cc1-9b53-e7b92af6bc6d

📥 Commits

Reviewing files that changed from the base of the PR and between be3eb3c and 39dc0a3.

📒 Files selected for processing (79)
  • PRPs/PRP-19-knowledge-and-agent-guide-pages.md
  • PRPs/PRP-20-explorer-interactivity.md
  • PRPs/PRP-21-explorer-runs-jobs-interactivity.md
  • README.md
  • app/features/agents/agents/base.py
  • app/features/agents/agents/experiment.py
  • app/features/agents/agents/rag_assistant.py
  • app/features/agents/tests/test_base.py
  • app/features/analytics/routes.py
  • app/features/analytics/schemas.py
  • app/features/analytics/service.py
  • app/features/analytics/tests/conftest.py
  • app/features/analytics/tests/test_routes_integration.py
  • app/features/analytics/tests/test_schemas.py
  • app/features/config/schemas.py
  • app/features/config/service.py
  • app/features/config/tests/test_routes.py
  • app/features/config/tests/test_schemas.py
  • app/features/config/tests/test_service.py
  • app/features/demo/pipeline.py
  • app/features/dimensions/routes.py
  • app/features/dimensions/service.py
  • app/features/dimensions/tests/conftest.py
  • app/features/dimensions/tests/test_sort.py
  • app/features/jobs/routes.py
  • app/features/jobs/service.py
  • app/features/jobs/tests/conftest.py
  • app/features/jobs/tests/test_routes.py
  • app/features/registry/routes.py
  • app/features/registry/service.py
  • app/features/registry/tests/test_routes.py
  • app/features/seeder/schemas.py
  • app/features/seeder/service.py
  • app/features/seeder/tests/test_service.py
  • app/shared/seeder/config.py
  • app/shared/seeder/tests/test_config.py
  • app/shared/seeder/tests/test_core.py
  • docs/_base/API_CONTRACTS.md
  • docs/_base/REPO_MAP_INDEX.md
  • frontend/src/App.tsx
  • frontend/src/components/charts/index.ts
  • frontend/src/components/charts/revenue-bar-chart.tsx
  • frontend/src/components/common/index.ts
  • frontend/src/components/common/json-block.tsx
  • frontend/src/components/data-table/data-table-column-header.tsx
  • frontend/src/components/data-table/data-table-view-options.tsx
  • frontend/src/components/data-table/data-table.tsx
  • frontend/src/components/data-table/index.ts
  • frontend/src/hooks/index.ts
  • frontend/src/hooks/use-jobs.ts
  • frontend/src/hooks/use-lifecycle-curve.ts
  • frontend/src/hooks/use-products.ts
  • frontend/src/hooks/use-rag-sources.ts
  • frontend/src/hooks/use-runs.ts
  • frontend/src/hooks/use-stores.ts
  • frontend/src/hooks/use-timeseries.ts
  • frontend/src/lib/constants.ts
  • frontend/src/lib/csv-export.test.ts
  • frontend/src/lib/csv-export.ts
  • frontend/src/lib/knowledge-utils.test.ts
  • frontend/src/lib/knowledge-utils.ts
  • frontend/src/pages/chat.tsx
  • frontend/src/pages/explorer/job-detail.tsx
  • frontend/src/pages/explorer/jobs.tsx
  • frontend/src/pages/explorer/product-detail.tsx
  • frontend/src/pages/explorer/products.tsx
  • frontend/src/pages/explorer/run-compare.tsx
  • frontend/src/pages/explorer/run-detail.tsx
  • frontend/src/pages/explorer/runs.tsx
  • frontend/src/pages/explorer/sales.tsx
  • frontend/src/pages/explorer/store-detail.tsx
  • frontend/src/pages/explorer/stores.tsx
  • frontend/src/pages/guide.tsx
  • frontend/src/pages/knowledge.tsx
  • frontend/src/types/api.ts
  • scripts/run_demo.py
  • scripts/seed_random.py
  • tests/test_demo_showcase_integration.py
  • tests/test_run_demo_unit.py
✨ Finishing Touches
🧪 Generate unit tests (beta)
  • Create PR with unit tests
  • Commit unit tests in branch dev

Thanks for using CodeRabbit! It's free for OSS, and your support helps us grow. If you like it, consider giving us a shout-out.

❤️ Share

Comment @coderabbitai help to get the list of available commands and usage tips.

@w7-mgfcode w7-mgfcode merged commit ae37ca5 into main May 18, 2026
12 checks passed
w7-mgfcode added a commit that referenced this pull request May 18, 2026
* feat: cut v0.2.13 — explorer interactivity, knowledge & guide pages (#191) (#192)

* feat(data): implement MarkdownGenerator age_days trigger via heuristic (#94) (#127)

Resolves #94 via the heuristic path documented in the issue. No schema
column, no Alembic migration, no FIFO cohort tracking — the trigger
self-reads the existing per-(store, product) on_hand_qty series and
fires when inventory has been "unrefreshed" past
`cfg.age_days_threshold`.

Decision rationale (schema column vs. heuristic):
- The schema column path would add `oldest_unit_age_days` to
  `inventory_snapshot_daily`, plus an Alembic migration, plus FIFO
  cohort tracking in `InventorySnapshotGenerator`. No downstream
  consumer reads this column today — adding it for one generator
  trigger violates the "don't design for hypothetical future
  requirements" rule in CLAUDE.md.
- The heuristic path is self-contained in MarkdownGenerator,
  deterministic (preserves the zero-rng-draw regression invariant),
  and additive (no migration, no model change). 354 LOC net, all
  inside one slice.

Heuristic spec:
- A "refresh" is a day where `on_hand_qty` rose by >=
  `_AGE_DAYS_SPIKE_THRESHOLD` (0.3 = 30% jump) vs the prior day.
- Age at day t = days since most recent refresh (or `dates[0]` if no
  refresh has been observed).
- Firing requires age >= `age_days_threshold` AND on_hand >=
  `markdown_min_units_remaining` — never markdown an empty shelf.
- After firing, refresh anchor resets to the day AFTER the markdown
  window ends, so back-to-back fires can't happen and the next age
  clock starts from a "clear shelf" baseline.

Wiring: `MarkdownGenerator.generate()` gains an optional kwarg
`inventory_records: list[dict[str, Any]] | None = None` which `core.py`
passes through from `InventorySnapshotGenerator`. Disabled-path and
non-age_days-path behavior is byte-identical (kwarg ignored).

Tests: +7 new in `TestAgeDaysTrigger`, -1 obsolete
`NotImplementedError` test. Coverage: no-records defensive, threshold
not-met, threshold met, spike resets age, post-fire reset avoids
back-to-back, low-inventory skip, unknown-product skip, rng
non-consumption.

Validation (local):
- ruff check + format: clean
- mypy --strict: 0 issues, 192 files
- pyright --strict: 0 errors
- pytest -m "not integration": 969 passed (+7 vs pre-PR)

Closes #94.

* feat(api,docs): e2e demo pipeline + showcase script (#128) (#129)

* docs(docs): add INITIAL-14 + PRP-15 e2e demo pipeline plan (#128)

Adds the planning documents for the end-to-end demo pipeline work tracked
in #128. Implementation commits follow on this branch.

- INITIAL-14.md: PRD for `make demo` (problem, solution, success metrics,
  open questions resolved in the PRP).
- PRPs/PRP-15-e2e-demo-pipeline.md: full execution plan (16 tasks → 6
  commits, additive only — no schema changes, no API edits).

* feat(data): add demo_minimal scenario preset (#128)

Tiny preset that powers the upcoming `make demo` target. Three stores ×
ten products × 92 days (2024-10-01..2024-12-31) — wide enough to satisfy
an expanding backtest with n_splits=3, horizon=14, min_train_size=30
(needs >= 72 days, 92 leaves margin), small enough to keep the demo
loop comfortable on a laptop.

Mirrors the retail_standard tuning (mild linear trend, noise_sigma=0.10,
modest promotion + stockout probabilities) so backtest WAPE stays
non-NaN across all three baseline models.

- app/shared/seeder/config.py: add DEMO_MINIMAL enum + from_scenario branch
- app/features/seeder/service.py: add ScenarioInfo entry in list_scenarios
- tests cover the new preset and the updated scenario count

* feat(api,docs): scripts/run_demo.py end-to-end pipeline driver (#128)

Single-file async driver that walks the published HTTP surface
(precheck -> reset? -> seed -> status -> features -> train x3 ->
backtest x3 -> register -> verify -> agent -> cleanup). Mirrors the
shape of scripts/seed_random.py and scripts/check_db.py.

- HttpClient: thin httpx.AsyncClient wrapper with explicit 60 s
  timeout (default 5 s is too short for /seeder/generate); surfaces
  RFC 7807 problem+json bodies as a typed StepError that echoes
  title / detail / request_id (never the raw body — secrets-safe).
- DemoContext + StepOutcome dataclasses thread cross-step references.
- Reporter renders the output-formatting.md glyphs (verbose by
  default, --quiet collapses to one line per step).
- Per-step error handling converts httpx + StepError into fail
  outcomes; precheck failure exits 2, any other failure exits 1,
  green exits 0.
- Agent step (10/11) skips with ⏭️ when neither OPENAI_API_KEY nor
  ANTHROPIC_API_KEY is set; reads via app.core.config.get_settings()
  to honor the no-os.environ-in-feature-code rule.
- Registry handshake uses the mandatory pending -> running -> success
  transition and the wire alias "model_config" (not "model_config_data");
  artifact_hash is computed client-side via sha256 since we share the
  FS with the API on this single-host system.
- Winner selection: lowest aggregated WAPE, skipping NaN folds.

Also adds scripts/__init__.py so tests can `import scripts.run_demo`
without invoking the file as a script.

* feat(repo): top-level Makefile with demo / demo-quick / demo-clean (#128)

Wraps scripts/run_demo.py so reviewers can run the full end-to-end
demo with one command. Recipes mirror the three modes the script
supports: full run, skip-seed iteration, destructive reset.

Make targets:
- demo        — docker compose up -d + alembic + run_demo
- demo-quick  — run_demo --skip-seed (no compose/migration touch)
- demo-clean  — full reset (--reset) before seeding
- help        — default goal; lists targets + preconditions

Tab-indented recipes and .PHONY declarations per make conventions.
Preconditions (Postgres on :5433, uvicorn on :8123) documented in
the help block; the script itself enforces them via the precheck
step and exits 2 on failure.

* test(api): unit + integration coverage for run_demo (#128)

Unit (`tests/test_run_demo_unit.py`, 32 cases):
- argparse defaults + all-flags variants
- DemoContext defaults (no leaking state across runs)
- _select_winner: lowest-WAPE, NaN-skip, all-NaN -> None, empty -> None
- _model_config_payload: discriminated-union shape per baseline; rejects
  unsupported model_type (defends the "no lightgbm in PRP-15" boundary)
- Reporter: glyph mapping; verbose + quiet output; summary green / failure
  / over-budget soft-warn branches
- StepError formats RFC 7807 (title/detail/request_id) without leaking
  the raw response body
- HttpClient (mocked httpx.AsyncClient): 2xx, 204, non-2xx -> StepError
- Step payload sanity: seed sends demo_minimal+correct dims+ISO dates;
  features sends cutoff_date as ISO; train fires three model_types in
  parallel; agent step skips with ⏭️ when no LLM key

Integration (`tests/test_e2e_demo.py`, @pytest.mark.integration):
- Skips if Postgres on :5433 isn't reachable
- Boots uvicorn on :8124 as a subprocess (avoids the dev :8123 default)
- Runs scripts/run_demo.py --reset against it; asserts exit 0 +
  canonical "runs=3 winner=... alias=demo-production" summary
- Second case asserts a bogus URL exits 2 (no silent success)
- Cleans up uvicorn on teardown with terminate/kill fallback
- Resolves `uv` via shutil.which to keep ruff S607 happy and avoid
  PATH-dependent exec at test time

* ci(repo): nightly e2e demo workflow (#128)

Adds .github/workflows/e2e-nightly.yml — runs scripts/run_demo.py
against a fresh Postgres+pgvector service every night at 07:00 UTC
(plus on-demand via workflow_dispatch). Catches regressions in the
documented end-to-end pipeline before they bleed into the per-PR
gate.

Per PRP-15 + INITIAL-14 risk note: this workflow is intentionally
NOT a required status check on dev or main. Flake-budget lives in
the nightly slot, not in ci.yml.

- pgvector/pgvector:pg16 service container (same as ci.yml `test` job)
- uvicorn started in background; /health polled with a 30 s deadline
- run_demo.py called with --seed 42 (deterministic)
- LLM-key env vars intentionally absent — agent step auto-skips via
  ⏭️, keeping the workflow self-contained
- uvicorn logs uploaded as artifact on failure (7-day retention) so
  postmortems can read what the API was doing when the script broke
- astral-sh/setup-uv pinned by 40-char SHA per security-patterns.md
- permissions: contents: read (least-privilege)

* docs(docs): cross-link make demo from README + RUNBOOKS + REPO_MAP_INDEX (#128)

Discoverability layer for PRP-15.

- README.md: new 'Try it: end-to-end demo' step right after the curl
  /health verification; shows the canonical final-line summary so
  reviewers know what green looks like.
- docs/DAILY-FLOW.md: new 'First-Run Smoke (Demo Pipeline)' section
  documenting all three Make targets.
- docs/_base/RUNBOOKS.md: new 'make demo fails at step X' Common
  Incidents entry with a 7-point diagnosis flow keyed to the script's
  step names + a postmortem-capture recipe.
- docs/_base/REPO_MAP_INDEX.md: Makefile and scripts/run_demo.py rows
  added to the Document Index table.

Pure additive; no existing content removed or renamed.

* fix(data): update /seeder/scenarios route test for demo_minimal preset (#128)

Companion to feat(data): add demo_minimal scenario preset — the
route-level assertion in TestListScenarios.test_returns_scenarios still
expected 6 scenarios; bumping to 7 and adding the demo_minimal name
membership check to match the service-layer + config-layer tests
already updated in 005c189.

* fix(api): harden run_demo for integration test + real DB (#128)

Three real failures surfaced when first running the integration test
against docker-compose Postgres + a freshly booted uvicorn; all three
are now closed:

scripts/run_demo.py:
1. step_status: discover the real (store_id, product_id) from
   /dimensions/stores + /dimensions/products instead of hardcoding 1.
   Postgres auto-increment does NOT reset after delete, so the freshly
   seeded IDs are NOT 1 (they were ~150-260 on this branch after a few
   delete/seed cycles).
2. step_register: copy the trained-model artifact into the registry's
   own root (settings.registry_artifact_root) and record a registry-
   relative URI. The registry verify endpoint resolves artifact_uri
   against its own root, which is separate from where /forecasting/train
   writes (settings.forecast_model_artifacts_dir). Pre-fix, verify
   returned 404 even though the artifact existed on disk.
3. step_agent: skip with the soft-skip glyph on any LLM provider failure
   (invalid key, model unavailable, 5xx), and make _llm_key_present
   provider-aware so it matches the right env var to the configured
   agent_default_model. Pre-fix, an .env with anthropic/openai keys but
   a Gemini default model failed hard at chat-time.
4. Bumped DEFAULT_TIMEOUT_S from 60 to 120 because /seeder/generate
   for demo_minimal can spend 60-90 s on slower laptops once you
   include inventory + prices + promotions inserts.
5. step_seed detail string: GenerateResult.records_created uses 'sales'
   (singular), not 'sales_daily'; cosmetic fix.

tests/test_e2e_demo.py:
- Redirect uvicorn stdout to a temp file rather than subprocess.PIPE.
  The seeder + structlog produce enough INFO log volume to fill a
  64-KB pipe buffer; once full, uvicorn blocks on write and seeder
  requests hang for the full --timeout. Verified locally: integration
  suite now passes in ~6.5 s instead of timing out at 120 s.
- Cleanup leaves the log file on disk only when the test failed
  (postmortem-friendly).

tests/test_run_demo_unit.py:
- Bump test_defaults timeout expectation to match the new 120 s
  default.

End-to-end manual run on this machine: 11 steps, wall_clock=2 s,
exit 0. Integration test: 2 passed in 6.48 s.

* chore(repo): bump authlib + fastmcp to clear Socket-flagged CVEs (#130) (#131)

Headline:
- authlib  1.6.6  -> 1.7.2  (clears GHSA-wvwj-cvrp-7pv5 — JWS signature
  verification bypass; patched at >= 1.6.9)
- fastmcp  2.14.4 -> 3.2.4  (clears GHSA-vv7q-7jx5-f767 — OpenAPI
  Provider SSRF + path traversal; patched at >= 3.2.0)

Both CVEs were flagged on PR #129 by Socket Security and are
pre-existing on dev (not introduced by #128).

Wider scope — read before merging:
`uv lock --upgrade-package authlib --upgrade-package fastmcp` triggers
a full re-resolve of the dependency graph. Because dev's uv.lock had
drifted from pyproject.toml (the project's constraint envelope had
loosened over time), this single command also brings the lockfile in
sync with current pyproject.toml. Net diff: 243 insertions / 369
deletions on uv.lock; no other files touched.

Transitive cascades worth flagging:
- anthropic    0.77.0 -> 0.102.0 (pydantic-ai-slim extra)
- pydantic-graph 1.51.0 -> 1.96.0
- temporalio   1.20.0 -> 1.27.2
- alembic      1.18.1 -> 1.18.4
- aws-* and cohere transitives bumped along
- griffe 1.15.0 dropped in favor of griffelib 2.0.2 (fastmcp 3.x switched)
- Removed: cloudpickle, diskcache, fakeredis, invoke, lupa, prometheus
  exporter, pydocket, redis, rsa, sortedcontainers — these were
  transitives of fastmcp 2.x that fastmcp 3.x no longer pulls in.

Verification on this host:
- uv sync --extra dev  -> green
- ruff check .         -> clean
- mypy --strict app/   -> 192 files clean
- pyright app/         -> 0 errors (50 warnings, pre-existing)
- pytest -m 'not integration' -> 969 passed

Known install quirk: griffelib 2.0.2 ships a top-level `griffe/`
package whose RECORD files don't always materialize on first install
when uv replaces an older `griffe` dist in the same sync. A clean
venv install (which CI does via `uv sync --frozen`) is unaffected;
local devs who upgrade in place may need a one-shot
`uv pip install --force-reinstall griffelib` if `import griffe` fails.

* feat(api,ui): in-product demo showcase page (#132) (#133)

* feat(api): add demo slice driving the e2e pipeline via /demo endpoints (#132)

New app/features/demo slice exposing POST /demo/run and WS /demo/stream. It
drives the published API surface in-process via httpx.ASGITransport (no
cross-slice imports, satisfying the vertical-slice rule) and streams one
StepEvent per pipeline step: precheck -> reset -> seed -> status -> features
-> train x3 -> backtest x3 -> register -> verify -> agent -> cleanup.

A module-level asyncio.Lock enforces single-flight; concurrent runs get an
RFC 7807 409. The orchestration is a faithful in-process port of
scripts/run_demo.py (PR #129). Implements PRP-17.

* test(api): cover the demo slice pipeline, routes, and e2e integration (#132)

Unit tests mock the in-process HTTP client to exercise step sequencing,
winner selection, and fail-fast; route tests cover POST /demo/run (200 +
409) and the WS /demo/stream handler. The integration test seeds
demo_minimal and asserts an end-to-end green run against real Postgres.

Implements PRP-17.

* feat(ui): add showcase page streaming the live demo pipeline (#132)

New /showcase route and nav entry. The page opens a one-shot WebSocket to
/demo/stream via a use-demo-pipeline hook (wrapping useWebSocket) and renders
the 11 pipeline steps as live status cards: glyph, detail, duration, the
backtest per-model WAPE breakdown with the winner highlighted, and a
pass/fail summary banner.

Also block-scopes a pre-existing no-case-declarations lint error in
chat.tsx so pnpm lint is green for this PR. Implements PRP-17.

* test(ui): add vitest setup and use-demo-pipeline hook coverage (#132)

Adds the frontend test stack (vitest + jsdom + @testing-library/react), a
test script, and vitest.config.ts. use-demo-pipeline.test.ts covers the
pure event reducer (idle -> running -> pass transitions, summary assembly,
error phase) and a renderHook smoke test.

The package.json pnpm.onlyBuiltDependencies entry is the RUNBOOKS-documented
fix for pnpm 11's esbuild build-script gate. Implements PRP-17.

* docs(docs): document the demo slice and showcase page (#132)

Adds the PRP-17 spec; a 'Try it in the browser' pointer in README; the
/demo/run + /demo/stream rows and a WebSocket Events section in
API_CONTRACTS; a 'Showcase pipeline fails' runbook incident; and
REPO_MAP_INDEX rows for the demo slice and showcase page.

Implements PRP-17.

* chore(repo): back-merge main into dev to absorb v0.2.10 release commits (#136) (#137)

* chore(main): release 0.2.9 (#126)

* feat: release v0.2.10 — demo showcase page + e2e pipeline (#134)

* feat(data): implement MarkdownGenerator age_days trigger via heuristic (#94) (#127)

Resolves #94 via the heuristic path documented in the issue. No schema
column, no Alembic migration, no FIFO cohort tracking — the trigger
self-reads the existing per-(store, product) on_hand_qty series and
fires when inventory has been "unrefreshed" past
`cfg.age_days_threshold`.

Decision rationale (schema column vs. heuristic):
- The schema column path would add `oldest_unit_age_days` to
  `inventory_snapshot_daily`, plus an Alembic migration, plus FIFO
  cohort tracking in `InventorySnapshotGenerator`. No downstream
  consumer reads this column today — adding it for one generator
  trigger violates the "don't design for hypothetical future
  requirements" rule in CLAUDE.md.
- The heuristic path is self-contained in MarkdownGenerator,
  deterministic (preserves the zero-rng-draw regression invariant),
  and additive (no migration, no model change). 354 LOC net, all
  inside one slice.

Heuristic spec:
- A "refresh" is a day where `on_hand_qty` rose by >=
  `_AGE_DAYS_SPIKE_THRESHOLD` (0.3 = 30% jump) vs the prior day.
- Age at day t = days since most recent refresh (or `dates[0]` if no
  refresh has been observed).
- Firing requires age >= `age_days_threshold` AND on_hand >=
  `markdown_min_units_remaining` — never markdown an empty shelf.
- After firing, refresh anchor resets to the day AFTER the markdown
  window ends, so back-to-back fires can't happen and the next age
  clock starts from a "clear shelf" baseline.

Wiring: `MarkdownGenerator.generate()` gains an optional kwarg
`inventory_records: list[dict[str, Any]] | None = None` which `core.py`
passes through from `InventorySnapshotGenerator`. Disabled-path and
non-age_days-path behavior is byte-identical (kwarg ignored).

Tests: +7 new in `TestAgeDaysTrigger`, -1 obsolete
`NotImplementedError` test. Coverage: no-records defensive, threshold
not-met, threshold met, spike resets age, post-fire reset avoids
back-to-back, low-inventory skip, unknown-product skip, rng
non-consumption.

Validation (local):
- ruff check + format: clean
- mypy --strict: 0 issues, 192 files
- pyright --strict: 0 errors
- pytest -m "not integration": 969 passed (+7 vs pre-PR)

Closes #94.

* feat(api,docs): e2e demo pipeline + showcase script (#128) (#129)

* docs(docs): add INITIAL-14 + PRP-15 e2e demo pipeline plan (#128)

Adds the planning documents for the end-to-end demo pipeline work tracked
in #128. Implementation commits follow on this branch.

- INITIAL-14.md: PRD for `make demo` (problem, solution, success metrics,
  open questions resolved in the PRP).
- PRPs/PRP-15-e2e-demo-pipeline.md: full execution plan (16 tasks → 6
  commits, additive only — no schema changes, no API edits).

* feat(data): add demo_minimal scenario preset (#128)

Tiny preset that powers the upcoming `make demo` target. Three stores ×
ten products × 92 days (2024-10-01..2024-12-31) — wide enough to satisfy
an expanding backtest with n_splits=3, horizon=14, min_train_size=30
(needs >= 72 days, 92 leaves margin), small enough to keep the demo
loop comfortable on a laptop.

Mirrors the retail_standard tuning (mild linear trend, noise_sigma=0.10,
modest promotion + stockout probabilities) so backtest WAPE stays
non-NaN across all three baseline models.

- app/shared/seeder/config.py: add DEMO_MINIMAL enum + from_scenario branch
- app/features/seeder/service.py: add ScenarioInfo entry in list_scenarios
- tests cover the new preset and the updated scenario count

* feat(api,docs): scripts/run_demo.py end-to-end pipeline driver (#128)

Single-file async driver that walks the published HTTP surface
(precheck -> reset? -> seed -> status -> features -> train x3 ->
backtest x3 -> register -> verify -> agent -> cleanup). Mirrors the
shape of scripts/seed_random.py and scripts/check_db.py.

- HttpClient: thin httpx.AsyncClient wrapper with explicit 60 s
  timeout (default 5 s is too short for /seeder/generate); surfaces
  RFC 7807 problem+json bodies as a typed StepError that echoes
  title / detail / request_id (never the raw body — secrets-safe).
- DemoContext + StepOutcome dataclasses thread cross-step references.
- Reporter renders the output-formatting.md glyphs (verbose by
  default, --quiet collapses to one line per step).
- Per-step error handling converts httpx + StepError into fail
  outcomes; precheck failure exits 2, any other failure exits 1,
  green exits 0.
- Agent step (10/11) skips with ⏭️ when neither OPENAI_API_KEY nor
  ANTHROPIC_API_KEY is set; reads via app.core.config.get_settings()
  to honor the no-os.environ-in-feature-code rule.
- Registry handshake uses the mandatory pending -> running -> success
  transition and the wire alias "model_config" (not "model_config_data");
  artifact_hash is computed client-side via sha256 since we share the
  FS with the API on this single-host system.
- Winner selection: lowest aggregated WAPE, skipping NaN folds.

Also adds scripts/__init__.py so tests can `import scripts.run_demo`
without invoking the file as a script.

* feat(repo): top-level Makefile with demo / demo-quick / demo-clean (#128)

Wraps scripts/run_demo.py so reviewers can run the full end-to-end
demo with one command. Recipes mirror the three modes the script
supports: full run, skip-seed iteration, destructive reset.

Make targets:
- demo        — docker compose up -d + alembic + run_demo
- demo-quick  — run_demo --skip-seed (no compose/migration touch)
- demo-clean  — full reset (--reset) before seeding
- help        — default goal; lists targets + preconditions

Tab-indented recipes and .PHONY declarations per make conventions.
Preconditions (Postgres on :5433, uvicorn on :8123) documented in
the help block; the script itself enforces them via the precheck
step and exits 2 on failure.

* test(api): unit + integration coverage for run_demo (#128)

Unit (`tests/test_run_demo_unit.py`, 32 cases):
- argparse defaults + all-flags variants
- DemoContext defaults (no leaking state across runs)
- _select_winner: lowest-WAPE, NaN-skip, all-NaN -> None, empty -> None
- _model_config_payload: discriminated-union shape per baseline; rejects
  unsupported model_type (defends the "no lightgbm in PRP-15" boundary)
- Reporter: glyph mapping; verbose + quiet output; summary green / failure
  / over-budget soft-warn branches
- StepError formats RFC 7807 (title/detail/request_id) without leaking
  the raw response body
- HttpClient (mocked httpx.AsyncClient): 2xx, 204, non-2xx -> StepError
- Step payload sanity: seed sends demo_minimal+correct dims+ISO dates;
  features sends cutoff_date as ISO; train fires three model_types in
  parallel; agent step skips with ⏭️ when no LLM key

Integration (`tests/test_e2e_demo.py`, @pytest.mark.integration):
- Skips if Postgres on :5433 isn't reachable
- Boots uvicorn on :8124 as a subprocess (avoids the dev :8123 default)
- Runs scripts/run_demo.py --reset against it; asserts exit 0 +
  canonical "runs=3 winner=... alias=demo-production" summary
- Second case asserts a bogus URL exits 2 (no silent success)
- Cleans up uvicorn on teardown with terminate/kill fallback
- Resolves `uv` via shutil.which to keep ruff S607 happy and avoid
  PATH-dependent exec at test time

* ci(repo): nightly e2e demo workflow (#128)

Adds .github/workflows/e2e-nightly.yml — runs scripts/run_demo.py
against a fresh Postgres+pgvector service every night at 07:00 UTC
(plus on-demand via workflow_dispatch). Catches regressions in the
documented end-to-end pipeline before they bleed into the per-PR
gate.

Per PRP-15 + INITIAL-14 risk note: this workflow is intentionally
NOT a required status check on dev or main. Flake-budget lives in
the nightly slot, not in ci.yml.

- pgvector/pgvector:pg16 service container (same as ci.yml `test` job)
- uvicorn started in background; /health polled with a 30 s deadline
- run_demo.py called with --seed 42 (deterministic)
- LLM-key env vars intentionally absent — agent step auto-skips via
  ⏭️, keeping the workflow self-contained
- uvicorn logs uploaded as artifact on failure (7-day retention) so
  postmortems can read what the API was doing when the script broke
- astral-sh/setup-uv pinned by 40-char SHA per security-patterns.md
- permissions: contents: read (least-privilege)

* docs(docs): cross-link make demo from README + RUNBOOKS + REPO_MAP_INDEX (#128)

Discoverability layer for PRP-15.

- README.md: new 'Try it: end-to-end demo' step right after the curl
  /health verification; shows the canonical final-line summary so
  reviewers know what green looks like.
- docs/DAILY-FLOW.md: new 'First-Run Smoke (Demo Pipeline)' section
  documenting all three Make targets.
- docs/_base/RUNBOOKS.md: new 'make demo fails at step X' Common
  Incidents entry with a 7-point diagnosis flow keyed to the script's
  step names + a postmortem-capture recipe.
- docs/_base/REPO_MAP_INDEX.md: Makefile and scripts/run_demo.py rows
  added to the Document Index table.

Pure additive; no existing content removed or renamed.

* fix(data): update /seeder/scenarios route test for demo_minimal preset (#128)

Companion to feat(data): add demo_minimal scenario preset — the
route-level assertion in TestListScenarios.test_returns_scenarios still
expected 6 scenarios; bumping to 7 and adding the demo_minimal name
membership check to match the service-layer + config-layer tests
already updated in 005c189.

* fix(api): harden run_demo for integration test + real DB (#128)

Three real failures surfaced when first running the integration test
against docker-compose Postgres + a freshly booted uvicorn; all three
are now closed:

scripts/run_demo.py:
1. step_status: discover the real (store_id, product_id) from
   /dimensions/stores + /dimensions/products instead of hardcoding 1.
   Postgres auto-increment does NOT reset after delete, so the freshly
   seeded IDs are NOT 1 (they were ~150-260 on this branch after a few
   delete/seed cycles).
2. step_register: copy the trained-model artifact into the registry's
   own root (settings.registry_artifact_root) and record a registry-
   relative URI. The registry verify endpoint resolves artifact_uri
   against its own root, which is separate from where /forecasting/train
   writes (settings.forecast_model_artifacts_dir). Pre-fix, verify
   returned 404 even though the artifact existed on disk.
3. step_agent: skip with the soft-skip glyph on any LLM provider failure
   (invalid key, model unavailable, 5xx), and make _llm_key_present
   provider-aware so it matches the right env var to the configured
   agent_default_model. Pre-fix, an .env with anthropic/openai keys but
   a Gemini default model failed hard at chat-time.
4. Bumped DEFAULT_TIMEOUT_S from 60 to 120 because /seeder/generate
   for demo_minimal can spend 60-90 s on slower laptops once you
   include inventory + prices + promotions inserts.
5. step_seed detail string: GenerateResult.records_created uses 'sales'
   (singular), not 'sales_daily'; cosmetic fix.

tests/test_e2e_demo.py:
- Redirect uvicorn stdout to a temp file rather than subprocess.PIPE.
  The seeder + structlog produce enough INFO log volume to fill a
  64-KB pipe buffer; once full, uvicorn blocks on write and seeder
  requests hang for the full --timeout. Verified locally: integration
  suite now passes in ~6.5 s instead of timing out at 120 s.
- Cleanup leaves the log file on disk only when the test failed
  (postmortem-friendly).

tests/test_run_demo_unit.py:
- Bump test_defaults timeout expectation to match the new 120 s
  default.

End-to-end manual run on this machine: 11 steps, wall_clock=2 s,
exit 0. Integration test: 2 passed in 6.48 s.

* chore(repo): bump authlib + fastmcp to clear Socket-flagged CVEs (#130) (#131)

Headline:
- authlib  1.6.6  -> 1.7.2  (clears GHSA-wvwj-cvrp-7pv5 — JWS signature
  verification bypass; patched at >= 1.6.9)
- fastmcp  2.14.4 -> 3.2.4  (clears GHSA-vv7q-7jx5-f767 — OpenAPI
  Provider SSRF + path traversal; patched at >= 3.2.0)

Both CVEs were flagged on PR #129 by Socket Security and are
pre-existing on dev (not introduced by #128).

Wider scope — read before merging:
`uv lock --upgrade-package authlib --upgrade-package fastmcp` triggers
a full re-resolve of the dependency graph. Because dev's uv.lock had
drifted from pyproject.toml (the project's constraint envelope had
loosened over time), this single command also brings the lockfile in
sync with current pyproject.toml. Net diff: 243 insertions / 369
deletions on uv.lock; no other files touched.

Transitive cascades worth flagging:
- anthropic    0.77.0 -> 0.102.0 (pydantic-ai-slim extra)
- pydantic-graph 1.51.0 -> 1.96.0
- temporalio   1.20.0 -> 1.27.2
- alembic      1.18.1 -> 1.18.4
- aws-* and cohere transitives bumped along
- griffe 1.15.0 dropped in favor of griffelib 2.0.2 (fastmcp 3.x switched)
- Removed: cloudpickle, diskcache, fakeredis, invoke, lupa, prometheus
  exporter, pydocket, redis, rsa, sortedcontainers — these were
  transitives of fastmcp 2.x that fastmcp 3.x no longer pulls in.

Verification on this host:
- uv sync --extra dev  -> green
- ruff check .         -> clean
- mypy --strict app/   -> 192 files clean
- pyright app/         -> 0 errors (50 warnings, pre-existing)
- pytest -m 'not integration' -> 969 passed

Known install quirk: griffelib 2.0.2 ships a top-level `griffe/`
package whose RECORD files don't always materialize on first install
when uv replaces an older `griffe` dist in the same sync. A clean
venv install (which CI does via `uv sync --frozen`) is unaffected;
local devs who upgrade in place may need a one-shot
`uv pip install --force-reinstall griffelib` if `import griffe` fails.

* feat(api,ui): in-product demo showcase page (#132) (#133)

* feat(api): add demo slice driving the e2e pipeline via /demo endpoints (#132)

New app/features/demo slice exposing POST /demo/run and WS /demo/stream. It
drives the published API surface in-process via httpx.ASGITransport (no
cross-slice imports, satisfying the vertical-slice rule) and streams one
StepEvent per pipeline step: precheck -> reset -> seed -> status -> features
-> train x3 -> backtest x3 -> register -> verify -> agent -> cleanup.

A module-level asyncio.Lock enforces single-flight; concurrent runs get an
RFC 7807 409. The orchestration is a faithful in-process port of
scripts/run_demo.py (PR #129). Implements PRP-17.

* test(api): cover the demo slice pipeline, routes, and e2e integration (#132)

Unit tests mock the in-process HTTP client to exercise step sequencing,
winner selection, and fail-fast; route tests cover POST /demo/run (200 +
409) and the WS /demo/stream handler. The integration test seeds
demo_minimal and asserts an end-to-end green run against real Postgres.

Implements PRP-17.

* feat(ui): add showcase page streaming the live demo pipeline (#132)

New /showcase route and nav entry. The page opens a one-shot WebSocket to
/demo/stream via a use-demo-pipeline hook (wrapping useWebSocket) and renders
the 11 pipeline steps as live status cards: glyph, detail, duration, the
backtest per-model WAPE breakdown with the winner highlighted, and a
pass/fail summary banner.

Also block-scopes a pre-existing no-case-declarations lint error in
chat.tsx so pnpm lint is green for this PR. Implements PRP-17.

* test(ui): add vitest setup and use-demo-pipeline hook coverage (#132)

Adds the frontend test stack (vitest + jsdom + @testing-library/react), a
test script, and vitest.config.ts. use-demo-pipeline.test.ts covers the
pure event reducer (idle -> running -> pass transitions, summary assembly,
error phase) and a renderHook smoke test.

The package.json pnpm.onlyBuiltDependencies entry is the RUNBOOKS-documented
fix for pnpm 11's esbuild build-script gate. Implements PRP-17.

* docs(docs): document the demo slice and showcase page (#132)

Adds the PRP-17 spec; a 'Try it in the browser' pointer in README; the
/demo/run + /demo/stream rows and a WebSocket Events section in
API_CONTRACTS; a 'Showcase pipeline fails' runbook incident; and
REPO_MAP_INDEX rows for the demo slice and showcase page.

Implements PRP-17.

* chore(main): release 0.2.10 (#135)

* docs(docs): fix broken PRP-0/INITIAL-0 relative links in phase 0 doc (#138) (#139)

* docs(repo): fix readme dev-deps command and stale .github template placeholders (#140) (#141)

* docs(docs): fill DEV_GUIDE.md onboarding stub sections (#142) (#143)

* docs(repo): refresh stale CLAUDE.md note, document /demo API, align PR template (#144) (#145)

* fix(ui): chart series render black — drop hsl() wrapper on oklch chart vars (#149) (#153)

index.css defines --chart-N twice: legacy shadcn-v3 HSL triplets and
Tailwind-4 / shadcn-v4 complete oklch() colours. The oklch definitions win
the cascade, so at runtime --chart-N is a full colour. The chart components
still wrapped it as hsl(var(--chart-N)) → hsl(oklch(...)), which is invalid
CSS, so recharts fell back to a black fill/stroke — invisible on the dark
theme.

Reference var(--chart-N) directly in backtest-folds-chart.tsx and
time-series-chart.tsx. Verified in a browser: the backtest per-fold bars
and the forecast line now render in colour.

* fix(jobs): backtest job result keeps fold metrics, stability and baselines (#148) (#152)

* fix(jobs): backtest job result keeps fold metrics, stability and baselines (#148)

_execute_backtest ran BacktestingService.run_backtest — which computes
per-fold metrics, stability indices and a naive/seasonal baseline comparison
— but stored only four aggregated values and discarded the rest. The
dashboard (/visualize/backtest) reads aggregated_metrics.{*_mean,
stability_index}, fold_metrics[] and baseline_comparison, so it showed
"0 folds", all-zero metrics and an empty chart.

Add _shape_backtest_result(), which flattens a BacktestResponse into the
contract the dashboard expects, and _finite(), which coerces NaN/inf to 0.0
so the result stays JSONB-safe (stability is NaN with fewer than two folds).

Add app/features/jobs/tests/test_service.py with unit coverage for the
shaping logic: fold metrics, *_mean keys, stability, baseline comparison,
the no-baselines path, and NaN coercion.

* refactor(jobs): centralize backtest metric keys and surface drift (#148)

Addresses review feedback on PR #152.

- Hoist the dashboard's metric set into _BACKTEST_METRICS and the headline
  stability metric into _STABILITY_METRIC, so the hardcoded keys live in one
  documented place instead of being repeated across the shaping logic.
- Log jobs.backtest_metrics_missing when an expected metric is absent from the
  backtest response, so a future rename in the backtesting service fails loud
  instead of silently emitting 0.0.
- Document the WAPE stability convention in the _shape_backtest_result docstring.
- Tests: assert backtest_id / model_type / duration_ms pass through unchanged,
  and add a regression test for the missing-metric default path.

* fix(ui): forecast page reads forecasts/forecast from predict job result (#147) (#151)

The /visualize/forecast page never rendered the chart for a valid completed
predict job. It read job.result.predictions with field `predicted`, but
POST /jobs (job_type="predict") returns job.result.forecasts with field
`forecast`. forecastData was therefore always undefined and the page fell
through to "No prediction data available in job result".

Read result.forecasts with field `forecast`, and pass predictedKey="forecast"
to TimeSeriesChart (which already supports a configurable data key).

Verified in a browser: entering a completed predict job ID now renders the
14-day forecast line chart with correct tooltip values.

* fix(registry): tolerate multiple matches in _find_duplicate (#146) (#150)

Under the default registry_duplicate_policy="detect", duplicate runs are
created intentionally, so multiple non-archived model_run rows can share one
config hash. _find_duplicate used scalar_one_or_none(), which raised
MultipleResultsFound once two duplicates existed — POST /registry/runs then
returned HTTP 500. This made the demo/Showcase register step fail
deterministically on any DB with repeated runs.

Order the lookup by created_at desc, LIMIT 1, and use scalars().first() so it
returns the most recent matching run instead of asserting a single match.

Add an integration regression test that POSTs an identical run three times
under the detect policy and asserts all three return 201.

* fix(ui): derive TimeSeriesChart line stroke from the config key (#156) (#157)

TimeSeriesChart builds chartConfig with dynamic keys ([actualKey] /
[predictedKey]), so shadcn's ChartContainer injects --color-<key> CSS
variables. The <Line> elements, however, hardcoded stroke="var(--color-actual)"
and stroke="var(--color-predicted)". The forecast page passes
predictedKey="forecast", so the injected variable is --color-forecast;
var(--color-predicted) was undefined, the stroke was invalid, and SVG fell
back to its initial value `none` — the forecast line was invisible.

Build the stroke from the key: stroke={`var(--color-${actualKey})`} /
stroke={`var(--color-${predictedKey})`}.

Verified in a browser: the forecast line now renders in colour.

* feat(ui): job picker dropdown on forecast and backtest pages (#154) (#155)

The visualization pages only accepted a job ID typed into a text box, so
users had to already know the ID. Add a JobPicker component: a dropdown of
completed jobs of the relevant type (predict / backtest), newest first, with
each option labelled by short id, model and timestamp.

- New shared component src/components/common/job-picker.tsx, used by both
  forecast.tsx and backtest.tsx.
- The manual job-ID input stays alongside the dropdown for pasting an ID.
- The most recent completed job auto-loads on mount so a chart shows
  immediately without interaction.

No backend change — GET /jobs?job_type=&status=completed already exists.
Verified in a browser on both pages.

* chore(repo): back-merge main into dev after v0.2.11 (#160) (#161)

* chore(main): release 0.2.9 (#126)

* feat: release v0.2.10 — demo showcase page + e2e pipeline (#134)

* feat(data): implement MarkdownGenerator age_days trigger via heuristic (#94) (#127)

Resolves #94 via the heuristic path documented in the issue. No schema
column, no Alembic migration, no FIFO cohort tracking — the trigger
self-reads the existing per-(store, product) on_hand_qty series and
fires when inventory has been "unrefreshed" past
`cfg.age_days_threshold`.

Decision rationale (schema column vs. heuristic):
- The schema column path would add `oldest_unit_age_days` to
  `inventory_snapshot_daily`, plus an Alembic migration, plus FIFO
  cohort tracking in `InventorySnapshotGenerator`. No downstream
  consumer reads this column today — adding it for one generator
  trigger violates the "don't design for hypothetical future
  requirements" rule in CLAUDE.md.
- The heuristic path is self-contained in MarkdownGenerator,
  deterministic (preserves the zero-rng-draw regression invariant),
  and additive (no migration, no model change). 354 LOC net, all
  inside one slice.

Heuristic spec:
- A "refresh" is a day where `on_hand_qty` rose by >=
  `_AGE_DAYS_SPIKE_THRESHOLD` (0.3 = 30% jump) vs the prior day.
- Age at day t = days since most recent refresh (or `dates[0]` if no
  refresh has been observed).
- Firing requires age >= `age_days_threshold` AND on_hand >=
  `markdown_min_units_remaining` — never markdown an empty shelf.
- After firing, refresh anchor resets to the day AFTER the markdown
  window ends, so back-to-back fires can't happen and the next age
  clock starts from a "clear shelf" baseline.

Wiring: `MarkdownGenerator.generate()` gains an optional kwarg
`inventory_records: list[dict[str, Any]] | None = None` which `core.py`
passes through from `InventorySnapshotGenerator`. Disabled-path and
non-age_days-path behavior is byte-identical (kwarg ignored).

Tests: +7 new in `TestAgeDaysTrigger`, -1 obsolete
`NotImplementedError` test. Coverage: no-records defensive, threshold
not-met, threshold met, spike resets age, post-fire reset avoids
back-to-back, low-inventory skip, unknown-product skip, rng
non-consumption.

Validation (local):
- ruff check + format: clean
- mypy --strict: 0 issues, 192 files
- pyright --strict: 0 errors
- pytest -m "not integration": 969 passed (+7 vs pre-PR)

Closes #94.

* feat(api,docs): e2e demo pipeline + showcase script (#128) (#129)

* docs(docs): add INITIAL-14 + PRP-15 e2e demo pipeline plan (#128)

Adds the planning documents for the end-to-end demo pipeline work tracked
in #128. Implementation commits follow on this branch.

- INITIAL-14.md: PRD for `make demo` (problem, solution, success metrics,
  open questions resolved in the PRP).
- PRPs/PRP-15-e2e-demo-pipeline.md: full execution plan (16 tasks → 6
  commits, additive only — no schema changes, no API edits).

* feat(data): add demo_minimal scenario preset (#128)

Tiny preset that powers the upcoming `make demo` target. Three stores ×
ten products × 92 days (2024-10-01..2024-12-31) — wide enough to satisfy
an expanding backtest with n_splits=3, horizon=14, min_train_size=30
(needs >= 72 days, 92 leaves margin), small enough to keep the demo
loop comfortable on a laptop.

Mirrors the retail_standard tuning (mild linear trend, noise_sigma=0.10,
modest promotion + stockout probabilities) so backtest WAPE stays
non-NaN across all three baseline models.

- app/shared/seeder/config.py: add DEMO_MINIMAL enum + from_scenario branch
- app/features/seeder/service.py: add ScenarioInfo entry in list_scenarios
- tests cover the new preset and the updated scenario count

* feat(api,docs): scripts/run_demo.py end-to-end pipeline driver (#128)

Single-file async driver that walks the published HTTP surface
(precheck -> reset? -> seed -> status -> features -> train x3 ->
backtest x3 -> register -> verify -> agent -> cleanup). Mirrors the
shape of scripts/seed_random.py and scripts/check_db.py.

- HttpClient: thin httpx.AsyncClient wrapper with explicit 60 s
  timeout (default 5 s is too short for /seeder/generate); surfaces
  RFC 7807 problem+json bodies as a typed StepError that echoes
  title / detail / request_id (never the raw body — secrets-safe).
- DemoContext + StepOutcome dataclasses thread cross-step references.
- Reporter renders the output-formatting.md glyphs (verbose by
  default, --quiet collapses to one line per step).
- Per-step error handling converts httpx + StepError into fail
  outcomes; precheck failure exits 2, any other failure exits 1,
  green exits 0.
- Agent step (10/11) skips with ⏭️ when neither OPENAI_API_KEY nor
  ANTHROPIC_API_KEY is set; reads via app.core.config.get_settings()
  to honor the no-os.environ-in-feature-code rule.
- Registry handshake uses the mandatory pending -> running -> success
  transition and the wire alias "model_config" (not "model_config_data");
  artifact_hash is computed client-side via sha256 since we share the
  FS with the API on this single-host system.
- Winner selection: lowest aggregated WAPE, skipping NaN folds.

Also adds scripts/__init__.py so tests can `import scripts.run_demo`
without invoking the file as a script.

* feat(repo): top-level Makefile with demo / demo-quick / demo-clean (#128)

Wraps scripts/run_demo.py so reviewers can run the full end-to-end
demo with one command. Recipes mirror the three modes the script
supports: full run, skip-seed iteration, destructive reset.

Make targets:
- demo        — docker compose up -d + alembic + run_demo
- demo-quick  — run_demo --skip-seed (no compose/migration touch)
- demo-clean  — full reset (--reset) before seeding
- help        — default goal; lists targets + preconditions

Tab-indented recipes and .PHONY declarations per make conventions.
Preconditions (Postgres on :5433, uvicorn on :8123) documented in
the help block; the script itself enforces them via the precheck
step and exits 2 on failure.

* test(api): unit + integration coverage for run_demo (#128)

Unit (`tests/test_run_demo_unit.py`, 32 cases):
- argparse defaults + all-flags variants
- DemoContext defaults (no leaking state across runs)
- _select_winner: lowest-WAPE, NaN-skip, all-NaN -> None, empty -> None
- _model_config_payload: discriminated-union shape per baseline; rejects
  unsupported model_type (defends the "no lightgbm in PRP-15" boundary)
- Reporter: glyph mapping; verbose + quiet output; summary green / failure
  / over-budget soft-warn branches
- StepError formats RFC 7807 (title/detail/request_id) without leaking
  the raw response body
- HttpClient (mocked httpx.AsyncClient): 2xx, 204, non-2xx -> StepError
- Step payload sanity: seed sends demo_minimal+correct dims+ISO dates;
  features sends cutoff_date as ISO; train fires three model_types in
  parallel; agent step skips with ⏭️ when no LLM key

Integration (`tests/test_e2e_demo.py`, @pytest.mark.integration):
- Skips if Postgres on :5433 isn't reachable
- Boots uvicorn on :8124 as a subprocess (avoids the dev :8123 default)
- Runs scripts/run_demo.py --reset against it; asserts exit 0 +
  canonical "runs=3 winner=... alias=demo-production" summary
- Second case asserts a bogus URL exits 2 (no silent success)
- Cleans up uvicorn on teardown with terminate/kill fallback
- Resolves `uv` via shutil.which to keep ruff S607 happy and avoid
  PATH-dependent exec at test time

* ci(repo): nightly e2e demo workflow (#128)

Adds .github/workflows/e2e-nightly.yml — runs scripts/run_demo.py
against a fresh Postgres+pgvector service every night at 07:00 UTC
(plus on-demand via workflow_dispatch). Catches regressions in the
documented end-to-end pipeline before they bleed into the per-PR
gate.

Per PRP-15 + INITIAL-14 risk note: this workflow is intentionally
NOT a required status check on dev or main. Flake-budget lives in
the nightly slot, not in ci.yml.

- pgvector/pgvector:pg16 service container (same as ci.yml `test` job)
- uvicorn started in background; /health polled with a 30 s deadline
- run_demo.py called with --seed 42 (deterministic)
- LLM-key env vars intentionally absent — agent step auto-skips via
  ⏭️, keeping the workflow self-contained
- uvicorn logs uploaded as artifact on failure (7-day retention) so
  postmortems can read what the API was doing when the script broke
- astral-sh/setup-uv pinned by 40-char SHA per security-patterns.md
- permissions: contents: read (least-privilege)

* docs(docs): cross-link make demo from README + RUNBOOKS + REPO_MAP_INDEX (#128)

Discoverability layer for PRP-15.

- README.md: new 'Try it: end-to-end demo' step right after the curl
  /health verification; shows the canonical final-line summary so
  reviewers know what green looks like.
- docs/DAILY-FLOW.md: new 'First-Run Smoke (Demo Pipeline)' section
  documenting all three Make targets.
- docs/_base/RUNBOOKS.md: new 'make demo fails at step X' Common
  Incidents entry with a 7-point diagnosis flow keyed to the script's
  step names + a postmortem-capture recipe.
- docs/_base/REPO_MAP_INDEX.md: Makefile and scripts/run_demo.py rows
  added to the Document Index table.

Pure additive; no existing content removed or renamed.

* fix(data): update /seeder/scenarios route test for demo_minimal preset (#128)

Companion to feat(data): add demo_minimal scenario preset — the
route-level assertion in TestListScenarios.test_returns_scenarios still
expected 6 scenarios; bumping to 7 and adding the demo_minimal name
membership check to match the service-layer + config-layer tests
already updated in 005c189.

* fix(api): harden run_demo for integration test + real DB (#128)

Three real failures surfaced when first running the integration test
against docker-compose Postgres + a freshly booted uvicorn; all three
are now closed:

scripts/run_demo.py:
1. step_status: discover the real (store_id, product_id) from
   /dimensions/stores + /dimensions/products instead of hardcoding 1.
   Postgres auto-increment does NOT reset after delete, so the freshly
   seeded IDs are NOT 1 (they were ~150-260 on this branch after a few
   delete/seed cycles).
2. step_register: copy the trained-model artifact into the registry's
   own root (settings.registry_artifact_root) and record a registry-
   relative URI. The registry verify endpoint resolves artifact_uri
   against its own root, which is separate from where /forecasting/train
   writes (settings.forecast_model_artifacts_dir). Pre-fix, verify
   returned 404 even though the artifact existed on disk.
3. step_agent: skip with the soft-skip glyph on any LLM provider failure
   (invalid key, model unavailable, 5xx), and make _llm_key_present
   provider-aware so it matches the right env var to the configured
   agent_default_model. Pre-fix, an .env with anthropic/openai keys but
   a Gemini default model failed hard at chat-time.
4. Bumped DEFAULT_TIMEOUT_S from 60 to 120 because /seeder/generate
   for demo_minimal can spend 60-90 s on slower laptops once you
   include inventory + prices + promotions inserts.
5. step_seed detail string: GenerateResult.records_created uses 'sales'
   (singular), not 'sales_daily'; cosmetic fix.

tests/test_e2e_demo.py:
- Redirect uvicorn stdout to a temp file rather than subprocess.PIPE.
  The seeder + structlog produce enough INFO log volume to fill a
  64-KB pipe buffer; once full, uvicorn blocks on write and seeder
  requests hang for the full --timeout. Verified locally: integration
  suite now passes in ~6.5 s instead of timing out at 120 s.
- Cleanup leaves the log file on disk only when the test failed
  (postmortem-friendly).

tests/test_run_demo_unit.py:
- Bump test_defaults timeout expectation to match the new 120 s
  default.

End-to-end manual run on this machine: 11 steps, wall_clock=2 s,
exit 0. Integration test: 2 passed in 6.48 s.

* chore(repo): bump authlib + fastmcp to clear Socket-flagged CVEs (#130) (#131)

Headline:
- authlib  1.6.6  -> 1.7.2  (clears GHSA-wvwj-cvrp-7pv5 — JWS signature
  verification bypass; patched at >= 1.6.9)
- fastmcp  2.14.4 -> 3.2.4  (clears GHSA-vv7q-7jx5-f767 — OpenAPI
  Provider SSRF + path traversal; patched at >= 3.2.0)

Both CVEs were flagged on PR #129 by Socket Security and are
pre-existing on dev (not introduced by #128).

Wider scope — read before merging:
`uv lock --upgrade-package authlib --upgrade-package fastmcp` triggers
a full re-resolve of the dependency graph. Because dev's uv.lock had
drifted from pyproject.toml (the project's constraint envelope had
loosened over time), this single command also brings the lockfile in
sync with current pyproject.toml. Net diff: 243 insertions / 369
deletions on uv.lock; no other files touched.

Transitive cascades worth flagging:
- anthropic    0.77.0 -> 0.102.0 (pydantic-ai-slim extra)
- pydantic-graph 1.51.0 -> 1.96.0
- temporalio   1.20.0 -> 1.27.2
- alembic      1.18.1 -> 1.18.4
- aws-* and cohere transitives bumped along
- griffe 1.15.0 dropped in favor of griffelib 2.0.2 (fastmcp 3.x switched)
- Removed: cloudpickle, diskcache, fakeredis, invoke, lupa, prometheus
  exporter, pydocket, redis, rsa, sortedcontainers — these were
  transitives of fastmcp 2.x that fastmcp 3.x no longer pulls in.

Verification on this host:
- uv sync --extra dev  -> green
- ruff check .         -> clean
- mypy --strict app/   -> 192 files clean
- pyright app/         -> 0 errors (50 warnings, pre-existing)
- pytest -m 'not integration' -> 969 passed

Known install quirk: griffelib 2.0.2 ships a top-level `griffe/`
package whose RECORD files don't always materialize on first install
when uv replaces an older `griffe` dist in the same sync. A clean
venv install (which CI does via `uv sync --frozen`) is unaffected;
local devs who upgrade in place may need a one-shot
`uv pip install --force-reinstall griffelib` if `import griffe` fails.

* feat(api,ui): in-product demo showcase page (#132) (#133)

* feat(api): add demo slice driving the e2e pipeline via /demo endpoints (#132)

New app/features/demo slice exposing POST /demo/run and WS /demo/stream. It
drives the published API surface in-process via httpx.ASGITransport (no
cross-slice imports, satisfying the vertical-slice rule) and streams one
StepEvent per pipeline step: precheck -> reset -> seed -> status -> features
-> train x3 -> backtest x3 -> register -> verify -> agent -> cleanup.

A module-level asyncio.Lock enforces single-flight; concurrent runs get an
RFC 7807 409. The orchestration is a faithful in-process port of
scripts/run_demo.py (PR #129). Implements PRP-17.

* test(api): cover the demo slice pipeline, routes, and e2e integration (#132)

Unit tests mock the in-process HTTP client to exercise step sequencing,
winner selection, and fail-fast; route tests cover POST /demo/run (200 +
409) and the WS /demo/stream handler. The integration test seeds
demo_minimal and asserts an end-to-end green run against real Postgres.

Implements PRP-17.

* feat(ui): add showcase page streaming the live demo pipeline (#132)

New /showcase route and nav entry. The page opens a one-shot WebSocket to
/demo/stream via a use-demo-pipeline hook (wrapping useWebSocket) and renders
the 11 pipeline steps as live status cards: glyph, detail, duration, the
backtest per-model WAPE breakdown with the winner highlighted, and a
pass/fail summary banner.

Also block-scopes a pre-existing no-case-declarations lint error in
chat.tsx so pnpm lint is green for this PR. Implements PRP-17.

* test(ui): add vitest setup and use-demo-pipeline hook coverage (#132)

Adds the frontend test stack (vitest + jsdom + @testing-library/react), a
test script, and vitest.config.ts. use-demo-pipeline.test.ts covers the
pure event reducer (idle -> running -> pass transitions, summary assembly,
error phase) and a renderHook smoke test.

The package.json pnpm.onlyBuiltDependencies entry is the RUNBOOKS-documented
fix for pnpm 11's esbuild build-script gate. Implements PRP-17.

* docs(docs): document the demo slice and showcase page (#132)

Adds the PRP-17 spec; a 'Try it in the browser' pointer in README; the
/demo/run + /demo/stream rows and a WebSocket Events section in
API_CONTRACTS; a 'Showcase pipeline fails' runbook incident; and
REPO_MAP_INDEX rows for the demo slice and showcase page.

Implements PRP-17.

* chore(main): release 0.2.10 (#135)

* feat: release v0.2.11 — visualization fixes, job picker, demo showcase (#158)

* feat(data): implement MarkdownGenerator age_days trigger via heuristic (#94) (#127)

Resolves #94 via the heuristic path documented in the issue. No schema
column, no Alembic migration, no FIFO cohort tracking — the trigger
self-reads the existing per-(store, product) on_hand_qty series and
fires when inventory has been "unrefreshed" past
`cfg.age_days_threshold`.

Decision rationale (schema column vs. heuristic):
- The schema column path would add `oldest_unit_age_days` to
  `inventory_snapshot_daily`, plus an Alembic migration, plus FIFO
  cohort tracking in `InventorySnapshotGenerator`. No downstream
  consumer reads this column today — adding it for one generator
  trigger violates the "don't design for hypothetical future
  requirements" rule in CLAUDE.md.
- The heuristic path is self-contained in MarkdownGenerator,
  deterministic (preserves the zero-rng-draw regression invariant),
  and additive (no migration, no model change). 354 LOC net, all
  inside one slice.

Heuristic spec:
- A "refresh" is a day where `on_hand_qty` rose by >=
  `_AGE_DAYS_SPIKE_THRESHOLD` (0.3 = 30% jump) vs the prior day.
- Age at day t = days since most recent refresh (or `dates[0]` if no
  refresh has been observed).
- Firing requires age >= `age_days_threshold` AND on_hand >=
  `markdown_min_units_remaining` — never markdown an empty shelf.
- After firing, refresh anchor resets to the day AFTER the markdown
  window ends, so back-to-back fires can't happen and the next age
  clock starts from a "clear shelf" baseline.

Wiring: `MarkdownGenerator.generate()` gains an optional kwarg
`inventory_records: list[dict[str, Any]] | None = None` which `core.py`
passes through from `InventorySnapshotGenerator`. Disabled-path and
non-age_days-path behavior is byte-identical (kwarg ignored).

Tests: +7 new in `TestAgeDaysTrigger`, -1 obsolete
`NotImplementedError` test. Coverage: no-records defensive, threshold
not-met, threshold met, spike resets age, post-fire reset avoids
back-to-back, low-inventory skip, unknown-product skip, rng
non-consumption.

Validation (local):
- ruff check + format: clean
- mypy --strict: 0 issues, 192 files
- pyright --strict: 0 errors
- pytest -m "not integration": 969 passed (+7 vs pre-PR)

Closes #94.

* feat(api,docs): e2e demo pipeline + showcase script (#128) (#129)

* docs(docs): add INITIAL-14 + PRP-15 e2e demo pipeline plan (#128)

Adds the planning documents for the end-to-end demo pipeline work tracked
in #128. Implementation commits follow on this branch.

- INITIAL-14.md: PRD for `make demo` (problem, solution, success metrics,
  open questions resolved in the PRP).
- PRPs/PRP-15-e2e-demo-pipeline.md: full execution plan (16 tasks → 6
  commits, additive only — no schema changes, no API edits).

* feat(data): add demo_minimal scenario preset (#128)

Tiny preset that powers the upcoming `make demo` target. Three stores ×
ten products × 92 days (2024-10-01..2024-12-31) — wide enough to satisfy
an expanding backtest with n_splits=3, horizon=14, min_train_size=30
(needs >= 72 days, 92 leaves margin), small enough to keep the demo
loop comfortable on a laptop.

Mirrors the retail_standard tuning (mild linear trend, noise_sigma=0.10,
modest promotion + stockout probabilities) so backtest WAPE stays
non-NaN across all three baseline models.

- app/shared/seeder/config.py: add DEMO_MINIMAL enum + from_scenario branch
- app/features/seeder/service.py: add ScenarioInfo entry in list_scenarios
- tests cover the new preset and the updated scenario count

* feat(api,docs): scripts/run_demo.py end-to-end pipeline driver (#128)

Single-file async driver that walks the published HTTP surface
(precheck -> reset? -> seed -> status -> features -> train x3 ->
backtest x3 -> register -> verify -> agent -> cleanup). Mirrors the
shape of scripts/seed_random.py and scripts/check_db.py.

- HttpClient: thin httpx.AsyncClient wrapper with explicit 60 s
  timeout (default 5 s is too short for /seeder/generate); surfaces
  RFC 7807 problem+json bodies as a typed StepError that echoes
  title / detail / request_id (never the raw body — secrets-safe).
- DemoContext + StepOutcome dataclasses thread cross-step references.
- Reporter renders the output-formatting.md glyphs (verbose by
  default, --quiet collapses to one line per step).
- Per-step error handling converts httpx + StepError into fail
  outcomes; precheck failure exits 2, any other failure exits 1,
  green exits 0.
- Agent step (10/11) skips with ⏭️ when neither OPENAI_API_KEY nor
  ANTHROPIC_API_KEY is set; reads via app.core.config.get_settings()
  to honor the no-os.environ-in-feature-code rule.
- Registry handshake uses the mandatory pending -> running -> success
  transition and the wire alias "model_config" (not "model_config_data");
  artifact_hash is computed client-side via sha256 since we share the
  FS with the API on this single-host system.
- Winner selection: lowest aggregated WAPE, skipping NaN folds.

Also adds scripts/__init__.py so tests can `import scripts.run_demo`
without invoking the file as a script.

* feat(repo): top-level Makefile with demo / demo-quick / demo-clean (#128)

Wraps scripts/run_demo.py so reviewers can run the full end-to-end
demo with one command. Recipes mirror the three modes the script
supports: full run, skip-seed iteration, destructive reset.

Make targets:
- demo        — docker compose up -d + alembic + run_demo
- demo-quick  — run_demo --skip-seed (no compose/migration touch)
- demo-clean  — full reset (--reset) before seeding
- help        — default goal; lists targets + preconditions

Tab-indented recipes and .PHONY declarations per make conventions.
Preconditions (Postgres on :5433, uvicorn on :8123) documented in
the help block; the script itself enforces them via the precheck
step and exits 2 on failure.

* test(api): unit + integration coverage for run_demo (#128)

Unit (`tests/test_run_demo_unit.py`, 32 cases):
- argparse defaults + all-flags variants
- DemoContext defaults (no leaking state across runs)
- _select_winner: lowest-WAPE, NaN-skip, all-NaN -> None, empty -> None
- _model_config_payload: discriminated-union shape per baseline; rejects
  unsupported model_type (defends the "no lightgbm in PRP-15" boundary)
- Reporter: glyph mapping; verbose + quiet output; summary green / failure
  / over-budget soft-warn branches
- StepError formats RFC 7807 (title/detail/request_id) without leaking
  the raw response body
- HttpClient (mocked httpx.AsyncClient): 2xx, 204, non-2xx -> StepError
- Step payload sanity: seed sends demo_minimal+correct dims+ISO dates;
  features sends cutoff_date as ISO; train fires three model_types in
  parallel; agent step skips with ⏭️ when no LLM key

Integration (`tests/test_e2e_demo.py`, @pytest.mark.integration):
- Skips if Postgres on :5433 isn't reachable
- Boots uvicorn on :8124 as a subprocess (avoids the dev :8123 default)
- Runs scripts/run_demo.py --reset against it; asserts exit 0 +
  canonical "runs=3 winner=... alias=demo-production" summary
- Second case asserts a bogus URL exits 2 (no silent success)
- Cleans up uvicorn on teardown with terminate/kill fallback
- Resolves `uv` via shutil.which to keep ruff S607 happy and avoid
  PATH-dependent exec at test time

* ci(repo): nightly e2e demo workflow (#128)

Adds .github/workflows/e2e-nightly.yml — runs scripts/run_demo.py
against a fresh Postgres+pgvector service every night at 07:00 UTC
(plus on-demand via workflow_dispatch). Catches regressions in the
documented end-to-end pipeline before they bleed into the per-PR
gate.

Per PRP-15 + INITIAL-14 risk note: this workflow is intentionally
NOT a required status check on dev or main. Flake-budget lives in
the nightly slot, not in ci.yml.

- pgvector/pgvector:pg16 service container (same as ci.yml `test` job)
- uvicorn started in background; /health polled with a 30 s deadline
- run_demo.py called with --seed 42 (deterministic)
- LLM-key env vars intentionally absent — agent step auto-skips via
  ⏭️, keeping the workflow self-contained
- uvicorn logs uploaded as artifact on failure (7-day retention) so
  postmortems can read what the API was doing when the script broke
- astral-sh/setup-uv pinned by 40-char SHA per security-patterns.md
- permissions: contents: read (least-privilege)

* docs(docs): cross-link make demo from README + RUNBOOKS + REPO_MAP_INDEX (#128)

Discoverability layer for PRP-15.

- README.md: new 'Try it: end-to-end demo' step right after the curl
  /health verification; shows the canonical final-line summary so
  reviewers know what green looks like.
- docs/DAILY-FLOW.md: new 'First-Run Smoke (Demo Pipeline)' section
  documenting all three Make targets.
- docs/_base/RUNBOOKS.md: new 'make demo fails at step X' Common
  Incidents entry with a 7-point diagnosis flow keyed to the script's
  step names + a postmortem-capture recipe.
- docs/_base/REPO_MAP_INDEX.md: Makefile and scripts/run_demo.py rows
  added to the Document Index table.

Pure additive; no existing content removed or renamed.

* fix(data): update /seeder/scenarios route test for demo_minimal preset (#128)

Companion to feat(data): add demo_minimal scenario preset — the
route-level assertion in TestListScenarios.test_returns_scenarios still
expected 6 scenarios; bumping to 7 and adding the demo_minimal name
membership check to match the service-layer + config-layer tests
already updated in 005c189.

* fix(api): harden run_demo for integration test + real DB (#128)

Three real failures surfaced when first running the integration test
against docker-compose Postgres + a freshly booted uvicorn; all three
are now closed:

scripts/run_demo.py:
1. step_status: discover the real (store_id, product_id) from
   /dimensions/stores + /dimensions/products instead of hardcoding 1.
   Postgres auto-increment does NOT reset after delete, so the freshly
   seeded IDs are NOT 1 (they were ~150-260 on this branch after a few
   delete/seed cycles).
2. step_register: copy the trained-model artifact into the registry's
   own root (settings.registry_artifact_root) and record a registry-
   relative URI. The registry verify endpoint resolves artifact_uri
   against its own root, which is separate from where /forecasting/train
   writes (settings.forecast_model_artifacts_dir). Pre-fix, verify
   returned 404 even though the artifact existed on disk.
3. step_agent: skip with the soft-skip glyph on any LLM provider failure
   (invalid key, model unavailable, 5xx), and make _llm_key_present
   provider-aware so it matches the right env var to the configured
   agent_default_model. Pre-fix, an .env with anthr…
@w7-mgfcode w7-mgfcode mentioned this pull request May 18, 2026
6 tasks
w7-mgfcode added a commit that referenced this pull request May 18, 2026
…#202) (#203)

* feat: cut v0.2.13 — explorer interactivity, knowledge & guide pages (#191) (#192)

* feat(data): implement MarkdownGenerator age_days trigger via heuristic (#94) (#127)

Resolves #94 via the heuristic path documented in the issue. No schema
column, no Alembic migration, no FIFO cohort tracking — the trigger
self-reads the existing per-(store, product) on_hand_qty series and
fires when inventory has been "unrefreshed" past
`cfg.age_days_threshold`.

Decision rationale (schema column vs. heuristic):
- The schema column path would add `oldest_unit_age_days` to
  `inventory_snapshot_daily`, plus an Alembic migration, plus FIFO
  cohort tracking in `InventorySnapshotGenerator`. No downstream
  consumer reads this column today — adding it for one generator
  trigger violates the "don't design for hypothetical future
  requirements" rule in CLAUDE.md.
- The heuristic path is self-contained in MarkdownGenerator,
  deterministic (preserves the zero-rng-draw regression invariant),
  and additive (no migration, no model change). 354 LOC net, all
  inside one slice.

Heuristic spec:
- A "refresh" is a day where `on_hand_qty` rose by >=
  `_AGE_DAYS_SPIKE_THRESHOLD` (0.3 = 30% jump) vs the prior day.
- Age at day t = days since most recent refresh (or `dates[0]` if no
  refresh has been observed).
- Firing requires age >= `age_days_threshold` AND on_hand >=
  `markdown_min_units_remaining` — never markdown an empty shelf.
- After firing, refresh anchor resets to the day AFTER the markdown
  window ends, so back-to-back fires can't happen and the next age
  clock starts from a "clear shelf" baseline.

Wiring: `MarkdownGenerator.generate()` gains an optional kwarg
`inventory_records: list[dict[str, Any]] | None = None` which `core.py`
passes through from `InventorySnapshotGenerator`. Disabled-path and
non-age_days-path behavior is byte-identical (kwarg ignored).

Tests: +7 new in `TestAgeDaysTrigger`, -1 obsolete
`NotImplementedError` test. Coverage: no-records defensive, threshold
not-met, threshold met, spike resets age, post-fire reset avoids
back-to-back, low-inventory skip, unknown-product skip, rng
non-consumption.

Validation (local):
- ruff check + format: clean
- mypy --strict: 0 issues, 192 files
- pyright --strict: 0 errors
- pytest -m "not integration": 969 passed (+7 vs pre-PR)

Closes #94.

* feat(api,docs): e2e demo pipeline + showcase script (#128) (#129)

* docs(docs): add INITIAL-14 + PRP-15 e2e demo pipeline plan (#128)

Adds the planning documents for the end-to-end demo pipeline work tracked
in #128. Implementation commits follow on this branch.

- INITIAL-14.md: PRD for `make demo` (problem, solution, success metrics,
  open questions resolved in the PRP).
- PRPs/PRP-15-e2e-demo-pipeline.md: full execution plan (16 tasks → 6
  commits, additive only — no schema changes, no API edits).

* feat(data): add demo_minimal scenario preset (#128)

Tiny preset that powers the upcoming `make demo` target. Three stores ×
ten products × 92 days (2024-10-01..2024-12-31) — wide enough to satisfy
an expanding backtest with n_splits=3, horizon=14, min_train_size=30
(needs >= 72 days, 92 leaves margin), small enough to keep the demo
loop comfortable on a laptop.

Mirrors the retail_standard tuning (mild linear trend, noise_sigma=0.10,
modest promotion + stockout probabilities) so backtest WAPE stays
non-NaN across all three baseline models.

- app/shared/seeder/config.py: add DEMO_MINIMAL enum + from_scenario branch
- app/features/seeder/service.py: add ScenarioInfo entry in list_scenarios
- tests cover the new preset and the updated scenario count

* feat(api,docs): scripts/run_demo.py end-to-end pipeline driver (#128)

Single-file async driver that walks the published HTTP surface
(precheck -> reset? -> seed -> status -> features -> train x3 ->
backtest x3 -> register -> verify -> agent -> cleanup). Mirrors the
shape of scripts/seed_random.py and scripts/check_db.py.

- HttpClient: thin httpx.AsyncClient wrapper with explicit 60 s
  timeout (default 5 s is too short for /seeder/generate); surfaces
  RFC 7807 problem+json bodies as a typed StepError that echoes
  title / detail / request_id (never the raw body — secrets-safe).
- DemoContext + StepOutcome dataclasses thread cross-step references.
- Reporter renders the output-formatting.md glyphs (verbose by
  default, --quiet collapses to one line per step).
- Per-step error handling converts httpx + StepError into fail
  outcomes; precheck failure exits 2, any other failure exits 1,
  green exits 0.
- Agent step (10/11) skips with ⏭️ when neither OPENAI_API_KEY nor
  ANTHROPIC_API_KEY is set; reads via app.core.config.get_settings()
  to honor the no-os.environ-in-feature-code rule.
- Registry handshake uses the mandatory pending -> running -> success
  transition and the wire alias "model_config" (not "model_config_data");
  artifact_hash is computed client-side via sha256 since we share the
  FS with the API on this single-host system.
- Winner selection: lowest aggregated WAPE, skipping NaN folds.

Also adds scripts/__init__.py so tests can `import scripts.run_demo`
without invoking the file as a script.

* feat(repo): top-level Makefile with demo / demo-quick / demo-clean (#128)

Wraps scripts/run_demo.py so reviewers can run the full end-to-end
demo with one command. Recipes mirror the three modes the script
supports: full run, skip-seed iteration, destructive reset.

Make targets:
- demo        — docker compose up -d + alembic + run_demo
- demo-quick  — run_demo --skip-seed (no compose/migration touch)
- demo-clean  — full reset (--reset) before seeding
- help        — default goal; lists targets + preconditions

Tab-indented recipes and .PHONY declarations per make conventions.
Preconditions (Postgres on :5433, uvicorn on :8123) documented in
the help block; the script itself enforces them via the precheck
step and exits 2 on failure.

* test(api): unit + integration coverage for run_demo (#128)

Unit (`tests/test_run_demo_unit.py`, 32 cases):
- argparse defaults + all-flags variants
- DemoContext defaults (no leaking state across runs)
- _select_winner: lowest-WAPE, NaN-skip, all-NaN -> None, empty -> None
- _model_config_payload: discriminated-union shape per baseline; rejects
  unsupported model_type (defends the "no lightgbm in PRP-15" boundary)
- Reporter: glyph mapping; verbose + quiet output; summary green / failure
  / over-budget soft-warn branches
- StepError formats RFC 7807 (title/detail/request_id) without leaking
  the raw response body
- HttpClient (mocked httpx.AsyncClient): 2xx, 204, non-2xx -> StepError
- Step payload sanity: seed sends demo_minimal+correct dims+ISO dates;
  features sends cutoff_date as ISO; train fires three model_types in
  parallel; agent step skips with ⏭️ when no LLM key

Integration (`tests/test_e2e_demo.py`, @pytest.mark.integration):
- Skips if Postgres on :5433 isn't reachable
- Boots uvicorn on :8124 as a subprocess (avoids the dev :8123 default)
- Runs scripts/run_demo.py --reset against it; asserts exit 0 +
  canonical "runs=3 winner=... alias=demo-production" summary
- Second case asserts a bogus URL exits 2 (no silent success)
- Cleans up uvicorn on teardown with terminate/kill fallback
- Resolves `uv` via shutil.which to keep ruff S607 happy and avoid
  PATH-dependent exec at test time

* ci(repo): nightly e2e demo workflow (#128)

Adds .github/workflows/e2e-nightly.yml — runs scripts/run_demo.py
against a fresh Postgres+pgvector service every night at 07:00 UTC
(plus on-demand via workflow_dispatch). Catches regressions in the
documented end-to-end pipeline before they bleed into the per-PR
gate.

Per PRP-15 + INITIAL-14 risk note: this workflow is intentionally
NOT a required status check on dev or main. Flake-budget lives in
the nightly slot, not in ci.yml.

- pgvector/pgvector:pg16 service container (same as ci.yml `test` job)
- uvicorn started in background; /health polled with a 30 s deadline
- run_demo.py called with --seed 42 (deterministic)
- LLM-key env vars intentionally absent — agent step auto-skips via
  ⏭️, keeping the workflow self-contained
- uvicorn logs uploaded as artifact on failure (7-day retention) so
  postmortems can read what the API was doing when the script broke
- astral-sh/setup-uv pinned by 40-char SHA per security-patterns.md
- permissions: contents: read (least-privilege)

* docs(docs): cross-link make demo from README + RUNBOOKS + REPO_MAP_INDEX (#128)

Discoverability layer for PRP-15.

- README.md: new 'Try it: end-to-end demo' step right after the curl
  /health verification; shows the canonical final-line summary so
  reviewers know what green looks like.
- docs/DAILY-FLOW.md: new 'First-Run Smoke (Demo Pipeline)' section
  documenting all three Make targets.
- docs/_base/RUNBOOKS.md: new 'make demo fails at step X' Common
  Incidents entry with a 7-point diagnosis flow keyed to the script's
  step names + a postmortem-capture recipe.
- docs/_base/REPO_MAP_INDEX.md: Makefile and scripts/run_demo.py rows
  added to the Document Index table.

Pure additive; no existing content removed or renamed.

* fix(data): update /seeder/scenarios route test for demo_minimal preset (#128)

Companion to feat(data): add demo_minimal scenario preset — the
route-level assertion in TestListScenarios.test_returns_scenarios still
expected 6 scenarios; bumping to 7 and adding the demo_minimal name
membership check to match the service-layer + config-layer tests
already updated in 005c189.

* fix(api): harden run_demo for integration test + real DB (#128)

Three real failures surfaced when first running the integration test
against docker-compose Postgres + a freshly booted uvicorn; all three
are now closed:

scripts/run_demo.py:
1. step_status: discover the real (store_id, product_id) from
   /dimensions/stores + /dimensions/products instead of hardcoding 1.
   Postgres auto-increment does NOT reset after delete, so the freshly
   seeded IDs are NOT 1 (they were ~150-260 on this branch after a few
   delete/seed cycles).
2. step_register: copy the trained-model artifact into the registry's
   own root (settings.registry_artifact_root) and record a registry-
   relative URI. The registry verify endpoint resolves artifact_uri
   against its own root, which is separate from where /forecasting/train
   writes (settings.forecast_model_artifacts_dir). Pre-fix, verify
   returned 404 even though the artifact existed on disk.
3. step_agent: skip with the soft-skip glyph on any LLM provider failure
   (invalid key, model unavailable, 5xx), and make _llm_key_present
   provider-aware so it matches the right env var to the configured
   agent_default_model. Pre-fix, an .env with anthropic/openai keys but
   a Gemini default model failed hard at chat-time.
4. Bumped DEFAULT_TIMEOUT_S from 60 to 120 because /seeder/generate
   for demo_minimal can spend 60-90 s on slower laptops once you
   include inventory + prices + promotions inserts.
5. step_seed detail string: GenerateResult.records_created uses 'sales'
   (singular), not 'sales_daily'; cosmetic fix.

tests/test_e2e_demo.py:
- Redirect uvicorn stdout to a temp file rather than subprocess.PIPE.
  The seeder + structlog produce enough INFO log volume to fill a
  64-KB pipe buffer; once full, uvicorn blocks on write and seeder
  requests hang for the full --timeout. Verified locally: integration
  suite now passes in ~6.5 s instead of timing out at 120 s.
- Cleanup leaves the log file on disk only when the test failed
  (postmortem-friendly).

tests/test_run_demo_unit.py:
- Bump test_defaults timeout expectation to match the new 120 s
  default.

End-to-end manual run on this machine: 11 steps, wall_clock=2 s,
exit 0. Integration test: 2 passed in 6.48 s.

* chore(repo): bump authlib + fastmcp to clear Socket-flagged CVEs (#130) (#131)

Headline:
- authlib  1.6.6  -> 1.7.2  (clears GHSA-wvwj-cvrp-7pv5 — JWS signature
  verification bypass; patched at >= 1.6.9)
- fastmcp  2.14.4 -> 3.2.4  (clears GHSA-vv7q-7jx5-f767 — OpenAPI
  Provider SSRF + path traversal; patched at >= 3.2.0)

Both CVEs were flagged on PR #129 by Socket Security and are
pre-existing on dev (not introduced by #128).

Wider scope — read before merging:
`uv lock --upgrade-package authlib --upgrade-package fastmcp` triggers
a full re-resolve of the dependency graph. Because dev's uv.lock had
drifted from pyproject.toml (the project's constraint envelope had
loosened over time), this single command also brings the lockfile in
sync with current pyproject.toml. Net diff: 243 insertions / 369
deletions on uv.lock; no other files touched.

Transitive cascades worth flagging:
- anthropic    0.77.0 -> 0.102.0 (pydantic-ai-slim extra)
- pydantic-graph 1.51.0 -> 1.96.0
- temporalio   1.20.0 -> 1.27.2
- alembic      1.18.1 -> 1.18.4
- aws-* and cohere transitives bumped along
- griffe 1.15.0 dropped in favor of griffelib 2.0.2 (fastmcp 3.x switched)
- Removed: cloudpickle, diskcache, fakeredis, invoke, lupa, prometheus
  exporter, pydocket, redis, rsa, sortedcontainers — these were
  transitives of fastmcp 2.x that fastmcp 3.x no longer pulls in.

Verification on this host:
- uv sync --extra dev  -> green
- ruff check .         -> clean
- mypy --strict app/   -> 192 files clean
- pyright app/         -> 0 errors (50 warnings, pre-existing)
- pytest -m 'not integration' -> 969 passed

Known install quirk: griffelib 2.0.2 ships a top-level `griffe/`
package whose RECORD files don't always materialize on first install
when uv replaces an older `griffe` dist in the same sync. A clean
venv install (which CI does via `uv sync --frozen`) is unaffected;
local devs who upgrade in place may need a one-shot
`uv pip install --force-reinstall griffelib` if `import griffe` fails.

* feat(api,ui): in-product demo showcase page (#132) (#133)

* feat(api): add demo slice driving the e2e pipeline via /demo endpoints (#132)

New app/features/demo slice exposing POST /demo/run and WS /demo/stream. It
drives the published API surface in-process via httpx.ASGITransport (no
cross-slice imports, satisfying the vertical-slice rule) and streams one
StepEvent per pipeline step: precheck -> reset -> seed -> status -> features
-> train x3 -> backtest x3 -> register -> verify -> agent -> cleanup.

A module-level asyncio.Lock enforces single-flight; concurrent runs get an
RFC 7807 409. The orchestration is a faithful in-process port of
scripts/run_demo.py (PR #129). Implements PRP-17.

* test(api): cover the demo slice pipeline, routes, and e2e integration (#132)

Unit tests mock the in-process HTTP client to exercise step sequencing,
winner selection, and fail-fast; route tests cover POST /demo/run (200 +
409) and the WS /demo/stream handler. The integration test seeds
demo_minimal and asserts an end-to-end green run against real Postgres.

Implements PRP-17.

* feat(ui): add showcase page streaming the live demo pipeline (#132)

New /showcase route and nav entry. The page opens a one-shot WebSocket to
/demo/stream via a use-demo-pipeline hook (wrapping useWebSocket) and renders
the 11 pipeline steps as live status cards: glyph, detail, duration, the
backtest per-model WAPE breakdown with the winner highlighted, and a
pass/fail summary banner.

Also block-scopes a pre-existing no-case-declarations lint error in
chat.tsx so pnpm lint is green for this PR. Implements PRP-17.

* test(ui): add vitest setup and use-demo-pipeline hook coverage (#132)

Adds the frontend test stack (vitest + jsdom + @testing-library/react), a
test script, and vitest.config.ts. use-demo-pipeline.test.ts covers the
pure event reducer (idle -> running -> pass transitions, summary assembly,
error phase) and a renderHook smoke test.

The package.json pnpm.onlyBuiltDependencies entry is the RUNBOOKS-documented
fix for pnpm 11's esbuild build-script gate. Implements PRP-17.

* docs(docs): document the demo slice and showcase page (#132)

Adds the PRP-17 spec; a 'Try it in the browser' pointer in README; the
/demo/run + /demo/stream rows and a WebSocket Events section in
API_CONTRACTS; a 'Showcase pipeline fails' runbook incident; and
REPO_MAP_INDEX rows for the demo slice and showcase page.

Implements PRP-17.

* chore(repo): back-merge main into dev to absorb v0.2.10 release commits (#136) (#137)

* chore(main): release 0.2.9 (#126)

* feat: release v0.2.10 — demo showcase page + e2e pipeline (#134)

* feat(data): implement MarkdownGenerator age_days trigger via heuristic (#94) (#127)

Resolves #94 via the heuristic path documented in the issue. No schema
column, no Alembic migration, no FIFO cohort tracking — the trigger
self-reads the existing per-(store, product) on_hand_qty series and
fires when inventory has been "unrefreshed" past
`cfg.age_days_threshold`.

Decision rationale (schema column vs. heuristic):
- The schema column path would add `oldest_unit_age_days` to
  `inventory_snapshot_daily`, plus an Alembic migration, plus FIFO
  cohort tracking in `InventorySnapshotGenerator`. No downstream
  consumer reads this column today — adding it for one generator
  trigger violates the "don't design for hypothetical future
  requirements" rule in CLAUDE.md.
- The heuristic path is self-contained in MarkdownGenerator,
  deterministic (preserves the zero-rng-draw regression invariant),
  and additive (no migration, no model change). 354 LOC net, all
  inside one slice.

Heuristic spec:
- A "refresh" is a day where `on_hand_qty` rose by >=
  `_AGE_DAYS_SPIKE_THRESHOLD` (0.3 = 30% jump) vs the prior day.
- Age at day t = days since most recent refresh (or `dates[0]` if no
  refresh has been observed).
- Firing requires age >= `age_days_threshold` AND on_hand >=
  `markdown_min_units_remaining` — never markdown an empty shelf.
- After firing, refresh anchor resets to the day AFTER the markdown
  window ends, so back-to-back fires can't happen and the next age
  clock starts from a "clear shelf" baseline.

Wiring: `MarkdownGenerator.generate()` gains an optional kwarg
`inventory_records: list[dict[str, Any]] | None = None` which `core.py`
passes through from `InventorySnapshotGenerator`. Disabled-path and
non-age_days-path behavior is byte-identical (kwarg ignored).

Tests: +7 new in `TestAgeDaysTrigger`, -1 obsolete
`NotImplementedError` test. Coverage: no-records defensive, threshold
not-met, threshold met, spike resets age, post-fire reset avoids
back-to-back, low-inventory skip, unknown-product skip, rng
non-consumption.

Validation (local):
- ruff check + format: clean
- mypy --strict: 0 issues, 192 files
- pyright --strict: 0 errors
- pytest -m "not integration": 969 passed (+7 vs pre-PR)

Closes #94.

* feat(api,docs): e2e demo pipeline + showcase script (#128) (#129)

* docs(docs): add INITIAL-14 + PRP-15 e2e demo pipeline plan (#128)

Adds the planning documents for the end-to-end demo pipeline work tracked
in #128. Implementation commits follow on this branch.

- INITIAL-14.md: PRD for `make demo` (problem, solution, success metrics,
  open questions resolved in the PRP).
- PRPs/PRP-15-e2e-demo-pipeline.md: full execution plan (16 tasks → 6
  commits, additive only — no schema changes, no API edits).

* feat(data): add demo_minimal scenario preset (#128)

Tiny preset that powers the upcoming `make demo` target. Three stores ×
ten products × 92 days (2024-10-01..2024-12-31) — wide enough to satisfy
an expanding backtest with n_splits=3, horizon=14, min_train_size=30
(needs >= 72 days, 92 leaves margin), small enough to keep the demo
loop comfortable on a laptop.

Mirrors the retail_standard tuning (mild linear trend, noise_sigma=0.10,
modest promotion + stockout probabilities) so backtest WAPE stays
non-NaN across all three baseline models.

- app/shared/seeder/config.py: add DEMO_MINIMAL enum + from_scenario branch
- app/features/seeder/service.py: add ScenarioInfo entry in list_scenarios
- tests cover the new preset and the updated scenario count

* feat(api,docs): scripts/run_demo.py end-to-end pipeline driver (#128)

Single-file async driver that walks the published HTTP surface
(precheck -> reset? -> seed -> status -> features -> train x3 ->
backtest x3 -> register -> verify -> agent -> cleanup). Mirrors the
shape of scripts/seed_random.py and scripts/check_db.py.

- HttpClient: thin httpx.AsyncClient wrapper with explicit 60 s
  timeout (default 5 s is too short for /seeder/generate); surfaces
  RFC 7807 problem+json bodies as a typed StepError that echoes
  title / detail / request_id (never the raw body — secrets-safe).
- DemoContext + StepOutcome dataclasses thread cross-step references.
- Reporter renders the output-formatting.md glyphs (verbose by
  default, --quiet collapses to one line per step).
- Per-step error handling converts httpx + StepError into fail
  outcomes; precheck failure exits 2, any other failure exits 1,
  green exits 0.
- Agent step (10/11) skips with ⏭️ when neither OPENAI_API_KEY nor
  ANTHROPIC_API_KEY is set; reads via app.core.config.get_settings()
  to honor the no-os.environ-in-feature-code rule.
- Registry handshake uses the mandatory pending -> running -> success
  transition and the wire alias "model_config" (not "model_config_data");
  artifact_hash is computed client-side via sha256 since we share the
  FS with the API on this single-host system.
- Winner selection: lowest aggregated WAPE, skipping NaN folds.

Also adds scripts/__init__.py so tests can `import scripts.run_demo`
without invoking the file as a script.

* feat(repo): top-level Makefile with demo / demo-quick / demo-clean (#128)

Wraps scripts/run_demo.py so reviewers can run the full end-to-end
demo with one command. Recipes mirror the three modes the script
supports: full run, skip-seed iteration, destructive reset.

Make targets:
- demo        — docker compose up -d + alembic + run_demo
- demo-quick  — run_demo --skip-seed (no compose/migration touch)
- demo-clean  — full reset (--reset) before seeding
- help        — default goal; lists targets + preconditions

Tab-indented recipes and .PHONY declarations per make conventions.
Preconditions (Postgres on :5433, uvicorn on :8123) documented in
the help block; the script itself enforces them via the precheck
step and exits 2 on failure.

* test(api): unit + integration coverage for run_demo (#128)

Unit (`tests/test_run_demo_unit.py`, 32 cases):
- argparse defaults + all-flags variants
- DemoContext defaults (no leaking state across runs)
- _select_winner: lowest-WAPE, NaN-skip, all-NaN -> None, empty -> None
- _model_config_payload: discriminated-union shape per baseline; rejects
  unsupported model_type (defends the "no lightgbm in PRP-15" boundary)
- Reporter: glyph mapping; verbose + quiet output; summary green / failure
  / over-budget soft-warn branches
- StepError formats RFC 7807 (title/detail/request_id) without leaking
  the raw response body
- HttpClient (mocked httpx.AsyncClient): 2xx, 204, non-2xx -> StepError
- Step payload sanity: seed sends demo_minimal+correct dims+ISO dates;
  features sends cutoff_date as ISO; train fires three model_types in
  parallel; agent step skips with ⏭️ when no LLM key

Integration (`tests/test_e2e_demo.py`, @pytest.mark.integration):
- Skips if Postgres on :5433 isn't reachable
- Boots uvicorn on :8124 as a subprocess (avoids the dev :8123 default)
- Runs scripts/run_demo.py --reset against it; asserts exit 0 +
  canonical "runs=3 winner=... alias=demo-production" summary
- Second case asserts a bogus URL exits 2 (no silent success)
- Cleans up uvicorn on teardown with terminate/kill fallback
- Resolves `uv` via shutil.which to keep ruff S607 happy and avoid
  PATH-dependent exec at test time

* ci(repo): nightly e2e demo workflow (#128)

Adds .github/workflows/e2e-nightly.yml — runs scripts/run_demo.py
against a fresh Postgres+pgvector service every night at 07:00 UTC
(plus on-demand via workflow_dispatch). Catches regressions in the
documented end-to-end pipeline before they bleed into the per-PR
gate.

Per PRP-15 + INITIAL-14 risk note: this workflow is intentionally
NOT a required status check on dev or main. Flake-budget lives in
the nightly slot, not in ci.yml.

- pgvector/pgvector:pg16 service container (same as ci.yml `test` job)
- uvicorn started in background; /health polled with a 30 s deadline
- run_demo.py called with --seed 42 (deterministic)
- LLM-key env vars intentionally absent — agent step auto-skips via
  ⏭️, keeping the workflow self-contained
- uvicorn logs uploaded as artifact on failure (7-day retention) so
  postmortems can read what the API was doing when the script broke
- astral-sh/setup-uv pinned by 40-char SHA per security-patterns.md
- permissions: contents: read (least-privilege)

* docs(docs): cross-link make demo from README + RUNBOOKS + REPO_MAP_INDEX (#128)

Discoverability layer for PRP-15.

- README.md: new 'Try it: end-to-end demo' step right after the curl
  /health verification; shows the canonical final-line summary so
  reviewers know what green looks like.
- docs/DAILY-FLOW.md: new 'First-Run Smoke (Demo Pipeline)' section
  documenting all three Make targets.
- docs/_base/RUNBOOKS.md: new 'make demo fails at step X' Common
  Incidents entry with a 7-point diagnosis flow keyed to the script's
  step names + a postmortem-capture recipe.
- docs/_base/REPO_MAP_INDEX.md: Makefile and scripts/run_demo.py rows
  added to the Document Index table.

Pure additive; no existing content removed or renamed.

* fix(data): update /seeder/scenarios route test for demo_minimal preset (#128)

Companion to feat(data): add demo_minimal scenario preset — the
route-level assertion in TestListScenarios.test_returns_scenarios still
expected 6 scenarios; bumping to 7 and adding the demo_minimal name
membership check to match the service-layer + config-layer tests
already updated in 005c189.

* fix(api): harden run_demo for integration test + real DB (#128)

Three real failures surfaced when first running the integration test
against docker-compose Postgres + a freshly booted uvicorn; all three
are now closed:

scripts/run_demo.py:
1. step_status: discover the real (store_id, product_id) from
   /dimensions/stores + /dimensions/products instead of hardcoding 1.
   Postgres auto-increment does NOT reset after delete, so the freshly
   seeded IDs are NOT 1 (they were ~150-260 on this branch after a few
   delete/seed cycles).
2. step_register: copy the trained-model artifact into the registry's
   own root (settings.registry_artifact_root) and record a registry-
   relative URI. The registry verify endpoint resolves artifact_uri
   against its own root, which is separate from where /forecasting/train
   writes (settings.forecast_model_artifacts_dir). Pre-fix, verify
   returned 404 even though the artifact existed on disk.
3. step_agent: skip with the soft-skip glyph on any LLM provider failure
   (invalid key, model unavailable, 5xx), and make _llm_key_present
   provider-aware so it matches the right env var to the configured
   agent_default_model. Pre-fix, an .env with anthropic/openai keys but
   a Gemini default model failed hard at chat-time.
4. Bumped DEFAULT_TIMEOUT_S from 60 to 120 because /seeder/generate
   for demo_minimal can spend 60-90 s on slower laptops once you
   include inventory + prices + promotions inserts.
5. step_seed detail string: GenerateResult.records_created uses 'sales'
   (singular), not 'sales_daily'; cosmetic fix.

tests/test_e2e_demo.py:
- Redirect uvicorn stdout to a temp file rather than subprocess.PIPE.
  The seeder + structlog produce enough INFO log volume to fill a
  64-KB pipe buffer; once full, uvicorn blocks on write and seeder
  requests hang for the full --timeout. Verified locally: integration
  suite now passes in ~6.5 s instead of timing out at 120 s.
- Cleanup leaves the log file on disk only when the test failed
  (postmortem-friendly).

tests/test_run_demo_unit.py:
- Bump test_defaults timeout expectation to match the new 120 s
  default.

End-to-end manual run on this machine: 11 steps, wall_clock=2 s,
exit 0. Integration test: 2 passed in 6.48 s.

* chore(repo): bump authlib + fastmcp to clear Socket-flagged CVEs (#130) (#131)

Headline:
- authlib  1.6.6  -> 1.7.2  (clears GHSA-wvwj-cvrp-7pv5 — JWS signature
  verification bypass; patched at >= 1.6.9)
- fastmcp  2.14.4 -> 3.2.4  (clears GHSA-vv7q-7jx5-f767 — OpenAPI
  Provider SSRF + path traversal; patched at >= 3.2.0)

Both CVEs were flagged on PR #129 by Socket Security and are
pre-existing on dev (not introduced by #128).

Wider scope — read before merging:
`uv lock --upgrade-package authlib --upgrade-package fastmcp` triggers
a full re-resolve of the dependency graph. Because dev's uv.lock had
drifted from pyproject.toml (the project's constraint envelope had
loosened over time), this single command also brings the lockfile in
sync with current pyproject.toml. Net diff: 243 insertions / 369
deletions on uv.lock; no other files touched.

Transitive cascades worth flagging:
- anthropic    0.77.0 -> 0.102.0 (pydantic-ai-slim extra)
- pydantic-graph 1.51.0 -> 1.96.0
- temporalio   1.20.0 -> 1.27.2
- alembic      1.18.1 -> 1.18.4
- aws-* and cohere transitives bumped along
- griffe 1.15.0 dropped in favor of griffelib 2.0.2 (fastmcp 3.x switched)
- Removed: cloudpickle, diskcache, fakeredis, invoke, lupa, prometheus
  exporter, pydocket, redis, rsa, sortedcontainers — these were
  transitives of fastmcp 2.x that fastmcp 3.x no longer pulls in.

Verification on this host:
- uv sync --extra dev  -> green
- ruff check .         -> clean
- mypy --strict app/   -> 192 files clean
- pyright app/         -> 0 errors (50 warnings, pre-existing)
- pytest -m 'not integration' -> 969 passed

Known install quirk: griffelib 2.0.2 ships a top-level `griffe/`
package whose RECORD files don't always materialize on first install
when uv replaces an older `griffe` dist in the same sync. A clean
venv install (which CI does via `uv sync --frozen`) is unaffected;
local devs who upgrade in place may need a one-shot
`uv pip install --force-reinstall griffelib` if `import griffe` fails.

* feat(api,ui): in-product demo showcase page (#132) (#133)

* feat(api): add demo slice driving the e2e pipeline via /demo endpoints (#132)

New app/features/demo slice exposing POST /demo/run and WS /demo/stream. It
drives the published API surface in-process via httpx.ASGITransport (no
cross-slice imports, satisfying the vertical-slice rule) and streams one
StepEvent per pipeline step: precheck -> reset -> seed -> status -> features
-> train x3 -> backtest x3 -> register -> verify -> agent -> cleanup.

A module-level asyncio.Lock enforces single-flight; concurrent runs get an
RFC 7807 409. The orchestration is a faithful in-process port of
scripts/run_demo.py (PR #129). Implements PRP-17.

* test(api): cover the demo slice pipeline, routes, and e2e integration (#132)

Unit tests mock the in-process HTTP client to exercise step sequencing,
winner selection, and fail-fast; route tests cover POST /demo/run (200 +
409) and the WS /demo/stream handler. The integration test seeds
demo_minimal and asserts an end-to-end green run against real Postgres.

Implements PRP-17.

* feat(ui): add showcase page streaming the live demo pipeline (#132)

New /showcase route and nav entry. The page opens a one-shot WebSocket to
/demo/stream via a use-demo-pipeline hook (wrapping useWebSocket) and renders
the 11 pipeline steps as live status cards: glyph, detail, duration, the
backtest per-model WAPE breakdown with the winner highlighted, and a
pass/fail summary banner.

Also block-scopes a pre-existing no-case-declarations lint error in
chat.tsx so pnpm lint is green for this PR. Implements PRP-17.

* test(ui): add vitest setup and use-demo-pipeline hook coverage (#132)

Adds the frontend test stack (vitest + jsdom + @testing-library/react), a
test script, and vitest.config.ts. use-demo-pipeline.test.ts covers the
pure event reducer (idle -> running -> pass transitions, summary assembly,
error phase) and a renderHook smoke test.

The package.json pnpm.onlyBuiltDependencies entry is the RUNBOOKS-documented
fix for pnpm 11's esbuild build-script gate. Implements PRP-17.

* docs(docs): document the demo slice and showcase page (#132)

Adds the PRP-17 spec; a 'Try it in the browser' pointer in README; the
/demo/run + /demo/stream rows and a WebSocket Events section in
API_CONTRACTS; a 'Showcase pipeline fails' runbook incident; and
REPO_MAP_INDEX rows for the demo slice and showcase page.

Implements PRP-17.

* chore(main): release 0.2.10 (#135)

* docs(docs): fix broken PRP-0/INITIAL-0 relative links in phase 0 doc (#138) (#139)

* docs(repo): fix readme dev-deps command and stale .github template placeholders (#140) (#141)

* docs(docs): fill DEV_GUIDE.md onboarding stub sections (#142) (#143)

* docs(repo): refresh stale CLAUDE.md note, document /demo API, align PR template (#144) (#145)

* fix(ui): chart series render black — drop hsl() wrapper on oklch chart vars (#149) (#153)

index.css defines --chart-N twice: legacy shadcn-v3 HSL triplets and
Tailwind-4 / shadcn-v4 complete oklch() colours. The oklch definitions win
the cascade, so at runtime --chart-N is a full colour. The chart components
still wrapped it as hsl(var(--chart-N)) → hsl(oklch(...)), which is invalid
CSS, so recharts fell back to a black fill/stroke — invisible on the dark
theme.

Reference var(--chart-N) directly in backtest-folds-chart.tsx and
time-series-chart.tsx. Verified in a browser: the backtest per-fold bars
and the forecast line now render in colour.

* fix(jobs): backtest job result keeps fold metrics, stability and baselines (#148) (#152)

* fix(jobs): backtest job result keeps fold metrics, stability and baselines (#148)

_execute_backtest ran BacktestingService.run_backtest — which computes
per-fold metrics, stability indices and a naive/seasonal baseline comparison
— but stored only four aggregated values and discarded the rest. The
dashboard (/visualize/backtest) reads aggregated_metrics.{*_mean,
stability_index}, fold_metrics[] and baseline_comparison, so it showed
"0 folds", all-zero metrics and an empty chart.

Add _shape_backtest_result(), which flattens a BacktestResponse into the
contract the dashboard expects, and _finite(), which coerces NaN/inf to 0.0
so the result stays JSONB-safe (stability is NaN with fewer than two folds).

Add app/features/jobs/tests/test_service.py with unit coverage for the
shaping logic: fold metrics, *_mean keys, stability, baseline comparison,
the no-baselines path, and NaN coercion.

* refactor(jobs): centralize backtest metric keys and surface drift (#148)

Addresses review feedback on PR #152.

- Hoist the dashboard's metric set into _BACKTEST_METRICS and the headline
  stability metric into _STABILITY_METRIC, so the hardcoded keys live in one
  documented place instead of being repeated across the shaping logic.
- Log jobs.backtest_metrics_missing when an expected metric is absent from the
  backtest response, so a future rename in the backtesting service fails loud
  instead of silently emitting 0.0.
- Document the WAPE stability convention in the _shape_backtest_result docstring.
- Tests: assert backtest_id / model_type / duration_ms pass through unchanged,
  and add a regression test for the missing-metric default path.

* fix(ui): forecast page reads forecasts/forecast from predict job result (#147) (#151)

The /visualize/forecast page never rendered the chart for a valid completed
predict job. It read job.result.predictions with field `predicted`, but
POST /jobs (job_type="predict") returns job.result.forecasts with field
`forecast`. forecastData was therefore always undefined and the page fell
through to "No prediction data available in job result".

Read result.forecasts with field `forecast`, and pass predictedKey="forecast"
to TimeSeriesChart (which already supports a configurable data key).

Verified in a browser: entering a completed predict job ID now renders the
14-day forecast line chart with correct tooltip values.

* fix(registry): tolerate multiple matches in _find_duplicate (#146) (#150)

Under the default registry_duplicate_policy="detect", duplicate runs are
created intentionally, so multiple non-archived model_run rows can share one
config hash. _find_duplicate used scalar_one_or_none(), which raised
MultipleResultsFound once two duplicates existed — POST /registry/runs then
returned HTTP 500. This made the demo/Showcase register step fail
deterministically on any DB with repeated runs.

Order the lookup by created_at desc, LIMIT 1, and use scalars().first() so it
returns the most recent matching run instead of asserting a single match.

Add an integration regression test that POSTs an identical run three times
under the detect policy and asserts all three return 201.

* fix(ui): derive TimeSeriesChart line stroke from the config key (#156) (#157)

TimeSeriesChart builds chartConfig with dynamic keys ([actualKey] /
[predictedKey]), so shadcn's ChartContainer injects --color-<key> CSS
variables. The <Line> elements, however, hardcoded stroke="var(--color-actual)"
and stroke="var(--color-predicted)". The forecast page passes
predictedKey="forecast", so the injected variable is --color-forecast;
var(--color-predicted) was undefined, the stroke was invalid, and SVG fell
back to its initial value `none` — the forecast line was invisible.

Build the stroke from the key: stroke={`var(--color-${actualKey})`} /
stroke={`var(--color-${predictedKey})`}.

Verified in a browser: the forecast line now renders in colour.

* feat(ui): job picker dropdown on forecast and backtest pages (#154) (#155)

The visualization pages only accepted a job ID typed into a text box, so
users had to already know the ID. Add a JobPicker component: a dropdown of
completed jobs of the relevant type (predict / backtest), newest first, with
each option labelled by short id, model and timestamp.

- New shared component src/components/common/job-picker.tsx, used by both
  forecast.tsx and backtest.tsx.
- The manual job-ID input stays alongside the dropdown for pasting an ID.
- The most recent completed job auto-loads on mount so a chart shows
  immediately without interaction.

No backend change — GET /jobs?job_type=&status=completed already exists.
Verified in a browser on both pages.

* chore(repo): back-merge main into dev after v0.2.11 (#160) (#161)

* chore(main): release 0.2.9 (#126)

* feat: release v0.2.10 — demo showcase page + e2e pipeline (#134)

* feat(data): implement MarkdownGenerator age_days trigger via heuristic (#94) (#127)

Resolves #94 via the heuristic path documented in the issue. No schema
column, no Alembic migration, no FIFO cohort tracking — the trigger
self-reads the existing per-(store, product) on_hand_qty series and
fires when inventory has been "unrefreshed" past
`cfg.age_days_threshold`.

Decision rationale (schema column vs. heuristic):
- The schema column path would add `oldest_unit_age_days` to
  `inventory_snapshot_daily`, plus an Alembic migration, plus FIFO
  cohort tracking in `InventorySnapshotGenerator`. No downstream
  consumer reads this column today — adding it for one generator
  trigger violates the "don't design for hypothetical future
  requirements" rule in CLAUDE.md.
- The heuristic path is self-contained in MarkdownGenerator,
  deterministic (preserves the zero-rng-draw regression invariant),
  and additive (no migration, no model change). 354 LOC net, all
  inside one slice.

Heuristic spec:
- A "refresh" is a day where `on_hand_qty` rose by >=
  `_AGE_DAYS_SPIKE_THRESHOLD` (0.3 = 30% jump) vs the prior day.
- Age at day t = days since most recent refresh (or `dates[0]` if no
  refresh has been observed).
- Firing requires age >= `age_days_threshold` AND on_hand >=
  `markdown_min_units_remaining` — never markdown an empty shelf.
- After firing, refresh anchor resets to the day AFTER the markdown
  window ends, so back-to-back fires can't happen and the next age
  clock starts from a "clear shelf" baseline.

Wiring: `MarkdownGenerator.generate()` gains an optional kwarg
`inventory_records: list[dict[str, Any]] | None = None` which `core.py`
passes through from `InventorySnapshotGenerator`. Disabled-path and
non-age_days-path behavior is byte-identical (kwarg ignored).

Tests: +7 new in `TestAgeDaysTrigger`, -1 obsolete
`NotImplementedError` test. Coverage: no-records defensive, threshold
not-met, threshold met, spike resets age, post-fire reset avoids
back-to-back, low-inventory skip, unknown-product skip, rng
non-consumption.

Validation (local):
- ruff check + format: clean
- mypy --strict: 0 issues, 192 files
- pyright --strict: 0 errors
- pytest -m "not integration": 969 passed (+7 vs pre-PR)

Closes #94.

* feat(api,docs): e2e demo pipeline + showcase script (#128) (#129)

* docs(docs): add INITIAL-14 + PRP-15 e2e demo pipeline plan (#128)

Adds the planning documents for the end-to-end demo pipeline work tracked
in #128. Implementation commits follow on this branch.

- INITIAL-14.md: PRD for `make demo` (problem, solution, success metrics,
  open questions resolved in the PRP).
- PRPs/PRP-15-e2e-demo-pipeline.md: full execution plan (16 tasks → 6
  commits, additive only — no schema changes, no API edits).

* feat(data): add demo_minimal scenario preset (#128)

Tiny preset that powers the upcoming `make demo` target. Three stores ×
ten products × 92 days (2024-10-01..2024-12-31) — wide enough to satisfy
an expanding backtest with n_splits=3, horizon=14, min_train_size=30
(needs >= 72 days, 92 leaves margin), small enough to keep the demo
loop comfortable on a laptop.

Mirrors the retail_standard tuning (mild linear trend, noise_sigma=0.10,
modest promotion + stockout probabilities) so backtest WAPE stays
non-NaN across all three baseline models.

- app/shared/seeder/config.py: add DEMO_MINIMAL enum + from_scenario branch
- app/features/seeder/service.py: add ScenarioInfo entry in list_scenarios
- tests cover the new preset and the updated scenario count

* feat(api,docs): scripts/run_demo.py end-to-end pipeline driver (#128)

Single-file async driver that walks the published HTTP surface
(precheck -> reset? -> seed -> status -> features -> train x3 ->
backtest x3 -> register -> verify -> agent -> cleanup). Mirrors the
shape of scripts/seed_random.py and scripts/check_db.py.

- HttpClient: thin httpx.AsyncClient wrapper with explicit 60 s
  timeout (default 5 s is too short for /seeder/generate); surfaces
  RFC 7807 problem+json bodies as a typed StepError that echoes
  title / detail / request_id (never the raw body — secrets-safe).
- DemoContext + StepOutcome dataclasses thread cross-step references.
- Reporter renders the output-formatting.md glyphs (verbose by
  default, --quiet collapses to one line per step).
- Per-step error handling converts httpx + StepError into fail
  outcomes; precheck failure exits 2, any other failure exits 1,
  green exits 0.
- Agent step (10/11) skips with ⏭️ when neither OPENAI_API_KEY nor
  ANTHROPIC_API_KEY is set; reads via app.core.config.get_settings()
  to honor the no-os.environ-in-feature-code rule.
- Registry handshake uses the mandatory pending -> running -> success
  transition and the wire alias "model_config" (not "model_config_data");
  artifact_hash is computed client-side via sha256 since we share the
  FS with the API on this single-host system.
- Winner selection: lowest aggregated WAPE, skipping NaN folds.

Also adds scripts/__init__.py so tests can `import scripts.run_demo`
without invoking the file as a script.

* feat(repo): top-level Makefile with demo / demo-quick / demo-clean (#128)

Wraps scripts/run_demo.py so reviewers can run the full end-to-end
demo with one command. Recipes mirror the three modes the script
supports: full run, skip-seed iteration, destructive reset.

Make targets:
- demo        — docker compose up -d + alembic + run_demo
- demo-quick  — run_demo --skip-seed (no compose/migration touch)
- demo-clean  — full reset (--reset) before seeding
- help        — default goal; lists targets + preconditions

Tab-indented recipes and .PHONY declarations per make conventions.
Preconditions (Postgres on :5433, uvicorn on :8123) documented in
the help block; the script itself enforces them via the precheck
step and exits 2 on failure.

* test(api): unit + integration coverage for run_demo (#128)

Unit (`tests/test_run_demo_unit.py`, 32 cases):
- argparse defaults + all-flags variants
- DemoContext defaults (no leaking state across runs)
- _select_winner: lowest-WAPE, NaN-skip, all-NaN -> None, empty -> None
- _model_config_payload: discriminated-union shape per baseline; rejects
  unsupported model_type (defends the "no lightgbm in PRP-15" boundary)
- Reporter: glyph mapping; verbose + quiet output; summary green / failure
  / over-budget soft-warn branches
- StepError formats RFC 7807 (title/detail/request_id) without leaking
  the raw response body
- HttpClient (mocked httpx.AsyncClient): 2xx, 204, non-2xx -> StepError
- Step payload sanity: seed sends demo_minimal+correct dims+ISO dates;
  features sends cutoff_date as ISO; train fires three model_types in
  parallel; agent step skips with ⏭️ when no LLM key

Integration (`tests/test_e2e_demo.py`, @pytest.mark.integration):
- Skips if Postgres on :5433 isn't reachable
- Boots uvicorn on :8124 as a subprocess (avoids the dev :8123 default)
- Runs scripts/run_demo.py --reset against it; asserts exit 0 +
  canonical "runs=3 winner=... alias=demo-production" summary
- Second case asserts a bogus URL exits 2 (no silent success)
- Cleans up uvicorn on teardown with terminate/kill fallback
- Resolves `uv` via shutil.which to keep ruff S607 happy and avoid
  PATH-dependent exec at test time

* ci(repo): nightly e2e demo workflow (#128)

Adds .github/workflows/e2e-nightly.yml — runs scripts/run_demo.py
against a fresh Postgres+pgvector service every night at 07:00 UTC
(plus on-demand via workflow_dispatch). Catches regressions in the
documented end-to-end pipeline before they bleed into the per-PR
gate.

Per PRP-15 + INITIAL-14 risk note: this workflow is intentionally
NOT a required status check on dev or main. Flake-budget lives in
the nightly slot, not in ci.yml.

- pgvector/pgvector:pg16 service container (same as ci.yml `test` job)
- uvicorn started in background; /health polled with a 30 s deadline
- run_demo.py called with --seed 42 (deterministic)
- LLM-key env vars intentionally absent — agent step auto-skips via
  ⏭️, keeping the workflow self-contained
- uvicorn logs uploaded as artifact on failure (7-day retention) so
  postmortems can read what the API was doing when the script broke
- astral-sh/setup-uv pinned by 40-char SHA per security-patterns.md
- permissions: contents: read (least-privilege)

* docs(docs): cross-link make demo from README + RUNBOOKS + REPO_MAP_INDEX (#128)

Discoverability layer for PRP-15.

- README.md: new 'Try it: end-to-end demo' step right after the curl
  /health verification; shows the canonical final-line summary so
  reviewers know what green looks like.
- docs/DAILY-FLOW.md: new 'First-Run Smoke (Demo Pipeline)' section
  documenting all three Make targets.
- docs/_base/RUNBOOKS.md: new 'make demo fails at step X' Common
  Incidents entry with a 7-point diagnosis flow keyed to the script's
  step names + a postmortem-capture recipe.
- docs/_base/REPO_MAP_INDEX.md: Makefile and scripts/run_demo.py rows
  added to the Document Index table.

Pure additive; no existing content removed or renamed.

* fix(data): update /seeder/scenarios route test for demo_minimal preset (#128)

Companion to feat(data): add demo_minimal scenario preset — the
route-level assertion in TestListScenarios.test_returns_scenarios still
expected 6 scenarios; bumping to 7 and adding the demo_minimal name
membership check to match the service-layer + config-layer tests
already updated in 005c189.

* fix(api): harden run_demo for integration test + real DB (#128)

Three real failures surfaced when first running the integration test
against docker-compose Postgres + a freshly booted uvicorn; all three
are now closed:

scripts/run_demo.py:
1. step_status: discover the real (store_id, product_id) from
   /dimensions/stores + /dimensions/products instead of hardcoding 1.
   Postgres auto-increment does NOT reset after delete, so the freshly
   seeded IDs are NOT 1 (they were ~150-260 on this branch after a few
   delete/seed cycles).
2. step_register: copy the trained-model artifact into the registry's
   own root (settings.registry_artifact_root) and record a registry-
   relative URI. The registry verify endpoint resolves artifact_uri
   against its own root, which is separate from where /forecasting/train
   writes (settings.forecast_model_artifacts_dir). Pre-fix, verify
   returned 404 even though the artifact existed on disk.
3. step_agent: skip with the soft-skip glyph on any LLM provider failure
   (invalid key, model unavailable, 5xx), and make _llm_key_present
   provider-aware so it matches the right env var to the configured
   agent_default_model. Pre-fix, an .env with anthropic/openai keys but
   a Gemini default model failed hard at chat-time.
4. Bumped DEFAULT_TIMEOUT_S from 60 to 120 because /seeder/generate
   for demo_minimal can spend 60-90 s on slower laptops once you
   include inventory + prices + promotions inserts.
5. step_seed detail string: GenerateResult.records_created uses 'sales'
   (singular), not 'sales_daily'; cosmetic fix.

tests/test_e2e_demo.py:
- Redirect uvicorn stdout to a temp file rather than subprocess.PIPE.
  The seeder + structlog produce enough INFO log volume to fill a
  64-KB pipe buffer; once full, uvicorn blocks on write and seeder
  requests hang for the full --timeout. Verified locally: integration
  suite now passes in ~6.5 s instead of timing out at 120 s.
- Cleanup leaves the log file on disk only when the test failed
  (postmortem-friendly).

tests/test_run_demo_unit.py:
- Bump test_defaults timeout expectation to match the new 120 s
  default.

End-to-end manual run on this machine: 11 steps, wall_clock=2 s,
exit 0. Integration test: 2 passed in 6.48 s.

* chore(repo): bump authlib + fastmcp to clear Socket-flagged CVEs (#130) (#131)

Headline:
- authlib  1.6.6  -> 1.7.2  (clears GHSA-wvwj-cvrp-7pv5 — JWS signature
  verification bypass; patched at >= 1.6.9)
- fastmcp  2.14.4 -> 3.2.4  (clears GHSA-vv7q-7jx5-f767 — OpenAPI
  Provider SSRF + path traversal; patched at >= 3.2.0)

Both CVEs were flagged on PR #129 by Socket Security and are
pre-existing on dev (not introduced by #128).

Wider scope — read before merging:
`uv lock --upgrade-package authlib --upgrade-package fastmcp` triggers
a full re-resolve of the dependency graph. Because dev's uv.lock had
drifted from pyproject.toml (the project's constraint envelope had
loosened over time), this single command also brings the lockfile in
sync with current pyproject.toml. Net diff: 243 insertions / 369
deletions on uv.lock; no other files touched.

Transitive cascades worth flagging:
- anthropic    0.77.0 -> 0.102.0 (pydantic-ai-slim extra)
- pydantic-graph 1.51.0 -> 1.96.0
- temporalio   1.20.0 -> 1.27.2
- alembic      1.18.1 -> 1.18.4
- aws-* and cohere transitives bumped along
- griffe 1.15.0 dropped in favor of griffelib 2.0.2 (fastmcp 3.x switched)
- Removed: cloudpickle, diskcache, fakeredis, invoke, lupa, prometheus
  exporter, pydocket, redis, rsa, sortedcontainers — these were
  transitives of fastmcp 2.x that fastmcp 3.x no longer pulls in.

Verification on this host:
- uv sync --extra dev  -> green
- ruff check .         -> clean
- mypy --strict app/   -> 192 files clean
- pyright app/         -> 0 errors (50 warnings, pre-existing)
- pytest -m 'not integration' -> 969 passed

Known install quirk: griffelib 2.0.2 ships a top-level `griffe/`
package whose RECORD files don't always materialize on first install
when uv replaces an older `griffe` dist in the same sync. A clean
venv install (which CI does via `uv sync --frozen`) is unaffected;
local devs who upgrade in place may need a one-shot
`uv pip install --force-reinstall griffelib` if `import griffe` fails.

* feat(api,ui): in-product demo showcase page (#132) (#133)

* feat(api): add demo slice driving the e2e pipeline via /demo endpoints (#132)

New app/features/demo slice exposing POST /demo/run and WS /demo/stream. It
drives the published API surface in-process via httpx.ASGITransport (no
cross-slice imports, satisfying the vertical-slice rule) and streams one
StepEvent per pipeline step: precheck -> reset -> seed -> status -> features
-> train x3 -> backtest x3 -> register -> verify -> agent -> cleanup.

A module-level asyncio.Lock enforces single-flight; concurrent runs get an
RFC 7807 409. The orchestration is a faithful in-process port of
scripts/run_demo.py (PR #129). Implements PRP-17.

* test(api): cover the demo slice pipeline, routes, and e2e integration (#132)

Unit tests mock the in-process HTTP client to exercise step sequencing,
winner selection, and fail-fast; route tests cover POST /demo/run (200 +
409) and the WS /demo/stream handler. The integration test seeds
demo_minimal and asserts an end-to-end green run against real Postgres.

Implements PRP-17.

* feat(ui): add showcase page streaming the live demo pipeline (#132)

New /showcase route and nav entry. The page opens a one-shot WebSocket to
/demo/stream via a use-demo-pipeline hook (wrapping useWebSocket) and renders
the 11 pipeline steps as live status cards: glyph, detail, duration, the
backtest per-model WAPE breakdown with the winner highlighted, and a
pass/fail summary banner.

Also block-scopes a pre-existing no-case-declarations lint error in
chat.tsx so pnpm lint is green for this PR. Implements PRP-17.

* test(ui): add vitest setup and use-demo-pipeline hook coverage (#132)

Adds the frontend test stack (vitest + jsdom + @testing-library/react), a
test script, and vitest.config.ts. use-demo-pipeline.test.ts covers the
pure event reducer (idle -> running -> pass transitions, summary assembly,
error phase) and a renderHook smoke test.

The package.json pnpm.onlyBuiltDependencies entry is the RUNBOOKS-documented
fix for pnpm 11's esbuild build-script gate. Implements PRP-17.

* docs(docs): document the demo slice and showcase page (#132)

Adds the PRP-17 spec; a 'Try it in the browser' pointer in README; the
/demo/run + /demo/stream rows and a WebSocket Events section in
API_CONTRACTS; a 'Showcase pipeline fails' runbook incident; and
REPO_MAP_INDEX rows for the demo slice and showcase page.

Implements PRP-17.

* chore(main): release 0.2.10 (#135)

* feat: release v0.2.11 — visualization fixes, job picker, demo showcase (#158)

* feat(data): implement MarkdownGenerator age_days trigger via heuristic (#94) (#127)

Resolves #94 via the heuristic path documented in the issue. No schema
column, no Alembic migration, no FIFO cohort tracking — the trigger
self-reads the existing per-(store, product) on_hand_qty series and
fires when inventory has been "unrefreshed" past
`cfg.age_days_threshold`.

Decision rationale (schema column vs. heuristic):
- The schema column path would add `oldest_unit_age_days` to
  `inventory_snapshot_daily`, plus an Alembic migration, plus FIFO
  cohort tracking in `InventorySnapshotGenerator`. No downstream
  consumer reads this column today — adding it for one generator
  trigger violates the "don't design for hypothetical future
  requirements" rule in CLAUDE.md.
- The heuristic path is self-contained in MarkdownGenerator,
  deterministic (preserves the zero-rng-draw regression invariant),
  and additive (no migration, no model change). 354 LOC net, all
  inside one slice.

Heuristic spec:
- A "refresh" is a day where `on_hand_qty` rose by >=
  `_AGE_DAYS_SPIKE_THRESHOLD` (0.3 = 30% jump) vs the prior day.
- Age at day t = days since most recent refresh (or `dates[0]` if no
  refresh has been observed).
- Firing requires age >= `age_days_threshold` AND on_hand >=
  `markdown_min_units_remaining` — never markdown an empty shelf.
- After firing, refresh anchor resets to the day AFTER the markdown
  window ends, so back-to-back fires can't happen and the next age
  clock starts from a "clear shelf" baseline.

Wiring: `MarkdownGenerator.generate()` gains an optional kwarg
`inventory_records: list[dict[str, Any]] | None = None` which `core.py`
passes through from `InventorySnapshotGenerator`. Disabled-path and
non-age_days-path behavior is byte-identical (kwarg ignored).

Tests: +7 new in `TestAgeDaysTrigger`, -1 obsolete
`NotImplementedError` test. Coverage: no-records defensive, threshold
not-met, threshold met, spike resets age, post-fire reset avoids
back-to-back, low-inventory skip, unknown-product skip, rng
non-consumption.

Validation (local):
- ruff check + format: clean
- mypy --strict: 0 issues, 192 files
- pyright --strict: 0 errors
- pytest -m "not integration": 969 passed (+7 vs pre-PR)

Closes #94.

* feat(api,docs): e2e demo pipeline + showcase script (#128) (#129)

* docs(docs): add INITIAL-14 + PRP-15 e2e demo pipeline plan (#128)

Adds the planning documents for the end-to-end demo pipeline work tracked
in #128. Implementation commits follow on this branch.

- INITIAL-14.md: PRD for `make demo` (problem, solution, success metrics,
  open questions resolved in the PRP).
- PRPs/PRP-15-e2e-demo-pipeline.md: full execution plan (16 tasks → 6
  commits, additive only — no schema changes, no API edits).

* feat(data): add demo_minimal scenario preset (#128)

Tiny preset that powers the upcoming `make demo` target. Three stores ×
ten products × 92 days (2024-10-01..2024-12-31) — wide enough to satisfy
an expanding backtest with n_splits=3, horizon=14, min_train_size=30
(needs >= 72 days, 92 leaves margin), small enough to keep the demo
loop comfortable on a laptop.

Mirrors the retail_standard tuning (mild linear trend, noise_sigma=0.10,
modest promotion + stockout probabilities) so backtest WAPE stays
non-NaN across all three baseline models.

- app/shared/seeder/config.py: add DEMO_MINIMAL enum + from_scenario branch
- app/features/seeder/service.py: add ScenarioInfo entry in list_scenarios
- tests cover the new preset and the updated scenario count

* feat(api,docs): scripts/run_demo.py end-to-end pipeline driver (#128)

Single-file async driver that walks the published HTTP surface
(precheck -> reset? -> seed -> status -> features -> train x3 ->
backtest x3 -> register -> verify -> agent -> cleanup). Mirrors the
shape of scripts/seed_random.py and scripts/check_db.py.

- HttpClient: thin httpx.AsyncClient wrapper with explicit 60 s
  timeout (default 5 s is too short for /seeder/generate); surfaces
  RFC 7807 problem+json bodies as a typed StepError that echoes
  title / detail / request_id (never the raw body — secrets-safe).
- DemoContext + StepOutcome dataclasses thread cross-step references.
- Reporter renders the output-formatting.md glyphs (verbose by
  default, --quiet collapses to one line per step).
- Per-step error handling converts httpx + StepError into fail
  outcomes; precheck failure exits 2, any other failure exits 1,
  green exits 0.
- Agent step (10/11) skips with ⏭️ when neither OPENAI_API_KEY nor
  ANTHROPIC_API_KEY is set; reads via app.core.config.get_settings()
  to honor the no-os.environ-in-feature-code rule.
- Registry handshake uses the mandatory pending -> running -> success
  transition and the wire alias "model_config" (not "model_config_data");
  artifact_hash is computed client-side via sha256 since we share the
  FS with the API on this single-host system.
- Winner selection: lowest aggregated WAPE, skipping NaN folds.

Also adds scripts/__init__.py so tests can `import scripts.run_demo`
without invoking the file as a script.

* feat(repo): top-level Makefile with demo / demo-quick / demo-clean (#128)

Wraps scripts/run_demo.py so reviewers can run the full end-to-end
demo with one command. Recipes mirror the three modes the script
supports: full run, skip-seed iteration, destructive reset.

Make targets:
- demo        — docker compose up -d + alembic + run_demo
- demo-quick  — run_demo --skip-seed (no compose/migration touch)
- demo-clean  — full reset (--reset) before seeding
- help        — default goal; lists targets + preconditions

Tab-indented recipes and .PHONY declarations per make conventions.
Preconditions (Postgres on :5433, uvicorn on :8123) documented in
the help block; the script itself enforces them via the precheck
step and exits 2 on failure.

* test(api): unit + integration coverage for run_demo (#128)

Unit (`tests/test_run_demo_unit.py`, 32 cases):
- argparse defaults + all-flags variants
- DemoContext defaults (no leaking state across runs)
- _select_winner: lowest-WAPE, NaN-skip, all-NaN -> None, empty -> None
- _model_config_payload: discriminated-union shape per baseline; rejects
  unsupported model_type (defends the "no lightgbm in PRP-15" boundary)
- Reporter: glyph mapping; verbose + quiet output; summary green / failure
  / over-budget soft-warn branches
- StepError formats RFC 7807 (title/detail/request_id) without leaking
  the raw response body
- HttpClient (mocked httpx.AsyncClient): 2xx, 204, non-2xx -> StepError
- Step payload sanity: seed sends demo_minimal+correct dims+ISO dates;
  features sends cutoff_date as ISO; train fires three model_types in
  parallel; agent step skips with ⏭️ when no LLM key

Integration (`tests/test_e2e_demo.py`, @pytest.mark.integration):
- Skips if Postgres on :5433 isn't reachable
- Boots uvicorn on :8124 as a subprocess (avoids the dev :8123 default)
- Runs scripts/run_demo.py --reset against it; asserts exit 0 +
  canonical "runs=3 winner=... alias=demo-production" summary
- Second case asserts a bogus URL exits 2 (no silent success)
- Cleans up uvicorn on teardown with terminate/kill fallback
- Resolves `uv` via shutil.which to keep ruff S607 happy and avoid
  PATH-dependent exec at test time

* ci(repo): nightly e2e demo workflow (#128)

Adds .github/workflows/e2e-nightly.yml — runs scripts/run_demo.py
against a fresh Postgres+pgvector service every night at 07:00 UTC
(plus on-demand via workflow_dispatch). Catches regressions in the
documented end-to-end pipeline before they bleed into the per-PR
gate.

Per PRP-15 + INITIAL-14 risk note: this workflow is intentionally
NOT a required status check on dev or main. Flake-budget lives in
the nightly slot, not in ci.yml.

- pgvector/pgvector:pg16 service container (same as ci.yml `test` job)
- uvicorn started in background; /health polled with a 30 s deadline
- run_demo.py called with --seed 42 (deterministic)
- LLM-key env vars intentionally absent — agent step auto-skips via
  ⏭️, keeping the workflow self-contained
- uvicorn logs uploaded as artifact on failure (7-day retention) so
  postmortems can read what the API was doing when the script broke
- astral-sh/setup-uv pinned by 40-char SHA per security-patterns.md
- permissions: contents: read (least-privilege)

* docs(docs): cross-link make demo from README + RUNBOOKS + REPO_MAP_INDEX (#128)

Discoverability layer for PRP-15.

- README.md: new 'Try it: end-to-end demo' step right after the curl
  /health verification; shows the canonical final-line summary so
  reviewers know what green looks like.
- docs/DAILY-FLOW.md: new 'First-Run Smoke (Demo Pipeline)' section
  documenting all three Make targets.
- docs/_base/RUNBOOKS.md: new 'make demo fails at step X' Common
  Incidents entry with a 7-point diagnosis flow keyed to the script's
  step names + a postmortem-capture recipe.
- docs/_base/REPO_MAP_INDEX.md: Makefile and scripts/run_demo.py rows
  added to the Document Index table.

Pure additive; no existing content removed or renamed.

* fix(data): update /seeder/scenarios route test for demo_minimal preset (#128)

Companion to feat(data): add demo_minimal scenario preset — the
route-level assertion in TestListScenarios.test_returns_scenarios still
expected 6 scenarios; bumping to 7 and adding the demo_minimal name
membership check to match the service-layer + config-layer tests
already updated in 005c189.

* fix(api): harden run_demo for integration test + real DB (#128)

Three real failures surfaced when first running the integration test
against docker-compose Postgres + a freshly booted uvicorn; all three
are now closed:

scripts/run_demo.py:
1. step_status: discover the real (store_id, product_id) from
   /dimensions/stores + /dimensions/products instead of hardcoding 1.
   Postgres auto-increment does NOT reset after delete, so the freshly
   seeded IDs are NOT 1 (they were ~150-260 on this branch after a few
   delete/seed cycles).
2. step_register: copy the trained-model artifact into the registry's
   own root (settings.registry_artifact_root) and record a registry-
   relative URI. The registry verify endpoint resolves artifact_uri
   against its own root, which is separate from where /forecasting/train
   writes (settings.forecast_model_artifacts_dir). Pre-fix, verify
   returned 404 even though the artifact existed on disk.
3. step_agent: skip with the soft-skip glyph on any LLM provider failure
   (invalid key, model unavailable, 5xx), and make _llm_key_present
   provider-aware so it matches the right env var to the configured
   agent_default_model. Pre-fix, …
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant