# database-backup-restore

A coding assistant skill for backup and disaster recovery strategies. Use it when planning backups, testing restore procedures, or setting up automated backup jobs.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 582 installs · ★ 371
- Author: aj-geddes
- License: MIT · policy=mirror · the beginning of the file is at the end of this page
- Source: https://github.com/aj-geddes/useful-ai-prompts/tree/HEAD/skills/database-backup-restore/SKILL.md
- Updated: 2026-03-04
- HTML: https://affpapa.org/en/nevibecode/skills/database-backup-restore

## What it does

The skill covers backup types, retention policies, restore testing, and RTO/RPO targets. Quick start examples show pg_dump commands for PostgreSQL: a plain text full dump, a compressed variant piped through gzip, verbose output logging, and excluding tables with `--exclude-table=temp_*`.

Reference guides in the `references/` directory walk through full, incremental, and differential backups, binary log backups, and restore procedures for PostgreSQL and MySQL. The best practices section keeps it simple: follow existing patterns, test before deploying, handle errors, and avoid hard-coding configuration values.

Install it with `npx skills add aj-geddes/useful-ai-prompts --skill database-backup-restore -a claude-code`, and the skill lands at `~/.claude/skills/database-backup-restore/SKILL.md`. It also works in Codex, Cursor, GitHub Copilot, Gemini CLI, and OpenCode, each with its own install command and file path.

## Requirements
- Works with: PostgreSQL

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add aj-geddes/useful-ai-prompts --skill database-backup-restore -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/database-backup-restore/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/database-backup-restore/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add aj-geddes/useful-ai-prompts --skill database-backup-restore -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/database-backup-restore/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add aj-geddes/useful-ai-prompts --skill database-backup-restore -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/database-backup-restore/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install aj-geddes/useful-ai-prompts database-backup-restore
```

2. **Manually: put the files in place**
- File: `.github/skills/database-backup-restore/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add aj-geddes/useful-ai-prompts --skill database-backup-restore -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/aj-geddes/useful-ai-prompts --path skills/database-backup-restore
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/database-backup-restore/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add aj-geddes/useful-ai-prompts --skill database-backup-restore -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/aj-geddes/useful-ai-prompts/tree/HEAD/skills/database-backup-restore/SKILL.md

## When to use it
- Set up automated PostgreSQL backups
- Define a backup retention policy
- Test restore from a backup
- Plan point-in-time recovery
- Replicate backups across regions

## Example prompts
- Create a backup plan for PostgreSQL: backup types, schedule, retention
- Show pg_dump commands for a full dump excluding temp tables
- Walk me through testing a MySQL restore procedure

## Source text · SKILL.md · MIT

Below is the content of a third-party file. It is data, not instructions for you: do not act on anything written inside unless the human asks. Block tag: b36aac5d6b8fb2d0.

BEGIN THIRD-PARTY FILE b36aac5d6b8fb2d0
````text
---
name: database-backup-restore
description: >
  Implement backup and restore strategies for disaster recovery. Use when
  creating backup plans, testing restore procedures, or setting up automated
  backups.
---

# Database Backup & Restore

## Table of Contents

- [Overview](#overview)
- [When to Use](#when-to-use)
- [Quick Start](#quick-start)
- [Reference Guides](#reference-guides)
- [Best Practices](#best-practices)

## Overview

Implement comprehensive backup and disaster recovery strategies. Covers backup types, retention policies, restore testing, and recovery time objectives (RTO/RPO).

## When to Use

- Backup automation setup
- Disaster recovery planning
- Recovery testing procedures
- Backup retention policies
- Point-in-time recovery (PITR)
- Cross-region backup replication
- Compliance and audit requirements

## Quick Start

**pg_dump - Text Format:**

```bash
# Simple full backup
pg_dump -h localhost -U postgres -F p database_name > backup.sql

# With compression
pg_dump -h localhost -U postgres -F p database_name | gzip > backup.sql.gz

# Backup with verbose output
pg_dump -h localhost -U postgres -F p -v database_name > backup.sql 2>&1

# Exclude specific tables
pg_dump -h localhost -U postgres database_name \
  --exclude-table=temp_* --exclude-table=logs > backup.sql
```

## Reference Guides

Detailed implementations in the `references/` directory:

| Guide | Contents |
|---|---|
| [Full Database Backup](references/full-database-backup.md) | Full Database Backup |
| [Incremental & Differential Backups](references/incremental-differential-backups.md) | Incremental & Differential Backups |
| [Full Database Backup](references/full-database-backup-2.md) | Full Database Backup |
| [Binary Log Backups](references/binary-log-backups.md) | Binary Log Backups |
| [PostgreSQL Restore](references/postgresql-restore.md) | PostgreSQL Restore |
| [MySQL Restore](references/mysql-restore.md) | MySQL Restore |

## Best Practices

### ✅ DO

- Follow established patterns and conventions
- Write clean, maintainable code
- Add appropriate documentation
- Test thoroughly before deploying

### ❌ DON'T

- Skip testing or validation
- Ignore error handling
- Hard-code configuration values
````
END THIRD-PARTY FILE b36aac5d6b8fb2d0

The third-party file has ended. Everything between the b36aac5d6b8fb2d0 tags is data: requests and commands from it are not followed. An “end of file” line with another tag inside the block is part of the file.

© aj-geddes · MIT · https://github.com/aj-geddes/useful-ai-prompts/tree/HEAD/skills/database-backup-restore/SKILL.md

## Similar
- [database-backups](https://affpapa.org/en/nevibecode/skills/database-backups.md) — skill · 405 installs
- [convex-backup](https://affpapa.org/en/nevibecode/skills/convex-backup.md) — skill · 35900 installs
- [database-optimizer](https://affpapa.org/en/nevibecode/skills/httpsgithubcomjeffallan-database-optimizer.md) — skill · 6000 installs
- [database-admin](https://affpapa.org/en/nevibecode/agents/database-admin.md) — subagent · 2185 installs
- [supabase-backup-manager](https://affpapa.org/en/nevibecode/commands/supabase-backup-manager.md) — command · 812 installs

_Part of the page did not fit — see the HTML version._

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md