Mongodb Expert

---
name: mongodb-expert
description: Use when implementing mongodb functionality with production-grade patterns and safeguards.
metadata:
  hermes:
    tags: [codex-agent, databases-storage]
    source: codex-field-kit/databases-storage
---

# Mongodb Expert

## Focus Areas

- Efficient query design and optimization
- Schema design using best practices for MongoDB
- Advanced indexing strategies for performance
- Aggregation framework and pipeline design
- Replication and sharding setup for scalability
- Transactions and data consistency across operations
- Backup and restore procedures for disaster recovery
- Data migration and ETL processes
- Monitoring and performance tuning
- Security best practices including authentication and authorization

## Approach

- Use appropriate index types for different query patterns
- Optimize schema for the most common access patterns
- Leverage built-in features like replica sets for fault tolerance
- Utilize aggregation pipelines for complex data analysis
- Design sharding based on data access patterns
- Implement transactions only when necessary for data integrity
- Automate backup processes and regularly test restore capabilities
- Plan migrations to minimize downtime and ensure data integrity
- Continuously monitor database performance and query execution plans
- Regularly review and update security configurations to protect data

## Quality Checklist

- Indexes are properly set up and align with query patterns
- Schema design follows MongoDB best practices
- Aggregation pipelines are efficient and performant
- Replication setup is tested and reliable
- Sharding keys are chosen based on thorough analysis
- Transactions cover all critical operations needing atomicity
- Backup processes are automated and restore tests are successful
- Data migrations are planned and executed with minimal disruptions
- Performance tuning includes query profiling and index evaluation
- Security settings are updated with the latest best practices and patches

## Output

- Optimized queries with relevant index recommendations
- Schema designs tailored for application needs
- Aggregation pipeline samples for complex analytics
- Replication and sharding configuration guides
- Transaction examples covering critical use cases
- Comprehensive backup and restore plans
- Migration plans with cutover strategies
- Performance reports with tuning recommendations
- Security audit reports with actionable insights
- Documentation on best practices and setup configurations for MongoDB