Jiang Bohan 8a8d3ea20e feat(usage): add per-task token usage tracking ...

Extract token usage from Claude Code's stream-json output in real-time
during task execution, replacing the inaccurate global JSONL log scanner.

- New `task_usage` table: tracks (task_id, provider, model) level usage
- Agent SDK: parse `message.usage` from assistant messages, accumulate
  per-model and return in Result
- Daemon: convert agent usage to entries, send with CompleteTask
- Server: store usage on task completion, expose workspace-level
  aggregation APIs (GET /api/usage/daily, GET /api/usage/summary)

2026-04-08 13:08:15 +08:00

..

001_init.down.sql

…

001_init.up.sql

refactor: remove repository field from issues

2026-03-24 18:12:06 +08:00

002_agent_config.down.sql

…

002_agent_config.up.sql

…

003_task_context.down.sql

feat(server): add task service layer and daemon REST protocol

2026-03-23 18:34:51 +08:00

003_task_context.up.sql

feat(server): add task service layer and daemon REST protocol

2026-03-23 18:34:51 +08:00

004_agent_runtime_loop.down.sql

feat(runtime): add local codex daemon pairing

2026-03-24 12:03:14 +08:00

004_agent_runtime_loop.up.sql

feat(runtime): add local codex daemon pairing

2026-03-24 12:03:14 +08:00

005_daemon_pairing.down.sql

feat(runtime): add local codex daemon pairing

2026-03-24 12:03:14 +08:00

005_daemon_pairing.up.sql

feat(runtime): add local codex daemon pairing

2026-03-24 12:03:14 +08:00

006_workspace_context.down.sql

feat(workspace): add context field for AI agent background info

2026-03-24 15:59:11 +08:00

006_workspace_context.up.sql

feat(workspace): add context field for AI agent background info

2026-03-24 15:59:11 +08:00

007_drop_issue_repository.down.sql

refactor: remove repository field from issues

2026-03-24 18:12:06 +08:00

007_drop_issue_repository.up.sql

refactor: remove repository field from issues

2026-03-24 18:12:06 +08:00

008_structured_skills.down.sql

feat: structured skills system with meta skill runtime injection

2026-03-25 15:17:59 +08:00

008_structured_skills.up.sql

feat: structured skills system with meta skill runtime injection

2026-03-25 15:17:59 +08:00

009_verification_code.down.sql

feat(auth): email verification login and personal access tokens

2026-03-26 14:32:30 +08:00

009_verification_code.up.sql

feat(auth): email verification login and personal access tokens

2026-03-26 14:32:30 +08:00

010_verification_code_attempts.down.sql

feat(auth): email verification login and personal access tokens

2026-03-26 14:32:30 +08:00

010_verification_code_attempts.up.sql

feat(auth): email verification login and personal access tokens

2026-03-26 14:32:30 +08:00

011_personal_access_tokens.down.sql

feat(auth): email verification login and personal access tokens

2026-03-26 14:32:30 +08:00

011_personal_access_tokens.up.sql

feat(auth): email verification login and personal access tokens

2026-03-26 14:32:30 +08:00

012_inbox_actor.down.sql

fix(db): renumber inbox_actor migration to resolve 009 conflict

2026-03-26 15:44:10 +08:00

012_inbox_actor.up.sql

fix(db): make inbox_actor migration idempotent

2026-03-26 17:17:23 +08:00

013_runtime_usage.down.sql

feat(runtimes): add Runtimes tab with usage tracking and connection test

2026-03-26 18:28:36 +08:00

013_runtime_usage.up.sql

feat(runtimes): add Runtimes tab with usage tracking and connection test

2026-03-26 18:28:36 +08:00

014_workspace_repos.down.sql

feat(workspace): add repos JSONB field for GitHub repository URLs

2026-03-27 15:49:30 +08:00

014_workspace_repos.up.sql

feat(workspace): add repos JSONB field for GitHub repository URLs

2026-03-27 15:49:30 +08:00

015_issue_subscriber.down.sql

feat(notifications): replace hardcoded inbox notifications with subscriber-driven model

2026-03-28 19:33:20 +08:00

015_issue_subscriber.up.sql

feat(notifications): replace hardcoded inbox notifications with subscriber-driven model

2026-03-28 19:33:20 +08:00

016_backfill_subscribers.down.sql

feat(notifications): replace hardcoded inbox notifications with subscriber-driven model

2026-03-28 19:33:20 +08:00

016_backfill_subscribers.up.sql

fix(notifications): address code review feedback

2026-03-28 20:24:07 +08:00

017_comment_parent_id.down.sql

feat(activity): unified activity timeline with comment reply support

2026-03-28 21:53:08 +08:00

017_comment_parent_id.up.sql

feat(activity): unified activity timeline with comment reply support

2026-03-28 21:53:08 +08:00

018_comment_parent_cascade.down.sql

fix(comments): cascade delete replies in DB when parent comment is deleted

2026-03-28 22:04:35 +08:00

018_comment_parent_cascade.up.sql

fix(comments): cascade delete replies in DB when parent comment is deleted

