Does this skill work automatically within Claude Code?

When combined with mcp-sqlite-tools, Claude can use this skill to directly query your usage data and provide analytical summaries upon request.

What database does the Session Analytics skill use?

This skill queries the cclog SQLite database, which is typically located at ~/.claude/cclog.db.

Can this skill help me reduce my Claude API costs?

Yes, it provides detailed SQL queries to estimate costs per model and project, allowing you to identify high-consumption patterns and optimize your usage.

How do I sync my Claude Code transcripts to the database?

You need to install cclog globally via npm (npm i -g cclog) and run the 'cclog sync' command to populate the SQLite database.

Session Analytics

Name: Session Analytics
Author: spences10

byspences10

•

分析与监控

Analyzes Claude Code session data to track token usage, project history, and estimated API costs.

The Session Analytics skill enables developers to gain deep insights into their Claude Code usage by querying the cclog SQLite database. It provides a standardized way to monitor performance metrics, track token consumption across different models, and audit usage patterns by project or day. By leveraging SQL-based reporting, users can effectively manage their API expenses and retrieve historical context from previous interactions, including searching through AI thinking blocks for improved workflow observability.

主要功能

01Track daily messaging trends and token consumption over time

023 GitHub stars

03Analyze usage and costs associated with specific project paths

04Search historical thinking blocks for context and debugging

05Query token usage broken down by specific AI models

06Calculate estimated API costs based on input and output token volume

使用场景

01Auditing developer productivity and message frequency across repositories

02Monitoring and managing monthly API spend for Claude Code

03Retrieving previous AI reasoning and context for complex troubleshooting

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add spences10/claude-code-toolkit analytics

For use in Claude.ai and ChatGPT

Download Skill