Skip to content
@SQLAnvil

SQLAnvil

Define your data transformations in SQL. SQLAnvil compiles, versions, and runs them against BigQuery, PostgreSQL, or Supabase.
README.md

SQLAnvil

SQL workflow tool for BigQuery, PostgreSQL, Supabase, and MySQL/MariaDB.

SQLAnvil is an open-source fork of Dataform OSS (Apache 2.0), extended with first-class PostgreSQL, Supabase, and MySQL/MariaDB 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 CONFLICT upserts, btree/gin/gist/brin indexes, tablespaces, fillfactor
  • Supabase — everything Postgres, plus RLS policies, Realtime publications, pgvector indexes, Supabase Wrappers (FDW)
  • MySQL / MariaDB — one adapter validated against both: CTAS tables, ON DUPLICATE KEY UPDATE upserts, the full mysql: {} config block (engine/charset/collation, secondary indexes incl. FULLTEXT/SPATIAL, native partitioning), matview emulation

Repositories

Repo What
sqlanvil The core monorepo — compiler, CLI, and protobuf definitions
agent-skills The sqlanvil-engineering-fundamentals Agent Skill — teaches coding agents the SQLAnvil dialect. Install with npx skills add SQLAnvil/agent-skills
docs Reference docs and design documents, published at sqlanvil.com/docs

Using SQLAnvil with AI agents

SQLAnvil is built to be driven by coding agents (Claude Code, Codex, Cursor, Gemini CLI, and others):

  • agent-skills — the canonical sqlanvil-engineering-fundamentals Agent Skill. One install teaches any supporting agent the SQLAnvil authoring dialect (statement separators, postgres:/mysql: config blocks, ref() discipline, CLI verbs):

    npx skills add SQLAnvil/agent-skills

  • AGENTS.md in every project — sqlanvil init and sqlanvil migrate-dataform scaffold a warehouse-tailored AGENTS.md (plus a CLAUDE.md bridge), so any agent working in the repo knows the dialect with zero setup.

  • llms.txt — the docs site publishes an llms.txt index for agent retrieval.

Links

  • Website — sqlanvil.com
  • Docs — sqlanvil.com/docs
  • Agent Skill — npx skills add SQLAnvil/agent-skills
  • 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.

Popular repositories Loading

  1. sqlanvil sqlanvil Public

    Analytics engineering for Postgres & Supabase — Dataform-style SQL workflows (SQLX, refs, assertions, incremental tables, materialized views).

    TypeScript 1

  2. docs docs Public

    SQLAnvil documentation — reference docs and design documents. Published at sqlanvil.com/docs/

  3. .github .github Public

    SQLAnvil organization profile

  4. supabase-sqlanvil-starter supabase-sqlanvil-starter Public template

    Analytics engineering for Supabase in ~5 min — a ready-to-run SQLAnvil starter (derived tables, incremental rollups, materialized views, assertions, scheduled runs).

  5. vscode-sqlanvil-tools vscode-sqlanvil-tools Public

    Forked from ashish10alex/vscode-dataform-tools

    SQLAnvil Tools - VS Code extension to run and visualise SQLAnvil data pipelines and much more

    TypeScript

  6. agent-skills agent-skills Public

    Agent Skills for SQLAnvil — install with: npx skills add SQLAnvil/agent-skills

Repositories

Showing 6 of 6 repositories

People

This organization has no public members. You must be a member to see who’s a part of this organization.

Top languages

Loading…

Most used topics

Loading…
Developer Program Member