Diagnose MongoDB deployments and optimize indexing, sharding, and replication.
npx skills add https://github.com/phuxp17/demo_web --skill mongodb-expert-phuxp17
Please help me install this Agent Skill. Skill: mongodb-expert Source: https://github.com/phuxp17/demo_web/tree/main/.agent/skills/mongodb-expert Command: npx skills add https://github.com/phuxp17/demo_web --skill mongodb-expert-phuxp17
This Skill helps engineers diagnose and resolve MongoDB performance bottlenecks, design efficient schemas, and optimize indexing, replication, and sharding for scalable data platforms.
Example: audit a MongoDB deployment and return a prioritized optimization plan showing indexing, schema changes, and shard key recommendations.
High-intent search queries and answers about installing and using this skill.
To optimize MongoDB performance, analyze explain plans to identify full collection scans and apply the ESR rule for compound indexes. This ensures efficient document retrieval by prioritizing indexed fields and covered queries to minimize collection scans.
MongoDB schema design avoids large unbounded arrays by embedding only bounded data or using referencing patterns. This improves read and write efficiency by preventing document size limits and reducing memory overhead during array modifications.
Choosing a MongoDB shard key requires analyzing query patterns and data distribution to ensure even chunk distribution. Composite shards are recommended when single fields cannot provide sufficient cardinality or targeted query isolation.
Yes, MongoDB optimization applies to standalone, replica sets, and sharded clusters in both on-premises and Atlas-like deployments. It addresses replication configuration, read preferences, and transaction patterns across these multi-node environments.
Handling MongoDB transactions in a replica set requires configuring read preferences and applying reliable multi-document transaction patterns. This maintains data consistency across nodes while optimizing concurrency within the deployment.
rabbicseOptimize slow PostgreSQL and MySQL queries with EXPLAIN ANALYZE validation.
AstrumonDiagnose slow SQL queries and optimize PostgreSQL and SQLite configurations.
diendhAnalyze MongoDB deployments and generate prioritized optimization plans.
Fujigo-SoftwareDesign scalable databases with data modeling, normalization, and indexing.
