skills.rest
belokonm
belokonmCOMMUNITY
Explore all skills by this author →
GitHub

postgres-pro

Automate PostgreSQL administration, performance tuning, and backup/restore workflows.

8|11|Updated Feb 15, 2026
Search Tags:#monitoring#postgresql#backup#replication#tuning#ha#pitr
One-click install
npx skills add https://github.com/belokonm/claude-supercode-skills --skill postgres-pro-belokonm
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/belokonm/claude-supercode-skills/tree/main/postgres-pro-skill
Command: npx skills add https://github.com/belokonm/claude-supercode-skills --skill postgres-pro-belokonm

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

PostgreSQL administration, performance tuning, high-availability setup, and disaster recovery are complex and error-prone; this skill provides a structured approach and automation to ensure reliable operation, optimal performance, and robust backup/restore workflows.

Core Features & Use Cases

  • Configuration tuning and best-practice recommendations (shared_buffers, work_mem, autovacuum).
  • Replication setup and high-availability workflows (streaming replication, failover, PITR readiness).
  • Backup and restore automation (pg_dump/pg_restore, compressed backups, automated retention and validation).
  • Partitioning, monitoring, and ongoing maintenance patterns for production deployments.

Quick Start

Run the backup_pg.py script to perform an initial backup of all non-template databases on your PostgreSQL server.

Frequently Asked Questions about postgres-pro

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

FAQPage Schema
How do I automate PostgreSQL backup and restore workflows for production databases?▼

Automate PostgreSQL backup and restore workflows by running script-based tooling like backup_pg.py to perform compressed pg_dump operations, manage automated retention policies, and validate restorability for non-template databases.

What are the best practices for PostgreSQL performance tuning and configuration?▼

PostgreSQL performance tuning applies best-practice configuration values for parameters like shared_buffers, work_mem, and autovacuum to optimize memory allocation, query execution, and routine maintenance across on-prem and cloud deployments.

How do I set up PostgreSQL replication and high availability with automated failover?▼

Set up PostgreSQL replication and high availability by configuring streaming replication and failover workflows, ensuring Point-in-Time Recovery (PITR) readiness to maintain continuous database operations duringnode failures.

Does this PostgreSQL administration approach work for both on-prem and cloud deployments?▼

Yes, this PostgreSQL administration approach works across both on-prem and cloud deployments, applying reproducible script-based operations for partitioning, monitoring, and ongoing maintenance patterns regardless of the hosting environment.

Can I use these scripts for database partitioning and ongoing maintenance?▼

Yes, you can use these scripts for database partitioning and ongoing maintenance patterns, providing structured automation to manage large production datasets and ensure reliable continuous operation.

Related Skills

Explore More Software Engineering Skills→
wangx7wangx7

cloud-sql-basics

Provision and administer Cloud SQL instances for MySQL, PostgreSQL, and SQL Server.

Community
Intermediate
lapc506lapc506
4

Database Reliability

Automate PostgreSQL replication, failover, pooling, and backup management.

Community
Advanced
MacPhobosMacPhobos

digitalocean-compute

Manages DigitalOcean Droplets, App Platform, Functions, Kubernetes, and GPU instances.

Community
Intermediate
rafaelcallejarafaelcalleja
2

databases

Manage PostgreSQL and MongoDB schema design, queries, and administration.

Community
Advanced