postgresql-optimization
Expert PostgreSQL guidance for query optimization, advanced features like JSONB, and performance tuning strategies.
Install
npx skills add https://github.com/github/awesome-copilot --skill postgresql-optimizationStats
| Total installs | 8,755 |
| Weekly installs | 8.7K |
| GitHub stars | 27.4K |
| First seen | Feb 25, 2026 |
| Source | @github/awesome-copilot |
Summary
- Covers JSONB operations, array types, window functions, full-text search, custom types, range types, and geometric types with practical examples
- Includes query optimization strategies using EXPLAIN ANALYZE, index design patterns (composite, partial, covering, expression), and connection/memory management
- Provides monitoring and maintenance techniques via pg_stat_statements, pg_stat_user_indexes, and database size analysis
- Demonstrates common anti-patterns alongside optimized alternatives for pagination, aggregation, and JSON queries with expected performance improvements
Tags
Related skills
| Skill | Installs | vs postgresql-optimization |
|---|---|---|
| create-spring-boot-java-project | 7,614 | -1,141 |
| opencontext | 10,515 | +1,760 |
| backend-testing | 11,809 | +3,054 |
| dataverse-python-usecase-builder | 7,430 | -1,325 |
| architecture-patterns | 10,017 | +1,262 |
FAQ
- How many installs does postgresql-optimization have?
- postgresql-optimization has 8,755 total installs and 8.7K installs this week.
- Where is postgresql-optimization hosted?
- postgresql-optimization is published by @github/awesome-copilot at https://github.com/github/awesome-copilot.
- How many GitHub stars does postgresql-optimization have?
- postgresql-optimization has 27.4K GitHub stars.
- When was postgresql-optimization first indexed?
- OrangeBot.AI first indexed postgresql-optimization on Feb 25, 2026.
- How do I install postgresql-optimization?
- Run: npx skills add https://github.com/github/awesome-copilot --skill postgresql-optimization