Can I use this with AWS EC2?

Absolutely. It is designed to work with any remote server accessible via SSH, including EC2, DigitalOcean droplets, and private VPS servers.

Does this skill support PostgreSQL?

Yes, it supports both PostgreSQL and MySQL databases with specialized commands for backup and restoration for each engine.

Does it clean up temporary backup files after completion?

Yes, the workflow includes a cleanup step that asks to remove remote and local temporary backup files once the restore is verified.

What happens if the local database already exists?

The skill will prompt you to choose between overwriting the existing database (with an optional backup), creating a new database with a unique name, or canceling.

Clone Database

Name: Clone Database
Author: yanmxa

byyanmxa

•

Database Management

Automates the end-to-end process of cloning remote MySQL or PostgreSQL databases from servers to a local development environment.

This skill simplifies database synchronization by orchestrating a complete workflow: it creates a remote backup via SSH, securely downloads the data using rsync or SCP, and restores it to your local machine. It intelligently handles existing databases by offering overwrite or rename options, automatically generates connection URLs (DATABASE_URL), and ensures data integrity with table verification. Ideal for developers needing fresh production or staging data for local debugging and development without manual export/import steps.

Key Features

01Streaming sync mode for fast transfers without intermediate files

029 GitHub stars

03Automatic DATABASE_URL generation for application integration

04Intelligent local restore with overwrite or rename options

05Supports both MySQL and PostgreSQL database types

06Automated SSH backup and secure download via rsync or SCP

Use Cases

01Pulling database snapshots from AWS EC2 instances for offline analysis

02Syncing production data to local for debugging specific issues

03Setting up a local environment with staging data for new features

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add yanmxa/cc-plugins clone-database

For use in Claude.ai and ChatGPT

Download Skill