Ccrecall

ccrecall

[](https://viteplus.dev) [](https://vitest.dev)

Sync Claude Code transcripts to SQLite for analytics. Query your session history, token usage, tool calls, and team/swarm data.

Quick Start

Use ccrecall inline in Claude Code sessions. Tell Claude:

"run npx ccrecall sync then show me my top 5 projects by token usage"

"use npx ccrecall search to find sessions where we discussed database migrations"

"run npx ccrecall stats and tell me how many tokens I've used this week"

Claude runs the command, gets structured output, and can answer follow-up questions about your session history.

How It Works

Claude Code stores transcripts as JSONL files in `~/.claude/projects/`. ccrecall parses these into a SQLite database so you can query across all sessions.

**Step 1.** Tell Claude to sync your transcripts:

npx ccrecall sync

**Step 2.** ccrecall incrementally imports new content and reports what it found:

Synced 42 sessions, 1,847 messages, 923 tool calls

**Step 3.** Claude can now query the database using any ccrecall command or raw SQL:

npx ccrecall stats
npx ccrecall search "database migration"
npx ccrecall query "SELECT project_path, SUM(input_tokens) FROM sessions s JOIN messages m ON m.session_id = s.id GROUP BY project_path ORDER BY 2 DESC LIMIT 5"

**Important:** Claude doesn't know about ccrecall unless you mention it. Just mention `{npx,pnpx,bunx} ccrecall` and Claude will discover subcommands and flags from the CLI output.

Commands

npx ccrecall sync                  # Import transcripts (incremental)
npx ccrecall stats                 # Session/message/token counts
npx ccrecall sessions              # List recent sessions
npx ccrecall search          # Full-text search acr