claude-usage-analyzer

Analyze Claude Code transcripts to generate SQLite databases and HTML dashboards.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/mporenta/airflow --skill claude-usage-analyzer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: claude-usage-analyzer
Source: https://github.com/mporenta/airflow/tree/main/.claude/skills/claude-usage-analyzer
Command: npx skills add https://github.com/mporenta/airflow --skill claude-usage-analyzer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Claude Code usage data from local transcripts is hard to interpret at a glance; this Skill provides an end-to-end analytics workflow that ingests, analyzes, and visualizes usage to reveal token patterns, project activity, and workflow insights.

Core Features & Use Cases

  • Local, zero-dependency analytics pipeline that ingests ~/.claude data and outputs an interactive HTML dashboard.
  • Token usage breakdown by day, project, model, and tool usage, including session insights and cache analysis.
  • Compare time ranges and identify high-cost sessions to optimize workflows.

Quick Start

Run the included build_usage_db.py to generate the SQLite database for your date range, then run generate_dashboard.py to view the interactive dashboard.

Frequently Asked Questions about claude-usage-analyzer

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

FAQPage Schema
How do I analyze Claude Code token usage from local transcripts?▼

To analyze Claude Code token usage from local transcripts, run the build_usage_db.py script to generate a SQLite database from your ~/.claude data, then run generate_dashboard.py to view an interactive HTML dashboard showing token breakdowns by day, project, and model.

Can I visualize Claude Code session patterns and cache efficiency without external dependencies?▼

Yes, Claude Code session patterns and cache efficiency can be visualized without external dependencies by running a local analytics pipeline that ingests ~/.claude data, normalizes it into SQLite, and outputs a configurable HTML dashboard with zero external requirements.

What insights can I get from a Claude Code usage analytics dashboard?▼

A Claude Code usage analytics dashboard reveals token distribution across models, project activity levels, tool usage patterns, session insights, and cache efficiency metrics. It helps identify high-cost sessions and compare time ranges to optimize your workflows.

How do I track Claude Code project activity and tool patterns across different date ranges?▼

To track Claude Code project activity and tool patterns across date ranges, execute build_usage_db.py with your target dates to populate the SQLite database, then generate_dashboard.py to surface session patterns, token distribution, and workflow insights in an interactive view.

Does the Claude usage analyzer require any external libraries or API connections?▼

No, the Claude usage analyzer requires zero external dependencies and no API connections. It operates entirely locally by extracting data from ~/.claude transcripts, processing it with SQLite, and rendering a self-contained HTML dashboard.

What is the best way to identify high-cost Claude Code sessions for workflow optimization?▼

The best way to identify high-cost Claude Code sessions is to generate a local analytics dashboard that breaks down token usage by day, project, and model, allowing you to compare time ranges and isolate sessions with inefficient cache usage or excessive token consumption.