mongodb-atlas

Optimize MongoDB queries by analyzing existing indexes, creating compound or text indexes for frequently searched fields, and building aggregation pipelines to filter and transform data efficiently. This skill automates index creation, maintenance, and performance tuning to accelerate query response times.

Design MongoDB schemas by modeling data structures with Prisma, defining relationships, and creating appropriate indexes for query patterns. This skill guides schema design, TTL collection management, and index strategies to match your application's data access requirements.

Aggregation pipelines transform and analyze MongoDB data through stages like match, group, and sort. This skill helps develop complex pipelines for data analysis, supports testing via Mongo shell commands, and integrates with Atlas clusters for production workloads.

Yes. This skill automates MongoDB Atlas cluster management using the Atlas CLI and API, enabling programmatic cluster lifecycle operations, configuration updates, and administrative tasks alongside schema and query optimization.

Yes. This skill integrates with Prisma MongoDB implementations, supporting schema modeling, query optimization, index creation, and aggregation pipeline development to enhance performance and maintainability of ORM-based applications.

Index optimization works best for predictable query patterns; compound indexes have cardinality tradeoffs, and over-indexing increases write overhead. This skill guides index selection and maintenance strategies, but query structure and data volume still affect performance.