skills.rest
pluginagentmarketplace
pluginagentmarketplaceCOMMUNITY
Explore all skills by this author →
GitHub

postgresql

Automate PostgreSQL administration tasks for production deployments across Linux, macOS, and Docker.

1|Updated Nov 18, 2025
Search Tags:#monitoring#postgresql#configuration#replication#high-availability#backup-recovery#database-administration
One-click install
npx skills add https://github.com/pluginagentmarketplace/custom-plugin-sql --skill postgresql-pluginagentmarketplace
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgresql
Source: https://github.com/pluginagentmarketplace/custom-plugin-sql/tree/main/skills/postgresql-dba
Command: npx skills add https://github.com/pluginagentmarketplace/custom-plugin-sql --skill postgresql-pluginagentmarketplace

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

Administrators and developers often need to deploy, configure, and maintain PostgreSQL as a production-grade database, including tuning, backups, and high availability.

Core Features & Use Cases

  • Installation and setup of PostgreSQL on Linux, macOS, and containerized environments.
  • Connection, user and role management, configuration and performance tuning.
  • Backup and recovery, replication, and high-availability readiness for production workloads.
  • Use cases include setting up a multi-node cluster, performing regular backups, and enabling secure remote access.

Quick Start

Install PostgreSQL on your system and connect to it to create a test database.

Frequently Asked Questions about postgresql

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

FAQPage Schema
How do I set up PostgreSQL replication and high availability for production?▼

PostgreSQL replication and high availability require configuring a multi-node cluster with failover readiness. This process uses practical shell commands and configuration templates to ensure production workloads remain accessible during node failures.

What is the best way to automate PostgreSQL backup and recovery?▼

Automating PostgreSQL backup and recovery requires scheduling regular database dumps and validating restore procedures. This ensures production data integrity and enables quick recovery using included shell scripts and best-practice configuration templates.

How do I install and configure PostgreSQL on Linux, macOS, and Docker?▼

Installing and configuring PostgreSQL on Linux, macOS, and Docker environments involves running system-specific setup scripts and applying configuration templates. This establishes a functional database instance ready for connection management and performance tuning.

Can I use this approach to manage PostgreSQL users, roles, and remote access?▼

Yes, PostgreSQL user, role, and remote access management is supported through configuration tuning. You can enable secure remote connections by applying best-practice guidance and using provided SQL commands to manage database permissions.

Does PostgreSQL high availability work across containerized environments?▼

PostgreSQL high availability and failover readiness work across Docker and containerized environments. The setup uses configuration templates and shell scripts designed to install, monitor, and secure production database deployments across different platforms.

Why do I need configuration tuning for PostgreSQL production deployments?▼

Configuration tuning for PostgreSQL production deployments optimizes database performance and stability under workload. Applying best-practice settings for connection management and resource allocation prevents bottlenecks and ensures secure, efficient data operations.

Related Skills

Explore More Software Engineering Skills→
ray-manalotoray-manaloto
1

mise-host-vs-mise-tools

Distinguish system libraries from mise dev tools before installation.

Official
Intermediate
IldarMinaevIldarMinaev
1

postgresql-troubleshooting-sql

Run SQL scripts to diagnose PostgreSQL health, replication, storage, and query performance.

Community
Advanced
HouseGarofaloHouseGarofalo
3

haproxy

Configure HAProxy for load balancing, SSL termination, and health checks.

Official
Intermediate
manutejmanutej
61

PostgreSQL Database Administration

Automate PostgreSQL administration for customer support platform databases.

Community
Advanced