feat(plugin): persistent execution history database (SQLite) #827
Description
Purpose
Track execution history across sessions in SQLite — what was done, by which agent, cost, duration, outcome. Survives session restarts unlike MCP server state.
Changes
packages/codingbuddy-plugin/— SQLite database module- Schema: sessions, tool_calls, agent_activations, costs, pr_results
- Storage:
~/.codingbuddy/history.db
Supersedes
- feat: cross-session execution history (persistent tracking) #815 (cross-session execution history) — Plugin DB is naturally persistent
Acceptance Criteria
- SQLite DB at ~/.codingbuddy/history.db
- Record: session_id, timestamp, agent, task, tools_used, cost, outcome, pr_numbers
- Query via plugin API or MCP tool proxy
- Auto-cleanup configurable retention period