backup-script-gen

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

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

# 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