skills.rest
Tnemo65
Tnemo65COMMUNITY
Explore all skills by this author →
GitHub

postgres-pro

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

Updated Apr 27, 2026
Search Tags:#performance#postgresql#backup#sql#replication#tuning#high-availability
One-click install
npx skills add https://github.com/Tnemo65/template --skill postgres-pro-tnemo65
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
UKGovernmentBEISUKGovernmentBEIS
2.5k

system-info

Gather Linux OS, kernel, CPU, memory, and uptime details from standard files.

Official
Basic
arbazkhan971arbazkhan971
26

postgres

Optimize PostgreSQL production performance with tuning, indexing, and replication guidance.

Community
Advanced
mohamed-g-shoaibmohamed-g-shoaib

postgres-pro

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

Community
Advanced
mtsatryanmtsatryan
1

database-administrator

Automate PostgreSQL, MySQL, MongoDB, and Redis administration for high availability and performance.

Community
Advanced