db-guardian

What problem does it solve?

The db-guardian skill prevents dangerous MongoDB actions by enforcing backup-before-change protocols, protecting critical collections, and guiding safe migrations, cleanup, and season turnover workflows for the Super Cartola Manager.

Core Features & Use Cases

• Max safety guardrails for destructive operations: Enforces rules like backing up before any destructive write/delete/drop-like actions, blocks high-risk patterns, and identifies protected collections that must never be reset or deleted (e.g., users, system_config, audit_logs).
• Controlled season turnover (snapshot, cleanup, prepare next season): Provides an operational blueprint to create filesystem snapshots of final standings and financial summaries, then perform selective cleanup of game data and prepare the next season configuration.
• Data integrity and performance readiness: Covers health checks, integrity/consistency checks (orphan detection, duplicates), required index patterns, and profiling approaches to reduce slow queries and maintain query performance.

Quick Start

Ask the db-guardian skill to generate a safe MongoDB season turnover plan for the current season, including a verified backup/snapshot step, a dry-run/confirm flow, and a selective cleanup strategy that preserves protected collections.