メニュー
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.
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.
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.
| name | redis-audit |
| description | 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. |
| when_to_use | - User asks about Redis billing - User needs to optimize memory usage - User encounters Redis performance issues - User needs to audit Redis configuration - User wants to reduce Redis expenses |
| allowed-tools | Bash(redis-cli *) |
| Factor | Impact | Optimization |
|---|---|---|
| Memory | Primary cost | Compression, TTLs |
| Connections | Resource usage | Pooling |
| Commands | CPU usage | Batching, pipelines |
| Network | Egress | Compression |
redis-cli INFO memory
Analyze fragmentation, peak memory, and eviction stats.
See cases/memory-optimization.md for optimization.
redis-cli INFO clients
Check connection count and timeout settings.
See cases/connection-optimization.md for pooling strategies.
redis-cli --hotkeys
Find keys with disproportionate access patterns.
See cases/hot-key-optimization.md for sharding strategies.
redis-cli SLOWLOG GET 10
Identify expensive operations and optimize queries.
| Problem | Case File | Solution |
|---|---|---|
| High memory | cases/memory-optimization.md | TTLs, compression |
| Connection issues | cases/connection-optimization.md | Pooling |
| Hot keys | cases/hot-key-optimization.md | Sharding |
| Optimization | Before | After | Improvement |
|---|---|---|---|
| Memory compression | 1GB | 300MB | 70% |
| Connection pooling | 500 conns | 50 conns | 90% |
| Key sharding | 100K ops/key | 10K ops/key | 90% |
## Redis Cost Audit Report
### 1. Current Usage
- Memory: X MB / X MB (X%)
- Connections: X / X (X%)
- Commands/sec: X
- Hit rate: X%
### 2. Performance Issues
- Slow commands: X
- Hot keys: X
- Memory fragmentation: X
### 3. Recommendations (by priority)
1. [P0] Apply case: <case-name> → Expected improvement: XX%
### 4. Cost Projection
- Current: $X/month
- After optimization: $X/month
- Savings: $X/month (XX%)