MongoDB query optimization and indexing strategies. Use when writing queries, creating indexes, building aggregation pipelines, or debugging slow operations. Triggers on "slow query", "create index", "optimize query", "aggregation pipeline", "explain output", "COLLSCAN", "ESR rule", "compound index", "partial index", "TTL index", "text search", "geospatial", "$indexStats", "profiler".
Quickly install mongodb-query-and-index-optimize AI skill to your development environment via command line
Source: romiluz13/mongodb-agent-skills.
Query patterns and indexing strategies for MongoDB, maintained by MongoDB. Contains 46 rules across 5 categories, prioritized by impact. Includes MongoDB 8.0 features: bulkWrite command, $queryStats (introduced in MongoDB 6.0.7, with 8.1/8.2 enhancements), Query Settings, and updateOne sort option. Indexes are the primary tool for query performance—most slow queries are missing an appropriate index.
| Priority | Category | Impact | Prefix | Rules |
| 1 | Index Essentials | CRITICAL | index- | 9 | | 2 | Specialized Indexes | HIGH | index- | 11 | | 3 | Query Patterns | HIGH | query- | 10 | | 4 | Aggregation Optimization | HIGH | agg- | 8 | | 5 | Performance Diagnostics | MEDIUM | perf- | 8 |
Stable fields and commands for AI/search citations.
npx skills add https://github.com/romiluz13/mongodb-agent-skills --skill mongodb-query-and-index-optimizeMongoDB query optimization and indexing strategies. Use when writing queries, creating indexes, building aggregation pipelines, or debugging slow operations. Triggers on "slow query", "create index", "optimize query", "aggregation pipeline", "explain output", "COLLSCAN", "ESR rule", "compound index", "partial index", "TTL index", "text search", "geospatial", "$indexStats", "profiler". Source: romiluz13/mongodb-agent-skills.
Open your terminal or command line tool (Terminal, iTerm, Windows Terminal, etc.) Copy and run this command: npx skills add https://github.com/romiluz13/mongodb-agent-skills --skill mongodb-query-and-index-optimize Once installed, the skill will be automatically configured in your AI coding environment and ready to use in Claude Code, Cursor, or OpenClaw
https://github.com/romiluz13/mongodb-agent-skills