Back to library
Monitoring·n8n workflow

Database Backup Verification

Daily: verify latest DB backup exists, completed successfully, and is recent (<24h old) — flag stale or failed backups to #databases.

Overview

**What it does**: Daily schedule → query backup provider (AWS RDS, Azure Backup, PostgreSQL WAL archive, custom store) → code validates: status=completed, age<24h, size>threshold → IF failed/stale → LLM explains issue (backup not found, too old, corrupted, undersized) + recovery steps → Slack to #databases. **Setup (4 steps)**: 1. Connect backup provider: AWS RDS, Azure, GCP, or custom API + credentials 2. Set validation rules: max age (default 24h), min size (default 100MB) 3. Configure Slack channel: #databases 4. Test: query manually; force age violation; verify alert **Apps/nodes**: Schedule, HTTP request (backup API), code node (validation), OpenAI (diagnosis), Slack. **Credentials required**: Backup provider credentials, OpenAI account, Slack workspace. **Difficulty**: Easy | **Setup time**: 6 minutes. **Business outcome**: Backup failures caught before disaster → RTO/RPO ↑ confidence, data loss risk ↓ 99%, DBA validation burden ↓.

What's included

Importable n8n workflow (JSON)
Real, wired nodes — trigger, logic, and actions
Setup notes: which credentials to connect
Free updates when the workflow changes
Commercial-use license — keep and customize
Email support if you get stuck

Quickstart

  1. 01

    Download the JSON

    With an active Library Pass, download the workflow file right from this page or your dashboard.

  2. 02

    Import into n8n

    Choose Import from File and select the downloaded JSON. The full agent graph appears, ready to configure.

  3. 03

    Plug in credentials

    Each integration node prompts for credentials on first run. The setup guide lists every credential the agent expects.

  4. 04

    Activate and test

    Run once with sample input, confirm the expected output, then flip the activate toggle.

Frequently Asked Questions

How do I import this workflow into n8n?
Download the JSON file from your Library Pass, go to your n8n workspace, click the import button, select "Import from File", and upload the JSON. The entire workflow graph will load instantly, ready for configuration.
What credentials do I need to provide?
Each workflow lists required credentials in its description (e.g., Slack API key, GitHub token, PagerDuty account). You connect your own credentials—the workflow file contains only placeholder names, no actual API keys or secrets.
Are the credentials included in the JSON file?
No. For security, credential IDs are sanitized before distribution. You connect your own accounts when you first run the workflow. n8n will prompt you to authenticate each service.
Can I edit or customize the workflow after importing?
Yes, absolutely. Once imported, the workflow is yours to modify. You can change node logic, add/remove steps, adjust schedules, or integrate with different services. All changes are saved in your n8n workspace.
What n8n version is required?
These workflows use standard n8n-nodes-base node types (released 2022+). They work on n8n Cloud, self-hosted versions 0.180+, and Docker deployments. Community nodes (if required) are noted in the workflow description.
What if something breaks after I import it?
Check the workflow description for setup steps and credential names. Most issues are credential-related. If you get stuck, email support@autoflowworks.com with a screenshot of the error, and we'll help you troubleshoot.
Can I use this workflow for my customers or business?
Yes. The commercial-use license lets you keep, customize, and deploy the workflow for your business or clients. You can redistribute customized versions (except the original unmodified JSON without a valid Library Pass).
Will the workflow receive updates?
Yes. When we improve a workflow (fix bugs, add features, optimize node types), you'll get the updated JSON for free. Check your Library Pass dashboard for new versions.
Do I need n8n Pro or a paid plan?
Not necessarily. These workflows run on n8n Free if you have enough execution time and storage. For production use (frequent triggers, high data volumes, many webhooks), you may want n8n Cloud Pro or higher. Check n8n's pricing for details.
Can I ask for a custom workflow?
Yes! We offer custom workflow design for specific DevOps/SRE use cases. Visit /custom-solutions or email support@autoflowworks.com with your requirements for a quote.

Reviews (0)

No reviews yet. Be the first.

Sign in to leave a review.

Library Pass

Included with any pass

This agent — and every other in the library — comes with a Library Pass. One pass, the whole catalog.

Get a Library Pass
  • Every agent in the library
  • All new releases while active
  • Unlimited downloads
  • Commercial-use license
  • Priority email support
  • 30-day money-back guarantee
Browse the full library →

More in Monitoring

Monitoring
n8n workflow

Cron Job Failure Watchdog

Monitor cron job heartbeats; on failure, LLM summarizes what failed, when it last ran, and recovery steps — escalate to #batch-jobs.

Included with a PassView →
Monitoring
n8n workflow

Error Budget Burn Alert

Hourly check: if error budget burn rate exceeds 50%, escalate to the on-call engineer with burn %, incident rate, and time to exhaustion.

Included with a PassView →
Monitoring
n8n workflow

Grafana Dashboard Snapshot on Alert

When a Grafana alert fires, auto-render a dashboard snapshot and post it to Slack — on-call engineers see metrics context instantly, no Grafana login required.

Included with a PassView →