Automated database maintenance workflow for PostgreSQL databases

• Automate weekly database maintenance tasks for PostgreSQL databases.
• Monitor database performance and detect bloat issues.
• Log maintenance results in Google Sheets for easy tracking.
• Notify team members about maintenance status via Slack.

Triggers weekly on Sunday at 03:00 UTC using a cron job. Builds a maintenance plan for specified PostgreSQL databases. Executes maintenance tasks such as analyze, vacuum, and backup. Evaluates the results to detect bloat and determine status. Logs results into Google Sheets and sends notifications via Slack.

1. 1
   Import the workflow template into your n8n instance.
2. 2
   Configure the Google Sheets credentials for logging.
3. 3
   Set up Slack integration for notifications.
4. 4
   Adjust the cron expression if a different schedule is needed.
5. 5
   Activate the workflow to start automated maintenance.