skills.rest
Marwan78888
Marwan78888COMMUNITY
Explore all skills by this author →
GitHub

postgres-pro

Diagnose and optimize PostgreSQL query plans, indexes, and replication workflows.

16|Updated Apr 19, 2026
Search Tags:#performance#indexing#postgresql#maintenance#replication#query-optimization#postgres
One-click install
npx skills add https://github.com/Marwan78888/Neuron-Cli --skill postgres-pro-marwan78888
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/Marwan78888/Neuron-Cli/tree/main/scratch/claude-skills-main/skills/postgres-pro
Command: npx skills add https://github.com/Marwan78888/Neuron-Cli --skill postgres-pro-marwan78888

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

PostgreSQL performance and replication issues can hamper application reliability; this skill provides structured guidance to diagnose and optimize.

Core Features & Use Cases

  • Analyze and tune query plans with EXPLAIN ANALYZE to identify bottlenecks and select effective indexes (B-tree, GiST, GIN, BRIN) based on workload.
  • Configure replication (streaming and logical) and maintenance workflows (VACUUM, ANALYZE, autovacuum tuning) to ensure high availability and data integrity.
  • Load and apply best practices for monitoring, statistics, and bloat management to maintain long-term performance with minimal downtime.
  • Real-world use case: optimize a database that experiences rising latency by pinpointing slow scans, implementing targeted indexes, and validating improvements with EXPLAIN ANALYZE.

Quick Start

Audit a PostgreSQL deployment to identify slow queries, replication lag, and maintenance gaps, then implement recommended optimizations.

Frequently Asked Questions about postgres-pro

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

FAQPage Schema
How do I diagnose slow PostgreSQL queries and improve performance?▼

Diagnose slow PostgreSQL queries by running EXPLAIN ANALYZE to identify bottlenecks in the query plan, then apply targeted indexes like B-tree, GiST, GIN, or BRIN based on your specific workload to accelerate query times.

How do I set up PostgreSQL replication to ensure high availability?▼

Configure PostgreSQL replication by setting up streaming or logical replication workflows, ensuring high availability and data integrity across production databases, development environments, or CI pipelines while monitoring for replication lag.

What is the best way to manage PostgreSQL maintenance and bloat?▼

Manage PostgreSQL maintenance by tuning autovacuum, running VACUUM and ANALYZE operations, and applying bloat management best practices to maintain long-term performance and data integrity with minimal downtime.

When should I use BRIN indexes instead of B-tree in PostgreSQL?▼

Use BRIN indexes for large tables with naturally ordered data to save space, and B-tree indexes for standard lookups, selecting the specific index type by analyzing query plans with EXPLAIN ANALYZE to match your workload.

Can I use this PostgreSQL optimization workflow in CI pipelines?▼

Yes, you can apply these PostgreSQL optimization and maintenance workflows in CI pipelines, development environments, and production databases to validate improvements and ensure reliability without interruption.

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

PostgreSQL replication lag occurs when streaming or logical replication falls behind, which you can diagnose and fix by auditing maintenance gaps, tuning autovacuum, and optimizing slow query scans that delay replication.

Related Skills

Explore More Data & Analytics Skills→
GDSDNGDSDN
3

db-explain

Analyze PostgreSQL query plans with EXPLAIN ANALYZE to identify bottlenecks.

Community
Advanced
randoneeringrandoneering

postgresql

Analyze PostgreSQL configurations, queries, and health metrics for optimization.

Community
Advanced
djankiesdjankies

configuring-connection-pools

Configure Prisma Client connection pools for PostgreSQL deployments.

Community
Advanced
Khoatran1999Khoatran1999

databases

Design schemas, optimize queries, and manage maintenance for MongoDB and PostgreSQL.

Community
Advanced