postgres-backup-restore

Community

Automate PostgreSQL backups restore in Docker.

Authorracar
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Automate the process of loading PostgreSQL backup files into local databases running in Docker containers. This accelerates debugging and testing by making realistic data readily available in local environments.

Core Features & Use Cases

  • Automated backup restoration: copy, drop, recreate, and restore databases from SQL files into a Dockerized PostgreSQL instance.
  • Manual workflow support: step-by-step instructions for users who prefer full control over each phase.
  • Use Case: Reproduce production-like issues locally by restoring sanitized or real backups into a local Docker PostgreSQL database.

Quick Start

Run the automated restore script with: ./scripts/restore_backup.sh <backup-file> <container-id> <database-name> Example: ./scripts/restore_backup.sh ~/Descargas/qa-order-service.sql c091f5a68780 order_development

Dependency Matrix

Required Modules

docker

Components

scripts

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: postgres-backup-restore
Download link: https://github.com/racar/racar_agent_skills/archive/main.zip#postgres-backup-restore

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.