This n8n workflow automates the process of monitoring the freshness of data tables within a Postgres database. It checks whether specific tables have been updated recently and sends alerts if any data has become stale, ensuring data integrity and timely updates.

The workflow begins with a Schedule Trigger that initiates the process at regular intervals. It then produces a list of tables along with their timestamp columns, which are configured in a code node. For each table, the workflow retrieves the most recent row based on the timestamp column, calculates the age of this data in days, and compares it against a threshold (default of 3 days).

Tables with recent updates are filtered out, leaving only those that are considered stale. For each stale table, an email alert is dispatched through an existing workflow, notifying the relevant team or individual about the data’s outdated status. The workflow includes optional sticky notes for guidance, helping users customize parameters such as the list of tables and threshold for staleness.

This automation is particularly useful for data management teams and system administrators who need to ensure their database tables are consistently updated, and any delays or issues are promptly addressed to maintain data accuracy and reliability.