SessionQL
A typed pipeline language for events, search, bounded patterns, lineage, and aggregation.
RFC 0001 · SessionQL 1.0 and Query IR 1.0
One durable session record for every agent runtime.
USL normalizes runtime-specific logs into a canonical append-only record. RFC 0001 specifies the SessionQL query plane that can be built on top.
sessionql
from sessions
| search hybrid $question top 3
| where provenance.runtime in $runtimes
| project sessionId, title, search.hits
| sort by search.score desc
| limit 20Portable semantics
Keep one durable record across runtimes.
The L1 log stays simple. Typed query semantics, evidence, and policy-aware sidecars compose above it without taking ownership of the facts.
One source of truth
The append-only L1 log remains canonical; every index and projection is rebuildable.
Fixed snapshots
Every result and cursor is pinned to one asOfSeq, policy, and set of index generations.
Evidence-first search
Text, semantic, and hybrid results link highlights and offsets back to canonical events.
Runtime lineage
Traverse fork, resume, handoff, and subagent edges without losing provenance.
Replay + tail
Bounded subscriptions move from deterministic replay into an at-least-once live stream.
Product scenarios
What session data can power.
SESDB turns agent history into reusable infrastructure—for model improvement, personal intelligence, unified operations, and portable work.
System architecture
Trace a session from capture to storage and handoff.
Select a module to inspect its responsibilities, dependencies, runtime flow, and source-backed implementation notes.
SESDB Console
Inspect sessions, usage, storage, and integrity in one console.
Monitor ingestion, inspect real sessions and native events, compare runtime usage, and verify the physical append log from one management console.
Open interactive demo
Safe sample data · no setup required
Operations overview
Live throughput, runtime distribution, recent sessions, and integrity health.
Sessions and events
Browse real sessions and inspect the latest native events from every source.
Global analytics
Compare tokens, cache efficiency, tools, projects, and runtimes in one metrics layer.
Source runtimes
Understand ingestion coverage across Codex, Claude Code, Pi, OpenCode, and Dimagent.
Physical storage
Inspect file size, valid data, headers, frames, and the append-only layout.
Integrity report
Rescan frame boundaries, CRCs, recovery positions, and quarantine state.