agentleFS
G1JoshiG1Joshi/Agent-Skills/skills/databases/mongodb/SKILL.md

mongodb

Skill15 starsChanged 42 days agoMITView on GitHub

Expert MongoDB document database assistance covering aggregation pipelines, compound indexes, replica sets, and sharding. Use when designing flexible JSON schemas, querying geospatial data, or scaling document stores.

11 other projects use a version of this.

Adopted by

Most recently taken up by

Used with

Projects with it also use performance, security and 2 more.

Other files people use alongside this one.

Files found in the same public projects as a version of this one, more often than they turn up anywhere else. Each project counts once, large collections count for less, and this file's own repository is left out.
  • klauswgSkill

    performance

    Optimize web performance for faster loading and better user experience. Use when asked to "speed up my site", "optimize performance", "reduce load time", "fix slow loading", "improve page speed", or "performance audit".

    Also in 3 projects that use this

  • 0xSeroSkill

    security

    Also in 3 projects that use this

  • MicrosoftSkill

    api-design

    Guide for designing and documenting RESTful APIs. Use when asked to design an API, create endpoints, or document an API.

    Also in 3 projects that use this

  • NVIDIASkill

    testing

    Run Python and Rust tests for physicsnemo-curator using uv + pytest with coverage reporting via pytest-cov, and cargo-nextest for Rust tests. Includes benchmark workflows with pytest-benchmark and criterion.

    Also in 3 projects that use this

The file

We split this skill into the rules it gives an agent

5 rules. 0 are common, 2 are distinctive, and 3 are very specific to this project.

  • 0

    Common

    Most of the 8 edited versions we read keep these.

  • 2

    Distinctive

    This author's own choices. Worth a look.

  • 3

    Very specific

    Tied to their project's names, files or tools. Probably skip.

  • Common
  • Distinctive
  • Very specific
  1. Very specific:

    Use $lookup with $project and pagination $facet:

    line 94
  2. Distinctive:

    Follow the ESR Rule for Indexes: Order compound indexes by Equality first, Sort second, and Range last.

    line 128
  3. Very specific:

    Use Bulk Operations: Batch multiple write operations using bulkWrite() to minimize network roundtrips.

    line 130
  4. Distinctive:

    Create unbounded arrays inside documents: Unbounded arrays degrade performance and can hit the 16MB document size limit.

    line 134
  5. Very specific:

    Use $lookup excessively: MongoDB is not a relational database.

    line 135

“Common” is measured: kept by at least 6 in 10 of the 8 edited versions of this file we could read. “Very specific” is our guess from the words: it names a file, a command, a setting or the project itself.

Keep what fits and drop the rest. Your version, ready for your agents.
Files
SKILL.md

MongoDB

MongoDB is a document database. It stores data in JSON-like documents (BSON). It is the most popular NoSQL database, known for flexibility and scalability.

When to Use

  • Flexible JSON Document Storage: Modeling evolving, nested domain entities with polymorphic schemas in BSON.
  • High-Velocity Operational Data Stores: Content management, e-commerce product catalogs, and user personalization platforms.
  • Rich Aggregation Pipelines: Transforming, joining ($lookup), grouping, and projecting analytical data streams in real time.
  • Global Sharding & Geospatial Indexing: Scaling collections horizontally across shards and executing 2dsphere geo queries.

Quick Start

// Using Mongoose (Node.js)
const kittySchema = new mongoose.Schema({
  name: String,
});
const Kitten = mongoose.model("Kitten", kittySchema);

const silence = new Kitten({ name: "Silence" });
await silence.save();

Core Concepts

BSON Documents & Schema Flexibility

Data is stored as binary JSON (BSON), supporting native dates, 64-bit integers, decimals, and geospatial points:

// MongoDB Document in collections/orders
{
  "_id": ObjectId("66f6ab42d1e1c3a628a58a98"),
  "orderNumber": "ORD-2026-901",
  "customer": { "id": "cust_12", "email": "alex@example.com" },
  "items": [
    { "sku": "WIDGET-01", "qty": 2, "price": 49.99 }
  ],
  "shippingAddress": {
    "type": "Point",
    "coordinates": [-73.9851, 40.7488] // 2dsphere GeoJSON
  },
  "status": "PROCESSING",
  "createdAt": ISODate("2026-09-27T10:00:00Z")
}

Powerful Multi-Stage Aggregation Framework

Transforms and aggregates documents through sequential pipeline stages:

db.orders.aggregate([
  {
    $match: { status: "COMPLETED", createdAt: { $gte: ISODate("2026-01-01") } },
  },
  { $unwind: "$items" },
  {
    $group: {
      _id: "$items.sku",
      totalRevenue: { $sum: { $multiply: ["$items.qty", "$items.price"] } },
      unitsSold: { $sum: "$items.qty" },
    },
  },
  { $sort: { totalRevenue: -1 } },
  { $limit: 5 },
]);

Replica Sets & Automated Failover

Ensures high availability through 3-node primary-secondary elections:

[ Primary (Read/Write) ] ──Oplog Replication (Async)──→ [ Secondary (Read Replicas) ]
                                                              │
                                                              ▼
                                                     [ Secondary (Voter) ]

Common Patterns

Aggregation Pipeline with Lookup and Facets

Problem: Normalizing and joining related documents across collections efficiently in a single query.

Solution: Use $lookup with $project and pagination $facet:

db.orders.aggregate([
  {
    $match: { status: "DELIVERED", createdAt: { $gte: ISODate("2025-01-01") } },
  },
  {
    $lookup: {
      from: "users",
      localField: "userId",
      foreignField: "_id",
      as: "customer",
    },
  },
  { $unwind: "$customer" },
  {
    $project: {
      orderId: "$_id",
      totalAmount: 1,
      customerName: "$customer.name",
      customerEmail: "$customer.email",
    },
  },
  { $sort: { totalAmount: -1 } },
  { $limit: 20 },
]);

Best Practices

Do:

  • Design for Data Access Patterns: Embed data that is read together frequently; reference data when unbounded growth is expected.
  • Follow the ESR Rule for Indexes: Order compound indexes by Equality first, Sort second, and Range last.
  • Enable JSON Schema Validation: Enforce required fields and types at the collection level via $jsonSchema.
  • Use Bulk Operations: Batch multiple write operations using bulkWrite() to minimize network roundtrips.

Don't:

  • Create unbounded arrays inside documents: Unbounded arrays degrade performance and can hit the 16MB document size limit.
  • Use $lookup excessively: MongoDB is not a relational database; heavy multi-collection joins destroy throughput.
  • Perform unindexed queries: Run .explain("executionStats") to verify queries utilize IXSCAN rather than COLLSCAN.

Troubleshooting

ErrorCauseSolution
Executor error during find command: OperationExceededTimeLimitQuery performing full collection scan (COLLSCAN) without supporting index.Run explain('executionStats') and add compound index matching filter and sort keys.
WriteConflict errorConcurrent updates modifying same document concurrently in WiredTiger.Implement retry logic in application layer or batch modifications.
BSONObj size exceeds maximum allowed size (16MB)Single document exceeded 16MB limit due to unbounded arrays.Refactor schema: move unbounded child arrays into separate collection with parent references.

References

Download now (ZIP)

Does it work?

Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.

No reviews yet

People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.

  • It worked
  • Partly
  • It didn't
What did you use it for? e.g. Reviewing pull requests in a Rails app

Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.

Your trail

Files you open will collect here, so you can find them again.

Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.

Now do this for your own.

Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.