gcp-cost

Extract and analyze GCP cost data from BTDP infrastructure using SQL queries.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/smorand/claude-config --skill gcp-cost
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: gcp-cost
Source: https://github.com/smorand/claude-config/tree/main/archives/skills.old/gcp-cost
Command: npx skills add https://github.com/smorand/claude-config --skill gcp-cost

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This archival Skill provides a framework to query and analyze GCP costs, focusing on post-discount costs and excluding marketplace when not requested.

Core Features & Use Cases

  • Load costs tables, apply filters by date, etc.

Quick Start

"Run a cost query for 2025."

Frequently Asked Questions about gcp-cost

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I retrieve and analyze GCP cost data from my cloud infrastructure?

Retrieve GCP cost data by querying the costs_distributed_per_day_v1 schema through the btdp-it-masterdata-retrieval workflow, applying date constraints and cost_after_discount_euro metrics to extract post-discount cloud spending with optional marketplace filtering.

Can I break down GCP billing by project and time period?

Yes. Construct SQL queries against the cost tables with date constraints and project-level filters to aggregate spending across daily, monthly, or project-based scopes, then apply rounding for formatted results.

How do I exclude marketplace costs from my GCP spending analysis?

GCP cost analysis applies is_marketplace filters by default to exclude marketplace spending. Include marketplace data only when explicitly requested by modifying the filter logic in your query.

What's the best way to get precise cloud-spend insights across multiple GCP projects?

Load the costs_distributed_per_day_v1 schema, execute SQL queries using cost_after_discount_euro with appropriate date and project filters, then aggregate results to produce precise breakdowns across your GCP infrastructure.

Can I use this for GCP cost optimization scenarios?

Yes. The Skill supports cost optimization analysis by enabling you to query spending patterns, identify cost drivers by project and time period, and compare post-discount costs to inform optimization decisions.