analytics

Category: Development & Coding | Uploader: spences10 | Downloads: 0 | Version: v1.0（Latest）

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.

Changelog: Source: GitHub https://github.com/spences10/claude-code-toolkit

Directory Structure

Current level: tree/main/plugins/analytics/

📁 .claude-plugin/
- 📄 plugin.json 129 B
📄 SKILL.md 2.1 KB

SKILL.md

---
name: analytics
# prettier-ignore
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

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

Database location: `~/.claude/ccrecall.db`

## CLI Commands

```bash
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

```sql
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

```sql
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

```sql
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

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

### Search thinking blocks

```sql
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

Comments 0

Latest | Hot

Please login before commenting.

Loading comments...

analytics

Directory Structure

SKILL.md

Report

Notice