session-recovery Skill

Source

• Creator: microsoft
• Repository: microsoft/aitour26-BRK445-building-enterprise-ready-ai-agents-with-microsoft-foundry
• Skill file: .copilot/skills/session-recovery/SKILL.md

What it does

Find and resume interrupted Copilot CLI sessions using sessionstore queries

Skill instructions

Context Squad agents run in Copilot CLI sessions that can be interrupted — terminal crashes, network drops, machine restarts, or accidental window closes. When this happens, in-progress work may be left in a partially-completed state: branches with uncommitted changes, issues marked in-progress with no active agent, or checkpoints that were never finalized. Copilot CLI stores session history in a SQLite database called sessionstore (read-only, accessed via the sql tool with database: "sessionstore"). This skill teaches agents how to query that store to detect interrupted sessions and resume work. Patterns 1. Find Recent Sessions Query the sessions table filtered by time window. Include the last checkpoint to understand where the session stopped: sql SELECT s.id, s.summary, s.cwd, s.branch, s.updatedat, (SELECT title FROM checkpoints WHERE sessionid = s.id ORDER BY checkpointnumber DESC LIMIT 1) AS lastcheckpoint FROM sessions s WHERE s.updatedat = datetime('now', '-24 hours') ORDER BY