Daily Postgres Table Backup to GitHub CSV

This n8n workflow provides a robust, automated solution for backing up Postgres databases by exporting all tables from the public schema into CSV files stored in a GitHub repository. It runs every 24 hours via a schedule trigger, ensuring your data snapshots are always current without manual intervention. The process intelligently handles existing files by updating them if data changes or creating new ones for newly discovered tables, leveraging GitHub's version control for historical tracking.

The workflow begins with a daily schedule trigger, followed by listing existing CSV files in the target GitHub repo. It then queries Postgres for all public table names, loops through each to extract full data, converts it to CSV format, and performs conditional uploads: updating if the file exists or creating anew otherwise. This setup minimizes redundancy and storage bloat while maintaining data integrity.

Ideal for developers, data analysts, and engineers needing reliable backups with version history. Benefits include reduced manual export time, disaster recovery readiness, and seamless integration of database snapshots into GitHub workflows for collaboration or CI/CD. Requires Postgres read access and GitHub OAuth2 credentials in n8n.