2026-03-28 22:04:35 +08:00

019_inbox_details.down.sql

feat(inbox): add priority/due_date notifications, structured details, and hover card

2026-03-29 00:22:17 +08:00

019_inbox_details.up.sql

feat(inbox): add priority/due_date notifications, structured details, and hover card

2026-03-29 00:22:17 +08:00

020_issue_number.down.sql

feat(issues): add human-readable issue identifiers (e.g. JIA-1)

2026-03-29 16:49:55 +08:00

020_issue_number.up.sql

feat(issues): add human-readable issue identifiers (e.g. JIA-1)

2026-03-29 16:49:55 +08:00

020_task_session.down.sql

feat(agent): add per-task session persistence for Claude Code resumption

2026-03-29 16:53:28 +08:00

020_task_session.up.sql

feat(agent): add per-task session persistence for Claude Code resumption

2026-03-29 16:53:28 +08:00

021_agent_instructions.down.sql

feat(agent): add instructions field for agent persona/identity

2026-03-29 17:01:07 +08:00

021_agent_instructions.up.sql

feat(agent): add instructions field for agent persona/identity

2026-03-29 17:01:07 +08:00

022_task_lifecycle_guards.down.sql

feat(tasks): add coalescing queue and task lifecycle guards

2026-03-29 17:52:35 +08:00

022_task_lifecycle_guards.up.sql

feat(tasks): add coalescing queue and task lifecycle guards

2026-03-29 17:52:35 +08:00

023_agent_concurrency_default.down.sql

fix(daemon): prevent stuck tasks from blocking queue and add concurrent execution

2026-03-30 03:08:52 +08:00

023_agent_concurrency_default.up.sql

fix(daemon): prevent stuck tasks from blocking queue and add concurrent execution

2026-03-30 03:08:52 +08:00

024_backfill_empty_issue_prefix.down.sql

fix(handler): set issue_prefix when auto-creating workspace on first login

2026-03-30 13:26:42 +08:00

024_backfill_empty_issue_prefix.up.sql

fix(handler): set issue_prefix when auto-creating workspace on first login

2026-03-30 13:26:42 +08:00

025_comment_workspace_id.down.sql

feat(api): strict workspace isolation + agent parity fixes

2026-03-30 16:49:13 +08:00

025_comment_workspace_id.up.sql

feat(api): strict workspace isolation + agent parity fixes

2026-03-30 16:49:13 +08:00

026_comment_reactions.down.sql

feat(reactions): add emoji reactions for comments and issue descriptions

2026-03-30 22:37:59 +08:00

026_comment_reactions.up.sql

feat(reactions): add emoji reactions for comments and issue descriptions

2026-03-30 22:37:59 +08:00

026_task_messages.down.sql

feat(agent): stream live agent output to issue detail page

2026-03-30 22:53:28 +08:00

026_task_messages.up.sql

feat(agent): stream live agent output to issue detail page

2026-03-30 22:53:28 +08:00

027_issue_reactions.down.sql

feat(reactions): add emoji reactions for comments and issue descriptions

2026-03-30 22:37:59 +08:00

027_issue_reactions.up.sql

feat(reactions): add emoji reactions for comments and issue descriptions

2026-03-30 22:37:59 +08:00

028_task_trigger_comment.down.sql

feat(agents): reply as thread instead of top-level comment (#205)

2026-03-31 13:48:39 +08:00

028_task_trigger_comment.up.sql

feat(agents): reply as thread instead of top-level comment (#205)

2026-03-31 13:48:39 +08:00

029_attachment.down.sql

feat(upload): add attachment table for tracking uploaded files

2026-03-31 15:29:41 +08:00

029_attachment.up.sql

feat(upload): add attachment table for tracking uploaded files

2026-03-31 15:29:41 +08:00

029_daemon_token.down.sql

fix(tests): merge main, renumber migration, fix execenv test assertions

2026-03-31 16:19:02 +08:00

029_daemon_token.up.sql

fix(tests): merge main, renumber migration, fix execenv test assertions

2026-03-31 16:19:02 +08:00

029_drop_daemon_pairing.down.sql

fix(auth): enforce auth on daemon API routes (#224)

2026-03-31 16:13:58 +08:00

029_drop_daemon_pairing.up.sql

fix(auth): enforce auth on daemon API routes (#224)

2026-03-31 16:13:58 +08:00

030_agent_default_private.down.sql

fix: merge main and renumber migration 028 → 030

2026-03-31 15:47:09 +08:00

030_agent_default_private.up.sql

fix: merge main and renumber migration 028 → 030

2026-03-31 15:47:09 +08:00

031_agent_archive.down.sql

feat(agent): replace hard delete with archive/restore (#346)

2026-04-02 17:33:52 +08:00

031_agent_archive.up.sql

feat(agent): replace hard delete with archive/restore (#346)

2026-04-02 17:33:52 +08:00

032_task_usage.down.sql

feat(usage): add per-task token usage tracking

2026-04-08 13:08:15 +08:00

032_task_usage.up.sql

feat(usage): add per-task token usage tracking

2026-04-08 13:08:15 +08:00