skills.rest
codeApe-7
codeApe-7COMMUNITY
Explore all skills by this author →
GitHub

postgres-pro

Tune PostgreSQL performance, replication, extensions, and maintenance for databases.

17|3|Updated Mar 18, 2026
Search Tags:#performance#query optimization#postgresql#extension#backup#replication
One-click install
npx skills add https://github.com/codeApe-7/ai-agent-workflowGroup --skill postgres-pro-codeape-7
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/codeApe-7/ai-agent-workflowGroup/tree/main/skills/database/postgres-pro
Command: npx skills add https://github.com/codeApe-7/ai-agent-workflowGroup --skill postgres-pro-codeape-7

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pg_stat_statements, postgis, pgvector, pgcrypto, and includes references (resource) and scripts (resource) and assets (resource) components.

What problem does it solve?

This Skill addresses the need for database experts to analyze, optimize, and configure PostgreSQL for high performance, reliability, and advanced features.

Core Features & Use Cases

  • Query Optimization: Helps identify slow queries with EXPLAIN ANALYZE and optimize indexing strategies.
  • Configuration Tuning: Guides tuning of autovacuum, shared buffers, and checkpoint settings for workload-specific performance improvements.
  • Replication Management: Assists in setting up, monitoring, and troubleshooting streaming and logical replication setups, ensuring high availability and disaster recovery.
  • Extension Handling: Manages and utilizes extensions like pg_stat_statements, postgis, and pgvector for enhanced database capabilities.
  • Use Case: A DBA can use this Skill to reduce query latency, prevent database bloat, and maintain replication health in a production environment.

Quick Start

Load your database, run EXPLAIN ANALYZE on relevant queries, and adjust shared buffers and autovacuum settings as recommended.

Frequently Asked Questions about postgres-pro

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

FAQPage Schema
How do I optimize slow PostgreSQL queries using EXPLAIN ANALYZE?▼

To optimize slow PostgreSQL queries, run EXPLAIN ANALYZE to identify execution bottlenecks, then adjust indexing strategies and tune shared buffers to reduce latency and improve query performance.

What is the best way to configure autovacuum and shared buffers for PostgreSQL performance tuning?▼

PostgreSQL performance tuning requires adjusting shared buffers for memory allocation and configuring autovacuum settings to prevent database bloat, ensuring workload-specific improvements for production environments.

How do I set up streaming and logical replication for PostgreSQL high availability?▼

Set up PostgreSQL replication by configuring streaming and logical replication to ensure high availability and disaster recovery, then monitor the setup to maintain replication health across production environments.

Can I use pgvector and postgis extensions together for advanced PostgreSQL database management?▼

Yes, advanced PostgreSQL database management supports utilizing extensions like pgvector and postgis together, handling vector similarity search and spatial data alongside standard query optimization and configuration tuning.

Why does PostgreSQL database bloat occur and how do I prevent it?▼

PostgreSQL database bloat occurs due to inefficient autovacuum operations and unoptimized checkpoints; prevent it by tuning autovacuum settings, adjusting shared buffers, and maintaining replication health consistently.

Related Skills

Explore More Data & Analytics Skills→
bobmatnycbobmatnyc
20

PostgreSQL Performance Optimization

Analyze PostgreSQL 15+ queries, indexes, and configuration using EXPLAIN ANALYZE.

Community
Advanced
oakossoakoss
14

postgres-tuning

Optimize PostgreSQL 17/18+ performance by tuning async I/O and analyzing query plans.

Official
Advanced
interflownexinterflownex
2

cloud-sql-postgres-vectorassist

Configure vector indexes and generate optimized SQL queries for Cloud SQL for PostgreSQL.

Community
Advanced
mohamed-g-shoaibmohamed-g-shoaib

postgres-pro

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

Community
Advanced