Mongodb Expert

What it does

This skill provides expert guidance on MongoDB database management and optimization. It helps troubleshoot complex queries, design efficient schemas, and optimize performance through analysis of your environment and categorization of issues into specific problem areas like document modeling or sharding strategies. The skill can detect your MongoDB setup using connection strings, configuration files, package dependencies, default ports, and Atlas configurations.

When to use it

• You're experiencing slow query performance in your MongoDB database.
• You need help designing a new schema for your data model.
• You’re receiving warnings about large document sizes approaching the 16MB limit.
• You are unsure whether to embed or reference data within your documents.
• You're trying to optimize a sharded cluster or replica set configuration.

Key capabilities

• MongoDB Environment Detection: Identifies MongoDB setup details (connection strings, configurations, package dependencies).
• Problem Categorization: Classifies issues into eight major problem areas including document modeling and schema design.
• Document Size Analysis: Provides commands to analyze document sizes and structures using db.collection.stats() and aggregation pipelines.
• Embed vs. Reference Guidance: Offers a decision matrix for choosing between embedding and referencing data.
• Anti-Pattern Identification: Highlights common anti-patterns like unbounded array growth in documents.

Example prompts

• "My MongoDB query is very slow, can you help me optimize it?"
• "I'm designing a new schema for my application; what are some best practices for document modeling?"
• “How do I determine if I should embed or reference data in my MongoDB documents?”
• "What’s wrong with this query: db.collection.find({}, { arrayField: { $slice: 1 } })?"

Tips & gotchas

• To get the most accurate recommendations, provide as much detail as possible about your MongoDB environment (connection strings, configuration files).
• The skill focuses on diagnosing and suggesting solutions for specific problem areas within MongoDB. It is not a general database management tool.
• Be aware that the skill provides commands to execute within your MongoDB shell; you will need access to a MongoDB client like mongosh or MongoDB Compass to run them.