git:20261012.c98446a to git:20261012.84aae05

18 added, 0 removed. Audit A to A.

# AGENTS.md — provider-cursor
Cursor-specific gotchas that do not fit in the root `AGENTS.md` size budget.
## Discovery performance
Discovery runs on every `vibe-replay sessions` call, so its cost is user-visible. A real
machine can hold a ~25 GB `state.vscdb` (mostly `bubbleId:*` rows) and hundreds of SDK
`index.db` files.
- **Probe, don't count.** Discovery only needs to know whether a composer has *any*
replayable bubble. `hasReplayableGlobalStateBubbleSql` is an `EXISTS` probe, and the
WASM fallback (`hasReplayableGlobalStateComposer`) loads bubbles in small chunks and
stops at the first hit. Never reintroduce `COUNT(*)` over bubbles: it forces SQLite to
parse every bubble of every composer (~19s here versus ~1s with `EXISTS`).
- **Composer metadata is cheap, bubbles are not.** Scanning all `composerData:*` rows is
about 2s for 185 MB. Anything that joins or parses `bubbleId:*` per composer must
short-circuit.
- **SDK agent index is persisted per database.** `getSdkAgentIndexOnce` caches each
`index.db`'s agent rows in `cursor-sdk-agent-index-v1`, keyed by path and invalidated by
the file's size/mtime plus its `-wal` size/mtime. Finished automation runs never change,
so a warm scan opens none of them. Misses are read with bounded concurrency and merged in
path order so a duplicate agent id resolves as a serial scan would. Only successfully
read databases get an entry, and nothing is written inside `withReadOnlySqlite(true, …)`
(`isSqliteReadOnlyScope`).
+ - **SDK enrichment: count spawns, not queries.** `ChildProcess.spawn` blocks the main
+ thread (~36 ms each in a large process), so `SCAN_CONCURRENCY` cannot parallelise it;
+ the old 4-5 `sqlite3` spawns per agent cost 100 s of the 106 s serial rich scan here.
+ `loadSdkAgentEnrichment` now reads a database in-process with sql.js only when it is
+ under `SQLJS_PREFERRED_MAX_BYTES` (16 MB) and `-wal`/`-journal` are empty
+ (`isMainFileComplete`; sql.js ignores sidecars, so it must never read past a non-empty
+ one). Everything else uses one `sqlite3 -readonly -json` run with two statements
+ (`parseConcatenatedJsonArrays`: no output = no runs, one array = runs without events),
+ falling back to the stepwise path on any non-snapshot error. `SqliteSnapshotRequiredError`
+ always propagates, and the fallback must never mask a main-file race. Test with spawn
+ counts (`sdk-enrichment-read-paths.test.ts`), not wall time: timings on a loaded
+ machine are noisy.
+ - **Known remaining cost: large shared `index.db`.** A 148 MB WAL-mode database holding
+ 266 agents still costs ~88 ms per agent, almost all in `withSqliteReadSource` staging a
+ fresh snapshot per operation (SQL itself is ~12 ms; the same call is 0.1 ms once the
+ snapshot is staged in the scope). Fixing it needs a fingerprint-validated, idle-expiring
+ snapshot pool; do not simply wrap a whole scan in one `withSqliteSnapshotScope`, which
+ would let cached scan results record a newer fingerprint than the data they hold.
- **`sourceFingerprint` intentionally changes whenever the live global DB does.** That is
by design (late tool results), not a cache bug; do not "fix" it to stabilise output.