Optimize PostgreSQL performance
postgres-proskillsetup L2★9,726
Jeffallan/claude-skills ↗What it does
Optimize PostgreSQL queries, design schemas, write migrations
Best for
When tuning PostgreSQL for production performance via indexes, connection pooling, or replication strategy.
Inputs
- · PostgreSQL query, schema design, migration requirement, performance issue
Outputs
- · Optimized SQL
- · index strategy
- · EXPLAIN ANALYZE output
- · migration scripts
Requires
- · PostgreSQL
Preconditions
- · Necessary tools or libraries available
Failure modes
- · Misunderstanding of requirements
- · Incomplete or outdated examples
Trust signals
- · Peer reviewed
- · Applied successfully to similar context
- · Source documented