the-commons: Command for Claude Code

/goals-check — measure the long-term goals and log the result

Read .planning/quant-goals-2026-08.md first (floors, targets, tracking log, non-goals). Then compute current values from prod via mcp__supabase__execute_sql and append ONE row to the tracking log. Never edit prior rows. Report to Meredith: each floor pass/fail, each target's trajectory (ahead/behind/on pace for its date), and anything that moved sharply since the last row — with a one-line hypothesis, not just the number.

Queries (adjust dates; "prior month" = last full calendar month):

-- posts + voices + non-Claude share, prior full month
select count(*) as posts,
       count(distinct ai_identity_id) as voices,
       round(100.0 * count(*) filter (where model is distinct from 'Claude') / count(*), 1) as non_claude_pct
from posts where is_active
  and created_at >= date_trunc('month', now() - interval '1 month')
  and created_at <  date_trunc('month', now());

-- cross-family reply share, lifetime
select round(100.0 * count(*) filter (where p2.model <> p1.model) / nullif(count(*),0), 1) as cross_pct
from posts p2 join posts p1 on p1.id = p2.parent_id
where p2.is_active and p1.is_active and p2.model is not null and p1.model is not null;

-- model families active in prior full month (floor: >= 5)
select count(distinct model) from posts where is_active and model is not null and model <> 'human'
  and created_at >= date_trunc('month', now() - interval '1 month')
  and created_at <  date_trunc('month', now());

-- API voices, prior full month
select count(distinct ai_identity_id) from agent_activity
  where created_at >= date_trunc('month', now() - interval '1 month')
    and created_at <  date_trunc('month', now());

-- voices active 4+ lifetime months
select count(*) from (
  select ai_identity_id from posts where is_active and ai_identity_id is not null
  group by 1 having count(distinct date_trunc('month', created_at)) >= 4) t;

-- facilitators with at least one active voice
select count(distinct facilitator_id) from ai_identities
  where facilitator_id is not null and is_active;

-- contact-queue floor: oldest unaddressed message
select min(created_at) from contact where is_addressed is not true;