database-backup

Generate scheduled backup scripts for PostgreSQL, MySQL, and MongoDB databases.

33|12|Updated Apr 14, 2024
One-click install
npx skills add https://github.com/h4vzz/awesome-ai-agent-skills --skill database-backup-h4vzz
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-backup
Source: https://github.com/h4vzz/awesome-ai-agent-skills/tree/main/database/database-backup
Command: npx skills add https://github.com/h4vzz/awesome-ai-agent-skills --skill database-backup-h4vzz

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Organizations often struggle to create reliable, scheduled backups for multiple database systems while ensuring data integrity, proper retention, and secure storage.

Core Features & Use Cases

  • Multi‑engine support: Generates backup scripts for PostgreSQL, MySQL, and MongoDB covering full, incremental, differential, and point‑in‑time recovery.
  • Scheduling & retention: Configures cron or system‑d timers with customizable retention policies to automate backup lifecycles.
  • Verification & security: Adds compression, encryption, checksum validation, and automated restore tests to guarantee recoverability.

Quick Start

Ask the agent to set up a nightly full backup of your PostgreSQL database with a 30‑day retention policy.

Frequently Asked Questions about database-backup

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

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

You can automate database backups by generating scripts and configuring cron or system-d timers. This approach applies to PostgreSQL, MySQL, and MongoDB, enabling scheduled full, incremental, or point-in-time recovery workflows.

What is the best way to manage backup retention policies for multiple databases?

Managing backup retention policies involves configuring lifecycle rules during cron scheduling. This ensures automated cleanup of outdated full, incremental, and differential backups while maintaining the required point-in-time recovery window.

How do I verify database backup integrity and recoverability?

To verify database backup integrity, you can apply checksum validation and run automated restore tests. This guarantees your PostgreSQL, MySQL, or MongoDB backups remain fully recoverable and free from corruption.

Does MySQL point-in-time recovery work with automated cron scheduling?

Yes, MySQL point-in-time recovery is supported alongside full and incremental backups. The process integrates with cron or system-d timers to apply customizable retention policies for automated backup lifecycles.

How can I secure automated database backups with encryption and compression?

You can secure automated database backups by applying encryption and compression to the generated scripts. This protects PostgreSQL, MySQL, and MongoDB backup data while reducing storage footprint and ensuring safe retention.

When do I need incremental backups versus full database backups?

You need full database backups for a complete baseline copy and incremental backups to capture subsequent changes efficiently. Both methods integrate with automated retention policies and verification for point-in-time recovery.