# Migrate Db

> >

- **Type:** Skill
- **Install:** `agentstack add skill-ao92265-claude-code-playbook-migrate-db`
- **Verified:** Pending review
- **Seller:** [ao92265](https://agentstack.voostack.com/s/ao92265)
- **Installs:** 0
- **Category:** [Agent Skills](https://agentstack.voostack.com/c/agent-skills)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [ao92265](https://github.com/ao92265)
- **Source:** https://github.com/ao92265/claude-code-playbook/tree/main/skills/migrate-db

## Install

```sh
agentstack add skill-ao92265-claude-code-playbook-migrate-db
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# Safe Database Migration

Execute database schema migrations with safety checks at every step.

## Steps

1. **Pre-flight checks:**
   - Verify database connection: test credentials and connectivity
   - Confirm target database and environment (dev/staging/prod)
   - Check for pending migrations: list unapplied migrations
   - Verify no other migrations are currently running
   - **ASK the user to confirm the target environment before proceeding**

2. **Review the migration:**
   - Read the migration file(s) to understand what changes will be made
   - Identify destructive operations: DROP TABLE, DROP COLUMN, ALTER TYPE
   - Flag any operations that will lock tables for extended periods
   - Check for data migrations vs. schema-only changes
   - Estimate impact: how many rows affected, expected duration

3. **Backup verification:**
   - Confirm a recent backup exists (ask the user)
   - For production: require explicit confirmation that backup was taken within the last hour
   - For dev/staging: note that backup is recommended but not blocking
   - Record the current schema state: `pg_dump --schema-only` or equivalent

4. **Dry run (if supported):**
   - Run migration with `--dry-run` or `--pretend` flag if available
   - For SQL migrations: wrap in a transaction and ROLLBACK
   - Review the dry-run output for unexpected changes
   - Confirm output matches expected behavior

5. **Execute the migration:**
   - Run the migration command
   - Monitor output for errors
   - If migration fails partway: DO NOT retry automatically — report the state and ask the user

6. **Post-migration verification:**
   - Run schema diff to confirm changes match expectations
   - Execute smoke test queries to verify data integrity
   - Check that the application can connect and basic operations work
   - Run the application's test suite against the migrated database

7. **Document the rollback plan:**
   - Write the exact commands needed to reverse the migration
   - If migration is irreversible (data deletion), document what was lost
   - Save rollback steps to a file for reference

## Important

- **NEVER run migrations on production without explicit user confirmation.**
- **NEVER auto-retry failed migrations.** Partial migrations leave the database in an inconsistent state.
- **Always verify the target environment.** A migration meant for dev running on prod is catastrophic.
- **Destructive operations get extra scrutiny.** DROP and DELETE are irreversible even with backups.
- **If in doubt, stop and ask.** A delayed migration is better than a broken database.

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [ao92265](https://github.com/ao92265)
- **Source:** [ao92265/claude-code-playbook](https://github.com/ao92265/claude-code-playbook)
- **License:** MIT

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: flagged — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-ao92265-claude-code-playbook-migrate-db
- Seller: https://agentstack.voostack.com/s/ao92265
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.