cost-audit-master

name	cost-audit-master
description	Master orchestrator for cloud cost audits. Coordinates multiple service-specific audit skills to provide comprehensive cost optimization recommendations. Trigger when user mentions full cost audit, comprehensive optimization, or multi-service cost review.
when_to_use	- User wants a complete cost audit - User needs to optimize multiple services - User wants prioritized recommendations - User needs cost reduction strategy - User wants to identify savings opportunities
allowed-tools	Bash(*)

Cloud Cost Audit Master

Supported Services

Service	Audit Skill	Key Metrics
Supabase	supabase-audit	DB size, queries, storage, Auth MAU
Cloudflare	cloudflare-audit	Workers, D1, KV, R2
D1	d1-cost-optimizer	Row Reads, indexes
Redis	redis-audit	Memory, connections
Indexes	index-optimizer	Missing, unused indexes
Queries	query-rewriter	Inefficient patterns
Monitoring	cost-monitor	Alerts, trends
Budget	spend-cap-manager	Spend caps, limits

Audit Workflow

Step 1: Service Discovery

Identify all cloud services in use.

Step 2: Execute Service Audits

Run each service-specific audit skill:

• supabase-audit → Database performance
• cloudflare-audit → Workers, D1, KV, R2
• redis-audit → Memory, connections
• index-optimizer → Index analysis
• query-rewriter → Query patterns

See cases/full-audit.md for comprehensive audit process.

Step 3: Aggregate Results

Collect findings from all audits.

Step 4: Prioritize Recommendations

Rank by:

1. Impact (cost savings)
2. Effort (implementation time)
3. Risk (potential issues)

Step 5: Generate Report

Create comprehensive audit report with prioritized action plan.

Matching Cases

Scope	Case File	Output
Full audit	cases/full-audit.md	Comprehensive report

Output Format

# Cloud Cost Audit Report

**Date:** YYYY-MM-DD
**Scope:** All services

## Executive Summary
- Total monthly cost: $X
- Potential savings: $X (XX%)
- Priority actions: X

## Service Analysis

### Supabase
- Status: [OK/Warning/Critical]
- Findings: X issues
- Savings: $X/month

### Cloudflare
- Status: [OK/Warning/Critical]
- Findings: X issues
- Savings: $X/month

### Redis
- Status: [OK/Warning/Critical]
- Findings: X issues
- Savings: $X/month

## Priority Recommendations

### P0 - Immediate (This Week)
1. [Action] → $X savings
2. [Action] → $X savings

### P1 - Short-term (This Month)
1. [Action] → $X savings

### P2 - Medium-term (This Quarter)
1. [Action] → $X savings

## Implementation Plan
| Week | Actions | Expected Savings |
|------|---------|------------------|
| 1 | P0 items | $X |
| 2 | P1 items | $X |
| 3-4 | P2 items | $X |

## Monitoring Setup
Reference: cost-monitor skill

## Next Audit
Recommended: YYYY-MM-DD (30 days)