Database Manager

This skill provides structured guidance for database operations across PostgreSQL, MySQL, and MongoDB, covering schema design, migrations, query optimization, and administration patterns.

Prerequisites

• Database server access (PostgreSQL, MySQL, or MongoDB)
• Basic SQL or query language knowledge
• Migration tool installed (Alembic, Prisma, Django, Flyway, etc.)

When to Use This Skill

• Designing database schemas for new features
• Writing and managing database migrations
• Optimizing slow queries and adding indexes
• Setting up backup and recovery strategies
• Debugging database connectivity or performance issues
• Choosing between SQL and NoSQL for a use case