brief

Guild Brief — the narrated read of the board

Read-only. This skill reports; it never dispatches an agent, never moves a task, and never writes a row. If the user wants work to start, that is guild:check-in.

Load guild:warehouse for the connection ritual and the view catalog. Everything below is a SELECT. Your job is to turn those rows into a briefing a human can act on — guild:check-in opens with the same reads, so what you write here is what the daily flow reads too.

Step 1 — is there a guild?

[ -f .guild/config.yaml ] || echo "no guild here"

If it is missing, say exactly this and stop:

No guild board found. Run /guild:check-in to initialize and start your first work session.

Step 2 — read the board

One script, one round trip. Write it with a quoted heredoc so the shell never touches the SQL:

export PATH="$HOME/.turso:$PATH"
cat > /tmp/brief.sql <<'SQL'
SELECT '## brief';        SELECT fact, value FROM v_brief;
SELECT '## direction';    SELECT id, priority, projects_runnable, runnable_project_ids,
                                 requirements_done, requirements_total, title FROM v_goal_progress;
SELECT '## projects';     SELECT json_object('id',id,'goal',goal_id,'why',why,
                                 'isolation',isolation,'worktree',worktree_path,
                                 'title',title) FROM v_projects_runnable;
SELECT '## requirements'; SELECT id, status, tasks_done, tasks_total, tasks_open,
                                 tasks_blocked, tasks_failed, title FROM v_requirement_progress
                           WHERE status <> 'done';
SELECT '## in-flight';    SELECT json_object('id',id,'req',requirement_id,'who',who,
                                 'minutes',minutes,'title',title) FROM v_in_flight;
SELECT '## bounties';     SELECT json_object('id',id,'req',requirement_id,'p',priority,
                                 'who',who,'title',title) FROM v_open_bounties;
SELECT '## blocked';      SELECT json_object('id',id,'req',requirement_id,'status',status,
                                 'reason',reason,'title',title) FROM v_blocked_tasks;
SELECT '## bugs';         SELECT json_object('id',id,'sev',severity,'status',status,
                                 'by',found_by,'req',requirement_id,'title',title) FROM v_open_bugs;
SELECT '## failed';       SELECT json_object('id',id,'who',who,'waived',waived,
                                 'reason',COALESCE(reason,''),'title',title) FROM v_failed_tasks;
SELECT '## findings';     SELECT json_object('id',id,'task',task_id,'sev',severity,
                                 'disp',disposition,'by',reviewer,'at',
                                 COALESCE(file,'') || ':' || COALESCE(line,''),
                                 'what',summary) FROM v_open_findings;
SELECT '## coverage';     SELECT json_object('id',id,'risk',risk,'due',interval_days,
                                 'since',COALESCE(days_since,-1),'area',area) FROM v_coverage_due;
SELECT '## docs-stale';   SELECT json_object('slug',slug,'kind',kind,'subject',
                                 subject_type || ':' || subject_id,'moved',subject_moved_at,
                                 'title',title) FROM v_doc_stale;
SELECT '## undocumented'; SELECT json_object('id',id,'at',finished_at,'title',title)
                            FROM v_undocumented_work;
SELECT '## gates';        SELECT json_object('node',node_id,'req',requirement_id,
                                 'kind',kind,'prompt',prompt) FROM v_gates_pending;
SELECT '## approvals';    SELECT json_object('id',id,'req',requirement_id,'status',status,
                                 'gate',gate_node_id,'title',title)
                            FROM v_plans_pending_approval;
SELECT '## moved';        SELECT json_object('ts',ts,'actor',actor,'verb',verb,
                                 'type',subject_type,'id',subject_id,'title',subject_title,
                                 'phrase',phrase) FROM v_recent_activity
                           WHERE ts >= COALESCE(NULLIF((SELECT value FROM guild_state
                                                         WHERE key='last-checkin'),'null'),'')
                           ORDER BY ts DESC LIMIT 30;
SQL
tursodb -q -m list .guild/guild.db < /tmp/brief.sql