SQLMesh/sqlmesh

Health v2 · maintenance only

Adoption not part of the score

3256 stars · 439 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

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

framework · maturity active

etl workflow-automation testing ci-cd cli analytics developer-tools databases python cli cross-platform dbt-compatible data-transformation sql-models dataops virtual-environments elt data-engineering

Member repositories

For agents

markdown · JSON · MCP: product_card(name="SQLMesh/sqlmesh")