skills.rest
cyanluna-git
cyanluna-gitCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

db-backup

Automate PostgreSQL backup and restore workflows across Docker and local environments.

Updated Dec 10, 2025
Search Tags:#automation#postgresql#restore#backup#docker#psql#pg_dump
One-click install
npx skills add https://github.com/cyanluna-git/edwards.reousrce.management --skill db-backup
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-backup
Source: https://github.com/cyanluna-git/edwards.reousrce.management/tree/main/.claude/skills/db-backup
Command: npx skills add https://github.com/cyanluna-git/edwards.reousrce.management --skill db-backup

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill automates the backup and restoration of PostgreSQL databases across Dockerized environments and local setups, reducing manual steps and the risk of data loss.

Core Features & Use Cases

  • Docker Backups: Create consistent dumps from the running Docker PostgreSQL container.
  • Local Backups: Back up a local PostgreSQL database (default host: localhost:5434).
  • Restores & Workflows: Restore from backup files to Docker or server databases, and list available backups.
  • Use Case: A developer needs to snapshot a dev database, archive dumps, and restore them to a test server with minimal downtime.

Quick Start

To back up the Docker DB: /db-backup backup To back up a local DB: /db-backup backup --local To list backups: /db-backup list To restore: /db-backup restore backup_20260130.sql

Frequently Asked Questions about db-backup

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

FAQPage Schema
How do I automate PostgreSQL backups in a Docker container?▼

To automate PostgreSQL backups in a Docker container, you can run a backup command that utilizes pg_dump to create consistent dumps directly from your running Docker PostgreSQL setup. This process requires Docker and Python utilities to execute the backup workflow automatically.

What's the best way to restore a PostgreSQL dump to a local server?▼

The best way to restore a PostgreSQL dump to a local server is using a restore command with your backup file. The skill uses psql to restore archives to either Docker or server targets, allowing you to easily recover your database from a previously generated SQL dump file.

Can I back up a local PostgreSQL database without Docker?▼

Yes, you can back up a local PostgreSQL database without Docker by appending a local flag to your backup command. This targets your local PostgreSQL instance, defaulting to localhost:5434, and uses pg_dump to generate the database dump file for local archives.

Does this PostgreSQL backup tool support listing available database dumps?▼

Yes, this PostgreSQL backup tool supports listing available database dumps. You can execute a list command to view all previously created backup files, making it easier to select the correct SQL dump when you need to restore to a Docker or server target.

Why do I need Python utilities for PostgreSQL backup and restore workflows?▼

You need Python utilities for PostgreSQL backup and restore workflows because they orchestrate the execution of underlying tools like pg_dump, psql, and Docker commands. Python acts as the automation layer to sequence these tools and handle the backup and restoration logic seamlessly.

Related Skills

Explore More Software Engineering Skills→
pgplexpgplex
994

Validate with Database

Validate PostgreSQL schema drift by comparing pg_dump with pgschema outputs.

Official
Intermediate
gpt-cmdrgpt-cmdr
73

executing-remote-plans

Execute HEC-RAS plans across remote machines via PsExec, Docker, or SSH.

Community
Advanced
pkoka888pkoka888
1

postgres-backup

Back up and restore PostgreSQL databases with pg_dump and Borg.

Community
Intermediate
jeremylongshorejeremylongshore
2.6k

managing-database-recovery

Orchestrate database recovery operations with the database-recovery-manager plugin.

Community
Advanced