Featured

automating-database-backups

Name: automating-database-backups
Author: jeremylongshore

This skill automates database backups using the database-backup-automator plugin. It creates scripts for scheduled backups, compression, encryption, and restore procedures across PostgreSQL, MySQL, MongoDB, and SQLite. Use this when the user requests database backup automation, disaster recovery planning, setting up backup schedules, or creating restore procedures. The skill is triggered by phrases like "create database backup", "automate database backups", "setup backup schedule", or "generate restore procedure".

TL;DR

Creates automated, secure database backups with restore documentation.

What Is It

Generates backup scripts for multiple database types
Configures automated backup schedules
Provides clear restore procedures
Supports encryption and compression

Key Features

Supports PostgreSQL, MySQL, MongoDB, SQLite
Creates compressed and encrypted scripts
Sets up cron jobs for scheduled backups
Generates detailed restore documentation
Integrates with cloud storage and monitoring plugins
Enforces retention policies
Includes secure storage recommendations
Must test restore procedures regularly

How to Use

1.Define database type and backup needs
2.Generate backup scripts with compression and encryption
3.Set up cron jobs for scheduled execution
4.Document and validate restore procedures
5.Store backups securely and offsite
6.Test restore processes regularly

Guardrails & Gotchas

Must test restore procedures regularly
Retention policies must manage storage space
Secure storage is critical and must be encrypted
Offsite storage is recommended

GitHub Stats

Author

@jeremylongshore

Repository

jeremylongshore/claude-code-pl...

Stars

2,466

Explore More Skills

revenuecat

@rawveg

Comprehensive assistance with RevenueCat in-app subscriptions and purchases

687

7mo ago

automating-database-backups

Explore More Skills

revenuecat

api-design-principles

solana-security