# SQLMesh/sqlmesh

Scalable and efficient data transformation framework - backwards compatible with dbt.

Repository: https://github.com/SQLMesh/sqlmesh
Canonical: https://ross.abutalabs.com/products/sqlmesh
Homepage: https://sqlmesh.readthedocs.io/en/stable/
Language: Python
License: Apache-2.0
License Family: permissive
Topics: dataops, elt, etl, sql, python, dataengineering, transformation, dbt
Last push: 2026-08-25T06:07:57+00:00

## Health v2 (maintenance only)
Score: 93/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 99, release rhythm 82, longevity 100
- inputs: {"age_days": 1440, "days_push": 8, "days_rel": 40, "gap_med": 1.0, "n_releases_24m": 261}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 3256, forks 439 (observed 2026-08-28T04:07:52.318659+00:00)

## What it is
SQLMesh is a scalable data transformation framework for running and deploying SQL or Python data models, backward compatible with dbt. It provides Terraform-style plan/apply workflows, virtual data environments, unit testing, and CI/CD integration for data pipelines.

## Use cases
- transform data in a warehouse with SQL models
- migrate from dbt without rewriting projects
- create isolated dev environments without warehouse costs
- unit test SQL transformations
- run blue-green deployments for data pipelines
- preview impact of model changes before applying

## When to choose
- you want a dbt-compatible transformation tool with lower compute costs
- you need plan/apply change management for data models
- you want built-in unit testing and data audits
- your team writes transformations in SQL or Python

## When to avoid
- you need a full orchestration scheduler like Airflow
- your stack is entirely non-SQL/non-Python
- you only need simple one-off ETL scripts

## Facets
- artifact type: framework
- maturity: active
- function: etl, workflow-automation, testing, ci-cd, cli
- domain: analytics, developer-tools, databases
- platform: python, cli, cross-platform
- tags: dbt-compatible, data-transformation, sql-models, dataops, virtual-environments, elt, data-engineering

## Member repositories
- SQLMesh/sqlmesh (main) score 93

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:07:52.318659+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T07:23:15.613882+00:00, confidence not recorded.
  - readme: https://github.com/SQLMesh/sqlmesh (fetched 2026-08-28T04:07:52.318659+00:00, sha e5d6257d17b0)
- Data as of 2026-08-30T08:39:29.467469+00:00.