skills.rest
Tyrizx
TyrizxOFFICIAL
Explore all skills by this author →
GitHub

chronicle

Analyze Copilot session history to generate standup reports, usage tips, and session search results.

Updated Aug 30, 2026
Search Tags:#vscode#sql#usage analysis#session history#copilot#session search#standup report
One-click install
npx skills add https://github.com/Tyrizx/Tyrizx --skill chronicle-tyrizx
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: chronicle
Source: https://github.com/Tyrizx/Tyrizx/tree/main/extensions/copilot/assets/prompts/skills/chronicle
Command: npx skills add https://github.com/Tyrizx/Tyrizx --skill chronicle-tyrizx

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Developers lose track of what they accomplished across Copilot chat sessions, making standups, workflow improvement, and cost optimization guesswork. This Skill queries the Copilot session store (local SQLite or cloud DuckDB) to turn raw session history into standup reports, personalized tips, and searchable records. ## Core Features & Use Cases - Standup Reports: Generate a daily standup from the last 24 hours of sessions, grouped by branch and feature, with PR status checked via GitHub CLI or MCP tools. - Usage & Cost Tips: Analyze prompting patterns, token usage, model mix, and compaction habits to produce 3-5 data-grounded recommendations for working more effectively and reducing token spend. - Session Search & Maintenance: Full-text search past sessions by keyword, file, or PR, reindex the session store, and get guidance on deleting session data. - Use Case: Before your morning standup, ask for a summary of yesterday's work and receive a formatted report of completed and in-progress features with linked PRs and session IDs. ## Quick Start Ask the assistant to generate a standup report from your Copilot session history for the last 24 hours.

Frequently Asked Questions about chronicle

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a standup report from Copilot chat history?▼

Ask for a standup or daily summary and the Skill queries the sessions table for the last 24 hours of activity, groups work by branch and feature, and checks PR status via GitHub CLI or MCP tools. Results are formatted as Done and In Progress sections with linked PRs and session IDs.

How to search past Copilot sessions by keyword or file?▼

Request a session search with your keyword and the Skill queries session summaries, conversation turns, file paths, and PR/issue references. Local stores use the FTS5 search_index table while cloud stores use ILIKE matching, with results grouped by repository.

Why is the copilot_sessionStoreSql tool not available?▼

The tool requires the github.copilot.chat.localIndex.enabled setting to be true in VS Code Settings. Enable this setting first, then the session store tool becomes available for querying and reindexing.

Does session history analysis work without cloud sync?▼

Yes, local SQLite storage supports standups, search, and usage tips, but per-event token usage data is only available on the cloud DuckDB backend. Enable chat.sessionSync.enabled for token-level cost analysis.

Can I delete my Copilot session data through this tool?▼

Deletion is intentionally not supported by the query tool to prevent accidental data loss. Use the Delete Session Sync Data command from the Command Palette to choose which sessions to remove from local storage and the cloud.

Related Skills

Explore More Software Engineering Skills→
jeff-hammjeff-hamm

session-archive

Archive, index, search, and recover Claude Code and Copilot chat sessions via CLI and SQLite index.

Community
Intermediate
CowboyLogicCowboyLogic

copilot-instruction-creator

Configure Copilot behavior with structured instruction files across scopes.

Official
Intermediate
yashodhahyashodhah

agent-customization

Manage and debug VS Code agent customization files like SKILL.md and AGENTS.md.

Community
Intermediate
GenEducationGenEducation

bmad-os-root-cause-analysis

Analyze bug-fix commits to produce structured root cause analysis reports.

Official
Advanced