from points145
Run a safe, scripted workflow to download production database dumps and restore them into a development environment (download-only and restore options).
Provides operational instructions and a scripted workflow to synchronise production PostgreSQL data into a development environment. The skill documents prerequisites (virtualenv, AWS CLI access, Docker), the primary migration script location, and usage modes (download-only, upload/restore, setup migrations). It enumerates steps the script performs: fetch credentials from Parameter Store, download a dump, restore to dev, run migrations, and create/update an admin user.
Use this skill when developers need a reproducible way to refresh their local/dev database with production-like data for debugging, QA, or feature testing. Use the download-only mode when you must avoid making changes to any running environment; use full migration modes in controlled dev environments with appropriate access controls.
backend/scripts/migrate-prod-to-dev.sh script and its usage optionsBest used with developer-focused agents that can run shell commands or present operational checklists (Copilot/GitHub CLI environments, local automation agents).
This skill has not been reviewed by our automated audit pipeline yet.
