skills.rest
mdjubaerhossensabbir
mdjubaerhossensabbirCOMMUNITY
Explore all skills by this author →
GitHub

chronicle

Analyze Copilot session history from SQLite or DuckDB databases.

Updated Jul 12, 2026
Search Tags:#workflow#analytics#productivity#reporting#sql#copilot
One-click install
npx skills add https://github.com/mdjubaerhossensabbir/Hiar_Jubba --skill chronicle-mdjubaerhossensabbir
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: chronicle
Source: https://github.com/mdjubaerhossensabbir/Hiar_Jubba/tree/main/chronicle
Command: npx skills add https://github.com/mdjubaerhossensabbir/Hiar_Jubba --skill chronicle-mdjubaerhossensabbir

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill solves the problem of fragmented and forgotten development history by providing a structured way to analyze, search, and report on past Copilot sessions, helping developers maintain context and improve efficiency.

Core Features & Use Cases

  • Standup Reporting: Automatically generates daily summaries of work completed, including PR status and key file changes.
  • Workflow Optimization: Analyzes prompting patterns and tool usage to provide actionable tips for better Copilot interaction.
  • Session Search: Enables keyword-based retrieval of past sessions across repositories, branches, and conversation turns.

Quick Start

Ask the chronicle skill to generate a standup report for your activity over the last twenty-four 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 daily standup report from my Copilot session history?▼

You can generate a daily standup report from your Copilot session history by querying local SQLite or cloud DuckDB databases to summarize PR status and key file changes over a specific timeframe.

Can I search past VS Code chat sessions by keyword across different repositories?▼

Yes, you can search past VS Code chat sessions by keyword across repositories and branches by querying session metadata and conversation turns stored in your local SQLite database.

How do I analyze Copilot prompting patterns to optimize my development workflow?▼

You can analyze Copilot prompting patterns to optimize your development workflow by examining tool usage and conversation turns to identify actionable tips for better interaction and cost-saving opportunities.

Do I need localIndex configuration to run read-only queries on Copilot session data?▼

Yes, you need localIndex configuration and the copilot_sessionStoreSql tool to execute read-only queries against session metadata stored in your SQLite or DuckDB databases.

Does chronicle work with both local SQLite and cloud DuckDB databases for session analytics?▼

Chronicle works with both local SQLite and cloud DuckDB databases to provide Copilot session analytics, operating across VS Code chat, CLI, and custom agent surfaces.

What's the best way to retrieve past Copilot CLI conversation turns for activity summaries?▼

The best way to retrieve past Copilot CLI conversation turns for activity summaries is by running read-only SQL queries against your stored session metadata using the copilot_sessionStoreSql tool.

Related Skills

Explore More Software Engineering Skills→
jonnymuirjonnymuir
1

session-recovery

Query the local SQLite session_store database to recover interrupted Copilot CLI sessions.

Community
Intermediate
roberttmadsen13-delroberttmadsen13-del

lean-ux-canvas

Facilitates Lean UX Canvas discovery with an eight-box workflow and export options.

Community
Advanced
fabioc-alohafabioc-aloha

chat-participant-patterns

Standardize VS Code Chat API usage for chat participants, tools, and agent skills.

Community
Intermediate
Lee-SiHyeonLee-SiHyeon
10

chronicle

Converts Copilot CLI session history into standup reports, tips, and Crokpat instructions.

Community
Intermediate