sqlmesh
Next-generation data transformation framework
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Python 3.9 or later.
- A data warehouse or local database (DuckDB, Postgres, etc.) is needed as the execution backend.
- Low install friction with a pure Python wheel.
License · maintenance · safety
permissive license (permissive) — 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.
last release 2026-07-24 (21 days) · last repo commit 2026-08-12 · 3,243 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 621,043 downloads/mo, #5,721 on PyPI
Alternatives
Verify before relying
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- 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.
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 on this page. Verify before relying on it.
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
sqlmesh on PyPI
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.
Requires Python 3.9 or later. A data warehouse or local database (DuckDB, Postgres, etc.) is needed as the execution backend.
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 applyingVerify 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 | permissive license permissive |
| Python support | Supports the current Python release >=3.9 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 20 packagesclickcroniterduckdbdateparserhumanizehyperscriptimportlib-metadataipywidgetsjinja2packagingpandaspydanticpython-dotenvrequestsrichruamel.yamlsqlglottenacitytime-machinejson-stream |
| Maintenance | Actively maintained 21 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 621,043 / month, #5,721 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Intended Audience :: DevelopersIntended Audience :: Science/ResearchLicense :: OSI Approved :: Apache Software LicenseOperating System :: OS IndependentProgramming Language :: Python :: 3 :: OnlyProgramming Language :: SQL |
Evidence: sqlmesh-0.236.1-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “dbt alternative”
- sqlmeshSQLMesh is a data transformation framework that lets you write, test,…
- prefect-dbtPrefect integration that orchestrates dbt workflows, allowing you to…
- astronomer-cosmosRenders dbt Core projects as Apache Airflow DAGs and Task Groups,…
Give your agent the search over MCP, or paste the wish link into any chat.
More Database packages
psycopg2-binary is a PostgreSQL database adapter for Python that implements the DB API 2.0 specification, enabling Python applications to connect to and query PostgreSQL databases with thread-safe concurrent operations.
Python client library for connecting to and executing commands against Redis key-value stores, supporting both synchronous and asynchronous operations.
Install it if your application needs to interact with Redis; the only prerequisite is a running Redis server instance.
YDB Python SDK is the official client library for connecting to and querying YDB databases from Python applications.
Install it if you need to connect Python applications to YDB databases.
Connects Python applications to Snowflake data warehouses using the DB API 2.0 specification, enabling SQL queries, data transfers, and warehouse operations.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
Provides base adapter protocols and shared functionality that database adapters use to integrate with dbt-core, handling connections, dialect translation, relation caching, and core interface management.
See also dbt-core · dbt-postgres · dbt-bigquery · dbt-databricks · dbt-redshift · sqlglot · dbt · dbt-spark · dbt-sqlserver · datacontract-cli