Chronicle - local and remote by vijayupadya · Pull Request #308602 · microsoft/vscode

vijayupadya · 2026-04-08T20:21:15Z

Chronicle — Session Search (local and cloud)

Overview

Chronicle enables agent to learn from your past coding sessions. It tracks session data locally, optionally syncs to cloud, and provides /chronicle commands for standups, tips, and freeform queries.

Architecture

┌─────────────────────────────────────────────────────────────────────┐
│                        VS Code Extension                            │
│                                                                     │
│                    ┌──────────────┐                                 │
│                    │  OTel Spans   │                                 │
│                    │  (chat turns, │                                 │
│                    │   tool calls) │                                 │
│                    └──────┬───────┘                                 │
│                           │                                         │
│              ┌────────────┴────────────┐                            │
│              │                         │                            │
│              ▼                         ▼                            │
│  ┌──────────────────┐    ┌──────────────────┐                      │
│  │ SessionStore      │    │ RemoteSession     │                      │
│  │ Tracker           │    │ Exporter          │                      │
│  │ (writes batched   │    │ (batched 500ms,   │                      │
│  │  every 3s)        │    │  circuit breaker) │                      │
│  └────────┬─────────┘    └────────┬─────────┘                      │
│           │                       │                                 │
│           ▼                       ▼                                 │
│  ┌──────────────────┐    ┌──────────────────┐                      │
│  │ Local SQLite DB   │                      │     │                      │
│  │ (sessions, turns, │    │ Cloud (DB)      │                      │
│  │  files, refs)     │    │                 │                      │
│  └──────────────────┘    └──────────────────┘                      │
│                                                                     │
│  ┌──────────────────────────────────────────────────────────────┐  │
│  │                    /chronicle Commands                        │  │
│  │                                                               │  │
│  │  ┌─────────┐   ┌─────────┐   ┌───────────┐                  │  │
│  │  │ standup  │  │  tips   │   │ free-form │                  │  │
│  │  │(pre-fetch│  │(tool-   │   │(tool-     │                  │  │
│  │  │ + LLM)  │   │ calling)│   │ calling)  │                  │  │
│  │  └────┬────┘   └────┬────┘   └─────┬─────┘                  │  │
│  │       │              │              │                         │  │
│  │       ▼              ▼              ▼                         │  │
│  │  Local SQLite   session_store_sql tool                       │  │
│  │  + Cloud API    (routes to local or cloud                    │  │
│  │  (merged,        based on consent)                           │  │
│  │   deduped)                                                    │  │
│  └──────────────────────────────────────────────────────────────┘  │
└─────────────────────────────────────────────────────────────────────┘

ChronicleIntent — /chronicle Commands

/chronicle standup
    │
    ├── Check SessionSearchLocalIndexEnabled (ExP) ──▶ No ──▶ return
    │
    ├── Query local SQLite (last 24h)
    │
    ├── Query cloud DB (last 24h, if hasCloudConsent)
    │
    ├── Merge + dedupe sessions by ID
    │
    └── Send to LLM with standup prompt template

**Telemetry**: `chronicle` event with subcommand, querySource, session counts.

/chronicle tips
    │
    ├── Check SessionSearchLocalIndexEnabled (ExP) ──▶ No ──▶ return
    │
    ├── Set system prompt with schema description
    │
    └── Delegate to DefaultIntentRequestHandler
         │
         ├── disableToolSearch = true (bypass server-side tool search)
         │
         └── getAvailableTools() → [session_store_sql] only
              │
              └── Model writes SQL ──▶ session_store_sql tool executes
                   │
                   ├── hasCloudConsent? ──▶ Yes ──▶ Query cloud DB
                   │
                   └── No ──▶ Query local SQLite

Data Flow — Session Lifecycle

