analytics

分类: 开发与编程 | 上传者: spences10 | 下载: 0 | 版本: v1.0（最新）

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.

更新日志: Source: GitHub https://github.com/spences10/claude-code-toolkit

目录结构

当前层级: plugins/analytics/

📁 .claude-plugin/
- 📄 plugin.json 152 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

登录后下载/点赞/收藏 ❤ 20 | ★ 0

analytics

目录结构

SKILL.md

举报内容

提示