SkillsAdd

pluginagentmarketplace/custom-plugin-postgresql · Archived

postgresql-backup

PostgreSQL backup and recovery - pg_dump, pg_basebackup, PITR

First seen Feb 10, 2026

Installation

$ npx skills add pluginagentmarketplace/custom-plugin-postgresql --skill postgresql-backup
View on skills.sh ↗ GitHub repository ↗

Stronger alternatives

This repository is archived — consider an actively maintained alternative.

postgresql-plpgsql Same source · more installs
pluginagentmarketplace/custom-plugin-postgresql

Write PL/pgSQL - functions, procedures, triggers, error handling

8 installs
postgresql-advanced-queries Same source · more installs
pluginagentmarketplace/custom-plugin-postgresql

Master advanced PostgreSQL queries - CTEs, window functions, recursive queries

8 installs
postgresql-fundamentals Same source · more installs
pluginagentmarketplace/custom-plugin-postgresql

Master PostgreSQL SQL fundamentals - data types, tables, constraints, schema design

6 installs
postgresql-monitoring Same source
pluginagentmarketplace/custom-plugin-postgresql

PostgreSQL monitoring - metrics, alerting, observability

3 installs

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

supabase-postgres-best-practices Shared topics
supabase/agent-skills

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill …

391.6K installs
prisma-cli Shared topics
prisma/skills

Prisma ORM CLI commands reference covering init, generate, migrate, db, dev, complete, studio, …

267K installs
supabase Shared topics
supabase/agent-skills

Use when doing ANY task involving Supabase. Triggers: Supabase products (Database, Auth, Edge F…

263K installs
neon-postgres Shared topics
neondatabase/agent-skills

>- Guides and best practices for working with Lakebase Postgres, the database behind Neon. Cove…

146.5K installs
firebase-data-connect Shared topics
firebase/agent-skills 142.2K installs
postgresql-optimization Similar name
github/awesome-copilot

PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data…

15.3K installs

Also in this package

Other skills from pluginagentmarketplace/custom-plugin-postgresql · top by installs.

npx skills add pluginagentmarketplace/custom-plugin-postgresql
postgresql-plpgsql 8 postgresql-advanced-queries 8 postgresql-fundamentals 6 postgresql-monitoring 3 postgresql-replication 3 postgresql-scaling 3 postgresql-performance 3 postgresql-json 3 postgresql-extensions 3 postgresql-docker 3

Browse all from pluginagentmarketplace/custom-plugin-postgresql

More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Also listed on

Alternate registries and mirrors of this skill.

Repository health

Stars 1
License LICENSE
Default branch main
Open issues 0
Status Archived

Skill metadata

Parsed from SKILL.md frontmatter.

Version3.0.0

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 1,738 B
  • docs SUMMARY.md 86 B

History

  1. First seen on skills.sh
  2. First recorded snapshot · 3 installs

SKILL.md

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")