User sends chat message
         │
         ▼
   VS Code creates OTel span (invoke_agent)
         │
         ├───────────────────────────────────────────┐
         │                                           │
         ▼                                           ▼
   SessionStoreTracker                    RemoteSessionExporter
         │                                           │
         ▼                                           ▼
   Buffer session row                     Translate to cloud events
   Buffer turn rows                       Buffer events
   Buffer file/ref rows                           │
         │                                           ▼
         ▼                                  Flush to Cloud
   Flush to SQLite (3s)                   POST /agents/sessions/{id}/events
         │                                  (500ms batches, circuit breaker)
         ▼                                           │
   Local session store                               ▼
   (workspaceStorage/                        Cloud session store
    GitHub.copilot-chat/                     (DB on backend)
    session-store.db)
         │                                           │
         └──────────────┬────────────────────────────┘
                        │
                        ▼
              /chronicle standup
              (queries both, merges, dedupes)

Copilot

Pull request overview

Introduces a new “Chronicle” session history subsystem in the Copilot extension, backed by a local SQLite store and populated from chat/OTel session activity, and wires it into a new /chronicle intent plus a chronicle_standup tool for generating standup summaries.

Changes:

Adds a SQLite-backed SessionStore (+ schema, FTS index, and tests) for sessions/turns/files/refs/checkpoints.
Adds tracking (SessionStoreTracker) to populate the store from completed OTel spans and chat session lifecycle.
Adds new user entry points: /chronicle standup intent and a chronicle_standup tool, plus prompt/query helpers and tests.

Copilot's findings

Files reviewed: 18/18 changed files
Comments generated: 8

github-actions · 2026-04-09T19:42:05Z

Screenshot Changes

Base: ca3b9bfb Current: 27532f6f

Changed (6)

chat/aiCustomizations/aiCustomizationManagementEditor/McpBrowseMode/Dark

Before	After

chat/aiCustomizations/aiCustomizationManagementEditor/McpBrowseMode/Light

Before	After

editor/inlineCompletions/other/JumpToHint/Dark

Before	After

editor/inlineCompletions/other/JumpToHint/Light

Before	After

agentSessionsViewer/WithMarkdownBadge/Dark

Before	After

agentSessionsViewer/WithMarkdownBadge/Light

Before	After

Copilot

Pull request overview

Adds a new “Chronicle” capability to Copilot Chat to persist session activity locally (SQLite/FTS) and optionally export session events to a remote backend, enabling a standup-style summary experience gated behind a team-internal setting.

Changes:

Introduces a SQLite-backed session store (schema, FTS indexing, read-only querying) plus unit tests.
Adds tracking/export plumbing: OTel span translation, local store population, remote event batching with circuit breaker + secret filtering, and consent flow scaffolding.
Registers a new /chronicle intent and a chronicle_standup tool, plus related context keys and contributions.

Copilot's findings

Files reviewed: 32/32 changed files
Comments generated: 8

…igrate-5049

Copilot

Pull request overview

Note

Copilot was unable to run its full agentic suite in this review.

Adds “Chronicle” session-history support with local SQLite indexing plus optional cloud sync/export, enabling /chronicle:* commands and a read-only SQL tool over recorded sessions.

Changes:

Introduces a local SQLite-backed SessionStore with FTS indexing and a VS Code tracker that records sessions/turns/files/refs from OTel spans.
Adds cloud querying/export plumbing (client + remote exporter) gated by user consent and repo exclusions.
Registers the /chronicle intent and a session_store_sql tool, plus settings/context keys and package contributions.

Copilot's findings

Comments suppressed due to low confidence (3)

extensions/copilot/src/platform/configuration/common/configurationService.ts:1

