How do I install the Postgresql Backup skill?

Run npx skillmds@latest add majiayu000/postgresql-backup in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

What does the Postgresql Backup skill do?

PostgreSQL backup and recovery - pg_dump, pg_basebackup, PITR It is listed under Coding & Dev Tools on SkillMD.

Is Postgresql Backup safe to use?

This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. Capability flags: docs only. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Postgresql Backup?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Postgresql Backup free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Postgresql Backup?

majiayu000 (@majiayu000) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Postgresql Backup by majiayu000 — Agent Skill

Name: Postgresql Backup
Rating: 4.2 (5 reviews)
Author: majiayu000

File contents

PostgreSQL Backup Skill

Atomic skill for backup and recovery

Overview

Production-ready patterns for logical backups, physical backups, and point-in-time recovery.

Prerequisites

PostgreSQL 16+
Sufficient disk space
Backup storage access

Parameters

parameters:
  backup_type:
    type: string
    required: true
    enum: [logical, physical, pitr]
  format:
    type: string
    enum: [custom, directory, plain]
    default: custom

Quick Reference

pg_dump (Logical)

# Custom format (recommended)
pg_dump -Fc -f backup.dump dbname

# Parallel backup
pg_dump -Fd -j 4 -f backup_dir dbname

# Compressed
pg_dump -Fc dbname | gzip > backup.dump.gz

pg_basebackup (Physical)

pg_basebackup -D /backup -Fp -Xs -P -R

pg_restore

pg_restore -d newdb -j 4 backup.dump
pg_restore --list backup.dump  # Preview

WAL Archiving

archive_mode = on
archive_command = 'cp %p /archive/%f'

Backup Strategy

Type	Use Case	Recovery Speed
pg_dump	Logical, portable	Slow
pg_basebackup	Full cluster	Fast
WAL + base	Point-in-time	Fast + precise

Troubleshooting

Problem	Cause	Solution
Backup failed	Disk full	Free space
Restore slow	Large DB	Use parallel
WAL missing	Archive failed	Check archive_command

Usage

Skill("postgresql-backup")

Frequently asked questions

Postgresql Backup