Postgresql Optimization
This is a structured workflow for optimizing PostgreSQL databases, walking you through performance assessment, query analysis with EXPLAIN ANALYZE, indexing strategy, and configuration tuning. It's organized into seven phases that chain together related skills like database-optimizer, sql-optimization-patterns, and postgres-best-practices. The workflow covers the usual suspects: shared_buffers, work_mem, autovacuum settings, and monitoring setup with Grafana. It's most useful if you're dealing with slow queries or need a systematic approach to database tuning rather than random tweaking. The prompts are pretty basic, so you'll need to know what you're looking for, but it keeps you from forgetting steps like scheduling VACUUM or checking table bloat.
- skills.sh installs
- 173
- GitHub stars
- 39.4K
- last updated
- Jun 3, 2026
Install
$ npx -y skills add sickn33/antigravity-awesome-skills --skill postgresql-optimization --agent claude-codeInstalls into .claude/skills of the current project.
Files
PostgreSQL Optimization Workflow
Overview
Specialized workflow for PostgreSQL database optimization including query tuning, indexing strategies, performance analysis, vacuum management, and production database administration.
When to Use This Workflow
Use this workflow when:
- Optimizing slow PostgreSQL queries
- Designing indexing strategies
- Analyzing database performance
- Tuning PostgreSQL configuration
- Managing production databases
Workflow Phases
Phase 1: Performance Assessment
Skills to Invoke
database-optimizer- Database optimizationpostgres-best-practices- PostgreSQL best practices
Actions
- Check database version
- Review configuration
- Analyze slow queries
- Check resource usage
- Identify bottlenecks
Copy-Paste Prompts
Use @database-optimizer to assess PostgreSQL performance
Phase 2: Query Analysis
Skills to Invoke
sql-optimization-patterns- SQL optimizationpostgres-best-practices- PostgreSQL patterns
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/sickn33/antigravity-awesome-skills
- Categories
- Backend & APIs, Databases
- First seen
- Jun 3, 2026
More from sickn33/antigravity-awesome-skills
All 708- Wireshark Analysis173
- 007171
- Documentation171
- React Flow Node Ts167
- Agent Orchestrator166
- Ai Ml165
- Avoid Ai Writing165
- Android Jetpack Compose Expert163
- Ddd Strategic Design163
- Activecampaign Automation156
- Domain Driven Design153
- Agents Md151
- Api Endpoint Builder150
- Privilege Escalation Methods146
- Agent Framework Azure Ai Py145
- Canva Automation144
- Ddd Tactical Patterns143
- Bevy Ecs Expert142
- Agents V2 Py141
- Ai Studio Image139
- Gitlab Automation139
- Ai Seo137
- Amplitude Automation137
- Linkedin Automation137
