SQLMesh

Open source

A data transformation framework for SQL and Python that previews the impact of changes, using virtual environments and a plan and apply workflow.

sqlmesh.readthedocs.io
SQLMesh homepage screenshot
GitHub stars
3.3k
Last 30 days
+32(+1%)
Last commit
yesterday
Repository age
4 years
Version
v0.236.4
Licence
Apache-2.0
Self-hosted
Yes

About SQLMesh

SQLMesh is a data transformation framework for running and deploying transformations written in SQL or Python. The documentation says it is meant to ship data quickly and without error, and positions it as more than a dbt alternative. It can be driven from a CLI, a notebook or a browser UI.

Changes go through a plan and apply workflow compared to Terraform, so the impact of an edit is visible before it runs, and instant SQL impact analysis is available in the CLI and in plan mode. Virtual Data Environments give developers isolated environments without data warehouse costs, and a CI/CD bot supports blue-green deployments.

The docs list many execution engines, including BigQuery, Snowflake, Databricks, DuckDB, Postgres, Redshift, Spark and Trino, and integrations with dbt, dlt and GitHub Actions. Unit tests can be generated as YAML files in a tests folder. A separate product, Tobiko Cloud, has its own documentation section.

Key features

  • Models written in SQL or Python
  • Plan and apply workflow like Terraform
  • Isolated development environments without warehouse cost
  • Instant SQL impact analysis in CLI or plan mode
  • CI/CD bot for blue-green deployments
  • Generated unit test files

Good fit for

  • Deploying SQL and Python data models
  • Previewing change impact before release
  • CI/CD for data pipelines
Built with
Python tools
Tags
sql
data engineering
data transformation
python
dbt alternative
ci/cd
data warehouse

SQLMesh: questions and answers

What is SQLMesh used for?
SQLMesh is a data transformation framework for SQL and Python that previews the impact of changes, using virtual environments and a plan and apply workflow. It is a good fit for deploying SQL and Python data models, previewing change impact before release, and CI/CD for data pipelines.
Is SQLMesh open source?
Yes. SQLMesh is open source under the Apache-2.0 licence. Its source code is on GitHub at SQLMesh/sqlmesh and is written mainly in Python.
Is SQLMesh free?
Yes. SQLMesh is open source, so the software itself is free to use.
Can I self-host SQLMesh?
Yes. SQLMesh can be self-hosted on your own server or infrastructure.
What are some alternatives to SQLMesh?
Similar open-source tools in the Data Pipelines & ETL category include Mage AI, MetricFlow and Bruin. SaaS products in the same category include Portable, Qubole and Y42.
Is SQLMesh actively maintained?
Yes. The most recent commit to SQLMesh was on 12 November 2026, and the latest release is v0.236.4, published on 22 October 2026. The project has 3.3k stars on GitHub, with 32 added in the last 30 days.

Open-source alternatives to SQLMesh

See all

SaaS alternatives to SQLMesh

See all