Integrate a second Postgres database
Operational data lives in Supabase, but a separate PostgreSQL database holds data that needs to be merged in. SQLAnvil orchestrates cross-database joins and writes the unified result back into Supabase schemas.
SQLAnvil
Define your data transformations in SQL. SQLAnvil compiles, versions, and runs them against BigQuery, PostgreSQL, or Supabase.
Use cases
Section titled “Use cases”Enrich Supabase with BigQuery public data
Join Supabase operational tables against public datasets in BigQuery — ZIP code demographics, postal boundaries, currency rates — and sync the enriched rows back into Supabase for use in your app.
ML training data pipeline
Curate, clean, and version training datasets directly in Supabase using SQLX views and incremental tables. Downstream ML pipelines read from stable, tested data models instead of raw tables.
BigQuery reporting warehouse
Pull data from multiple sources — Supabase, Postgres, external APIs — into a curated BigQuery warehouse. SQLAnvil models, tests, and refreshes the reporting layer on a schedule.
eCommerce product feed for Google Ads
Transform your eCommerce catalog in Supabase or Postgres into a clean, structured dataset and export it as JSON for Google Ads product feeds — with assertions to catch missing prices or broken image URLs before they go live.
What Dataform doesn’t do
Section titled “What Dataform doesn’t do”No Supabase or Postgres support. Dataform OSS dropped non-BigQuery adapters. If your data isn’t in BigQuery, it can’t help you.
Google-centric by design. Dataform’s open-source version exists to serve Google Cloud workflows. Features, roadmap, and documentation all assume BigQuery — everything else is out of scope.
SQLAnvil cares about your data, wherever it lives.
What SQLAnvil does
Section titled “What SQLAnvil does”BigQuery
Full support for BigQuery — partitioning, clustering, labels, materialized views, incremental upserts via MERGE.
PostgreSQL
Idiomatic Postgres DDL — native partitioning, INSERT … ON CONFLICT upserts, btree/gin/gist indexes, tablespaces.
Supabase
Extends Postgres with RLS policies, Realtime publications, pgvector indexes, and Supabase Wrappers (FDW).
SQLX + YAML + JS
Write SQL with config blocks, use actions.yaml for bulk definitions, or drive everything via the JavaScript API.
SQLAnvil is an open-source fork of Dataform OSS (Apache 2.0), extended with first-class PostgreSQL and Supabase support. It is not affiliated with or endorsed by Google.