skills.rest
spences10
spences10COMMUNITY
Explore all skills by this author →
WebsiteGitHub

session-analytics

Analyze Claude Code usage data from the ccrecall SQLite database.

35|2|Updated Jan 12, 2026
Search Tags:#analytics#sql#costs#session-history#token-usage#tool-usage#ccrecall
One-click install
npx skills add https://github.com/spences10/claude-code-toolkit --skill session-analytics
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: session-analytics
Source: https://github.com/spences10/claude-code-toolkit/tree/main/plugins/analytics
Command: npx skills add https://github.com/spences10/claude-code-toolkit --skill session-analytics

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Query Claude Code usage data quickly from the ccrecall SQLite database to reveal token usage, costs, and session history.

Core Features & Use Cases

  • Usage insights: analyze token counts, costs, and session history across projects.
  • Search & analytics: perform full-text searches across messages and extract trends.
  • Proactive optimization: identify tools usage and patterns to optimize workflows.

Quick Start

Sync transcripts to SQLite with bun x ccrecall sync to populate the local database.

Frequently Asked Questions about session-analytics

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze Claude Code token usage and costs across projects?▼

Find session history and token usage by running SQL queries against the ccrecall SQLite database. Sync your local transcripts first with bun x ccrecall sync to populate the data model with sessions, messages, and tool calls.

What's the best way to search Claude Code session history for specific messages?▼

Search Claude Code session history by performing full-text searches across messages stored in the ccrecall SQLite database. This extracts trends and returns ready-to-use metrics for your coding sessions.

Can I identify which tools are used most frequently in my Claude Code sessions?▼

Identify tool usage patterns in Claude Code sessions by querying tool calls recorded in the ccrecall database. This reveals usage frequencies to help you proactively optimize your coding workflows.

Does the session analytics approach require any external dependencies?▼

The session analytics approach requires no external dependencies, operating entirely on the local ccrecall SQLite database. You only need to run bun x ccrecall sync to populate the local database with your transcripts.

How do I get started with tracking Claude Code usage data locally?▼

Start tracking Claude Code usage data locally by running bun x ccrecall sync to sync transcripts to SQLite. Once populated, query the database for token counts, costs, and session history metrics.

Related Skills

Explore More Data & Analytics Skills→
TeiNamTeiNam
12

cost-tracking

Tracks and reports AI token usage and spending from a SQLite database.

Community
Intermediate
aaronjmarsaaronjmars
17

cost-report

Summarize API token usage and costs from CSV logs into detailed reports.

Community
Intermediate
alongor666alongor666
1

vue-component-dev

Develop Vue 3 components with Pinia stores and ECharts charts.

Community
Intermediate
ScientiaCapitalScientiaCapital
1

superbpe

Train and deploy SuperBPE tokenizers to reduce token usage.

Community
Advanced