Continuity runbook: Catalog import and sync

Task

A second maintainer can refresh the catalog locally (make import-all) and, only with extra approval, sync selected tables to Heroku — never import against production DATABASE_URL.

Success criteria

• Knows import is local-only (scripts/import-all.sh via Makefile)
• Knows full scripts/db/sync-local-to-opencreorg.sh with SYNC_TABLES=all DROP SCHEMA public and requires the destructive confirmation phrase
• Prefers --table flags for prod sync
• Runbook docs/continuity/runbooks/catalog-import-and-sync.md (skill continuity-catalog-import-and-sync)

Context

• AGENTS.md imports + production DB sections
• After a prod table sync, run production-health (HTTP), not GA compute on Heroku

Constraints

• existing maintainers only
• Do not run Part B (prod sync) in this ticket’s first drill unless a maintainer names tables
• No secret dumps

Agent prompt

See Agent prompt in docs/continuity/runbooks/catalog-import-and-sync.md.

Start with AGENTS.md and inspect the Makefile, scripts/import-all.sh, and scripts/db/sync-local-to-opencreorg.sh. Read the target runbook at docs/continuity/runbooks/catalog-import-and-sync.md, then verify it documents local-only imports, approved table selection, destructive confirmation, and production-health checks without exposing secrets.