This string-array setting is missing a validator (unlike the adjacent boolean setting). Without validation, malformed config values can reach SessionIndexingPreference and break matching logic at runtime. Add an appropriate array-of-strings validator (consistent with this file’s other settings) so invalid values are rejected/coerced early.
extensions/copilot/src/extension/tools/node/sessionStoreSqlTool.ts:1
The tool claims “Only SELECT queries are allowed”, but enforcement is currently a blocklist of a few keywords. This is especially risky on the local path when executeReadOnlyFallback() is used (Node without authorizer), since non-SELECT statements like VACUUM, ANALYZE, REINDEX, transaction control (BEGIN/COMMIT), or other dialect-specific write/export commands are not blocked. Prefer enforcing an allowlist (e.g., query must be a single statement starting with SELECT or WITH and contain no semicolons), and expand blocking to cover known mutators if an allowlist isn’t feasible.
extensions/copilot/src/extension/tools/node/sessionStoreSqlTool.ts:1
Table formatting doesn’t escape cell values. If a value contains | or newlines, the markdown table will break and can produce confusing output. Escape/replace | and line breaks in s before joining (and consider backtick-wrapping values) to keep rendering stable.

Files reviewed: 36/36 changed files
Comments generated: 8

…igrate-5049 # Conflicts: # extensions/copilot/src/extension/tools/common/toolNames.ts

…igrate-5049 # Conflicts: # extensions/copilot/src/extension/tools/node/allTools.ts

Copilot

Pull request overview

This PR introduces “Chronicle” session history for Copilot Chat, including a local SQLite-backed session store, optional cloud export, and a new /chronicle intent with tool-calling via a dedicated session_store_sql tool.

Changes:

Add local SQLite session store (schema + FTS5) and trackers to persist sessions/turns/files/refs.
Add cloud sync pipeline (event translation + batching + circuit breaker) and a cloud SQL query client.
Add /chronicle intent (standup + tips + freeform) plus session_store_sql tool and registrations.

Show a summary per file

