# bigquery

> Claude/Codex skill by [@costory-io](https://omgskills.com/library/costory-io/index.md) · 2 stars · Updated 2026-10-21

Use when the user asks about BigQuery costs, SKUs, on-demand Analysis vs capacity slots/editions, leftover on-demand, physical vs logical storage, time travel or fail-safe, streaming ingest, load/import jobs consuming a reservation, dbt or job labels, slot cost reallocation, dataset/table storage allocation, or unlabeled expensive queries. Call get\_skill with skillId "bigquery" before investigating BigQuery spend or cloning the \[BigQuery\] dashboard. Not for GCP spend-based CUDs (recipes gcp-spend-cud).

Tags: agent-skills, aws, azure, claude-code-plugin, claude-plugin, cloud-cost, cost-allocation, cost-optimization, cursor-plugin, finops, finops-agent, finops-mcp, gcp, gemini-cli-extension, kubernetes, llm-cost, mcp, mcp-server, model-context-protocol, remote-mcp

## Install

```sh
git clone https://github.com/costory-io/costory-finops-mcp-skills /tmp/costory-finops-mcp-skills && ln -s /tmp/costory-finops-mcp-skills/plugins/costory/skills/bigquery ~/.claude/skills/bigquery
```

## From README

BigQuery Invoice SKUs first. Bytes scanned, slot-ms, and table storage are not on the bill. Teach slots vs on-demand, open \[BigQuery\] BigQuery Dashboard, then allocate or optimize. Not this if: GCP spend CUD leftover → recipes → gcp-spend-cud. Generic Explorer → query. Whole-bill "what changed" → recipes → explain-period-change. Workflow getcontext — currency; note bq / useremail if already ingested Several organizations: if getcontext returns "Multiple organizations" with a list of slugs, do not pick one. Ask the user which org to use (from that list or listorganizations), then pass that slug to getcontext and the following tool calls. If the user already named the org (e.g. "org acme"), use that slug directly. search { type: \["dashboards"\], query: "BigQuery" } — use the template \[BigQuery\] BigQuery Dashboard. Org copies can differ. Never hardcode an id. get that template for the URL. Do not walk widgets. Teach Slots vs on-demand (two sentences): On-demand = pay per TiB scanned.

## Links

- HTML page: https://omgskills.com/library/costory-io/costory-finops-mcp-skills/plugins/costory/skills/bigquery/
- GitHub: https://github.com/costory-io/costory-finops-mcp-skills
- Author: [@costory-io](https://omgskills.com/library/costory-io/index.md)

## More from this repo

- [cost-change-investigation](https://omgskills.com/library/costory-io/costory-finops-mcp-skills/plugins/costory/skills/cost-change-investigation/index.md) — Used when investigating a cost change to explain what changed, when, and the best-supported drivers with contribution,...
   - [@costory-io](https://omgskills.com/library/costory-io/index.md) · 2 stars
- [dashboards](https://omgskills.com/library/costory-io/costory-finops-mcp-skills/plugins/costory/skills/dashboards/index.md) — Used when creating or extending Costory dashboards, generating interesting FinOps overviews (suggest\_groupby +...
   - [@costory-io](https://omgskills.com/library/costory-io/index.md) · 2 stars
- [recipes](https://omgskills.com/library/costory-io/costory-finops-mcp-skills/plugins/costory/skills/recipes/index.md) — Used when a user states a FinOps \*outcome\* rather than a tool.
   - [@costory-io](https://omgskills.com/library/costory-io/index.md) · 2 stars
