メニュー
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.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
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.
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.
Redis cost optimization expert. Analyzes memory usage, connection management, command patterns, hot keys, and provides optimization strategies. Trigger when user mentions Redis costs, memory optimization, or Redis audit.
| name | cost-monitor |
| description | 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. |
| when_to_use | - User needs to set up cost alerts - User wants to analyze cost trends - User needs to predict future expenses - User wants to monitor usage patterns - User needs to detect cost anomalies |
| allowed-tools | Bash(curl *, jq *) |
| Component | Purpose | Frequency |
|---|---|---|
| Usage Metrics | Track current usage | Real-time |
| Alerts | Early warning | On threshold |
| Trends | Pattern analysis | Daily/Weekly |
| Forecasting | Cost prediction | Monthly |
Configure threshold-based notifications for each service.
See cases/alert-setup.md for implementation.
Store usage metrics over time for analysis.
Identify patterns and growth rates.
See cases/trend-analysis.md for detailed analysis.
Predict future costs based on historical data.
| Task | Case File | Output |
|---|---|---|
| Alert setup | cases/alert-setup.md | Notification config |
| Trend analysis | cases/trend-analysis.md | Growth patterns |
| Anomaly detection | cases/trend-analysis.md | Spike alerts |
-- Database size
SELECT pg_database_size(current_database());
-- Active connections
SELECT count(*) FROM pg_stat_activity;
-- Query performance
SELECT query, calls, total_exec_time
FROM pg_stat_statements
ORDER BY total_exec_time DESC LIMIT 10;
# Workers usage
wrangler analytics
# D1 usage
wrangler d1 info <database>
# Memory usage
redis-cli INFO memory
# Key count
redis-cli DBSIZE
## Cost Monitoring Report
### 1. Current Usage
| Service | Metric | Value | Threshold | Status |
|---------|--------|-------|-----------|--------|
| Supabase | DB Size | X MB | 400 MB | OK |
| Workers | Requests | X K | 80 K | Warning |
### 2. Trend Analysis (30 days)
| Service | Metric | Daily Growth | Projected (30d) |
|---------|--------|--------------|-----------------|
| Supabase | DB Size | X MB/day | X MB |
### 3. Alerts Configured
- [Service] [Metric]: [Threshold] → [Channel]
### 4. Recommendations
1. [Action] → Expected impact