Kidsights-Data-Platform

Generate a PRISMA-style flow diagram for the NE25 analytic-sample construction (REDCap pull → eligible → analytic sample → weighted), with human-in-the-loop checkpoints to confirm exclusion-stage layout and methods-section wording. Output is a Mermaid `flowchart TD` block, either pasted into chat or written to a target `.qmd` file. Invoke when documenting the NE25 sample for a methods section, the WEIGHT_CONSTRUCTION narrative, an audit trail, or a collaborator handoff.

Regenerate `docs/index.html` (the GitHub Pages onboarding/orientation landing page) from current platform state — DB counts, CLAUDE.md status, recent commits, and known drift items. Invoke when the platform changes materially (new pipeline added, deferred work shifts, major status changes, DB drift items resolved or new ones surfaced) so the public-facing snapshot stays accurate.

Surgically update `HANDOFF.md` (root) — the maintainer-transition synthesis doc — so its volatile fields (in-flight work, drift items, last-audit commit, snapshot date, uncommitted-work breadcrumb) reflect current reality. Invoke during the pre-handoff window whenever material changes land that affect what the incoming maintainer needs to know. Sister skill to `/refresh-onboarding` (which regenerates the public Pages page); this one updates the internal markdown.

Regenerate `docs/database/TABLES.md` from live DuckDB introspection + the hand-written metadata in `docs/database/table_metadata.yaml`. Invoke when a table is added, dropped, renamed, moves between pipelines, or when row counts materially drift. Third member of the docs-refresh skill family (alongside `/refresh-onboarding` and `/refresh-handoff`).