Analyze Cloud Costs

Analyze Cloud Costs

Overview

Use this skill for evidence-backed Langfuse Cloud cost analysis. The primary source is the Metabase infra cost dashboard and its production cost marts; the deliverable should name the time window, query grain, top drivers, and caveats.

Workflow

1. Clarify the question and choose the grain:
   • Headline daily totals: total, AWS, ClickHouse, tracing events, and cost per 100k events.
   • Cost structure: provider, service, usage type, operation, account, and day.
   • Driver or regression analysis: compare a recent complete-day window against a prior baseline.
2. Load references/cost-marts.md for table IDs, field IDs, query examples, and caveats.
3. Use the Metabase MCP. If the Metabase tools are not visible, discover them with tool search before falling back to manual interpretation.
4. Prefer complete UTC days. Avoid treating current-day AWS cost as final because AWS CUR rows can arrive late.
5. Start broad, then drill down:
   • Provider split.
   • Service split within the dominant provider.
   • Usage type, operation, and account split for the top services.
   • Daily trend when explaining change over time.
6. Report only what the queried data supports. If a requested slice is absent, say that no rows were found for that slice instead of inventing a driver.

Query Rules

• Use mcp__metabase__.query for quick reads. Use construct_query plus execute_query when you need to inspect or reuse the opaque query.
• Pass filters, aggregations, group_by, and fields as JSON arrays. Some tool schemas may display these as strings; if that happens, serialize the same arrays without changing their shape.
• Keep limits explicit and small enough for analysis. Use pagination only when the continuation token is needed.