postgres-expert

Identify PostgreSQL performance bottlenecks and deliver a targeted optimization plan.

Updated Aug 23, 2026

Search Tags:#performance #indexing #postgresql #partitioning #replication #jsonb

Ready to run

npx skills add https://github.com/hvngroup/directus_b2b_crm --skill postgres-expert-hvngroup

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: postgres-expert
Source: https://github.com/hvngroup/directus_b2b_crm/tree/main/.agent/skills/postgres-expert
Command: npx skills add https://github.com/hvngroup/directus_b2b_crm --skill postgres-expert-hvngroup

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL performance and reliability often suffer from poorly optimized queries, bloated indexes, and suboptimal configuration. This skill provides a structured approach to diagnose and optimize PostgreSQL workloads, including advanced JSONB operations, indexing, partitioning, and connection management.

Core Features & Use Cases

Query optimization and EXPLAIN analysis for faster workloads.
JSONB operations and indexing for efficient data access.
Advanced indexing strategies (btree, gin, path ops) and partitioning for large datasets.
Connection management with PgBouncer and autovacuum tuning for maintenance.
Replication setup and HA considerations for production systems.

Quick Start

Analyze a live PostgreSQL instance and return a prioritized set of optimizations with concrete steps.

Frequently Asked Questions about postgres-expert

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

FAQPage Schema

How do I identify PostgreSQL performance bottlenecks and optimize slow queries?▼

PostgreSQL performance bottlenecks are identified through EXPLAIN analysis to deliver a targeted query tuning plan. This provides version-aware diagnostics, safe change recommendations, and reproducible maintenance steps with clear guardrails.

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

JSONB operations are optimized by applying advanced indexing strategies like GIN and path operators for efficient data access. This approach diagnoses suboptimal configurations and returns concrete steps to improve workload speed.

How does PostgreSQL partitioning improve performance for large datasets?▼

PostgreSQL partitioning improves performance by structuring large datasets to enable faster, targeted query scanning. The optimization plan analyzes your specific environment and provides safe partitioning recommendations with clear guardrails.

Can I use PgBouncer for PostgreSQL connection management and autovacuum tuning?▼

PgBouncer is supported for connection management alongside autovacuum tuning to maintain PostgreSQL reliability. This skill delivers version-aware diagnostics and reproducible maintenance steps to safely configure these features.

How do I set up PostgreSQL replication and high availability considerations?▼

PostgreSQL replication setup is analyzed to provide production-ready high availability considerations. The optimization plan evaluates your environment and returns safe change recommendations with clear guardrails for implementation.

Why does PostgreSQL performance suffer from bloated indexes and suboptimal configuration?▼

PostgreSQL performance suffers from bloated indexes and suboptimal configuration due to poorly optimized queries and unmanaged workloads. A structured diagnostic approach identifies these specific bottlenecks and delivers a prioritized optimization plan.