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

Ready to run

npx skills add https://github.com/jmerkow/my-agentic-stuff --skill collect-jmerkow

💬 Prompt for ChatGPT / Claude Chat▼

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.