postgresql-optimization — Skills

What it does

Use EXPLAIN (ANALYZE, BUFFERS) for detailed query analysis

Configure postgresql.conf for your workload (OLTP vs OLAP)

Use connection pooling (pgbouncer) for high-concurrency applications

Regular VACUUM and ANALYZE for optimal performance

Partition large tables using PostgreSQL 10+ declarative partitioning

Use pgstatstatements for query performance monitoring

VACUUM and ANALYZE: Regular maintenance for performance

Expert guidance on PostgreSQL-specific features, optimization patterns, and advanced data type capabilities.

Source

Repository: https://github.com/github/awesome-copilot

postgresql-optimization FAQ

What does the postgresql-optimization skill do?

PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. Covers JSONB operations, array types, custom types, range/geometric types, full-text search, window functions, and PostgreSQL extensions ecosystem. Use EXPLAIN (ANALYZE, BUFFERS) for detailed query analysis Configure postgresql.conf for your workload (OLTP vs OLAP)

What does postgresql-optimization require?

[ ] Track database growth and maintenance needs

How do I install postgresql-optimization?

Run: npx -y skills add https://github.com/github/awesome-copilot --skill postgresql-optimization --agent claude-code — the source lives at github.com/github/awesome-copilot.

Maintain postgresql-optimization?

Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.

[![postgresql-optimization on getagentictools](https://getagentictools.com/badge/skills/github-awesome-copilot-postgresql-optimization.svg)](https://getagentictools.com/skills/github-awesome-copilot-postgresql-optimization?ref=badge)

npx agentictools info skills/github-awesome-copilot-postgresql-optimization

The second line is the CLI lookup for this page — handy in READMEs and docs.