GCP To AWS

Discover Phase: OpenRouter Usage API Discovery

Self-contained OpenRouter usage discovery sub-file. Captures real cost and token-usage data directly from the OpenRouter API — read-only, consent-gated, aggregate per-model/per-day counts only — as an alternative to the user exporting usage by hand. Produces openrouter-usage-profile.json and, when ai-workload-profile.json exists, fills its current_costs section with real spend. If the user declines consent or has no OpenRouter key, exits cleanly with no output.

Why this matters for a Bedrock migration. OpenRouter is a multi-provider router: the app-code scan (discover-app-code.md) detects the OpenRouter transport (gateway_type: llm_router) but often cannot tell WHICH models actually carry the spend. /activity reports it directly — per model, per day, with token counts and dollar cost — so Estimate can size the Bedrock target against real volume instead of guessing.

Execute ALL steps in order. Do not skip or optimize.

Security Contract (applies to every step)

1. Exact-endpoint allowlist, GET + one scoped POST. Call ONLY the endpoints in the Step 2 Capture Endpoint Table. All are against https://openrouter.ai/api/v1; all are GET EXCEPT POST /analytics/query, which is a read-only aggregate query (no body field it accepts can create, change, or delete anything — metrics/dimensions/ time_range/filters only shape which existing aggregate rows come back). Never any other endpoint, never any other HTTP method on any OTHER endpoint, never a chat/completion or /generation call (those run inference and can return prompt/response content — this flow reads aggregate usage only), never a key-management endpoint.

2. The OpenRouter key must never enter this conversation (HARD RULE). Do not ask the user to paste the key in chat, and never echo, cat, or interpolate its VALUE into any command, question, or output — the agent only ever handles the file path $MIGRATION_DIR/.openrouter-key-env (chmod 600, inside the gitignored .migration/ tree). If the user pastes a key into the chat unprompted, do not use it: tell them it is now part of the transcript, recommend rotating it at openrouter.ai/keys, and continue with the Step 1 intake paths. All API calls go through a throwaway capture script that reads the key from the file. Only a sha256 fingerprint of the file appears in the manifest, and the key file is deleted by default when capture completes (Step 4).

