Get Index Recommendations

Get comprehensive MongoDB index recommendations.

Analyzes query patterns and generates prioritized index recommendations with ready-to-use MongoDB commands.

Use Cases:

• Get actionable index suggestions
• Prioritize database optimization
• Copy/paste index creation commands
• Track optimization opportunities

Recommendation Levels:

• HIGH PRIORITY: >100 queries, >300ms avg OR >10 very slow queries
• MEDIUM PRIORITY: >50 queries, >200ms avg OR >20 slow queries
• LOW PRIORITY: >10 queries but acceptable performance
• NO ACTION: Low usage, no optimization needed

Response Includes:

• Prioritized recommendations
• Usage and latency statistics
• MongoDB index creation commands
• Summary by priority level

Example:

curl -X GET "https://api.mixpeek.com/v1/analytics/namespaces/indexes/recommendations" \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "X-Namespace: your-namespace"