home / Database / Postgresql Skill by @BagelHole

Postgresql Skill by @BagelHole

FREE

github stars★ 1,180updatedMar 2026repo@BagelHole

$git clone https://github.com/BagelHole/DevOps-Security-Agent-Skills

The skill is the infrastructure/databases/postgresql folder inside that repository. Copy it into the folder your agent loads skills from; check your agent's documentation for where that is.

about Postgresql Skill by @BagelHole

Administer PostgreSQL databases. Configure replication, backups, and performance tuning.

our take

Administers PostgreSQL: installation and setup, initial users and databases, replication, backups and performance tuning, with a psql command reference.

when to use it

You deploy or maintain a PostgreSQL server
You configure replication and backups
You need a psql cheat sheet

before you install

Test restores, not just backups
Apply configuration changes in staging before production

what's inside

The original SKILL.md is organised into these sections:

When to Use
Prerequisites
Installation and Setup
Initial User and Database Setup
psql Commands Reference
Configuration Tuning
pghba.conf — Client Authentication
Backup and Restore
Logical Backups with pgdump
Physical Backups with pgbasebackup
Streaming Replication
Primary Server

source and license

Written and maintained by @BagelHole. It is published under the MIT license, which allows reuse with attribution. SkillDirectory does not claim authorship: this page adds our own review and links back to the original, and the skill's text belongs to its author.

View the full SKILL.md on GitHub ↗

Read the opening of the original SKILL.md

# PostgreSQL

Administer, optimize, and secure PostgreSQL databases in development and production environments.

## When to Use

- You need a reliable, ACID-compliant relational database.
- Your application requires advanced features such as JSONB, full-text search, or CTEs.
- You are setting up streaming replication or point-in-time recovery.
- You need to tune an existing PostgreSQL deployment for better throughput.

## Prerequisites

- Linux server (Debian/Ubuntu or RHEL-based) or Docker.
- Root or sudo access for package installation.
- Familiarity with SQL fundamentals.

## Installation and Setup

```bash
# Debian / Ubuntu
sudo apt update
sudo apt install -y postgresql postgresql-contrib

# RHEL / Amazon Linux
sudo dnf install -y postgresql15-server postgresql15-contrib
sudo postgresql-setup --initdb
sudo systemctl enable --now postgresql

# Verify
psql --version
sudo systemctl status postgresql
```

## Initial User and Database Setup

```bash
# Switch to the postgres system user
…

Excerpt only, quoted from the author's repository. Open the repository for the complete file.

↓ download .zip