cyberneticlibrary
← library

Optimize PostgreSQL schemas and queries

dbasubagentsetup L3★0
vaReliy/home-pulse-watcher ↗
What it does

Design schemas, migrations, indexes, and query optimization for PostgreSQL

Best for

Database-first design that optimizes schema, relationships, and queries before application code is written.

Inputs
  • · schema requirements
  • · query patterns
  • · Prisma schema
  • · EXPLAIN ANALYZE output
Outputs
  • · schema design
  • · migration files
  • · index recommendations
  • · optimized queries
Requires
  • · PostgreSQL
  • · Prisma ORM
  • · EXPLAIN ANALYZE
Preconditions

PostgreSQL running, Prisma installed, DBA scope (not application logic)

Failure modes
  • · N+1 queries
  • · missing indexes on hot paths
  • · incorrect FK relationships
  • · deadlocks in migrations
Trust signals
  • · includes EXPLAIN interpretation
  • · shows index strategy
  • · defines relationship patterns
  • · Prisma-specific examples