Design MongoDB schemas, write queries, and optimize aggregation pipelines and indexes.
npx skills add https://github.com/bacoco/openfang-fork --skill mongodb-bacoco
Please help me install this Agent Skill. Skill: mongodb Source: https://github.com/bacoco/openfang-fork/tree/main/crates/openfang-skills/bundled/mongodb Command: npx skills add https://github.com/bacoco/openfang-fork --skill mongodb-bacoco
This Skill empowers users to efficiently manage and interact with MongoDB databases, from designing optimal schemas and writing complex queries to ensuring high performance through effective indexing.
$elemMatch, $in, $text, and avoiding slow operators.$match, $group, $lookup, $facet, and $merge.Provide a MongoDB schema design for a blog post with comments, prioritizing read performance for fetching posts and their associated comments.
High-intent search queries and answers about installing and using this skill.
Optimize MongoDB queries by applying projections, leveraging `$elemMatch` and `$in` operators, and avoiding slow operators or unindexed wildcard regex patterns that cause performance bottlenecks.
The best way to structure MongoDB schema design for high read performance is choosing between embedding versus referencing, and utilizing subset or bucket patterns to optimize data retrieval for scalable applications.
Construct MongoDB aggregation pipelines by chaining stages like `$match`, `$group`, `$lookup`, `$facet`, and `$merge` to process and transform document data efficiently across multiple operations.
Use MongoDB compound indexes for multi-field queries, partial indexes for targeted subsets, and TTL indexes for auto-expiring data, while auditing usage to drop unused indexes and avoid update overhead.
Heavily indexed field updates cause MongoDB performance issues because each write operation must modify all associated indexes, creating significant write overhead and slowing database operations.
Unbounded arrays in MongoDB document models cause document size bloat, memory overhead during retrieval, and degraded write performance, requiring subset or bucket patterns to mitigate these limitations.
PatrickjoshanedezManage MongoDB databases in Node.js apps using Mongoose ODM.
sskim91Analyze SQL query execution plans and apply indexing strategies to reduce latency.
diego-tobalinaDesign MongoDB documents, optimize queries, and implement aggregation pipelines.
ricableDesign database schemas and migration plans for PostgreSQL, MySQL, and NoSQL systems.