Optimize PostgreSQL queries
databasesubagentsetup L3★0
avihuco2/wealthclick ↗What it does
Design PostgreSQL schemas with proper migrations
Best for
Crafting zero-downtime migrations and optimizing query patterns.
Inputs
- · schema requirements
- · query patterns
- · table definitions
Outputs
- · SQL migration files
- · index strategy
- · performance analysis
Requires
- · postgres.js
Preconditions
Repo: avihuco2/wealthclick. Context files must exist.
Failure modes
Incorrect schema assumptions, missing migration history, cardinality mismatch
Trust signals
- · Detailed multi-step procedure
- · Includes verification step
- · Specifies claude model
- · Comprehensive documentation (>2000 chars)