openclaw / backup-script-gen
Install for your project team
Run this command in your project directory to install the skill for your entire team:
mkdir -p .claude/skills/backup-script-gen && curl -L -o skill.zip "https://fastmcp.me/Skills/Download/2872" && unzip -o skill.zip -d .claude/skills/backup-script-gen && rm skill.zipProject Skills
This skill will be saved in .claude/skills/backup-script-gen/ and checked into git. All team members will have access to it automatically.
Important: Please verify the skill by reviewing its instructions before using it.
Generate database backup scripts with AI. Use when you need automated backups to S3, GCS, or local storage.
0 views
0 installs
Skill Content
--- name: backup-script-gen description: Generate database backup scripts with AI. Use when you need automated backups to S3, GCS, or local storage. --- # Backup Script Generator Setting up database backups involves shell scripts, cron jobs, cloud CLI tools, and retention policies. This tool generates complete backup scripts for any database to any destination. **One command. Zero config. Just works.** ## Quick Start ```bash npx ai-backup-script "PostgreSQL daily to S3" ``` ## What It Does - Generates complete backup scripts with error handling - Supports all major databases (Postgres, MySQL, MongoDB, Redis) - Handles cloud destinations (S3, GCS, Azure Blob) - Includes retention and rotation logic ## Usage Examples ```bash # PostgreSQL to S3 npx ai-backup-script "PostgreSQL daily to S3 with 30 day retention" # MongoDB to Google Cloud Storage npx ai-backup-script "MongoDB hourly to GCS" # MySQL to local with rotation npx ai-backup-script "MySQL weekly to /backups with 4 week rotation" # Redis with compression npx ai-backup-script "Redis snapshot to S3 compressed" ``` ## Best Practices - **Test your restores** - a backup you can't restore is useless - **Monitor failures** - add alerting to your backup jobs - **Encrypt at rest** - especially for cloud storage - **Document the restore process** - future you will thank present you ## When to Use This - Setting up backups for a new database - Migrating from manual backups to automated - Need a quick backup script for a side project - Want a starting point to customize ## Part of the LXGIC Dev Toolkit This is one of 110+ free developer tools built by LXGIC Studios. No paywalls, no sign-ups, no API keys on free tiers. Just tools that work. **Find more:** - GitHub: https://github.com/LXGIC-Studios - Twitter: https://x.com/lxgicstudios - Substack: https://lxgicstudios.substack.com - Website: https://lxgicstudios.com ## Requirements No install needed. Just run with npx. Node.js 18+ recommended. Needs OPENAI_API_KEY environment variable. ```bash npx ai-backup-script --help ``` ## How It Works Takes your description of database type, schedule, and destination. Generates a shell script using the appropriate dump tool (pg_dump, mysqldump, mongodump, etc.) with proper flags, compression, upload commands, and cleanup logic. ## License MIT. Free forever. Use it however you want. --- **Built by LXGIC Studios** - GitHub: [github.com/lxgicstudios/ai-backup-script](https://github.com/lxgicstudios/ai-backup-script) - Twitter: [@lxgicstudios](https://x.com/lxgicstudios)