cost-reportlisted
Install: claude install-skill Guilhermepelido/hermes-optimization-guide
# cost-report — LLM Cost Breakdown
Generate a human-readable (or machine-readable) cost report from Hermes' usage logs.
## Procedure
1. **Export logs.** Run:
```bash
hermes logs export --since ${WINDOW} --format jsonl --output /tmp/hermes-logs.jsonl
```
2. **Parse and aggregate.** Using DuckDB (preferred) or `jq` + `awk`:
```bash
duckdb -c "
CREATE TABLE logs AS SELECT * FROM read_json_auto('/tmp/hermes-logs.jsonl');
-- By provider
SELECT provider,
SUM(cost_usd) AS cost,
SUM(tokens_in) AS tok_in,
SUM(tokens_out) AS tok_out,
COUNT(*) AS calls
FROM logs
GROUP BY 1
ORDER BY 2 DESC;
"
```
3. **Produce four tables:**
**A. By provider**
```
Provider Cost($) Tokens-in Tokens-out Calls
anthropic 18.44 2.1M 380K 412
openai 6.20 1.2M 220K 187
cerebras 0.45 890K 140K 523
```
**B. By gateway**
```
Gateway Cost($) % of total
telegram 14.22 56%
cli 8.10 32%
discord 2.77 11%
cron 0.50 2%
```
**C. By active skill**
```
Skill Cost($) Calls Avg-cost
claude-code 9.40 22 $0.43
lightrag-query 4.11 189 $0.02
pr-review 3.20 8 $0.40
weekly-dep-audit 1.25 1 $1.25
```
**D. Daily trend** (simple ASCII sparkline)
```