How does the MongoDB Performance Advisor help with slow queries?

It provides a systematic process to run explain plans, identify bottlenecks like collection scans (COLLSCAN), and recommends indexes to reduce execution time and document examination.

Does this skill work with any MongoDB environment?

Yes, it provides standard mongosh commands and analysis patterns that are applicable to MongoDB Atlas, self-hosted instances, and local development environments.

Can this skill help me manage my existing database indexes?

Yes, it includes scripts to list all current indexes, check collection stats, and identify unique, sparse, or TTL indexes that might impact performance or storage.

What is the ESR rule mentioned in the skill?

The ESR rule stands for Equality, Sort, and Range. It is a best-practice guideline for ordering fields in compound indexes to ensure the database can efficiently filter and sort data.

MongoDB Performance Advisor

Name: MongoDB Performance Advisor
Author: hoqo

byhoqo

0•

データベース管理

Optimizes MongoDB database performance by analyzing query plans, recommending efficient indexing strategies, and identifying execution bottlenecks.

The MongoDB Performance Advisor is a specialized skill for Claude Code designed to help developers master database optimization and query efficiency. It provides expert guidance on the 'Equality, Sort, Range' (ESR) rule for compound indexes, interprets complex execution stats from explain plans, and offers actionable checklists for maintaining healthy database operations. Whether you are troubleshooting slow queries, setting up TTL indexes, or ensuring your aggregation pipelines are efficient, this skill serves as a high-level reference and strategic guide for maintaining high-performance MongoDB environments.

主な機能

01Compound index strategy recommendations based on the ESR rule

020 GitHub stars

03Reference scripts for index auditing and database size monitoring

04Query plan interpretation and execution stats analysis

05Identification of performance bottlenecks like COLLSCAN and high docsExamined ratios

06Comprehensive performance checklists for production-ready database configurations

ユースケース

01Designing optimal compound indexes for complex filtering and sorting patterns

02Auditing existing collections to identify redundant indexes or missing optimizations

03Diagnosing and fixing slow-running queries in production environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hoqo/claude-plugins performance-advisor

For use in Claude.ai and ChatGPT

Download Skill