skills.rest
yuhle-qug
yuhle-qugCOMMUNITY
Explore all skills by this author →
GitHub

postgres-expert

Optimize PostgreSQL queries, JSONB indexing, partitioning, and maintenance workflows.

Updated Jan 2, 2026
Search Tags:#performance#indexing#postgresql#partitioning#replication#postgres#autovacuum
One-click install
npx skills add https://github.com/yuhle-qug/Parking_Management_System --skill postgres-expert-yuhle-qug
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-expert
Source: https://github.com/yuhle-qug/Parking_Management_System/tree/main/.agent/skills/postgres-expert
Command: npx skills add https://github.com/yuhle-qug/Parking_Management_System --skill postgres-expert-yuhle-qug

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps database professionals optimize PostgreSQL performance and streamline administration tasks, reducing mean time to insight and improving query efficiency.

Core Features & Use Cases

  • Query optimization & use plan analysis: guidance on index usage, EXPLAIN ANALYZE reviews, and query rewriting.
  • JSONB indexing & advanced data types: guidance on using GIN/GiST indexes, jsonb_path_ops, and optimized queries.
  • Partitioning & large data management: strategies for range/list/hash partitioning and maintenance.
  • Autovacuum tuning & maintenance: guidance on vacuum/analyze thresholds, maintenance_work_mem, and per-table tuning.
  • Replication & HA readiness: monitoring replication status and configuring safe replication setups.

Quick Start

Run a PostgreSQL performance audit on the connected database and return a prioritized tuning plan.

Frequently Asked Questions about postgres-expert

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

FAQPage Schema
How do I optimize PostgreSQL query performance using EXPLAIN ANALYZE?▼

JSONB indexing in PostgreSQL uses GIN or GiST indexes with jsonb_path_ops to accelerate document queries. This Skill guides you through creating optimized indexes to improve JSONB query performance significantly.

What is the best way to partition large PostgreSQL tables?▼

PostgreSQL autovacuum tuning requires adjusting vacuum/analyze thresholds, maintenance_work_mem, and per-table settings. This Skill helps configure maintenance workflows to optimize autovacuum performance.

How do I monitor PostgreSQL replication status for HA readiness?▼

No external tools are required; this Skill relies solely on standard PostgreSQL tooling. A solid understanding of PostgreSQL internals is recommended to effectively use the provided diagnostics and tuning recommendations.

Why is my PostgreSQL autovacuum not keeping up with table bloat?▼

PostgreSQL autovacuum tuning adjusts vacuum/analyze thresholds, maintenance_work_mem, and per-table settings to address table bloat. This Skill provides maintenance workflows and per-table tuning recommendations to resolve autovacuum bottlenecks.

Related Skills

Explore More Software Engineering Skills→
ajayatwal1105-emersonajayatwal1105-emerson

add-integration

Configure MCP server integrations and generate `.mcp.json` files for external services.

Community
Advanced
nhonvonhonvo

postgres-expert

Optimize PostgreSQL performance and administration for production databases.

Community
Advanced
mohamed-g-shoaibmohamed-g-shoaib

postgres-pro

Analyze and optimize PostgreSQL performance, replication, and maintenance tasks.

Community
Advanced
AndyAnh174AndyAnh174

database-optimizer

Optimize relational and cloud database performance through index tuning and query rewriting.

Community
Advanced