skills.rest
jmerkow
jmerkowCOMMUNITY
Explore all skills by this author →
GitHub

collect

Collect and query Copilot session-store SQLite databases across local and remote hosts.

2|Updated Jun 15, 2026
Search Tags:#SQLite#chat history#session history#Copilot#database querying
One-click install
npx skills add https://github.com/jmerkow/my-agentic-stuff --skill collect-jmerkow
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: collect
Source: https://github.com/jmerkow/my-agentic-stuff/tree/main/plugins/sessions/skills/collect
Command: npx skills add https://github.com/jmerkow/my-agentic-stuff --skill collect-jmerkow

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies the process of collecting and querying Copilot session histories from local machines, WSL, and remote SSH hosts, enabling users to inspect, search, or export their Copilot chat history across machines.

Core Features & Use Cases

  • Cross-Machine Session Collection: Gather session-store.db databases from various sources into a single staging directory.
  • SQL Querying: Perform SQL queries against the collected databases to inspect, search, or export session data.
  • Use Case: When a user needs to review past chat sessions, search for specific keywords, or export their Copilot chat history for analysis.

Quick Start

Run the collect.sh script to collect session databases and then query them using sqlite3.

Frequently Asked Questions about collect

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

FAQPage Schema
How do I aggregate Copilot session histories across multiple machines?▼

Aggregating Copilot session histories involves collecting session-store SQLite databases from local, WSL, and remote SSH hosts into a single staging directory for unified querying.

What's the best way to search Copilot chat history from different remote hosts?▼

The best way to search Copilot chat history from different remote hosts is to collect their session-store.db files into a local staging directory and run SQL queries against them using sqlite3.

Can I query my Copilot session-store database using SQL?▼

Yes, you can query the Copilot session-store database using SQL. Once collected, the SQLite databases support standard SQL queries to inspect, search, or export your chat session data.

Do I need sqlite3 installed to collect and query Copilot session databases?▼

Yes, sqlite3 is required to query Copilot session databases. You also need local and remote access to the session databases to successfully collect and analyze the chat history.

What are the limitations when collecting Copilot chat history from WSL or SSH hosts?▼

A key limitation when collecting Copilot chat history is requiring local and remote access to the session databases and sqlite3 for querying. Without proper access to WSL or SSH hosts, the collection process will fail.

Related Skills

Explore More Software Engineering Skills→
rickylabsrickylabs

codex-wsl-remote

Manage Codex app-server sessions in WSL through SSH connections.

Community
Advanced
mdjubaerhossensabbirmdjubaerhossensabbir

chronicle

Analyze Copilot session history from SQLite or DuckDB databases.

Community
Advanced
snow-jallensnow-jallen

session-recovery

Query the session_store SQLite database to identify interrupted Copilot CLI sessions.

Community
Advanced
apresenceapresence

wormlens

Extract and search Claude Code and VS Code Copilot chat histories.

Community
Advanced