postgres-pro

Name: postgres-pro
Availability: InStock
Author: tnemo65

Tunes PostgreSQL performance, replication, and backups with validated configuration scripts.

Updated Apr 27, 2026

Search Tags:#performance #postgresql #backup #sql #replication #tuning #high-availability

Ready to run

npx skills add https://github.com/Tnemo65/template --skill postgres-pro-tnemo65

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: postgres-pro
Source: https://github.com/Tnemo65/template/tree/main/.cursor/skills/02-data-engineering/postgres-pro
Command: npx skills add https://github.com/Tnemo65/template --skill postgres-pro-tnemo65

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Optimizes PostgreSQL performance, reliability, and scalability for enterprise deployments by enabling expert configuration, replication, backups, and advanced features.

Core Features & Use Cases

Performance tuning: query optimization, indexing, vacuum, and planner adjustments.
Replication & high availability: set up streaming and logical replication, failover strategies.
Backup and recovery: PITR, backups, retention policies, and restore testing.
Advanced features and extensions: JSONB, PostGIS, parallel queries, and extension management.
Operational best practices: monitoring, logging, automation, and compliance with SLAs.

Quick Start

Initiate PostgreSQL optimization by providing deployment size, version, workload, and HA requirements, and I will deliver a tuned configuration and a rollout plan.

Frequently Asked Questions about postgres-pro

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

FAQPage Schema

How do I tune PostgreSQL for performance bottlenecks in a production environment?▼

To tune PostgreSQL performance bottlenecks, you optimize query execution, indexing, vacuuming, and planner adjustments based on deployment metrics and current configuration to achieve validated configuration recommendations.

What's the best way to set up PostgreSQL replication for high availability?▼

Setting up PostgreSQL replication for high availability involves configuring streaming and logical replication alongside failover strategies to meet business uptime targets and ensure reliability.

How do I configure PostgreSQL backups and point-in-time recovery?▼

Configuring PostgreSQL backups and point-in-time recovery requires establishing retention policies and restore testing to ensure reliable data recovery for production environments.

Can I use this PostgreSQL optimization approach for cloud deployments of varying sizes?▼

Yes, this PostgreSQL optimization approach applies to production environments of varying sizes, whether on-premises or cloud, requiring access to deployment metrics and HA requirements.

What advanced PostgreSQL features and extensions can I optimize?▼

You can optimize advanced PostgreSQL features and extensions including JSONB, PostGIS, parallel queries, and extension management for enterprise scalability.

What do I need to start optimizing my PostgreSQL deployment?▼

To start optimizing your PostgreSQL deployment, provide your deployment size, version, workload, and HA requirements to receive a tuned configuration and a rollout plan.