---
id: sqlmesh
version: "0.236.1"
license: Apache License Version 2.0, January 2004 http://www.apache.org/licenses/ TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION 1. Definitions. "License" shall mean the terms and conditions for… (full text in the JSON record)
license_treatment: permissive
maintenance: active
---

# sqlmesh — Next-generation data transformation framework

License: permissive · Maintenance: active · Downloads: 621.0K/mo

## What it is and what it does

SQLMesh is a data transformation framework that combines SQL and Python to define, test, and deploy data pipelines. It sits between raw data and analytics, letting you write transformations in SQL (with automatic dialect transpilation) or Python, then execute them against your data warehouse or local database. The framework tracks which tables have changed and runs only the necessary transformations, avoiding redundant computation.

The package includes built-in testing (unit tests and data audits), virtual development environments for isolated testing without warehouse costs, and a plan/apply workflow similar to Terraform for previewing changes before deployment. It provides column-level lineage tracking, incremental model support, and CLI tools for initialization, testing, and deployment. With 20 runtime dependencies including pandas, sqlglot, duckdb, and jinja2, it integrates with common data tools and supports multiple SQL dialects.

Use it for:

- Build and test SQL transformations locally before deploying to production data warehouses.
- Run incremental data loads that only process new or modified records, reducing compute costs.
- Create isolated development environments to test schema changes without affecting production data.
- Write data quality audits and unit tests for transformation logic before running in the warehouse.
- Migrate SQL code between different database dialects (e.g., Postgres to Snowflake) with automatic transpilation.
- Track and visualize data lineage to understand which tables depend on which transformations.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

SQLMesh is a data transformation framework that lets you write, test, and deploy SQL or Python transformations with built-in change tracking, incremental processing, and virtual development environments.

Yes. SQLMesh is actively maintained, has low install friction, carries a permissive Apache 2.0 license, and addresses a real need in data engineering workflows. It is suitable for teams building data pipelines who want testing, change tracking, and multi-dialect support built in. Start with a small project to evaluate whether its workflow and feature set fit your warehouse and team practices.

## Install

pip install sqlmesh
uv add sqlmesh
poetry add sqlmesh

## Installing sqlmesh

Before you install: Low install friction with a pure Python wheel. Active maintenance with a recent release (21 days ago) and steady repository activity. The package has 20 runtime dependencies including pandas, sqlglot, and duckdb, which are well-established libraries.

License in practice: Licensed under Apache License 2.0, a permissive open-source license. You can use, modify, and distribute SQLMesh freely in commercial and private projects, provided you include a copy of the license and document any changes you make.

Quickstart:

pip install 'sqlmesh[lsp]'
sqlmesh init
# Follow prompts to create a project (e.g., choose DuckDB)
sqlmesh test  # Run unit tests
sqlmesh plan  # Preview changes before applying

Requires Python 3.9 or later. A data warehouse or local database (DuckDB, Postgres, etc.) is needed as the execution backend.

Verify before relying:

- Whether the package supports all major SQL dialects claimed in the description or if some require additional configuration.
- Performance characteristics and scalability limits for large transformation DAGs.
- Community adoption and ecosystem maturity relative to established alternatives.

## Package facts

- License: Apache License Version 2.0, January 2004 http://www.apache.org/licenses/ TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION 1. Definitions. "License" shall mean the terms and conditions for… (full text in the JSON record) (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 621.0K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

SQL data transformation framework, dbt alternative, incremental data pipeline, data warehouse CI/CD, SQL model testing, virtual data environments, data lineage tracking, data-transformation, sql-framework, etl-pipeline

[View on SkillFed](https://skillfed.io/packages/sqlmesh) · [View on PyPI](https://pypi.org/project/sqlmesh/)