Automated Airtable to Postgres migration with n8n

Overview

This ETL system automates the process of migrating data from Airtable to PostgreSQL with a single API request.

It maps your Airtable schema into a Postgres-compatible structure. Automatically creates new tables in your Postgres database. Migrates all the data while preserving formats and relationships.

> ⚙️ Originally built in-house to help us migrate off Airtable after exceeding usage limits.

---

🔧 How It Works

1. Accepts Airtable and Postgres credentials via HTTP requests. 2. Authenticates both services and validates schema compatibility. 3. Fetches data from Airtable and maps each table and field to PostgreSQL equivalents. 4. Creates the necessary tables in your Postgres database. 5. Inserts all records in batches. 6. Returns a success response with summary stats.

> Bonus operations: You can list or delete created tables using API endpoints.