3. Aggregate data only. /activity returns per-day, per-model bucketed token counts and cost — no prompts, no completions, no request content. group_by=workspace and workspace_id are two DIFFERENT parameters — do not conflate them. group_by=workspace only SPLITS the response per workspace (it adds no content and is never needed by this flow); workspace_id FILTERS the response to one workspace's rows. A workspace-scoping request from the user is honored ONLY via the workspace_id filter (Step 1.5) — grouping alone must never be used to satisfy a scoping request, because a grouped-but- unfiltered response still returns every workspace's rows and summing across all of them silently reports account-wide spend as if it were scoped. (workspace_id is documented at OpenRouter's /activity reference; not independently verified against a live multi-workspace account.) /analytics/query is likewise aggregate-only — its response rows are per-model cost totals (byok_usage, openrouter_usage), never per-generation content; it is queried with dimensions: ["model"] and no generation_id dimension, which this flow never requests.

4. Capture to files, not context. The capture script writes responses under $MIGRATION_DIR/openrouter-capture/. Parse capture files with a throwaway extraction script if any exceeds ~500 rows — do NOT Read oversized raw captures into context.

5. Consent first. Nothing data-touching happens before the user answers [A] in Step 0 — no key intake, no key file on disk, no API call. The Step 0 consent is THE consent gate for this source (the orchestrator only decides whether to load this file).

Step 0: Consent Gate

Output exactly, then wait for the user's choice:

─── OpenRouter Usage Discovery (read-only) ───

I can pull your OpenRouter cost and per-model usage directly from the
OpenRouter API. This runs GET requests against a fixed list of
usage/credits endpoints, plus one read-only POST to `/analytics/query` for an
aggregate BYOK-vs-credits cost split per model — no request anywhere
creates, changes, or deletes anything:

  ✓ Captured: daily usage per model — request counts, prompt /
    completion / reasoning token counts, and dollar cost — plus your
    credits purchased/used total, and an aggregate BYOK-vs-credits cost
    split per model (how much of each model's spend ran on your own
    upstream key vs. OpenRouter credits). The same read-only POST also
    returns, still as aggregates: cached tokens, the BYOK platform fee,
    BYOK versus total request counts, p95 latency and p95 output
    tokens/sec, web-search cost, guardrail counts, and an hourly peak.
    No prompts or per-request content.
  ✗ Never captured: prompts or completions content, API keys, or
    anything from a chat/generation endpoint. No request that creates,
    changes, or deletes anything will run.

Window: last 30 days. You'll need an OpenRouter PROVISIONING (management)
key — a plain inference key cannot read account usage. Create one at
openrouter.ai/settings/provisioning-keys. (The key is written to a
chmod-600 file inside the gitignored .migration/ directory, never echoed,
and deleted when capture completes.)

[A] Proceed with OpenRouter usage discovery
[B] Skip — use the code scan / exported usage files only

• [A] → continue to Step 1.

• [B] → exit cleanly with no output (record the decline for the orchestrator).

Step 1: Key Intake and Preflight

1. Runtime available: curl --version (first line) and python3 --version (fall back to python, then node). If curl AND all script runtimes are missing → tell the user and exit cleanly.

2. Explain the key requirement (before asking for anything): "OpenRouter usage discovery needs a provisioning key (also called a management key) — a regular inference key (sk-or-v1-...) cannot read account usage or credits. Create one at openrouter.ai/settings/provisioning-keys. It is read-only for this flow — I only call those GET usage/credits endpoints and one read-only POST to /analytics/query."

3. Check the environment first (presence only, never the value):

   Copy

   [ -n "$(printenv OPENROUTER_PROVISIONING_KEY)" ] && echo ENV_KEY_PRESENT || echo ENV_KEY_ABSENT

4. Key intake. Ask: "How would you like to provide the provisioning key?" (offer [A] only on ENV_KEY_PRESENT):

   • [A] Use the OPENROUTER_PROVISIONING_KEY already in my environment → materialize env var to file in one command — the value never appears in the transcript:

     Copy

     printf 'OPENROUTER_PROVISIONING_KEY=%s\n' "$(printenv OPENROUTER_PROVISIONING_KEY)" > "$MIGRATION_DIR/.openrouter-key-env" && chmod 600 "$MIGRATION_DIR/.openrouter-key-env"

   • [B] I'll write it to a file myself → give the user this command to run in THEIR OWN terminal (not through the agent) — read -rs collects the key without echoing it:

     Copy

     read -rs k && printf 'OPENROUTER_PROVISIONING_KEY=%s\n' "$k" > "<MIGRATION_DIR>/.openrouter-key-env" && chmod 600 "<MIGRATION_DIR>/.openrouter-key-env" && unset k

     Substitute the literal run-directory path when presenting it (the path is not a secret). Continue when the user says it's done.

   • [C] Skip OpenRouter usage discovery → exit cleanly with no output.

5. Format check (never prints the key) — a provisioning key is non-empty and is NOT a bare inference key; reject an obviously-wrong value early:

   Copy

   grep -qE '^OPENROUTER_PROVISIONING_KEY=.+' "$MIGRATION_DIR/.openrouter-key-env" && echo KEY_FORMAT_OK || echo KEY_FORMAT_BAD

   On KEY_FORMAT_BAD: tell the user the file is empty / malformed and re-run intake (do not echo file contents). If the probe in Step 2 later returns 401, surface that the key is likely an inference key, not a provisioning key.

IMPORTANT: Do NOT rely on the environment variable during capture — env vars do not persist across Bash tool calls. The capture script reads the file path above.

Step 1.5: Workspace scoping (optional)

(Unverified against external docs: the workspace_id filter param and the GET /workspaces endpoint below are documented at OpenRouter's API reference but not independently confirmed against a live multi-workspace account.)

1. Call GET https://openrouter.ai/api/v1/workspaces (List Workspaces — returns id, name, slug per workspace) through the same capture script used in Step 2 (same key-handling rules apply — never a bare curl with the key).

2. 0 or 1 workspace on the account: skip this step silently — there is nothing to scope, and nothing to ask the user. Leave $WORKSPACE_ID unset.

3. More than one workspace: show the list and ask —

   Copy

   This OpenRouter account has multiple workspaces:
     [name / slug / id for each]
   
   Scope this capture to one workspace, or capture all?
   [A] All workspaces (default — matches today's unscoped behavior)
   [B] Pick one workspace

   Never silently default to a single workspace, and never silently default to "all" without showing the list — the choice must be stated, not assumed.

4. On [B]: record the chosen workspace's id as $WORKSPACE_ID (and its name for the profile metadata). OpenRouter's workspace_id filter takes one workspace at a time — no documented array form, unlike Anthropic's workspace_ids[]. This value is persisted into the manifest at Step 2d's very first write (not deferred to a successful full capture) — see Step 2d's workspace_scope field — so an interruption any time after that first write still has the scope recorded.

5. On [A], or when this step was skipped (≤1 workspace): leave $WORKSPACE_ID unset — capture proceeds unscoped, exactly as before this step existed.

Step 2: Capture

Create $MIGRATION_DIR/openrouter-capture/.

2a. Write the capture script to $MIGRATION_DIR/_capture_openrouter.py (or .js — whatever runtime Step 1 found). The script (and nothing else) touches the key:

• Reads OPENROUTER_PROVISIONING_KEY from $MIGRATION_DIR/.openrouter-key-env.

• Sends Authorization: Bearer <key> on every request. Never prints the key or the header; on HTTP errors it prints ONLY the status code and the response error.message.

• For /activity, requests the last 30 completed UTC days (the endpoint's own documented window — see https://openrouter.ai/docs/api/api-reference/analytics/get-user-activity.md). Compute window_end = today's UTC midnight (<UTC today>T00:00:00Z — i.e. the boundary between the current, not-yet-completed UTC day and the last completed one) and window_start = window_end minus 30 days, ONCE, before either /activity or /analytics/query runs; filter/keep /activity rows whose date falls in [window_start, window_end). Record both as window_start_utc/window_end_utc in the manifest (ISO 8601 UTC, see 2d) so a retry reuses the SAME bounds instead of recomputing them from a later now.

• A non-200 on one endpoint records failed for that row and continues — a missing endpoint or zero usage is normal, never a halt. Exception: a 401 OR 403 on the FIRST (probe) call means the key is not a management/provisioning key (OpenRouter returns 403 "Only management keys can perform this operation" for an inference key, and 401 for a revoked/invalid key) — abort before writing anything, print a distinct KEY_INVALID line, and do not write the manifest (see 2b). A written manifest tells the Discover route gate a capture completed; writing one after an auth failure would halt the whole phase on a missing profile.

• Prints one line per call: <file> ok|failed|skipped <n_rows>.

2b. Probe. The capture script runs the probe call first (2a rules apply — the agent never invokes curl with the key itself):

GET https://openrouter.ai/api/v1/credits  →  credits.json

• On 401 or 403: stop, write NO manifest and NO capture files, delete $MIGRATION_DIR/.openrouter-key-env now (this key was just proven invalid or wrong-type — do not leave a rejected key file on disk waiting for a later cleanup step this path never reaches), and tell the user: "The key was rejected (<status>). Confirm it is a provisioning / management key (openrouter.ai/settings/provisioning-keys), not a plain inference key — inference keys return 403 and cannot read account usage." Offer to re-run Step 1 intake or skip. On 429, wait 30 seconds and retry once.

• On success: continue to the capture table (the manifest is written in 2d, only after the probe authenticates).

2c. Capture Endpoint Table. Rows 1–3 are GET against https://openrouter.ai/api/v1. Row 4 is POST to that same base, read-only (an aggregate query, no body field creates, mutates, or deletes anything).

Notes:

• Row 2 /activity is the one that matters — its per-date/per-model rows, summed over the window, are the spend + volume signal. model is OpenRouter-namespaced (openai/gpt-4.1, anthropic/claude-...); keep it verbatim — Design maps the namespaced id to a Bedrock target the same way the app-code llm_router path does.

• Do NOT pass group_by=workspace (Security Contract rule 3) — it only splits rows and is never needed by this flow. When $WORKSPACE_ID is set, filter at capture time with workspace_id instead (above); when unset, the call is unchanged from today — unscoped, all workspaces.

• Row 4 /analytics/query sends this exact JSON body. time_range is NOT copied from /activity's date-filtering logic — /activity only keeps rows whose date falls in the last 30 days, it never constructs a timestamp pair. Build start/end directly as UTC YYYY-MM-DDTHH:MM:SSZ strings (seconds required — the API rejects minute-precision values like 2026-05-01T00:00Z with 400). On the FIRST attempt (no retry — the manifest does not yet have an /activity entry with status: "ok"): end = window_end_utc, start = window_start_utc — the SAME UTC-midnight-aligned bounds computed once in Step 2a (never now directly; now is only used to DERIVE window_end_utc's midnight boundary, not as the window's own end timestamp — this keeps Analytics aligned with /activity's "last 30 completed UTC days" convention regardless of what time of day capture runs). On a retry of this row alone (the manifest already has an /activity entry with status: "ok" — Step 2d's resume rule retries only the failed Analytics row and reuses the already-captured activity.json): reuse the ORIGINAL capture's window instead of rebuilding from the current now or re-deriving a fresh UTC midnight — end = the manifest's recorded window_end_utc, start = the manifest's recorded window_start_utc (NOT a fresh midnight computed at retry time, and NOT captured_at itself — captured_at is the capture TIMESTAMP, which is not necessarily UTC-midnight- aligned; window_end_utc is the aligned boundary derived from it once, in Step 2a, on the first attempt). This keeps row 4's window aligned with the /activity.json data already on disk (captured at captured_at, not re-captured on this retry) — rebuilding from a fresh now on a delayed retry would shift the Analytics window forward relative to /activity's frozen rows, silently dropping early days /activity still has data for and gaining trailing days /activity has none for, which can flip a model's classification (e.g. a mixed model's early BYOK-only days drop out of the Analytics window, leaving only its later non-BYOK days visible, misclassifying it no_byok). The span MUST stay at or under 30 days — openrouter_usage is capped at 31 days by the API, and widening the window risks a 400 on this row only (not on /activity, which has its own independent 30-day filter). When $WORKSPACE_ID is set (Step 1.5), add a filters array scoping to that workspace — same rule as row 2's &workspace_id=$WORKSPACE_ID, so this row's classification matches the same workspace scope /activity already captured, instead of silently reverting to account-wide:

  Copy

  {
    "metrics": ["byok_usage", "openrouter_usage"],
    "dimensions": ["model"],
    "time_range": { "start": "<UTC now minus 30 days, YYYY-MM-DDTHH:MM:SSZ>", "end": "<UTC now, YYYY-MM-DDTHH:MM:SSZ>" },
    "limit": 1000
  }

  When $WORKSPACE_ID is set, add "filters": [{ "field": "workspace", "operator": "eq", "value": "<$WORKSPACE_ID>" }] to that body (the workspace UUID, not its display name — same value already captured in Step 1.5). When unset, omit filters entirely — the call stays account-wide, unchanged from today.

• Rows 5 and 6 are further read-only POST /analytics/query calls, same endpoint as row 4, same time_range and the same workspace filters rule. Do not add api_key_id, user, or any other per-caller dimension. Row 5 body metrics are exactly tokens_prompt, tokens_completion, reasoning_tokens, cached_tokens, byok_fees, byok_request_count, request_count, p95_latency, p95_throughput, usage_web, guardrail_invoked_count, with "dimensions": ["model"] and no granularity. Row 6 body metrics are exactly tokens_prompt, tokens_completion, request_count, with "dimensions": ["model"] and "granularity": "hour". If metadata.truncated is true, retry that one call once with limit raised to 5000. If it is still truncated, keep the partial file, append a capture_warnings line naming the file, and do not treat models absent from the partial result as zero. A truncated row 6 must not be used for the peak — fall back to the busiest day in activity.json and set peak_source to "day".

  On a RESUMED invocation of this file (any retry entry point — the /activity-failed retry, the Analytics-only retry, or the pre-Analytics-manifest compatibility routing in discover.md), read $WORKSPACE_ID from the EXISTING manifest's workspace_scope field FIRST, before re-running Step 1.5 or falling back to an unset default — workspace_scope.workspace_id (when non-null) becomes $WORKSPACE_ID for this invocation; workspace_scope: null means $WORKSPACE_ID stays unset, deliberately, exactly as it was on the original capture. Step 1.5 is NEVER re-executed on a resume that has an existing manifest with a workspace_scope key present (null or not) — re-running Step 1.5 would re-call GET /workspaces and risk re-asking the user a question already answered, and more importantly risks the user picking a DIFFERENT workspace for what is supposed to be a continuation of the SAME capture, silently mixing scopes across the /activity data already on disk (captured under the original scope) and a freshly-scoped /analytics/query retry. A manifest with no workspace_scope key at all (pre-this-fix) has no recorded scope to restore — treat $WORKSPACE_ID as unset for the retry (same as today's behavior), since there is no reliable value to recover; this is a narrow, acknowledged gap for manifests written before this fix, not a new design decision this fix needs to solve further.

  Auth-failure handling on this row mirrors Step 2d's existing /activity mid-table-failure branch, not the probe's: this call is NOT the probe (that's still /credits), so a 401/403 here is a mid-table failure — record failed for this row and continue (do not print KEY_INVALID, do not abort, do not delete the key file). A 403 specifically, on a key that already passed the /credits probe and succeeded on /activity, is a confirmed management/provisioning key already — treat it as a transient/anomalous failure, not a key-validity signal, and fall into the standard retry-on-next-invocation behavior below. On 429, wait 30 seconds and retry once (same rule as the /credits probe). Unlike /activity, a failed or skipped status on this row is NOT terminal for the whole source — /activity's data alone is still sufficient to write a profile; a failed Analytics call only means cost_provenance falls back to "unknown" everywhere (Step 3), not that Step 3 is skipped.

2d. Run the script, then delete it. Record results in $MIGRATION_DIR/openrouter-capture/manifest.json:

{
  "captured_at": "<ISO 8601 UTC>",
  "window_days": 30,
  "window_start_utc": "<ISO 8601 UTC, UTC-midnight-aligned>",
  "window_end_utc": "<ISO 8601 UTC, UTC-midnight-aligned>",
  "workspace_scope": null,
  "provisioning_key_sha256": "<sha256 of .openrouter-key-env contents — fingerprint only>",
  "captures": [
    { "endpoint": "<row endpoint>", "file": "<file>", "status": "ok|failed|skipped", "note": null }
  ]
}

workspace_scope is written on EVERY manifest write in this step (the initial write and any retry-driven re-write), not only after a successful full capture — this is the SAME persistence timing already used for window_start_utc/window_end_utc above, and for the same reason: a capture interrupted after this write but before Step 3 must leave enough state on disk for a resumed Analytics-only retry (Step 2's retry path, entered directly without re-running Step 1.5) to reuse the EXACT SAME scope rather than defaulting to unset/account-wide. Value is null when Step 1.5 was skipped (≤1 workspace) or the user explicitly chose [A] All workspaces — both are deliberate "no scoping" outcomes, recorded as an explicit null, never an absent field — or { "workspace_id": "<id>", "workspace_name": "<name>" } when $WORKSPACE_ID was set via [B]. A manifest written by a version of this file that predates this field has NO workspace_scope key at all — that absence means "pre-this-fix manifest," not "account-wide," and callers must not conflate the two (see this file's Step 2 resume rules and discover.md's re-entry check for how an old manifest without window_start_utc/window_end_utc is already handled the same way; workspace_scope's absence is diagnosed identically).

Every attempted or deliberately skipped call gets an entry. /activity's status is special — unlike /key (optional context, skipped is harmless), /activity is the ONLY source of per-model rows, so its status determines whether this source produces anything at all:

If the /activity row's status is failed (a mid-table failure, e.g. a 500 — distinct from the 401/403 probe failure above, which never reaches this step): still write the manifest as shown (so a resumed run can tell what was already tried), but do not proceed to Step 3, and do not delete the key file yet — the key is still valid (the probe succeeded), and a resumed run needs it to retry. Tell the user: "OpenRouter usage discovery captured credits but the usage endpoint (/activity) failed (<note>) — no per-model signal to build a profile from. I'll retry it if you ask me to continue OpenRouter discovery again, or you can skip it for this run."

If the user chooses to skip (either right after this failure, or on a later resume): update the /activity entry's status to skipped in the existing manifest. This is a terminal, omitted-source outcome, not an alternate path into Step 3 — there is no activity.json to parse, so nothing downstream of here runs: do not execute Step 3, do not write openrouter-usage-profile.json, and do not touch ai-workload-profile.json. Delete the key file (per Step 4's cleanup) since capture is now finished for this run. Tell the user OpenRouter usage discovery was skipped for this run and no profile was produced — a later resume must not retry it or re-ask for consent (the manifest's skipped status is what records that this was a deliberate choice, not an unattempted capture).

A subsequent invocation of this file MUST check for these specific outcomes, not just manifest presence: read the existing manifest first.

• /activity entry's status is failed → retry ONLY that row (reusing the existing key file and the other rows' already-good captures rather than re-running Step 0–2b from scratch), update its entry to ok/failed in place, and only then either proceed to Step 3 (on ok) or repeat this same stop-and-offer-retry behavior (on another failed), or record skipped and stop per the paragraph above (if the user now chooses to abandon it).

• /activity entry's status is skipped → this run already made its decision; exit cleanly with no output and no re-ask, exactly like a Step 1 consent decline. Do NOT proceed to Step 3 — there is still no activity.json.

• /activity entry's status is ok → proceed to Step 3 as normal (the only status where a real capture exists to parse).

Analytics resume is selected by output file, not by the shared endpoint. Three captures POST /analytics/query. The classification row is the captures[] item whose file is analytics.json. analytics-volume.json and analytics-hourly.json are optional. An older manifest with one /analytics/query item and no file field is the classification row; do not invent volume or hourly retries for it. A resumed run can have /activity: ok, classification ok, volume failed, and hourly ok at once. Retry only the failed file. Never treat a later /analytics/query row as the classification row.

• /analytics/query entry's status is failed → retry ONLY that row when its file is analytics.json (classification). On the next invocation, reusing the manifest's recorded window_start_utc/window_end_utc for the retry's time_range (per Step 2c row 4's retry rule above), not a fresh now-based timestamp and not a freshly re-derived UTC midnight. Keep the key file while this retry is pending.

• Classification skipped → leave cost_provenance: "unknown" permanently for this run; do not re-ask, do not retry.

• Classification ok → proceed with classification as normal.

• Optional analytics-volume.json or analytics-hourly.json failed → that file is a terminal omission for this run. Do not retry it. The key is deleted once /activity and classification are terminal, so a later resume has no key to repeat the call. Do not block Step 3, classification, or key deletion on an optional file. A failed hourly file leaves the daily Activity totals in place and records a peak-only warning. A failed volume file leaves Activity token totals in place and marks the Analytics volume fields unknown.

Delete the key file once /activity reaches a terminal ok/skipped state (per Step 4's cleanup) — never while a retry is still live (a failed status with no user decision yet).

Step 3: Parse Captures into the Usage Profile

Workspace scope was already applied at capture time, not here. When $WORKSPACE_ID was set in Step 1.5, the /activity call in Step 2 carried &workspace_id=$WORKSPACE_ID, so activity.json's rows are already filtered to that workspace by the API itself — usage_by_model[] reflects only the selected workspace's activity, and no additional client-side filtering by workspace is needed or correct here. Group-and-sum below operates on whatever rows activity.json contains, scoped or not.

Sum across the window (a throwaway extraction script if captures are large):

Both OpenRouter responses wrap their payload in a top-level data key — unwrap data before reading anything below. /activity returns { "data": [ { "date", "model", "usage", ... } ] } (an array under data); /credits returns { "data": { "total_credits", "total_usage" } } (an object under data). /analytics/query is wrapped an EXTRA level deep — { "data": { "data": [ { "model", "byok_usage", "openrouter_usage" } ], "metadata": {...} } } — unwrap data.data for the row array, not just data (do not conflate this with /activity//credits's single-level unwrap above). Reading the response body's top level directly yields nothing and would produce a profile of zeros that still (wrongly) passes the monthly_cost_usd == sum of rows self-check.

• Activity (activity.json): group the rows in data[] by model; per model sum requests, prompt_tokens, completion_tokens, reasoning_tokens, and usage (USD). monthly_cost_usd = the sum of usage over the window — never scale a partial window up to a month. If the first non-zero date is < 30 days old, set partial_window: true and report the actual span in active_days.

• Credits (credits.json): read data.total_credits / data.total_usage (lifetime figures) — record them as context, NOT as the monthly baseline (the monthly figure comes from /activity summed over the window), and always account-wide: /credits has no workspace filter parameter, so this figure is never workspace-scoped even when $WORKSPACE_ID is set — label it plainly as account-wide wherever it is surfaced (see Step 4's report line).

• Stale-lifetime-usage check (live-verified — this happens on a real account, not a hypothetical edge case). If data[] is EMPTY (zero /activity rows — active_days: 0) but credits.data.total_usage > 0: the account has genuine historical spend that predates the 30-day window (or predates this provisioning key). Do not let this read as "confirmed zero spend" — that is a different, stronger claim than "no spend in the last 30 days," and the two are not distinguishable from monthly_cost_usd: 0 alone. Append to metadata.capture_warnings: "activity empty but credits.total_usage is $<total_usage> lifetime — spend exists outside the 30-day window; per-model attribution unavailable". summary.monthly_cost_usd still correctly reports 0 (that IS the accurate figure for the last 30 days — do not backfill it from the lifetime total, which has no per-model breakdown to attribute), but the warning is what tells a reader "$0 last 30 days" is not the same fact as "$0 ever."

• cost_provenance — now derived from /analytics/query's per-model byok_usage/openrouter_usage rows (analytics.json), not left "unknown" (prior limitation, now resolved). /activity's row shape still carries no BYOK-vs-credits signal on its own — that limitation is unchanged — but /analytics/query (Step 2c row 4) now supplies the signal /activity lacks: byok_usage is BYOK inference cost in USD, openrouter_usage is non-BYOK (credits-billed) inference cost in USD, both keyed by model over the SAME 30-day window as /activity.

  Build a model → { byok_usage, openrouter_usage } map from analytics.json keyed by the Analytics response's own model field — Analytics returns this in PERMASLUG form (e.g. openai/gpt-4.1-2025-04-14), not the short public id. The join key is /activity's model_permaslug field, not its model field — /activity rows carry both (Step 2c row 2: model, the short public id, and model_permaslug, the versioned/pinned id Analytics' model dimension actually returns). Joining on /activity's model field instead silently fails to match for any model whose permaslug differs from its short id — i.e. most actively-used models, which get re-dated releases — leaving them wrongly classified "unknown" with their real BYOK/non-BYOK split lost.

  For each /activity row, look up its model_permaslug in the Analytics map and classify using a $0.005 (half-cent) threshold — chosen to absorb float/display rounding noise without swallowing genuine low-but-real BYOK spend:

  • byok_usage > 0.005 AND openrouter_usage <= 0.005 → "byok_passthrough"

  • byok_usage > 0.005 AND openrouter_usage > 0.005 → "mixed"

  • byok_usage <= 0.005 AND openrouter_usage > 0.005 → "no_byok" (positive confirmation of no BYOK overlap — NOT the same as "no signal")

  • both <= 0.005 → "unknown" (no signal either way)

  A /activity row whose model_permaslug is ABSENT from the Analytics map also gets "unknown" (nothing to classify it with). A model present only in Analytics but not /activity is dropped silently — it has no /activity row to attach cost_provenance to.

  Roll the per-permaslug classification back up to the short model id — usage_by_model[].model stays in whatever short form it already uses; model_permaslug is a join key only and never leaks into the output. If the SAME short model id has multiple model_permaslug values across different /activity rows (differing dated releases observed in the same 30-day window), classify and sum each permaslug's byok_usage/ openrouter_usage independently (per the thresholds above), then combine into ONE usage_by_model[] row per short model id: sum monthly_cost_usd/token figures across the permaslug rows as already specified (never double-count a short model id's dollars by summing the same permaslug twice), and compute that row's single cost_provenance with the same precedence the profile-level rollup below already uses — any permaslug "mixed" → "mixed"; all permaslug-rows "byok_passthrough" and none "no_byok"/"mixed" → "byok_passthrough"; a mix of "byok_passthrough" and "no_byok" permaslug-rows → "mixed" (the short model id has BOTH BYOK-overlapping and non-overlapping spend, same reasoning as a single-row "mixed"); all permaslug-rows "no_byok" → "no_byok"; all permaslug-rows "unknown" → "unknown"; a mix including "unknown" alongside a classified value ("byok_passthrough", "no_byok", or "mixed") → "uncertain" — a NEW classification distinct from both the classified values and from plain "unknown". Do NOT let the classified value silently win: an unknown permaslug carries real /activity token/dollar volume with NO verified BYOK signal, and letting a classified sibling permaslug's label stand for the whole model either double-counts that volume (if the model is then treated as no_byok and summed as if fully confirmed) or silently drops it (if a consumer treats unknown rows as zero-weight). Still sum every contributing permaslug's tokens/dollars into the combined row — classification never excludes a permaslug's usage from the sum, only labels its provenance confidence. Append a metadata.capture_warnings entry for every model that resolves to "uncertain": "<model>: cost_provenance uncertain — at least one contributing permaslug has no Analytics signal; token/dollar totals include its usage but its BYOK-vs-credits split is unverified". Do not just take the last-seen permaslug's classification.

  Write this as usage_by_model[].cost_provenance (per model, see schema below). Then roll it up to metadata.cost_provenance (profile-level, kept for backward compatibility with code that only reads the top-level field), computed over models with nonzero /activity usage in the window:

  • all classified "byok_passthrough" → profile-level "byok_passthrough"

  • all classified "no_byok" → profile-level "no_byok"

  • any model "mixed", or a mix of byok_passthrough/mixed/no_byok across models → profile-level "mixed"

  • some models classified (any of byok_passthrough/mixed/no_byok) and at least one other model "unknown" (not every model, which is the next bullet) → profile-level "mixed" — the profile has at least one model carrying a real BYOK-overlap risk, so "unknown" would understate it. Do NOT use "unknown" just because one model's row couldn't be classified.

  • any model "uncertain" → profile-level "mixed" (same reasoning as the existing "some classified + at least one unknown" bullet above — an uncertain model still carries unresolved BYOK-overlap risk that a blanket "unknown" would understate).

  • the Analytics query itself failed (Step 2c row 4 status: "failed" or "skipped" in the manifest), or every classifiable model is "unknown" → profile-level "unknown", AND set every model's usage_by_model[].cost_provenance to "unknown" too, AND append a metadata.capture_warnings entry ("analytics.json <failed|skipped> — cost_provenance is unknown for all models"). Do NOT fail Step 3 or skip writing the profile in this case — /activity data is still valid and must still be written.

Volume, fee, latency, and peak (rows 5–6), joined onto the short model id. Analytics model is the permaslug. Join to /activity's model_permaslug, then roll up to the short usage_by_model[].model the same way cost provenance does. Sum cached_tokens, byok_fees (write byok_fees_usd), byok_request_count, usage_web (write web_search_cost_usd), and guardrail_invoked_count across permaslugs of one short id. Do not overwrite requests from /activity; write the Analytics request count as analytics_request_count. cached_tokens is a subset of prompt tokens — do not add it on top of prompt_tokens. For p95_latency_ms, take the max across permaslugs (the slower one). For p95_throughput_tokens_per_sec, take the min across permaslugs (the slower one). These are observed figures for the window, not a customer SLO. Do not split a mixed model's tokens or inference dollars using byok_request_count / request_count. That ratio may be disclosed; it is not a volume split. From row 6, sum hourly tokens across permaslugs of one short id, then write peak the same way as the OpenAI profile with peak_source "hour" (the maximum hour anywhere in the window, divided by 60). If row 6 is missing or truncated, use the busiest day in activity.json, null the per-minute fields, and set peak_source "day".

Write $MIGRATION_DIR/openrouter-usage-profile.json. Note on the example below: usage_by_model[].model is the short public id (e.g. "openai/gpt-4.1") — the join to Analytics that produced each row's cost_provenance happened on /activity's model_permaslug field, not on this model field; do not copy this example's apparent model-keyed shape into the join logic above.

{
  "metadata": {
    "report_date": "2026-08-21",
    "source": "openrouter_usage_api",
    "captured_at": "<from manifest>",
    "window_days": 30,
    "active_days": 30,
    "partial_window": false,
    "cost_provenance": "mixed",
    "credits_lifetime": { "total_credits": 100.5, "total_usage": 25.75 },
    "workspace_scope": null,
    "capture_warnings": ["key.json skipped (403)"]
  },
  "summary": {
    "monthly_cost_usd": 105.03,
    "currency": "USD",
    "models_seen": 5,
    "total_requests": 2856
  },
  "usage_by_model": [
    {
      "model": "openai/gpt-4.1",
      "provider_name": "OpenAI",
      "requests": 452,
      "prompt_tokens": 1300000,
      "completion_tokens": 145000,
      "reasoning_tokens": 0,
      "monthly_cost_usd": 41.61,
      "cost_provenance": "no_byok",
      "cached_tokens": 200000,
      "byok_fees_usd": 0,
      "byok_request_count": 0,
      "analytics_request_count": 452,
      "p95_latency_ms": 840,
      "p95_throughput_tokens_per_sec": 62,
      "web_search_cost_usd": 0,
      "guardrail_invoked_count": 0,
      "peak": {
        "busiest_day": "2026-08-12",
        "day_input_tokens": 80000,
        "day_output_tokens": 9000,
        "day_requests": 40,
        "day_to_average_ratio": 1.8,
        "peak_input_tokens_per_minute": 55,
        "peak_output_tokens_per_minute": 6,
        "peak_requests_per_minute": 0.4,
        "peak_source": "hour|day"
      }
    },
    {
      "model": "anthropic/claude-sonnet-4",
      "provider_name": "Anthropic",
      "requests": 180,
      "prompt_tokens": 900000,
      "completion_tokens": 90000,
      "reasoning_tokens": 0,
      "monthly_cost_usd": 63.42,
      "cost_provenance": "byok_passthrough"
    }
  ]
}

cost_provenance enum (both metadata.cost_provenance and usage_by_model[].cost_provenance): "byok_passthrough" | "mixed" | "no_byok" | "uncertain" | "unknown". no_byok is a positive-signal classification distinct from unknown (no-signal) — the llm-to-bedrock/SKILL.md consumer treats them differently (see that file's Step 1.5). uncertain is distinct from both: it means at least one contributing permaslug classified AND at least one other had no Analytics signal — the model's tokens/dollars are fully included in the totals, but its BYOK-vs-credits split is only partially verified.

usage_by_model sorted descending by prompt_tokens + completion_tokens. Include only models with non-zero usage. metadata.capture_warnings carries every failed/skipped manifest entry (empty array when all rows succeeded) — the same convention as the OpenAI usage path — so downstream phases can tell a failed capture (UNKNOWN volume) from a genuinely unused one (zero). Name the output file in every warning. A warning for analytics-hourly.json means the peak is uncertain. It does not make the daily volume or the daily cost UNKNOWN. A failed analytics.json still makes classification unknown. A failed analytics-volume.json leaves Activity token totals in place and marks the Analytics volume fields unknown. Validate: valid JSON, summary.monthly_cost_usd equals the sum of usage_by_model[].monthly_cost_usd (± rounding).

metadata.workspace_scope is null when the capture was unscoped (today's default, all workspaces) or { "workspace_id": "<id>", "workspace_name": "<name>" } when $WORKSPACE_ID was set in Step 1.5. This retains the selected scope in the written profile so downstream consumers (Clarify, Estimate, llm-to-bedrock/SKILL.md Step 1.5) can tell a workspace-scoped baseline from an account-wide one.

Step 4: Merge into the AI Workload Profile (if it exists), Then Clean Up

If $MIGRATION_DIR/ai-workload-profile.json exists (from app-code or IaC discovery), update it — the API data is authoritative for OpenRouter spend and volume:

1. metadata.sources_analyzed.openrouter_usage_api = true.

2. current_costs — provider-aware merge, the same rule as the OpenAI usage path:

   • No existing current_costs → set { "monthly_ai_spend": <summary.monthly_cost_usd>, "services_detected": ["OpenRouter"], "source": "openrouter_usage_api" }.

   • Existing costs for a DIFFERENT provider (e.g. a billing CSV captured Vertex spend, or the OpenAI usage path captured OpenAI-direct spend) → SUM the providers: source: "mixed", and record the per-provider split in breakdown[] ({ "provider": "openrouter", "monthly_spend": X, "source": "openrouter_usage_api" }, plus the other provider's entry). OpenRouter is a router — its spend already includes the upstream providers it fronts, so do NOT also add a separate "openai via openrouter" line; that would double-count.

   • Existing costs from the SAME source window → the API wins (source: "openrouter_usage_api"); move the displaced figure into current_costs.conflicting_sources[] — never silently resolved.

3. Append to detection_signals[]: { "method": "openrouter_usage_api", "pattern": "billed usage for <model>", "confidence": 0.99, "evidence": "<N> requests, <X> tokens in last 30d" } for each of the top 5 models by usage. (openrouter_usage_api is a live-usage detection method, parallel to openai_usage_api.)

4. These are two INDEPENDENT checks over every usage_by_model entry — run both, even for a model that already satisfies one of them (e.g. from an earlier run against a saved/retained ai-workload-profile.json). Checking workload presence only when the model was ALSO just added to models[] misses the case where a prior run (or a resumed one reusing an existing profile) already inserted the model row without its workload row, or where a resume merges a retained profile that already has the model from a DIFFERENT capture pass.

   a. Model row: for any usage_by_model model absent from models[], append { "model_id": "<model>", "service": "openrouter_api", "detected_via": ["usage_api"], "evidence": [{ "source": "usage_api", "pattern": "billed usage in last 30 days" }], "capabilities_used": ["text_generation"], "usage_context": "Observed in OpenRouter usage data — call sites not yet located in code" }. Code-derived entries always win on conflict; usage-only entries tell Clarify what the code scan missed (a model routed at runtime but not literal in the source). b. Workload row: for any usage_by_model model with NO workloads[] entry whose model_id matches it AND sdk_method: "usage_api" — checked by model identity alone, regardless of whether step (a) just inserted its models[] row this pass or the row was already present from before — append {workload_id: "wl_" + sha256(model_id + "|usage_api|plain")[:6], model_id: "<model>", sdk_method: "usage_api", capability: "text_generation", capability_confidence: "low", structured_output: false, call_sites: [{"file": "<usage_api>", "line": 0}]} (per schema-discover-ai.md § workloads[] "Usage-only workloads"). Without this, the model can exist in models[] with no corresponding workloads[] entry — Clarify's multi-workload confirmation table and Design's per-workload iteration both read workloads[], not models[], so a usage-only model present only in models[] is never surfaced for confirmation and never gets a design_block. Before appending, confirm no existing workloads[] entry already has this exact workload_id (the sha256 is deterministic per model, so a second merge of the same model naturally collides on it instead of duplicating).

   Recompute summary.total_models_detected to include any (a) addition (it counts models[] length, not just code-derived models).

5. If summary.ai_source does not already reflect the OpenRouter-fronted providers, leave it as the code scan set it — OpenRouter is a transport, and ai_source is about the source SDK/provider family, which the code scan owns.

If ai-workload-profile.json does NOT exist, Clarify and Estimate read openrouter-usage-profile.json directly for spend and volumes — but it is a supplement, not an anchor: the run still needs at least one primary artifact (resource inventory, AI workload profile, or billing profile) to pass the Discover handoff gate.

Clean up (default, not optional, but gated on BOTH rows being terminal): before deleting anything, confirm the manifest's /activity entry is ok or skipped AND the classification /analytics/query entry is ok or skipped (file is analytics.json, or the sole /analytics/query entry when file is absent). Optional analytics-volume.json and analytics-hourly.json failures do not keep the key. If classification is still failed, do NOT delete the key file here — tell the user: "OpenRouter Analytics classification is still pending a retry — keeping the key file until that resolves." Do not proceed with the rest of this Step 4 merge while that retry is pending. Only once /activity and classification are terminal: delete $MIGRATION_DIR/.openrouter-key-env now — the key is no longer needed. (This is the happy-path cleanup point; a 401/403 on the probe deletes it immediately at that point instead, per Step 2b, since a rejected key has nothing left to retry.) Tell the user it was deleted and that they can also revoke the provisioning key at openrouter.ai/settings/provisioning-keys if it was created just for this run.

Report: "OpenRouter usage discovery: $X/month across N models (window: 30 days[, partial: only M active days])[, scoped to workspace '<name>']." When $WORKSPACE_ID was set, append the workspace-scope clause above AND ", lifetime credits figures remain account-wide" — so the workspace-scoped monthly figure and the account-wide lifetime credits are never conflated in the one message. If metadata.capture_warnings is non-empty (including the stale-lifetime-usage case above), append it plainly — e.g. "Note: no billed usage in the last 30 days, but your account shows $<total_usage> in lifetime usage — that spend falls outside this window and isn't reflected in the figure above." Do NOT let a $0/month report stand unqualified when a capture warning says otherwise; the warning is what distinguishes "confirmed no recent spend" from "confirmed no recent spend, but real spend exists we can't attribute to a model."

The parent discover.md owns the phase status update — do not touch .phase-status.json here.

Scope Boundary

This fragment covers OpenRouter usage capture ONLY.

FORBIDDEN — Do NOT include ANY of:

• AWS service names, recommendations, or Bedrock equivalents

• Migration strategies, phases, timelines, cost estimates, or effort estimates

• Any chat/completion//generation call, any HTTP method other than GET EXCEPT the one read-only POST /analytics/query aggregate query, or any key printing

• Prompt or completion CONTENT anywhere

Your ONLY job: capture aggregate OpenRouter usage. Nothing else.