Cost Report Skill

Generate a comprehensive cost analysis report for Claude Code usage.

Query the Cost Guardian SQLite database at ~/.cost-guardian/usage.db and produce a detailed report covering:

Current Session — Cost, token breakdown, model used, number of API calls
Today's Usage — Total cost, calls, breakdown by model
Weekly Trend — Daily costs for the past 7 days
Top Expensive Sessions — 5 most costly sessions with timestamps
Model Efficiency — Cost per model, average tokens per call
Budget Health — Current spend vs configured limits, projected daily burn rate

Use bash commands with sqlite3 to query the database. Format output as clean markdown with tables.

If the database doesn't exist, inform the user that Cost Guardian needs to be set up first and provide installation instructions.

Generate a comprehensive cost analysis report for Claude Code usage.

Query the Cost Guardian SQLite database at ~/.cost-guardian/usage.db and produce a detailed report covering:

Current Session — Cost, token breakdown, model used, number of API calls
Today's Usage — Total cost, calls, breakdown by model
Weekly Trend — Daily costs for the past 7 days
Top Expensive Sessions — 5 most costly sessions with timestamps
Model Efficiency — Cost per model, average tokens per call
Budget Health — Current spend vs configured limits, projected daily burn rate

Use bash commands with sqlite3 to query the database. Format output as clean markdown with tables.

If the database doesn't exist, inform the user that Cost Guardian needs to be set up first and provide installation instructions.

Invocation