Architects complex database structures and manages data lifecycles through autonomous schema design and terminal-based execution.
Guides database schema design, migration planning, and query optimization based on universal development standards.
Guide database design, migration, and query optimization.
PgBouncer, connection optimization, and pooling strategies for database performance.
Architects robust database systems by implementing multi-tenant isolation, transaction boundaries, and data consistency strategies.
Guides database schema design, migration planning, and query optimization using universal development standards.
Guides database schema design, migration workflows, and query optimization using industry-standard development practices.
Process use when you need to work with database documentation.
Database - schema, indexes, migrations. Use when working with databases.
Implements database layers using Prisma, Drizzle ORM, TypeORM, SQLAlchemy 2.0, GORM, Diesel, Entity Framework Core 8, Hibernate/Panache…
Designs and optimizes database indexing strategies using ESR principles and advanced access patterns for maximum query performance.
Detects missing database indexes in PHP code.
Comprehensive guide for database management patterns covering PostgreSQL and MongoDB including schema design, indexing, transactions…
Write a safe, zero-downtime database migration plan for a schema change.
Generate database migration scripts for Liquibase, Flyway, Alembic with rollback safety, data preservation, and zero-downtime patterns
Create and manage database migrations with reversible changes, proper naming conventions, and zero-downtime deployment strategies.
Implements safe, version-controlled database schema changes and zero-downtime deployment patterns across multiple ORMs and SQL dialects.
Use for Drizzle migrations: schema/table/column changes, migration generation or regeneration, sequence conflicts after rebase, idempotent…
Database design and migration patterns for Alembic migrations, schema design (SQL/NoSQL), and database versioning.
Database design patterns, SQL best practices, ORM usage (Prisma/Drizzle), and migration strategies.
Database reconnaissance — full inventory of schema, migrations, data volume, backups, connection pooling, and query patterns.