词映 AI导航
工具库Skills 技能
我的收藏
词映 AI导航

Database Backup Automation Skill for PostgreSQL Restore Tests

Plan a backup, checksum, and restore workflow and verify the archive on a disposable PostgreSQL database.

中文

Install in Claude Code

Use a PostgreSQL test instance you control, pg_dump, pg_restore, two separate databases, and synthetic inventory data.

  1. Get the complete `plugins/database/database-backup-automator/skills/automating-database-backups` directory from the pinned GitHub commit.
  2. Copy it into the target project's `.claude/skills/`. Check `.claude/skills/automating-database-backups/SKILL.md`, start Claude Code at the project root, and call `/automating-database-backups`.

Example task

Insert three fixture rows into inventory. Create inventory.dump with pg_dump -Fc. Use pg_restore -d inventory_restore inventory.dump against the precreated empty destination.

What to check

The destination has the inventory table and all three rows. Record the archive location, checksum, and restore test time.

Original SKILL.md on GitHub · Updated

Frequently asked question

Is checking file size sufficient?

Use size as a basic signal, then restore the archive and verify representative rows or application behavior.