File	Description
test/componentFixtures/blocks-ci-screenshots.md	Updates CI snapshot image links.
extensions/copilot/src/platform/configuration/common/configurationService.ts	Adds team-internal config keys for session search and cloud sync.
extensions/copilot/src/platform/chronicle/node/test/sessionStore.spec.ts	Adds unit tests for the SQLite session store behavior.
extensions/copilot/src/platform/chronicle/node/sessionStore.ts	Implements SQLite-backed `SessionStore` with schema, migrations, FTS5, and read-only query APIs.
extensions/copilot/src/platform/chronicle/common/sessionStore.ts	Adds shared row types + `ISessionStore` service contract.
extensions/copilot/src/extension/tools/node/sessionStoreSqlTool.ts	Adds `session_store_sql` tool to query local or cloud session store.
extensions/copilot/src/extension/tools/node/allTools.ts	Registers the new `sessionStoreSqlTool`.
extensions/copilot/src/extension/tools/common/toolNames.ts	Adds tool name constants for session store SQL.
extensions/copilot/src/extension/test/vscode-node/services.ts	Wires `ISessionStore` into VS Code extension test service collection.
extensions/copilot/src/extension/test/node/services.ts	Wires `ISessionStore` into unit test service collection.
extensions/copilot/src/extension/prompts/node/panel/chroniclePrompt.tsx	Adds prompt wrapper for Chronicle tool-calling.
extensions/copilot/src/extension/intents/node/chronicleIntent.ts	Implements `/chronicle` subcommands and tool availability gating.
extensions/copilot/src/extension/intents/node/allIntents.ts	Registers the new `ChronicleIntent`.
extensions/copilot/src/extension/intents/node/agentIntent.ts	Explicitly disables `session_store_sql` for agent flows (chronicle-only).
extensions/copilot/src/extension/extension/vscode-node/services.ts	Creates and registers a persistent `SessionStore` instance for the extension host.
extensions/copilot/src/extension/extension/vscode-node/contributions.ts	Registers Chronicle contributions (local tracker + remote exporter).
extensions/copilot/src/extension/conversation/vscode-node/chatParticipants.ts	Minor formatting-only changes (blank lines).
extensions/copilot/src/extension/contextKeys/vscode-node/contextKeys.contribution.ts	Adds context key gating for session search enablement.
extensions/copilot/src/extension/common/constants.ts	Adds `Chronicle` intent and command mappings.
extensions/copilot/src/extension/chronicle/vscode-node/sessionStoreTracker.ts	Tracks OTel spans and batches writes to local SQLite.
extensions/copilot/src/extension/chronicle/vscode-node/remoteSessionExporter.ts	Buffers and flushes translated events to the cloud with circuit breaker.
extensions/copilot/src/extension/chronicle/node/cloudSessionStoreClient.ts	Implements cloud SQL query endpoint client.
extensions/copilot/src/extension/chronicle/node/cloudSessionApiClient.ts	Implements cloud session creation + event submission client.
extensions/copilot/src/extension/chronicle/common/test/standupPrompt.spec.ts	Adds tests for standup prompt building and extraction helpers.
extensions/copilot/src/extension/chronicle/common/test/sessionIndexingPreference.spec.ts	Adds tests for indexing preference logic.
extensions/copilot/src/extension/chronicle/common/test/secretFilter.spec.ts	Adds tests for secret redaction filters.
extensions/copilot/src/extension/chronicle/common/test/eventTranslator.spec.ts	Adds tests for span→event translation.
extensions/copilot/src/extension/chronicle/common/test/circuitBreaker.spec.ts	Adds tests for circuit breaker behavior.
extensions/copilot/src/extension/chronicle/common/standupPrompt.ts	Adds prompt construction helpers and canned SQLite queries.
extensions/copilot/src/extension/chronicle/common/sessionStoreTracking.ts	Adds helpers to extract file paths and refs from tool calls.
extensions/copilot/src/extension/chronicle/common/sessionIndexingPreference.ts	Adds consent/target selection logic (local vs cloud).
extensions/copilot/src/extension/chronicle/common/secretFilter.ts	Adds secret filtering/redaction utilities for cloud export.
extensions/copilot/src/extension/chronicle/common/eventTranslator.ts	Adds OTel span translation into CLI-compatible cloud events.
extensions/copilot/src/extension/chronicle/common/cloudSessionTypes.ts	Adds shared types for cloud session/event payloads.
extensions/copilot/src/extension/chronicle/common/circuitBreaker.ts	Adds circuit breaker implementation for cloud sync robustness.
extensions/copilot/package.nls.json	Adds localized strings for Chronicle command descriptions and settings text.
extensions/copilot/package.json	Adds Chronicle slash commands and contributes `copilot_sessionStoreSql` tool metadata.

Copilot's findings

Files reviewed: 37/37 changed files
Comments generated: 4

…igrate-5049 # Conflicts: # extensions/copilot/src/platform/configuration/common/configurationService.ts

vijayupadya added 2 commits April 8, 2026 19:54

chronicle

7047c76

local and cloud store

f82d439

Copilot AI review requested due to automatic review settings April 8, 2026 20:21

vijayupadya mentioned this pull request Apr 8, 2026

chronicle microsoft/vscode-copilot-chat#5049

Closed

Copilot started reviewing on behalf of vijayupadya April 8, 2026 20:22 View session

Copilot AI reviewed Apr 8, 2026

View reviewed changes

vs-code-engineering Bot assigned vijayupadya Apr 8, 2026

austindyoung mentioned this pull request Apr 8, 2026

[mirror] microsoft/vscode#308602 chronicle austindyoung/vscode-driftfence-mirror-fork#1334

Open

upload vscode events to remote store

bb17a1f

vijayupadya changed the title ~~chronicle~~ Chronicle - local and remote Apr 9, 2026

vijayupadya added 3 commits April 9, 2026 16:11

few updates

f0ec5d2

consent ui and settings

9f14396

few optimizations

ace0f70

vijayupadya requested a review from Copilot April 10, 2026 02:19

Copilot started reviewing on behalf of vijayupadya April 10, 2026 02:21 View session

Copilot AI reviewed Apr 10, 2026

View reviewed changes

