メニュー
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.
デフォルトでは、最初にソースを確認する Prompt が選択されています。直接コマンドに切り替えるか、ローカルコピーをダウンロードすることもできます。
インストールを決める前に、SKILL.md と SkillsMP に表示されている付属ファイルをお読みください。
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
直接コマンドでは確認用 Prompt が省略されます。実行前にソースを確認してください。
npx skills add https://github.com/huifer/CloudSaver --skill index-optimizerコマンドは1行のまま表示されます。コピー前に横へスクロールして全体を確認してください。
ローカルで確認しますか？SkillsMP が現在取得できるファイルをダウンロードできます。
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.
SOC 職業分類に基づく
SKILL.md を表示中
| name | index-optimizer |
| description | 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. |
| when_to_use | - User asks about index strategy - User needs to optimize query performance - User encounters slow queries - User wants to reduce database costs - User needs to audit index usage |
| allowed-tools | Bash(psql *, wrangler *) |
| Type | Use Case | Trade-off |
|---|---|---|
| Single Column | Simple equality/range | Low overhead |
| Composite | Multi-column queries | Column order matters |
| Partial | Subset of rows | Smaller, faster |
| Covering | Index-only scans | Larger, eliminates lookups |
| Anti-Pattern | Problem | Reference |
|---|---|---|
| Missing composite index | Multi-column queries slow | references/composite-index.md |
| Missing covering index | Table lookups required | references/covering-index.md |
| Missing partial index | Indexing all rows | references/partial-index.md |
| Unused indexes | Write overhead | references/unused-index.md |
| Redundant indexes | Duplicate coverage | references/redundant-index.md |
| Index skip scan | Wrong column order | references/index-skip-scan.md |
Check sequential scans and slow queries.
See references/composite-index.md for multi-column patterns.
Find indexes that are subsets of other indexes.
See references/redundant-index.md for detection.
Monitor index usage statistics.
See references/unused-index.md for detection and removal.
Apply appropriate index type based on query patterns:
references/composite-index.mdreferences/partial-index.mdreferences/covering-index.md| Optimization | Before | After | Improvement |
|---|---|---|---|
| Composite index | 500ms | 5ms | 99% |
| Partial index | 50MB | 5MB | 90% size reduction |
| Covering index | 50ms | 10ms | 80% faster |
| Remove unused | 100ms write | 70ms write | 30% faster |
| Remove redundant | 200MB | 100MB | 50% reduction |
## Index Optimization Report
### 1. Current State
- Total indexes: X
- Missing indexes: X
- Redundant indexes: X
- Unused indexes: X
### 2. Anti-Patterns Detected
| Table | Anti-Pattern | Reference | Fix |
|-------|--------------|-----------|-----|
| ... | ... | ... | ... |
### 3. Recommendations (by priority)
1. [P0] Fix: <anti-pattern> → Expected improvement: XX%
Reference: references/<file>.md
### 4. Implementation
Apply fixes from referenced files.