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.