05 — Supabase read-cache

<aside> ✅

Status: Published Last verified: 2026-07-23 — migration + plex_cache_status + sync_runs.duration_ms + Task Scheduler probe on LEGION5

</aside>

Purpose

Supabase plex schema mirror and MCP read path.

Why: Plex list endpoints often ignore server-side filters
Schema: 12 tables + views on_hand_by_part / item_balances + sync_runs (migration 0001)
MCP: SUPABASE_DB_URL_RO or SUPABASE_DB_URL; whitelisted plex_query
plex.parts = /mdm/v1/parts (rich); Active live count 17206; inv-defs is lean qty-join master
Snapshot ~09:00Z 2026-07-23: parts 42633, supply_items 2518, containers 12154, workcenters 147, buildings 4 (incl. *)
Default SPECS duration ≈ 51s (sum duration_ms parts→workcenters on 2026-07-23)
Cadence observed: masters ~09:00Z daily; production-history batch ~06:00Z (beyond repo default SPECS)
PlexSyncDaily task not found on LEGION5 (2026-07-23). Wrapper: scripts/run_sync.ps1 (path-relative). Recreate the scheduled task if this host should own it.
Distinct from public.plex_supply_items writeback staging