show-me-the-money

Backlog finder

Find features from past sessions that never shipped, without burning frontier quota. Scan all sessions in the current project by default using a Map-Reduce flow:

1. Map: Run one fast agy Flash worker per session. Each worker lists every feature discussed as IMPLEMENTED or NOT IMPLEMENTED.
2. Reduce: Compare all worker reports by date against git log to find the latest snapshot of open work.

1. Select scope

Query $HOME/.gemini/antigravity/conversation_summaries.db with sqlite3 to list root sessions where parent_conversation_id = ''. Always skip the active session.

• Single-project sweep by default: Scan all sessions for the current workspace across all time, ordered from oldest to newest.

WORKSPACE_PATH=$(pwd)
sqlite3 -json "$HOME/.gemini/antigravity/conversation_summaries.db" "
  SELECT
    conversation_id,
    title,
    workspace_uris,
    step_count,
    datetime(last_modified_time) AS last_active
  FROM conversation_summaries
  WHERE parent_conversation_id = ''
    AND killed = 0
    AND step_count > 4
    AND workspace_uris LIKE '%file://${WORKSPACE_PATH}\"%'
  ORDER BY last_modified_time ASC;
"

• Optional time sweep: Wait for the user to ask for a time window across all projects. Then swap the workspace_uris filter for AND last_modified_time >= datetime('now', '-N days').

2. Map: one agy Flash worker per session

Check your agent tier in the system prompt. When running on a frontier tier such as Gemini 4 Argon or Pro:

• Never read raw transcript.jsonl files in the main session.
• Never call invoke_subagent for transcript mining. Subagents inherit your frontier tier and burn high-cost quota.
• Always spawn one headless agy CLI worker per session pinned to a fast Flash tier such as flash-lite or flash-low.

Select the fastest Flash tier from agy models:

FLASH_MODEL=$(agy models | awk '/flash-lite|flash.*low/ {print $1; exit}')

Read only the chat turns and git commits. Skip tool logs, ask_question prompts, system notes, and scratch files.