How do I install the Sync DB skill?

Run npx skillmds@latest add diegosouzapw/sync-db in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Sync DB safe to use?

This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. Capability flags: reads secrets. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Sync DB?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Sync DB free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Sync DB?

diegosouzapw (@diegosouzapw) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Sync DB by diegosouzapw — Agent Skill

Name: Sync DB
Rating: 4.2 (5 reviews)
Author: diegosouzapw

Sync DB

This skill should be used when the user asks to "sync database", "get production data", "download prod db", "migrate database", "update local db", "refresh dev database", or needs to sync production data to local/dev environment.

diegosouzapw Updated Sep 8, 2026 54 repo stars

File contents

Sync Production Database to Development

Run the database migration script to sync production data to local development environment.

Prerequisites

Virtual environment must be activated: source backend/env/bin/activate
AWS CLI configured with Parameter Store access
Docker installed (for database operations)

Script Location

backend/scripts/migrate-prod-to-dev.sh

Usage Options

Download Production Database Only (Safest)

cd backend/scripts
./migrate-prod-to-dev.sh --download

Downloads production database to backend/backups/ without making any local changes.

Upload Latest Dump to Dev Database

cd backend/scripts
./migrate-prod-to-dev.sh --upload

Restores the most recent backup file to development database.

Run Django Migrations and Create Admin User Only

cd backend/scripts
./migrate-prod-to-dev.sh --setup

Runs migrations and creates/updates admin user (dev@genlayer.foundation / password).

Full Migration (Download + Upload + Setup)

cd backend/scripts
./migrate-prod-to-dev.sh

Complete workflow: download production data, restore to dev, run migrations, and create admin.

What It Does

Fetches production database credentials from AWS Parameter Store
Downloads production PostgreSQL database using Docker (matching version)
Restores to development database (local or AWS dev instance)
Runs Django migrations
Creates/updates admin user with Steward role

Notes

Backups are saved to backend/backups/ with timestamps
Uses Docker to avoid PostgreSQL version mismatch issues
See backend/scripts/README.md for detailed documentation and troubleshooting

---name: sync-dbdescription: This skill should be used when the user asks to "sync database", "get production data", "download prod db", "migrate database", "update local db", "refresh dev database", or needs to sync production data to local/dev environment.---# Sync Production Database to DevelopmentRun the database migration script to sync production data to local development environment.## Prerequisites- Virtual environment must be activated: `source backend/env/bin/activate`- AWS CLI configured with Parameter Store access- Docker installed (for database operations)## Script Location`backend/scripts/migrate-prod-to-dev.sh`## Usage Options### Download Production Database Only (Safest)```bashcd backend/scripts./migrate-prod-to-dev.sh --download```Downloads production database to `backend/backups/` without making any local changes.### Upload Latest Dump to Dev Database```bashcd backend/scripts./migrate-prod-to-dev.sh --upload```Restores the most recent backup file to development database.### Run Django Migrations and Create Admin User Only```bashcd backend/scripts./migrate-prod-to-dev.sh --setup```Runs migrations and creates/updates admin user (`dev@genlayer.foundation` / `password`).### Full Migration (Download + Upload + Setup)```bashcd backend/scripts./migrate-prod-to-dev.sh```Complete workflow: download production data, restore to dev, run migrations, and create admin.## What It Does1. Fetches production database credentials from AWS Parameter Store2. Downloads production PostgreSQL database using Docker (matching version)3. Restores to development database (local or AWS dev instance)4. Runs Django migrations5. Creates/updates admin user with Steward role## Notes- Backups are saved to `backend/backups/` with timestamps- Uses Docker to avoid PostgreSQL version mismatch issues- See `backend/scripts/README.md` for detailed documentation and troubleshooting

Frequently asked questions