exploring-llm-costs

Installation
SKILL.md

Exploring LLM costs

PostHog attaches per-call cost metadata to every $ai_generation and $ai_embedding event at ingestion time. Every cost question reduces to an aggregation over those two event types — the interesting variation is only in how you group, filter, and compare.

This skill covers the common cost investigations: total spend, breakdowns (model, provider, user, trace, custom property), token and cache-hit analysis, regression debugging, and materializing results as insights, dashboards, or alerts.

Tools

Tool Purpose
posthog:execute-sql Ad-hoc HogQL for any cost aggregation — the workhorse of this skill
posthog:query-llm-traces-list List traces with rolled-up cost, token, and error metrics
posthog:query-llm-trace Cost breakdown of a single trace across all its events
posthog:read-data-schema Discover which custom properties exist for breakdowns
Related skills
Installs
31
Repository
posthog/skills
GitHub Stars
34
First Seen
14 days ago