After every Copilot CLI upgrade, run these checks to verify session-recall still works with the new schema.
After every npm i -g @github/copilot or brew upgrade copilot-cli.
copilot --versioncp ~/.copilot/session-store.db ~/.copilot/session-store.db.bak-$(date +%Y%m%d)npm i -g @github/copilot
# or: brew upgrade copilot-clicopilot --versioncd auto-memory && session-recall schema-checkIf this fails with exit code 2:
- Schema drift detected. The Copilot CLI upgrade changed the DB schema.
- Run
sqlite3 ~/.copilot/session-store.db '.schema sessions'to see the new schema. - Update
EXPECTED_SCHEMAinsrc/session_recall/db/schema_check.pyto match. - Or rollback:
npm i -g @github/copilot@<old-version>
session-recall list --json | python3 -c "import sys,json; d=json.load(sys.stdin); print(f'{d[\"count\"]} sessions')"session-recall health --json | python3 -c "import sys,json; d=json.load(sys.stdin); print(f'overall: {d[\"overall_score\"]}')"Append to ~/.copilot/upgrade-log.md:
## YYYY-MM-DD — Copilot CLI vX.Y.Z → vA.B.C
- schema-check: PASS/FAIL
- list: PASS/FAIL
- health: PASS/FAIL (score: N.N)
- Pin previous version:
npm i -g @github/copilot@<old-version> - Open an issue or update
EXPECTED_SCHEMAinschema_check.py - Do NOT use the new Copilot CLI with a broken
session-recall