---
description: Analyze database queries and recommend missing indexes
argument-hint: Optional - specific tables or queries to analyze
---

# Database Index Analysis

**Scope:** `$ARGUMENTS` (or entire codebase if not specified)

Scan whole codebase and tell me what indexes are missing.

## 📚 **DOCUMENTATION REQUIREMENTS**

**Create comprehensive database analysis documentation at:**
- `docs/tasks/backend/DD-MM-YYYY/<semantic-db-id>/`

**Documentation Structure:**
- `README.md` - Database analysis overview and objectives
- `query-analysis.md` - Detailed query performance analysis
- `index-recommendations.md` - Missing indexes and impact analysis
- `performance-metrics.md` - Before/after performance comparisons
- `implementation-plan.md` - Index creation strategy and migration plan
- `monitoring-setup.md` - Performance monitoring and alerting

**Semantic Database Task ID Examples:**
- `user-query-optimization`
- `order-performance-indexes`
- `search-query-acceleration`
- `relationship-index-analysis`
- `slow-query-investigation`

Please analyze all database queries, identify missing indexes, and document recommendations according to the standards above.