Claude Code — Session Introspection

What it does

This skill exposes a DuckDB-backed index of Claude Code JSONL session logs, letting agents run named queries and ad-hoc SQL to surface session-level stats (duration, tokens), tool usage patterns, recent activity, errors, sandbox bypasses, and searchable conversation content. It provides scripts and named queries for common reports and can refresh the index on demand.

When to use it

Use this skill when the user asks about their Claude Code activity: retrieving session IDs, checking daily token consumption, finding past conversations, auditing tool usage or errors, or extracting sandbox bypass incidents. Do NOT use it for arbitrary codebase searches or non-session data.

What's included

• Scripts: yes — query scripts and resources/queries for named reports.
• References: none listed in the SKILL.md, but resources/queries contains reusable SQL.
• Instructions: SKILL.md documents tables/views (raw, messages, content_items, sessions, tool_calls, etc.), named queries and example command invocations, and guidance for inspecting JSON fields.

Compatible agents

Intended for Claude Code plugin hosts and agents that can run Bash and read local files; best suited to Claude Code environments with access to session JSONL logs and the plugin data directory.