Produce deep AGILAB audit and code-review artifacts with evidence-backed findings, mandatory architecture-foundation readiness, blast-radius tracing, security/test posture, and prioritized recommendations. Use when the user says "review AGILAB", "audit AGILAB", "code review AGILAB", "deep review", "architecture…
Nightly project health run — data audit, warehouse+api tests, smoke, log triage, freshness check. Writes docs/healthreport.md and one line to logs/health.log.
Schema, join keys, gotchas and canonical query patterns for nfl.duckdb. Load before writing any non-trivial SQL against the warehouse — table grains, view catalog, cross-era rules, and the traps that silently corrupt results.