@apilium/mongo-dba

MongoDB 8 DBA toolkit skill for Mayros -- aggregation pipelines, performance tuning, index optimization, sharding, Queryable Encryption, and vector search.

Installation

Copy this skill directory into your Mayros skills folder:

cp -r skills/mongo-dba ~/.mayros/skills/mongo-dba

Or install via the Mayros CLI:

mayros skill install @apilium/mongo-dba

Prerequisites

Install MongoDB Shell (mongosh):

# macOS
brew install mongosh

# Ubuntu/Debian
# Follow https://www.mongodb.com/docs/mongodb-shell/install/

# Verify
mongosh --version

Usage

Once configured, the agent can:

• Aggregation: Build complex pipelines with $match, $group, $lookup, $facet, $merge, and MongoDB 8 $percentile/$median
• Performance: Analyze query plans with explain(), identify slow queries, monitor currentOp
• Indexes: Create compound, partial, text, geospatial, wildcard, and TTL indexes; find unused indexes
• Schema design: Embedding vs referencing, schema validation with $jsonSchema, time series collections
• Sharding: Configure shard keys, monitor balancer, check chunk distribution
• Replication: Monitor replica set health, check oplog, manage members
• Vector search: Create vector indexes and run similarity queries (Atlas)
• Security: Queryable Encryption (MongoDB 8), user/role management

Example prompts

"Write an aggregation pipeline to get the top 10 customers by total orders"
"Explain why this query is doing a collection scan and suggest an index"
"What indexes should I create for my users collection?"
"Show me the p95 latency using MongoDB 8 $percentile"
"Set up a time series collection for IoT sensor data"
"How do I configure vector search for semantic similarity?"

Semantic Predicates

| Predicate | Scope | Description | |-----------|-------|-------------| | mongo:optimization_found | agent | Optimizations found by the agent | | mongo:pattern_applied | agent | Patterns applied by the agent | | mongo:admin_context | namespace | Admin context for enrichment |

License

MIT