MongoDB DBA Patterns Skill

What problem does it solve?

This Skill consolidates operational DBA patterns and runbooks to remove uncertainty when configuring, operating, and upgrading MongoDB instances used by IssueManager and similar .NET applications.

Core Features & Use Cases

• Replica set & cluster management: guidance for initiating replica sets, validating topology changes, and adding members for transaction support.
• Database, collection, and schema practices: recommendations for implicit collection creation with EF Core and explicit collection creation with validators for staging/production.
• Backup, restore & upgrades: schedules and commands for mongodump/mongorestore, Atlas backup guidance, and feature compatibility version procedures for safe major upgrades.
• Performance tuning & indexing: index strategies, partial indexes for archived data patterns, profiling and explain usage to diagnose slow queries.
• Security & operations: SCRAM-SHA-256 authentication, least-privilege user roles, TLS configuration, auditing, and secrets management recommendations.

Quick Start

Use the MongoDB DBA Patterns Skill to generate a concise step-by-step runbook for initializing a replica set, creating baseline indexes for IssueManager collections, and configuring least-privilege application users.