SQL workflow tool for BigQuery, PostgreSQL, and Supabase.
SQLAnvil is an open-source fork of Dataform OSS (Apache 2.0), extended with first-class PostgreSQL and Supabase support. Define your data transformations in SQLX, have SQLAnvil compile them to idiomatic SQL, and run them against your warehouse — all from the CLI.
- BigQuery — partitioning, clustering, labels, materialized views,
MERGE-based incremental upserts - PostgreSQL — idiomatic DDL: native partitioning,
INSERT ... ON CONFLICTupserts, btree/gin/gist/brin indexes, tablespaces, fillfactor - Supabase — RLS policies, Realtime publications, pgvector indexes, Supabase Wrappers (coming soon)
| Repo | What |
|---|---|
| sqlanvil | The core monorepo — compiler, CLI, and protobuf definitions |
| docs | Reference docs and design documents, published at sqlanvil.com/docs |
- Website — sqlanvil.com
- Docs — sqlanvil.com/docs
- Contributing — fork-and-PR; see each repo's
contributing.md
SQLAnvil is not affiliated with or endorsed by Google. "Dataform" is a trademark of Google LLC. SQLAnvil is licensed under the Apache License 2.0.