Claude Code PostgreSQL Backup Skill for Restore Verification
Test whether a custom-format archive can restore the expected schema and data into a separate database.
中文Install in Claude Code
Use local PostgreSQL tools, a scratch source database and an empty restore target. Use synthetic rows.
- Get the complete `plugins/devops/backup-strategy-implementor/skills/implementing-backup-strategies` directory from the pinned GitHub checkout.
- Copy it under the target project's `.claude/skills/`. Confirm `.claude/skills/implementing-backup-strategies/SKILL.md`, open Claude Code at the project root, and call `/implementing-backup-strategies`.
Example task
Back up a three-book fixture and restore it into a new empty database. Count `books` rows and verify one expected ISBN.What to check
The restored table has three rows and the selected ISBN matches. Record elapsed time and the backup artifact used.
Original SKILL.md on GitHub · Updated
Frequently asked question
Does listing the archive verify the recovery?
Listing verifies archive readability. Restore to the test target and query it to verify recovered data and schema.