skills.rest
seb1n
seb1nCOMMUNITY
Explore all skills by this author →
GitHub

database-backup

Automate PostgreSQL, MySQL, and MongoDB backup planning, scheduling, and verification.

147|32|Updated Feb 11, 2026
Search Tags:#database#postgresql#disaster recovery#restore#backup#mysql#mongodb
One-click install
npx skills add https://github.com/seb1n/awesome-ai-agent-skills --skill database-backup-seb1n
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-backup
Source: https://github.com/seb1n/awesome-ai-agent-skills/tree/main/database/database-backup
Command: npx skills add https://github.com/seb1n/awesome-ai-agent-skills --skill database-backup-seb1n

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the complex process of creating, scheduling, and verifying database backups, ensuring your critical data is protected against loss and can be reliably restored.

Core Features & Use Cases

  • Multi-Database Support: Handles PostgreSQL, MySQL, and MongoDB with specific tools for each.
  • Flexible Strategies: Supports full, incremental, differential, and point-in-time recovery.
  • Automated Scheduling & Retention: Configures cron jobs and manages storage by deleting old backups.
  • Verification: Includes steps to test backup integrity and perform restore drills.
  • Use Case: A company needs to ensure its production PostgreSQL database is backed up nightly, with a 30-day retention policy, and the backups are compressed and stored securely in AWS S3.

Quick Start

Generate a nightly full backup script for a PostgreSQL database named 'production' with 30-day retention, compressed and uploaded to /var/backups/postgresql.

Frequently Asked Questions about database-backup

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate database backups for PostgreSQL, MySQL, and MongoDB?▼

You can automate database backups by generating scheduling scripts and cron jobs that handle full, incremental, and differential strategies for PostgreSQL, MySQL, and MongoDB. This ensures your data is protected and consistently backed up without manual intervention.

How does point-in-time recovery work for database backups?▼

Point-in-time recovery allows you to restore a database to a specific moment, minimizing data loss after accidental deletion or corruption. The Skill supports planning and scripting these recovery strategies alongside full and incremental backups.

What's the best way to verify database backup integrity and test restores?▼

The best way to verify database backup integrity is to perform regular restore drills and automated integrity checks. This Skill includes steps to test backup files, ensuring your PostgreSQL, MySQL, or MongoDB data can be reliably recovered.

Can I compress and encrypt database backups before cloud storage integration?▼

Yes, you can compress and encrypt database backups before uploading them to cloud storage. This Skill supports configuring compression, encryption, and automated retention policies to securely manage storage space for PostgreSQL, MySQL, and MongoDB.

How do I manage backup retention policies and delete old database backups?▼

You manage backup retention policies by configuring automated rules that delete old database backups based on your storage limits. This Skill sets up retention schedules to automatically remove outdated PostgreSQL, MySQL, or MongoDB backup files.

Related Skills

Explore More Software Engineering Skills→
heinschulieheinschulie

database

Provision managed PostgreSQL, Redis, MySQL, and MongoDB databases via Railway templates.

Community
Intermediate
haJ1thaJ1t

backup-dr-planner

Develop backup and disaster recovery plans with RPO and RTO targets.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

implementing-backup-strategies

Generate backup configurations and setup scripts for databases and applications.

Community
Advanced
ryukyagamilightryukyagamilight
1

cloud-backup

Manage data backups and synchronization to AWS S3, Alibaba OSS, and Azure Blob Storage.

Community
Advanced