Session History Skill

When the user asks a question that might be informed by prior work (e.g. "what does this code do", "why did we decide to do it this way", "how was this implemented", "explain this", "what's the history/context"), query the opencode session database before answering. This avoids making assumptions or guess-based explanations.

Data model

Database: ~/.local/share/opencode/opencode.db (SQLite)

project (id, worktree, name)
  └── session (id, project_id, directory, title, time_created, model, agent)
        └── message (id, session_id, data)  -- data is JSON {role, agent, model}
              └── part (id, message_id, session_id, data)  -- data is JSON {type, text}