[Bug]: Usage page does not include OpenCode #7622

Before submitting

• I searched existing issues and did not find a duplicate.
• I included enough detail to reproduce or investigate the problem.

Area

apps/server, apps/web, packages/contracts, packages/shared

Steps to reproduce

1. Install and authenticate OpenCode (opencode auth login) and run a few sessions so ~/.local/share/opencode/opencode.db has assistant messages with token usage.
2. Start T3 Code from latest main (b2e2ccfd) and open the Usage page.
3. Select any window (Past 24h, 7 days, 30 days). Note totals and provider breakdown.

Expected behavior

Usage should include OpenCode alongside Claude Code and Codex. The page already reads provider CLIs own history so sessions started outside T3 Code still count. That is what ccusage does for Claude and Codex, and OpenCode should work the same way.

Actual behavior

Only claude and codex appear. UsageProviderKind is still ["claude", "codex"] and USAGE_CONTRACT_VERSION is 4 on main. OpenCode sends turn usage to the context meter, but the Usage page never scans opencode.db. The result is empty or understated totals for anyone who works through OpenCode, and no way to see that provider in charts, tables, or coverage reporting.

Related: closed #5706 described this gap for Grok and OpenCode. Three open PRs (#6040, #6014, #7221) propose the same provider, but none have landed on main.

Impact

Minor bug but frequent. Anyone using OpenCode alongside Claude or Codex sees incomplete cost and token numbers and cannot compare providers.

Version or commit

main @ b2e2ccf (2026-08-20)

Environment

Raspberry Pi OS, Node 26.5.0, OpenCode 1.0+, T3 Code web app via npx t3

Logs or stack traces

No error. UsageService only resolves ~/.claude/projects and ~/.codex/sessions. No source is reported for opencode, so the contract never emits that provider.

Workaround

Run opencode stats separately. That shows the same SQLite totals.

Contribution

I can help implement the scan. OpenCode stores usage in SQLite, not JSONL, so the server needs a read-only query against the message table rather than a file walk. Contract needs opencode added and version bumped to 5, and web and mobile need the label, color, and icon in PROVIDER_PRESENTATION.