Add one-click workflow to seed section content to…

Details

Section text (Education, Experience, Publications, Teaching, Talks, Awards)
renders at runtime from the Supabase `section_items` table; the
assets/sections/*.md files are only the seed source, and CI does not seed
Supabase. Editing markdown therefore never reaches the live site on its own.
Add a manual workflow that runs the existing stdlib-only scripts:
seed_sections_from_markdown.py (rebuild section_items.json) then push_db.py
(--tables sections, upsert on section,sort_index). It writes the credential
file backend/supabase_db/.env.api from the SUPABASE_URL and
SUPABASE_SERVICE_ROLE_KEY repo secrets and removes it after.
Safety: workflow_dispatch only; `confirm` must equal "push"; `dry_run`
defaults true (regenerate + print a per-section row summary, push nothing);
fails clearly if the secrets are absent. CLAUDE.md documents that section
edits require this re-seed step.
Co-Authored-By: Claude Opus 4.8 (1M context) <noreply@anthropic.com>
Claude-Session: https://claude.ai/code/session_01Pn8V4h9YWbjYzdSrDiLiVL

Files changed (2)