# Cost Report

> Weekly LLM cost breakdown by provider / gateway / skill, posted to private DM

- **Type:** Skill
- **Install:** `agentstack add skill-onlyterp-hermes-optimization-guide-cost-report`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [OnlyTerp](https://agentstack.voostack.com/s/onlyterp)
- **Installs:** 0
- **Category:** [AI & ML](https://agentstack.voostack.com/c/ai-and-ml)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [OnlyTerp](https://github.com/OnlyTerp)
- **Source:** https://github.com/OnlyTerp/hermes-optimization-guide/tree/main/skills/ops/cost-report

## Install

```sh
agentstack add skill-onlyterp-hermes-optimization-guide-cost-report
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# 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)
   ```
   Mon ▂
   Tue ▃
   Wed ▅█  ← weekly-dep-audit ran
   Thu ▃
   Fri ▄
   Sat ▂
   Sun ▁
   Total: $25.53
   ```

4. **Flag anomalies.** Use a 3x median-absolute-deviation rule on daily spend. Note any days or skills that exceed the threshold:
   > ⚠ Wed spent $9.80, 4.5x typical. Driven by `weekly-dep-audit`.

5. **Recommend savings.** Pattern-match the data:
   - Any single skill > 30% of weekly cost → suggest a cheaper model for that skill
   - Input tokens > 10x output tokens on any provider → suggest prompt caching
   - Repeated Claude skills/SOUL prefixes without cache hits → enable v0.14 1-hour prefix caching
   - Gemini calls without `google/gemini-3.1-flash` on classification-ish intents → suggest routing
   - Grok 4.3 / GPT-5.5 / Opus calls in cron or triage lanes → require explicit opt-in routing

6. **Deliver.** Post to private notification channel. Attach the raw JSON if format is json.

## Cron wiring

```yaml
- name: weekly-cost-report
  schedule: "0 9 * * 1"
  task: /cost-report window=7d format=markdown
  notify: telegram_private
```

## See also

- [Part 20: Observability & Cost](../../../part20-observability.md)
- [cost-routing playbook](../../../part20-observability.md#cost-routing-playbook-the-one-that-actually-saves-money)

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [OnlyTerp](https://github.com/OnlyTerp)
- **Source:** [OnlyTerp/hermes-optimization-guide](https://github.com/OnlyTerp/hermes-optimization-guide)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-onlyterp-hermes-optimization-guide-cost-report
- Seller: https://agentstack.voostack.com/s/onlyterp
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.