Skip to content
gcp-billing logo

GCP Billing 조회

gcp-billing

GCP Billing 조회

SKILL.md

Full skill instructions

GCP Billing 조회

결제 계정의 프로젝트별/서비스별 비용을 조회합니다.

사용법

/​gcp-billing                    # 기본 Billing Export 프로젝트 사용
/​gcp-billing my-project-id      # 특정 프로젝트의 Billing Export 사용

설정

Billing Export 프로젝트와 데이터셋을 확인:

  • 기본값: patent-481206 (context.md 참조)
  • 데이터셋: billing_export.gcp_billing_export_v1_*

실행할 쿼리

프로젝트별 비용 (최근 30일)

BILLING_PROJECT=${1:-patent-481206}

bq query --project_id=$BILLING_PROJECT --use_legacy_sql=false "
SELECT
  project.id AS project_id,
  project.name AS project_name,
  ROUND(SUM(cost), 2) AS total_cost,
  currency
FROM \`$BILLING_PROJECT.billing_export.gcp_billing_export_v1_*\`
WHERE DATE(usage_start_time) >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY project.id, project.name, currency
ORDER BY total_cost DESC
"

서비스별 비용 (최근 30일)

bq query --project_id=$BILLING_PROJECT --use_legacy_sql=false "
SELECT
  service.description AS service,
  ROUND(SUM(cost), 2) AS total_cost,
  currency
FROM \`$BILLING_PROJECT.billing_export.gcp_billing_export_v1_*\`
WHERE DATE(usage_start_time) >= DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)
GROUP BY service.description, currency
ORDER BY total_cost DESC
LIMIT 20
"

일별 비용 추이 (최근 7일)

bq query --project_id=$BILLING_PROJECT --use_legacy_sql=false "
SELECT
  DATE(usage_start_time) AS date,
  ROUND(SUM(cost), 2) AS daily_cost
FROM \`$BILLING_PROJECT.billing_export.gcp_billing_export_v1_*\`
WHERE DATE(usage_start_time) >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
GROUP BY date
ORDER BY date DESC
"

출력 형식

## 비용 현황

### 프로젝트별 비용 (30일)
| 프로젝트 | 비용 |
|----------|------|

### 서비스별 비용 (30일)
| 서비스 | 비용 |
|--------|------|

### 일별 추이 (7일)
| 날짜 | 비용 |
|------|------|

---
총 비용: $XX.XX

관련 스킬

스킬용도
/​gcp-billing-accounts결제 계정 목록
/​gcp-billing-projects계정별 프로젝트
/​gcp-usageAPI 사용량 조회

More Other skills

Delegate independent tasks to specialized agents working concurrently with isolated context.

295.4K 206.3K
View

Applies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply.

179.7K 100.1K
View

Toolkit for styling artifacts with a theme. These artifacts can be slides, docs, reportings, HTML landing pages, etc. There are 10 pre-set themes with colors/fonts that you can apply to any artifact that has been creating, or can generate a new theme on-the-fly.

179.7K 89.5K
View

A set of resources to help me write all kinds of internal communications, using the formats that my company likes to use. Claude should use this skill whenever asked to write some sort of internal communications (status reports, leadership updates, 3P updates, company newsletters, FAQs, incident reports, project updates, etc.).

179.7K 76.1K
View

Fundamental design principles for writing maintainable, testable Python code.

40.2K 21.9K
View

Modern responsive layouts using container queries, fluid typography, CSS Grid, and mobile-first strategies.

40.2K 20K
View

Generate Playwright tests from scenarios using interactive browser exploration and validation.

39.7K 18.2K
View

Modern React state management with Redux Toolkit, Zustand, Jotai, and React Query for every state category.

40.2K 14.7K
View

GDPR-compliant data handling with consent management, data subject rights, and privacy controls.

40.2K 14.3K
View

Python error handling patterns including input validation, exception hierarchies, and partial failure handling. Use when implementing validation logic, designing exception strategies, handling batch processing failures, or building robust APIs.

40.2K 13.5K
View

Detailed multi-file refactor planning with safety checks and rollback guidance.

39.7K 13K
View