What problem does it solve?
This skill eliminates the fragmented, error-prone workflow of managing multiple database systems (PostgreSQL, MySQL, MongoDB) with inconsistent tools and practices, reducing production incidents and manual overhead for development and operations teams.
Core Features & Use Cases
- Cross-platform schema design: Provides normalization guidelines, table/collection design patterns, and relationship best practices for relational (PostgreSQL/MySQL) and document (MongoDB) databases, with clear guidance on denormalization and hybrid patterns for performance.
- Safe migration workflows: Covers forward-only production migrations, reversible development migrations, and zero-downtime schema change patterns for Alembic, Prisma, Flyway, and native MongoDB migrations, with step-by-step safe change examples to avoid production outages.
- Performance and administration: Includes slow query identification, EXPLAIN analysis, index strategy, backup/recovery configuration, and connection pooling setup for all three database platforms, plus troubleshooting for common connectivity and performance issues.
- Use Case: A development team building a SaaS product with a hybrid PostgreSQL (user data) and MongoDB (content logs) architecture can use this skill to design consistent schemas, write non-blocking migrations for new features, and optimize slow reporting queries without downtime.
Quick Start
Use the database-manager skill to design a normalized users table schema for a new e-commerce feature and write a non-blocking migration to add it to the existing PostgreSQL database.
