skills.rest
alxvlo
alxvloCOMMUNITY
Explore all skills by this author →
GitHub

postgres-expert

Diagnose slow PostgreSQL queries and tune configurations for production databases.

Updated Aug 27, 2026
Search Tags:#indexing#postgresql#sql#partitioning#query-optimization#jsonb#pgbouncer
One-click install
npx skills add https://github.com/alxvlo/AHI_Capstone --skill postgres-expert-alxvlo
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-expert
Source: https://github.com/alxvlo/AHI_Capstone/tree/main/.opencode/skill/postgres-expert
Command: npx skills add https://github.com/alxvlo/AHI_Capstone --skill postgres-expert-alxvlo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL performance can be brittle; this Skill provides a structured approach to diagnose and optimize queries, indexing, partitioning, and connection management to ensure reliable, scalable databases.

Core Features & Use Cases

  • PostgreSQL query optimization and plan analysis
  • JSONB data handling and indexing strategies
  • Advanced indexing, partitioning, and maintenance best practices
  • Connection pooling and PgBouncer configuration for scalable apps
  • Replication setup and HA considerations

Quick Start

Run a targeted optimization pass on a live database to improve slow queries and index effectiveness.

Frequently Asked Questions about postgres-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I diagnose slow PostgreSQL queries in a production database?▼

Diagnose slow PostgreSQL queries by analyzing query execution plans to identify bottlenecks, then apply indexing strategies and configuration tuning to optimize performance across production environments.

What's the best way to optimize JSONB indexing in PostgreSQL?▼

Optimize JSONB indexing in PostgreSQL by applying specialized indexing strategies that improve data handling and retrieval efficiency, ensuring scalable performance when querying complex JSONB document structures.

When do I need table partitioning for PostgreSQL performance tuning?▼

Table partitioning is needed for PostgreSQL performance tuning when managing large production datasets, allowing you to distribute data strategically to improve query speed and maintenance automation.

Does PgBouncer connection pooling work with PostgreSQL replication setups?▼

PgBouncer connection pooling works with PostgreSQL replication setups to manage scalable application connections, integrating with high availability configurations to ensure reliable database access.

Why is autovacuum tuning necessary for PostgreSQL maintenance?▼

Autovacuum tuning is necessary for PostgreSQL maintenance to automate bloat prevention and transaction ID wraparound protection, ensuring reliable, scalable databases without manual vacuuming overhead.

Related Skills

Explore More Data & Analytics Skills→
yuhle-qugyuhle-qug

database-expert

Analyze and optimize database performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
shuakyle21shuakyle21
5

supabase-postgres-best-practices

Apply PostgreSQL performance best practices for Supabase apps.

Community
Advanced
nhonvonhonvo

postgres-expert

Optimize PostgreSQL performance and administration for production databases.

Community
Advanced
rnavarychrnavarych
14

role-database:newsql-distributed

Compare 12 NewSQL and distributed SQL databases for consistency and sharding.

Community
Advanced