spences10

Ccrecall — Data skill for Claude Code

Data community

🔄️ Sync Claude Code transcripts to SQLite for analytics, uses node:sqlite.

How to install Ccrecall

This entry records only its repository, not the path inside it, so there is no exact command to give. Open spences10/ccrecall and copy the folder into ~/.claude/skills/, or the file into ~/.claude/agents/.

What Ccrecall does

🔄️ Sync Claude Code transcripts to SQLite for analytics, uses node:sqlite.

Alternatives in Data

Notion Sync — /notion-sync - Push Ranked Jobs and Applications to a Notion Database 36.6k ★
Marketingskills — Marketing skills for Claude Code and AI agents 16.9k ★
12 Services Layer — Prompt 12: Wire Up Services Layer (Analytics, Policy, Settings, Sessions) 2.3k ★

README

ccrecall

[![built with vite+](https://img.shields.io/badge/built%20with-Vite+-646CFF?logo=vite&logoColor=white)](https://viteplus.dev) [![tested with vitest](https://img.shields.io/badge/tested%20with-Vitest-6E9F18?logo=vitest&logoColor=white)](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