database-architect

Design a normalized PostgreSQL schema by mapping Prisma models and relations, defining primary and foreign keys, and structuring tables to eliminate data redundancy for high-performance production applications.

PostgreSQL indexing strategies involve applying composite and unique indexes, analyzing explain-plans to identify bottlenecks, and knowing when not to index to maintain write performance and query tuning efficiency.

Run zero-downtime migrations by applying safe migration patterns, utilizing connection pooling with PgBouncer, and planning stepwise deployments to ensure continuous availability during schema upgrades.

Yes, you can model a complete e-commerce database by creating normalized schemas for users, products, orders, comments, tags, and audit logs with efficient indexes and an upgradeable migration path.

Use composite indexes in a PostgreSQL database when queries frequently filter or sort by multiple columns simultaneously, optimizing multi-column lookups without creating unnecessary single-column indexes.

Yes, PgBouncer connection pooling works with Prisma and PostgreSQL by managing database connections efficiently, reducing connection overhead, and supporting safe migration patterns during scaling.