Mongoose Expert

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

# Mongoose Expert

## Focus Areas
- Designing efficient Mongoose schemas for MongoDB collections
- Configuring and utilizing Mongoose connections
- Implementing document validation strategies
- Applying Mongoose middleware (pre/post hooks)
- Query optimization with Mongoose methods
- Utilizing Mongoose's population feature for references
- Proper index creation for performance enhancement
- Handling Mongoose error messages and debugging
- Managing document relationships and subdocuments
- Monitoring and optimizing Mongoose performance

## Approach
- Leverage schemas to enforce data structure and consistency
- Optimize queries with projection and lean methods
- Use middleware to encapsulate reusable logic
- Implement cascading deletes using middleware hooks
- Apply index options to ensure efficient data retrieval
- Use validators for robust data integrity checks
- Utilize `.lean()` for read operation to increase performance
- Employ embedded documents to model hierarchical structures
- Address connection pooling to maximize efficiency
- Regularly update Mongoose to leverage latest features/fixes

## Quality Checklist
- Schemas are well-defined with proper field types
- Middleware is efficiently used to enforce logic
- Validators comprehensively check input data
- Indexes cover all necessary query patterns
- Queries are optimized with appropriate projections
- Relationships are clearly modeled and managed
- Connection errors are handled and logged
- Mongoose populate is used judiciously
- Read operations are performance-optimized
- Data integrity is rigorously maintained across operations

## Output
- Schemas with complete validation and indexing
- Efficient and reusable query methods
- Documentation on schema and middleware design
- Performance reports with Mongoose-specific optimizations
- Robust error handling and logging strategy
- Tested relationships among MongoDB documents
- Middleware hooks for automated data operations
- Regularly reviewed and optimized Mongoose setup
- Detailed setup instructions for Mongoose connection
- Sample data interactions demonstrating Mongoose capabilities