analytics

name	analytics
description	Query Claude Code session analytics from ccrecall database. Use when user asks about token usage, session history, or wants to analyze their Claude Code usage patterns.

Session Analytics

Query your Claude Code usage data from the ccrecall SQLite database.

Prerequisites

# Sync transcripts to SQLite (requires bun)
bun x ccrecall sync

Database location: ~/.claude/ccrecall.db

CLI Commands

bun x ccrecall sync      # Import transcripts (incremental)
bun x ccrecall stats     # Show session/message/token counts
bun x ccrecall sessions  # List recent sessions
bun x ccrecall search    # Full-text search across messages
bun x ccrecall tools     # Show most-used tools
bun x ccrecall query     # Execute raw SQL

Quick Queries

Token usage by model

SELECT model,
       COUNT(*) as messages,
       SUM(input_tokens) as input_tok,
       SUM(output_tokens) as output_tok
FROM messages
WHERE model IS NOT NULL
GROUP BY model;

Daily usage

SELECT date(timestamp/1000, 'unixepoch') as day,
       COUNT(*) as msgs,
       SUM(output_tokens) as tokens
FROM messages
GROUP BY day
ORDER BY day DESC
LIMIT 7;

Usage by project

SELECT s.project_path,
       COUNT(m.uuid) as messages,
       SUM(m.output_tokens) as tokens
FROM sessions s
JOIN messages m ON m.session_id = s.id
GROUP BY s.project_path
ORDER BY tokens DESC
LIMIT 10;

Tool usage

SELECT tool_name, COUNT(*) as count
FROM tool_calls
GROUP BY tool_name
ORDER BY count DESC;

Search thinking blocks

SELECT substr(thinking, 1, 200) as preview,
       datetime(timestamp/1000, 'unixepoch') as time
FROM messages
WHERE thinking LIKE '%your search term%'
ORDER BY timestamp DESC
LIMIT 10;

Using with mcp-sqlite-tools

If you have mcp-sqlite-tools configured, Claude can query directly:

1. Open database: open_database ~/.claude/ccrecall.db
2. Tables: sessions, messages, tool_calls, tool_results, teams, team_members, team_tasks
3. Run queries above or ask Claude to analyze patterns

GitHub

https://github.com/spences10/ccrecall