Non-relational database query best practices

Help teams design maintainable, secure, and performant MongoDB and non-relational database queries for Java applications.

What is covered in this Skill?

• Document modeling for aggregates, embedded documents, references, arrays, and bounded growth
• MongoDB JSON Schema validation and compatibility-aware schema evolution
• Query design: explicit predicates, projections, sort stability, pagination, collation, and read concerns
• Index strategy: compound indexes, covering queries, partial indexes, TTL indexes, unique constraints, and lifecycle review
• Aggregation pipelines: stage ordering, $match pushdown, $project, $lookup, $unwind, $group, and memory controls
• Consistency, transactions, idempotency, migration safety, testing, observability, and production diagnostics

Scope: Framework-agnostic MongoDB and non-relational data modeling. For Java framework integrations, defer to the matching Spring Boot, Quarkus, or Micronaut MongoDB skill.

Constraints

Keep recommendations at the database-modeling and query layer unless the user explicitly asks for Java framework integration. After editing this repository's XML sources, regenerate skills and verify the build.