skills.rest
hvngroup
hvngroupCOMMUNITY
Explore all skills by this author →
Website𝕏@hvngroupGitHub

postgres-expert

Identify PostgreSQL performance bottlenecks and deliver a targeted optimization plan.

Updated Aug 23, 2026
Search Tags:#performance#indexing#postgresql#partitioning#replication#jsonb
One-click install
npx skills add https://github.com/hvngroup/directus_b2b_crm --skill postgres-expert-hvngroup
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
ariesanhthuariesanhthu

database-expert

Analyze EXPLAIN plans and optimize queries for PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
karrtik159karrtik159

postgresql-optimization

Optimize PostgreSQL queries and indexing strategies using EXPLAIN ANALYZE and pg_stat_statements.

Community
Advanced
vertivolatamvertivolatam
1

Database Reliability

Automate PostgreSQL replication, failover, backups, pooling, and monitoring.

Official
Advanced
uv-xiaouv-xiao
1

uv-ray-train

Orchestrates distributed ML training across multi-node clusters using Ray Train.

Community
Advanced