DevSource: AY Automate

Database Backup Verification

Checks daily that a scheduled database backup actually completed and is a reasonable size, then alerts the team if a backup is missing or looks truncated — catching a silent backup failure before it matters.

What this template does

Checks daily that a scheduled database backup actually completed and is a reasonable size, then alerts the team if a backup is missing or looks truncated — catching a silent backup failure before it matters. It's categorized in our directory under Dev & Agent Automation agent coordination, CI/CD glue, and developer-tool integrations — including our own Claude Code + n8n templates.

Integrations

  • PostgreSQL
    PostgreSQL
  • Slack
    Slack

Setup steps

  1. 1Check for today's backup file at the expected time and location.
  2. 2Compare its size against a rolling average to catch truncated backups.
  3. 3Alert Slack if the backup is missing or looks abnormal.
  4. 4Log successful checks so there's a visible history, not just silence.

More Dev templates

Other dev & agent automation templates in our directory.