菜单
Supabase cost optimization and audit expert. Monitors database performance, storage, bandwidth, Edge Functions, Auth MAU, and provides optimization recommendations. Trigger when user mentions Supabase costs, database optimization, or Supabase audit.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
| name | supabase-audit |
| description | Supabase cost optimization and audit expert. Monitors database performance, storage, bandwidth, Edge Functions, Auth MAU, and provides optimization recommendations. Trigger when user mentions Supabase costs, database optimization, or Supabase audit. |
| when_to_use | - User asks about Supabase billing - User needs to optimize database performance - User encounters Supabase cost overages - User needs to audit table structure and indexes - User wants to reduce Edge Function invocations |
| allowed-tools | Bash(psql *) |
| Component | Free Tier | Billing Metric |
|---|---|---|
| Database | 500MB | Storage size |
| Storage | 1GB | Storage + Egress |
| Auth | 50,000 MAU | Monthly Active Users |
| Edge Functions | 500K invocations | Invocations |
| Realtime | 200 concurrent | Connections |
| Bandwidth | 5GB | Egress |
| Anti-Pattern | Problem | Reference |
|---|---|---|
| Slow queries | High CPU time | references/slow-queries.md |
| Missing indexes | Sequential scans | references/index-optimization.md |
| Missing FK indexes | Slow joins | references/missing-foreign-key-index.md |
| Table bloat | Dead tuples | references/table-bloat.md |
| Connection issues | Too many connections | references/connection-pooling.md |
| Inefficient joins | Cartesian products | references/inefficient-join.md |
| Correlated subqueries | N+1 pattern | references/slow-subquery.md |
| Deep pagination | OFFSET performance | references/inefficient-pagination.md |
SELECT pg_database_size(current_database());
SELECT pg_size_pretty(pg_database_size(current_database()));
Use pg_stat_statements to find slow queries.
See references/slow-queries.md for detailed analysis.
Analyze sequential scans vs index scans.
See references/index-optimization.md for optimization strategies.
Check dead tuple ratio and vacuum status.
See references/table-bloat.md for cleanup procedures.
Ensure proper connection management.
See references/connection-pooling.md for configuration.
| Optimization | Before | After | Improvement |
|---|---|---|---|
| Add index | 500ms | 5ms | 99% |
| Clean bloat | 500MB | 300MB | 40% |
| Use pooling | 60 conn | 200+ conn | 233% |
| Fix join | 5000ms | 50ms | 99% |
| Cursor pagination | 100ms | 5ms | 95% |
## Supabase Cost Audit Report
### 1. Current Usage
- Database size: X MB / 500 MB (X%)
- Storage: X GB / 1 GB (X%)
- Bandwidth: X GB / 5 GB (X%)
- Auth MAU: X / 50,000 (X%)
### 2. Anti-Patterns Detected
| Query | Anti-Pattern | Reference | Fix |
|-------|--------------|-----------|-----|
| ... | ... | ... | ... |
### 3. Recommendations (by priority)
1. [P0] Fix: <anti-pattern> → Expected improvement: XX%
Reference: references/<file>.md
### 4. Cost Projection
- Current: $X/month
- After optimization: $X/month
- Savings: $X/month (XX%)
Cloudflare platform cost optimization expert. Monitors Workers, D1, KV, R2 usage, identifies cost anomalies, and provides optimization recommendations. Trigger when user mentions Cloudflare costs, Workers optimization, or platform audit.
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.
Cloud service cost monitoring expert. Sets up alerts, analyzes trends, and predicts future costs. Trigger when user mentions cost monitoring, usage alerts, or cost forecasting.
Cloudflare D1 database cost optimization expert. Analyzes SQL query Row Reads consumption, identifies cost explosion risks, and provides index optimization, query rewriting, and denormalization strategies. Trigger when user mentions D1, Row Reads, query optimization, or database cost.
Database indexing optimization expert. Identifies missing, redundant, and unused indexes, and provides optimization recommendations. Trigger when user mentions index optimization, query performance, or database tuning.
SQL query rewriting expert. Identifies inefficient query patterns and provides optimized alternatives. Trigger when user mentions query optimization, SQL rewriting, or query performance.