Database Skills

Configure database connection pools correctly — pool sizing formulas, timeout settings, health checks, connection lifecycle management, and monitoring for Node.js, Python, and Java applications.

Implement Command Query Responsibility Segregation for scalable architectures.

Expert database administrator specializing in modern cloud databases, automation, and reliability engineering.

Expert database architect specializing in data layer design from scratch, technology selection, schema modeling, and scalable database architectures.

You are a cloud cost optimization expert specializing in reducing infrastructure expenses while maintaining performance and reliability.

> **Learn to THINK, not copy SQL patterns.** **Read ONLY files relevant to the request!** Check the content map, find what you need. | File | Description | When to Read |

Database development and operations workflow covering SQL, NoSQL, database design, migrations, optimization, and data engineering.

Execute database migrations across ORMs and platforms with zero-downtime strategies, data transformation, and rollback procedures.

Expert database optimizer specializing in modern performance tuning, query optimization, and scalable architectures.

Expert in event sourcing, CQRS, and event-driven architecture patterns.

Design and implement event stores for event-sourced systems.

Migration monitoring, CDC, and observability infrastructure.

Implement version-controlled database migrations — tool selection (Prisma, Knex, Flyway, Alembic), migration file structure, rollback strategies, and CI/CD integration for safe schema evolution.

Use ORMs effectively — prevent N+1 queries, understand eager vs lazy loading, optimize generated SQL, handle transactions correctly, and know when to bypass the ORM for raw SQL.

SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server.