mongodb-expert

Analyze MongoDB deployments and generate targeted optimization plans.

218|14|Updated Apr 5, 2025
One-click install
npx skills add https://github.com/cin12211/orca-q --skill mongodb-expert
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: mongodb-expert
Source: https://github.com/cin12211/orca-q/tree/main/.agent/skills/mongodb-expert
Command: npx skills add https://github.com/cin12211/orca-q --skill mongodb-expert

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

ThisSkill helps teams solve MongoDB performance and schema design challenges by providing expert guidance on document modeling, aggregation optimization, sharding strategies, replica set configuration, indexing patterns, and read/write tuning to improve reliability and performance across deployments.

Core Features & Use Cases

  • Document Modeling & Schema Design: guidance on embed vs reference, bounded arrays, and schema evolution for scalable MongoDB deployments.
  • Aggregation & Indexing: optimization of pipelines, index strategies following ESR principles, and memory-aware queries.
  • Sharding & Replication: guidance on shard keys, balancer behavior, and replica set tuning for high availability.
  • Use Case: Imagine you have a large e-commerce catalog; use this skill to design a schema and indexes that support fast product lookups and analytics.

Quick Start

Analyze a MongoDB deployment and generate a targeted optimization plan.

Frequently Asked Questions about mongodb-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize MongoDB aggregation pipelines for slow queries?

To optimize MongoDB aggregation pipelines, apply memory-aware query construction and follow ESR index principles to reduce query latency. This ensures efficient pipeline execution by minimizing memory usage and leveraging appropriate index strategies across your deployment.

What is the best way to design a MongoDB schema for high read performance?

The best way to design a MongoDB schema for high performance is choosing embed versus reference patterns while maintaining bounded arrays. This ensures scalable document modeling that supports fast product lookups and analytics without unbounded document growth.

How do I choose a shard key for MongoDB sharded deployments?

Choosing a MongoDB shard key requires analyzing query patterns and balancer behavior to distribute data evenly. Proper shard key selection prevents hot shards and ensures scalable write operations across your sharded deployment.

Does this MongoDB tuning approach work for replica set configurations?

Yes, this MongoDB tuning approach works for replica set configurations by providing specific guidance on replica set tuning and read write optimization. It ensures high availability across standalone, replica set, and sharded deployments.

When should I not use embedded documents in MongoDB schema design?

You should not use embedded documents in MongoDB schema design when dealing with unbounded arrays or frequently updated related data. Using references instead prevents exceeding document size limits and reduces write amplification.