skills.rest
AndrejMX13
AndrejMX13COMMUNITY
Explore all skills by this author →
GitHub

postgres-pro

Analyze PostgreSQL query performance and configure replication for high availability.

Updated May 3, 2026
Search Tags:#database#postgresql#optimization#maintenance#replication#extensions
One-click install
npx skills add https://github.com/AndrejMX13/belpro --skill postgres-pro-andrejmx13
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/AndrejMX13/belpro/tree/main/.claude/skills/postgres-pro
Command: npx skills add https://github.com/AndrejMX13/belpro --skill postgres-pro-andrejmx13

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and scripts (resource) components.

What problem does it solve?

This Skill enables database administrators and developers to analyze and optimize PostgreSQL performance, configure replication, and utilize extensions effectively.

Core Features & Use Cases

  • Query Optimization: Run EXPLAIN ANALYZE and design indexes to improve slow queries.
  • Replication Setup: Configure streaming and logical replication for high availability and data sharing.
  • Extension Management: Install and manage PostgreSQL extensions like pg_stat_statements and PostGIS for enhanced capabilities.
  • Database Maintenance: Perform vacuuming, analyze statistics, monitor bloat, and troubleshoot replication lag for reliable database operation.
  • Use Case: Use this Skill to fine-tune a production PostgreSQL database by analyzing slow queries, setting up replication, and ensuring ongoing health.

Quick Start

Use the postgres-pro skill to analyze the current query performance and set up a replication slot for high availability.

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 in a production database?▼

To optimize slow PostgreSQL queries, you run EXPLAIN ANALYZE to inspect execution plans and design appropriate indexes. This Skill provides comprehensive guidance on performance tuning to improve slow query execution in high-availability systems.

What's the best way to configure streaming and logical replication for PostgreSQL high availability?▼

Configuring PostgreSQL replication for high availability involves setting up streaming and logical replication, including replication slots. This Skill guides database engineers through the setup process to ensure scalable and reliable data sharing.

How do I install and manage PostgreSQL extensions like PostGIS and pg_stat_statements?▼

Installing PostgreSQL extensions like PostGIS and pg_stat_statements enhances database capabilities and query tracking. This Skill provides guidance on effective extension management to add specialized functionalities to your database environment.

Why does PostgreSQL replication lag occur and how do I troubleshoot it?▼

PostgreSQL replication lag occurs due to synchronization delays in high-availability setups and requires active troubleshooting. This Skill helps you monitor database health, analyze statistics, and resolve replication lag for reliable operations.

Can I use this for ongoing PostgreSQL maintenance like vacuuming and monitoring bloat?▼

Yes, this Skill is suitable for ongoing PostgreSQL maintenance tasks including vacuuming, analyzing statistics, and monitoring bloat. It ensures reliable database operation by following best practices for large, high-availability systems.

Does this approach work for large-scale database systems requiring high availability?▼

Yes, this approach works for large-scale database systems requiring high availability and optimal operations. It is designed for database engineers managing extensive PostgreSQL environments needing performance tuning and scalability.

Related Skills

Explore More Software Engineering Skills→
Axel-DaMageAxel-DaMage
2

postgres-pro

Analyze PostgreSQL EXPLAIN output and manage JSONB, replication, and VACUUM tasks.

Community
Advanced
IldarMinaevIldarMinaev
1

postgresql-troubleshooting-sql

Run SQL scripts to diagnose PostgreSQL health, replication, storage, and query performance.

Community
Advanced
dabblersportdabblersport

supabase-postgres-best-practices

Optimize PostgreSQL query execution, connection pooling, and schema architecture.

Community
Advanced
arbazkhan971arbazkhan971
26

postgres

Optimize PostgreSQL production performance with tuning, indexing, and replication guidance.

Community
Advanced