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

•

データベース管理

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.

主な機能

Streaming sync mode for fast transfers without intermediate files
9 GitHub stars
Automatic DATABASE_URL generation for application integration
Intelligent local restore with overwrite or rename options
Supports both MySQL and PostgreSQL database types
Automated SSH backup and secure download via rsync or SCP

ユースケース

Pulling database snapshots from AWS EC2 instances for offline analysis
Syncing production data to local for debugging specific issues
Setting up a local environment with staging data for new features

概要

主な機能

Streaming sync mode for fast transfers without intermediate files
9 GitHub stars
Automatic DATABASE_URL generation for application integration
Intelligent local restore with overwrite or rename options
Supports both MySQL and PostgreSQL database types
Automated SSH backup and secure download via rsync or SCP

ユースケース

Pulling database snapshots from AWS EC2 instances for offline analysis
Syncing production data to local for debugging specific issues
Setting up a local environment with staging data for new features