vijayupadya added 10 commits April 9, 2026 20:19

test fix

bdf017b

feedback updates

d90b9cc

test fix

337dad6

Merge remote-tracking branch 'origin/main' into vscode-copilot-chat/m…

2b9d115

…igrate-5049

check setting to enable cmd

68e4f88

fix test

6677ba5

Settings update and tool update

9cd9af2

command update

09924de

Settings update

b871d4f

merge main

2326443

vijayupadya requested a review from Copilot April 15, 2026 00:11

Copilot started reviewing on behalf of vijayupadya April 15, 2026 00:17 View session

Copilot AI reviewed Apr 15, 2026

View reviewed changes

vijayupadya added 8 commits April 14, 2026 17:44

Merge remote-tracking branch 'origin/main' into vscode-copilot-chat/m…

17f7f0e

…igrate-5049 # Conflicts: # extensions/copilot/src/extension/tools/common/toolNames.ts

feedback updates

523aa86

setting and test update

485e4d0

few updates

adcd178

updates

43bac33

Merge remote-tracking branch 'origin/main' into vscode-copilot-chat/m…

52503de

…igrate-5049 # Conflicts: # extensions/copilot/src/extension/tools/node/allTools.ts

test update

4fac271

blocks ci update

1758933

vijayupadya requested a review from Copilot April 16, 2026 05:56

Copilot started reviewing on behalf of vijayupadya April 16, 2026 05:57 View session

Copilot AI reviewed Apr 16, 2026

View reviewed changes

feedback updates

828f19f

vijayupadya marked this pull request as ready for review April 16, 2026 06:44

vijayupadya marked this pull request as draft April 16, 2026 06:44

vijayupadya added 2 commits April 15, 2026 23:47

Merge remote-tracking branch 'origin/main' into vscode-copilot-chat/m…

8793d85

…igrate-5049 # Conflicts: # extensions/copilot/src/platform/configuration/common/configurationService.ts

comment update

49efd0f

vijayupadya marked this pull request as ready for review April 16, 2026 06:50

vijayupadya enabled auto-merge (squash) April 16, 2026 06:51

alexdima approved these changes Apr 16, 2026

View reviewed changes

vijayupadya merged commit 602484a into main Apr 16, 2026
26 checks passed

vijayupadya deleted the vscode-copilot-chat/migrate-5049 branch April 16, 2026 08:31

vs-code-engineering Bot added this to the 1.117.0 milestone Apr 16, 2026

vijayupadya mentioned this pull request Apr 18, 2026

Enable Chronicle - local and remote syncing #311132

Closed

Conversation

vijayupadya commented Apr 8, 2026 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Chronicle — Session Search (local and cloud)

Overview

Architecture

ChronicleIntent — /chronicle Commands

Data Flow — Session Lifecycle

Uh oh!

Copilot AI left a comment • edited by vijayupadya Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Choose a reason for hiding this comment

Pull request overview

Copilot's findings

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

github-actions Bot commented Apr 9, 2026 • edited Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Screenshot Changes

Changed (6)

Uh oh!

Copilot AI left a comment • edited by vijayupadya Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Choose a reason for hiding this comment

Pull request overview

Copilot's findings

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Copilot AI left a comment • edited by vijayupadya Loading Uh oh! There was an error while loading. Please reload this page.

Uh oh!

Choose a reason for hiding this comment

Pull request overview

Copilot's findings

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Copilot AI left a comment

Choose a reason for hiding this comment

Pull request overview

Copilot's findings

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Reviewers

Assignees

Labels

Projects

Milestone

Development

Uh oh!

3 participants

vijayupadya commented Apr 8, 2026 •

edited

Loading

Copilot AI left a comment •

edited by vijayupadya

Loading

github-actions Bot commented Apr 9, 2026 •

edited

Loading

Copilot AI left a comment •

edited by vijayupadya

Loading

Copilot AI left a comment •

edited by vijayupadya

Loading