skills.rest
mohamed-g-shoaib
mohamed-g-shoaibCOMMUNITY
Explore all skills by this author →
GitHub

postgres-pro

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

Updated Mar 10, 2026
Search Tags:#performance#postgresql#replication#jsonb#explain-analyze#vacuum
One-click install
npx skills add https://github.com/mohamed-g-shoaib/rootly --skill postgres-pro-mohamed-g-shoaib
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/mohamed-g-shoaib/rootly/tree/main/.agents/skills/postgres-pro
Command: npx skills add https://github.com/mohamed-g-shoaib/rootly --skill postgres-pro-mohamed-g-shoaib

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Analyzing and optimizing PostgreSQL performance, replication, and maintenance tasks to reduce toil and downtime.

Core Features & Use Cases

  • Performance tuning and query optimization using EXPLAIN ANALYZE
  • Replication setup, monitoring, and failover readiness (streaming and logical)
  • VACUUM, ANALYZE, and autovacuum tuning, maintenance planning, and extension usage
  • JSONB data design and index strategies for complex workloads

Quick Start

Run a PostgreSQL health check and apply recommended performance and replication optimizations.

Frequently Asked Questions about postgres-pro

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

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

PostgreSQL query optimization with EXPLAIN ANALYZE involves analyzing execution plans to identify bottlenecks and apply tuning strategies. This Skill evaluates query plans to recommend performance improvements for complex production workloads.

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

PostgreSQL replication configuration requires setting up streaming or logical replication, monitoring failover readiness, and ensuring high availability. This Skill provides workflows for replication setup and continuous monitoring to reduce downtime.

Why does PostgreSQL VACUUM and autovacuum need tuning in production?▼

PostgreSQL VACUUM and autovacuum tuning is needed to manage bloat and maintain performance in production databases. This Skill analyzes maintenance tasks to recommend VACUUM, ANALYZE, and autovacuum configurations that minimize toil.

Can I use JSONB index strategies for complex PostgreSQL workloads?▼

JSONB index strategies in PostgreSQL support complex workloads by enabling efficient data design and querying. This Skill applies JSONB operations and indexing techniques to optimize storage and retrieval for document-heavy applications.

Does this Skill support PostgreSQL extension usage and maintenance planning?▼

PostgreSQL extension usage and maintenance planning are supported to enhance database capabilities and schedule routine tasks. This Skill evaluates extensions and designs maintenance plans to ensure production stability and reduce operational overhead.

Related Skills

Explore More Software Engineering Skills→
rudi-bruchezrudi-bruchez

postgresql-health-check

Diagnose PostgreSQL 13+ health via SQL queries against system views.

Community
Intermediate
dieu-donneedieu-donnee

postgres-pro

Identify and optimize slow PostgreSQL queries using EXPLAIN ANALYZE and VACUUM tuning.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

managing-database-replication

Configure master-slave replication and automatic failover for PostgreSQL and MySQL deployments.

Community
Advanced
interflownexinterflownex
2

cloud-sql-postgres-monitor

Analyze PostgreSQL performance on Google Cloud SQL using PromQL and pg_stat_activity.

Community
Advanced