Agent skill · data analytics · aiskillstore
postgresql-optimization
PostgreSQL database optimization workflow for query tuning, indexing strategies, performance analysis, and production database management.
Why this skill is useful
Provides specific strategies and actions for PostgreSQL optimization that the AI wouldn't reliably generate on its own.
What it needs
About 2k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
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 optimization postgres-best-practices - PostgreSQL best practices Actions 1. Check database version 2. Review configuration 3. Analyze slow queries 4. Check resource usage 5. Identify bottlenecks Copy-Paste Prompts Phase 2: Query Analysis Skills to Invoke sql-optimization-patterns - SQL optimization postgres-best-practices - PostgreSQL patterns Actions 1. Run EXPLAIN ANALYZE 2. Identify scan types 3. Check join strategies 4. Analyze execution time 5. Find optimization opportunities Copy-Paste Prompts Phase 3: Indexing Strategy Skills to Invoke database-design - Index design postgresql - PostgreSQL indexing Actions 1. Identify missing indexes 2. Create B-tree indexes 3. Add composite indexes 4. Consider partial indexes 5. Review index usage Copy-Paste Prompts Phase 4: Query Optimization Skills to Invoke sql-optimization-patterns - Query tuning sql-pro - SQL expertise Actions 1. Rewrite inefficient queries 2. Optimize joins 3. Add CTEs where helpful 4. Implement pagination 5. Test improvements Copy-Paste Prompts Phase 5: Configuration Tuning Skills to Invoke postgres-best-practices - Configuration database-admin - Database administration Actions 1. Tune sharedbuffers 2. Configure workmem 3. Set effectivecachesize 4. Adjust checkpoint settings 5. Configure autovacuum Copy-Paste Prompts Phase 6: Maintenance Skills to Invoke database-admin - Database maintenance postgresql - PostgreSQL maintenance Actions 1. Schedule VACUUM 2. Run ANALYZE 3. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/postgresql-optimization