5,015 skills
Database migration best practices for schema changes, data migrations, rollbacks, and zero-downtime deployments across PostgreSQL, MySQL, and common ORMs (Prisma, Drizzle, Kysely, Django, TypeORM, golang-migrate).
Use when working with databases — migrations, queries, schema design, backups, and troubleshooting. Covers SQLite, PostgreSQL, and container-based database services.
PostgreSQL database operations including backups, transactions, user management, window functions, materialized views, and extensions.
Provides PostgreSQL best practices and design patterns for query optimization, indexing, and security. Use when writing SQL queries or migrations. Use when designing schemas or configuring connection pools. Use when troubleshooting slow queries or implementing Row Level Security (RLS). Do not use for generic application-level backend patterns or other database engines.
Provides advanced SQL query optimization, indexing strategies, and EXPLAIN analysis patterns. Use when debugging slow queries or analyzing EXPLAIN plans. Use when implementing efficient indexes or resolving N+1 query problems. Do not use when writing simple exploratory queries. Do not use for non-relational database optimization.