skills.rest
mtsatryan
mtsatryanCOMMUNITY
Explore all skills by this author →
GitHub

postgres-pro

Identify deployment requirements and bottlenecks in a PostgreSQL environment.

1|Updated Apr 23, 2026
Search Tags:#performance#postgresql#replication#query-optimization#backup-management#high-availability#database-tuning
One-click install
npx skills add https://github.com/mtsatryan/openclaw-ai-agents --skill postgres-pro-mtsatryan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/mtsatryan/openclaw-ai-agents/tree/main/postgres-pro
Command: npx skills add https://github.com/mtsatryan/openclaw-ai-agents --skill postgres-pro-mtsatryan

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It solves the challenge of configuring PostgreSQL for peak reliability, optimal performance, and robust replication across complex deployments.

Core Features & Use Cases

  • Comprehensive performance tuning across configuration, queries, vacuuming, and memory management.
  • High availability and replication strategies including streaming and logical replication, failover, and disaster recovery planning.
  • Automated backups, PITR, monitoring, and progressive maintenance to sustain SLA targets.

Quick Start

Set up an optimized PostgreSQL deployment by running an initial health review and apply recommended tuning settings immediately.

Frequently Asked Questions about postgres-pro

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

FAQPage Schema
How do I identify and fix PostgreSQL performance bottlenecks?▼

To resolve PostgreSQL performance bottlenecks, you need an initial health review to identify deployment requirements, followed by targeted tuning across configuration, queries, vacuuming, and memory management to improve overall throughput.

What is the best way to configure PostgreSQL replication for high availability?▼

Configuring PostgreSQL replication for high availability involves applying streaming and logical replication strategies, setting up automated failover, and planning disaster recovery to ensure continuous operation and meet SLA targets.

How does PostgreSQL backup management ensure RPO and RTO targets are met?▼

PostgreSQL backup management meets RPO and RTO targets by implementing automated backups, point-in-time recovery (PITR), and progressive maintenance, ensuring all changes are validated with tests and rollback plans.

Can I apply targeted tuning to an existing complex PostgreSQL deployment?▼

Yes, you can apply targeted tuning to existing complex PostgreSQL deployments by running an initial health review to find bottlenecks and immediately applying recommended configuration changes for optimal performance.

Why does my PostgreSQL environment need progressive maintenance and monitoring?▼

PostgreSQL environments require progressive maintenance and monitoring to sustain SLA targets over time, ensuring that applied tuning, backup configurations, and replication strategies continue to deliver reliable performance.

Related Skills

Explore More Software Engineering Skills→
7a336e6e7a336e6e
1

Optimizing Performance

Diagnose PostgreSQL bottlenecks via EXPLAIN ANALYZE and optimize indexing.

Community
Advanced
reverb256reverb256

sla-tracker

Monitor uptime and SLA compliance for NixOS multi-host clusters.

Community
Advanced
marquesfelipmarquesfelip

replication-strategies

Design PostgreSQL and MySQL replication strategies with failover runbooks.

Community
Advanced
wyattowalshwyattowalsh
4

database-architect

Design, generate, and validate SQL schemas and migrations across PostgreSQL, MySQL, and SQLite.

Community
Advanced