{"library":"sqlmesh","type":"library","category":null,"description":"SQLMesh is a next-generation data transformation framework designed to ship data quickly, efficiently, and without error. It enables data teams to run and deploy data transformations written in SQL or Python with visibility and control, supporting concepts like virtual data environments, automated testing, and CI/CD. It is backwards compatible with dbt and focuses on semantic understanding of SQL. The project maintains an active development cycle with frequent releases, with 0.234.0 being the latest stable version.","language":"python","status":"active","version":"0.234.0","tags":["data transformation","ETL","analytics engineering","SQL","Python","data orchestration","data quality","CI/CD","virtual environments","SQL transpilation"],"install":[{"cmd":"pip install sqlmesh","imports":["from sqlmesh import model","from sqlmesh import ExecutionContext","from sqlmesh.core.config import Config","from sqlglot import exp"]},{"cmd":"pip install \"sqlmesh[web]\"","imports":[]},{"cmd":"pip install \"sqlmesh[duckdb]\"","imports":[]}],"homepage":"https://sqlmesh.com/","github":"https://github.com/SQLMesh/sqlmesh","docs":"https://sqlmesh.readthedocs.io/en/stable/","changelog":null,"pypi":"https://pypi.org/project/sqlmesh/","npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"3.10–3.9","success_rate":50,"avg_install_s":21,"avg_import_s":5.13,"wheel_type":"wheel"},"url":"https://checklist.day/v1/registry/sqlmesh/compatibility"},"provenance":{"verified_status":"passing","verified_at":"Sun Jun 28","last_verified":"Sun Jun 28","next_check":"Tue Jul 28","install_tag":null}}