Agent skill
mongodb-query-builder
Build and optimize MongoDB queries, aggregation pipelines, and CRUD operations. Use when the user asks to query data, filter documents, join collections, aggregate results, update documents, or work with MongoDB data in any way.
Install this agent skill to your Project
npx add-skill https://github.com/majiayu000/claude-skill-registry/tree/main/skills/other/other/mongodb-query-builder
SKILL.md
MongoDB Query Builder
You are an expert MongoDB query builder. When asked to work with MongoDB data, build efficient queries following these guidelines.
Query Building Process
- Understand the data model: Ask about or infer the collection schema
- Choose the right operation: find, aggregate, updateOne/Many, deleteOne/Many
- Build incrementally: Start simple, add stages/operators as needed
- Optimize: Use indexes, avoid full collection scans, limit results
Aggregation Pipeline Stages Reference
| Stage | Purpose | Example |
|---|---|---|
$match |
Filter documents | { $match: { status: "active" } } |
$group |
Group and aggregate | { $group: { _id: "$category", total: { $sum: "$price" } } } |
$lookup |
Join collections | { $lookup: { from: "orders", localField: "_id", foreignField: "userId", as: "orders" } } |
$project |
Reshape documents | { $project: { name: 1, total: { $multiply: ["$price", "$qty"] } } } |
$sort |
Order results | { $sort: { createdAt: -1 } } |
$limit |
Cap output | { $limit: 20 } |
$unwind |
Flatten arrays | { $unwind: "$tags" } |
$addFields |
Add computed fields | { $addFields: { fullName: { $concat: ["$first", " ", "$last"] } } } |
$facet |
Multiple pipelines | { $facet: { byStatus: [...], byDate: [...] } } |
$bucket |
Range grouping | { $bucket: { groupBy: "$price", boundaries: [0, 50, 100, 500] } } |
$out |
Replace collection with results | { $out: "reports" } |
$merge |
Merge results into collection | { $merge: { into: "reports" } } |
Common Operators
Comparison: $eq, $ne, $gt, $gte, $lt, $lte, $in, $nin
Logical: $and, $or, $not, $nor
Array: $all, $elemMatch, $size, $push, $pull, $addToSet
String: $regex, $text, $concat, $substr, $toLower, $toUpper
Date: $dateToString, $year, $month, $dayOfMonth, $dateFromString
Pattern: Join with $lookup
// Simple join
db.orders.aggregate([
{
$lookup: {
from: "customers",
localField: "customerId",
foreignField: "_id",
as: "customer"
}
},
{ $unwind: "$customer" }
])
// Correlated subquery join (more powerful)
db.orders.aggregate([
{
$lookup: {
from: "products",
let: { items: "$lineItems" },
pipeline: [
{ $match: { $expr: { $in: ["$_id", "$$items"] } } },
{ $project: { name: 1, price: 1 } }
],
as: "products"
}
}
])
Pattern: Pagination
// Offset-based (simple but slow for large offsets)
db.collection.find(query).sort({ _id: 1 }).skip(page * size).limit(size)
// Cursor-based (efficient for large datasets)
db.collection.find({ _id: { $gt: lastSeenId } }).sort({ _id: 1 }).limit(size)
Pattern: Full-text Search
// Create text index first
db.articles.createIndex({ title: "text", body: "text" })
// Search
db.articles.find(
{ $text: { $search: "mongodb aggregation" } },
{ score: { $meta: "textScore" } }
).sort({ score: { $meta: "textScore" } })
Pattern: Transactions
const session = db.getMongo().startSession()
session.startTransaction()
try {
db.accounts.updateOne({ _id: from }, { $inc: { balance: -amount } }, { session })
db.accounts.updateOne({ _id: to }, { $inc: { balance: amount } }, { session })
session.commitTransaction()
} catch (e) {
session.abortTransaction()
throw e
}
Execution
Always execute queries via mongosh:
mongosh "$MONGODB_URI" --quiet --eval "<query>"
See examples/ for more complete query patterns.
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
majiayu000/claude-skill-registry
agent-ops-spec
Manage specification documents in .agent/specs/. Use when user provides requirements, acceptance criteria, or feature descriptions that need to be tracked and validated against implementation.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-testing
Test strategy, execution, and coverage analysis. Use when designing tests, running test suites, or analyzing test results beyond baseline checks.
majiayu000/claude-skill-registry
agent-ops-state
Maintain .agent state files. Use at session start, after meaningful steps, and before concluding: read/update constitution/memory/focus/issues/baseline consistently.
Didn't find tool you were looking for?