Is it safe to use for index creation?

The skill follows a safety-first policy: it will provide the exact commands for optimizations but will never execute write operations like index creation without your explicit approval.

Can this skill help me fix 'COLLSCAN' issues?

Absolutely. It contains specific diagnostic rules to interpret explain() output and provides actionable steps to convert collection scans into efficient index scans.

What is the ESR rule in this MongoDB skill?

The ESR (Equality-Sort-Range) rule is a fundamental indexing principle that dictates the order of fields in a compound index—placing equality filters first, then sort fields, and range filters last for maximum efficiency.

Does this skill support the latest MongoDB features?

Yes, it is updated for MongoDB 8.0 and includes specific rules for the bulkWrite command, $queryStats for workload analysis, and persistent index hints via Query Settings.

MongoDB Query & Index Optimizer

Name: MongoDB Query & Index Optimizer
Author: romiluz13

byromiluz13

•

Database Management

Optimizes MongoDB performance by implementing expert indexing strategies, efficient query patterns, and high-performance aggregation pipelines.

This specialized Claude Code skill provides a comprehensive framework of 46 rules for mastering MongoDB performance. It guides developers through the critical ESR (Equality-Sort-Range) rule for compound indexes, helps diagnose slow operations using explain plan analysis, and offers best practices for specialized indexing like TTL, geospatial, and wildcard indexes. Updated for MongoDB 8.0, it includes advanced patterns for bulk operations and query statistics, ensuring your database remains performant as your data scales.

Key Features

01Full support for MongoDB 8.0 features like bulkWrite and queryStats

02Aggregation pipeline optimization including early matching and projection

03Specialized index support for TTL, Geospatial, Text, and Partial indexes

048 GitHub stars

05Diagnostic patterns for identifying and fixing COLLSCAN and slow queries

06ESR Rule implementation for optimal compound index field ordering

Use Cases

01Fixing slow database performance by identifying missing or inefficient indexes

02Designing complex aggregation pipelines that stay within memory limits

03Automating the review of database queries during the AI-assisted coding process

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add romiluz13/mongodb-agent-skills mongodb-query-and-index-optimize

For use in Claude.ai and ChatGPT

Download Skill