automating-database-backups

Solid

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".

API & Backend 2,926 stars 433 forks Updated yesterday MIT

Install

View on GitHub

Quality Score: 91/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
93
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

## Overview This skill streamlines the creation of database backup solutions. It generates scripts, configures schedules, and provides comprehensive restore procedures, ensuring data safety and efficient recovery. ## How It Works 1. **Analyze Requirements**: Determines the database type (PostgreSQL, MySQL, MongoDB, or SQLite) and backup requirements (frequency, retention). 2. **Generate Scripts**: Creates backup scripts with compression and encryption. 3. **Schedule Backups**: Sets up cron jobs for automated, scheduled backups. 4. **Document Restore**: Generates clear, concise restore procedures. ## When to Use This Skill This skill activates when you need to: - Create a backup schedule for a database. - Automate the database backup process. - Generate scripts for database restoration. - Implement a disaster recovery plan for a database. ## Examples ### Example 1: Setting up Daily Backups for PostgreSQL User request: "Create daily backups for my PostgreSQL database." The skill will: 1. Generate a `pg_dump` script with compression and encryption. 2. Create a cron job to run the backup script daily. ### Example 2: Automating Weekly Backups for MongoDB User request: "Automate weekly backups for my MongoDB database." The skill will: 1. Generate a `mongodump` script with compression and encryption. 2. Create a cron job to run the backup script weekly and implement a retention policy. ## Best Practices - **Retention Policies**: Implement clear retention policies to ma...

Details

Author
jeremylongshore
Repository
jeremylongshore/claude-code-plugins-plus-skills
Created
1 years ago
Last Updated
yesterday
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Featured

implementing-backup-strategies

This skill implements backup strategies for databases and applications. It generates configuration files and setup code to ensure data protection and disaster recovery. Use this skill when the user requests to "implement backup strategy", "configure backups", "setup data recovery", or needs help with "backup automation". The skill provides production-ready configurations, best practices, and multi-platform support for database and application backups. It focuses on security and scalability.

2,926 Updated yesterday
jeremylongshore
AI & Automation Listed

database-backup

Create, schedule, and verify database backups with support for full, incremental, and point-in-time recovery strategies. Use when the user requests database backup or provides relevant inputs for this workflow.

258 Updated 3 months ago
seb1n
API & Backend Featured

comparing-database-schemas

This skill leverages the database-diff-tool plugin to compare database schemas, generate migration scripts, and provide rollback procedures. It is triggered when the user requests database schema comparisons, migration script generation, or database synchronization. Use this skill when asked to identify differences between database schemas (PostgreSQL or MySQL), create safe migration scripts with transaction safety, validate changes before deployment, or generate rollback procedures. The skill is activated by requests involving terms like "database diff", "schema comparison", "generate migration script", "database synchronization", or `/db-diff`.

2,926 Updated yesterday
jeremylongshore