Transformation
Collaboration
Testing
Data Transformation
Built For Growth
Don't hack custom scripts or use half-baked tools. SQLMesh ensures accurate and efficient data pipelines
with the most complete DataOps solution for transformation, testing, and collaboration.
Define With Semantic Understanding
Define With Semantic Understanding
SQLMesh validates your SQL as you write it. Environment-aware
column-level lineage makes it easy to understand the logic behind your tables.
Validate With Zero-Cost Environments
Validate With Zero-Cost Environments
Never rebuild a table again with Virtual Data Environments while
avoiding surprises in production with full end-to-end data previews.
Collaborate Effortlessly
Collaborate Effortlessly
SQLMesh makes it easy to understand your teammate's changes and
their downstream impact with our open source CI/CD bot and Automated Data Contracts.
Deploy Instantly
Deploy Instantly
Enjoy being able to finally promote development tables to
production with built-in data consistency enforcement and automatic data-gap
prevention.
Cutting-edge AI Products
Reliable Core Datasets
Production-grade Pipelines
Trustworthy Dashboards
Cutting-edge AI Products
Reliable Core Datasets
Production-grade Pipelines
Trustworthy Dashboards
Cutting-edge AI Products
Reliable Core Datasets
Production-grade Pipelines
Trustworthy Dashboards
Semantic Understanding
SQLMesh actually understands the SQL you write and improves developer productivity by finding issues
at compile time. Built-in column-level lineage provides a deeper understanding of your data model
and transpilation makes it easy to run your SQL across multiple engines.
Virtual Data Environments
Virtual Data Environments empower your data team to create dynamic representations of your data
while ensuring tables are never built more than once. Unit tests, Audits, and Data Diff provide
validation throughout your development workflow to make it easy to trust the datasets you produce.
Effortless Collaboration
Automated data contracts connect your entire data organization and make it easy to evolve together
without data consistency issues. Open source CI/CD bot tells reviewers exactly what is changed in a
given environment which reduces the overhead to reviewing a change.
Quality Deployments
Have confidence in the data you ship to production by deploying what has been validated and
leveraging SQLMesh's automatic data-gap prevention. Even when mistakes do happen, SQLMesh seamlessly
rolls back to the prior version allowing teams to reduce downtime in production.
SQLMesh UI
SQLMesh comes with a UI. You can develop your SQL, view lineage and dependencies, and manage your
workflows. It's completely free and included in our open source package.

Works With The Tools You Use Today
Extensible at its core, we continue to add integrations. Join our community
to help us shape our roadmap or make a contribution yourself!
Data Warehouse
Data Orchestration
dbt Compatibility
Run your dbt project as-is and unlock the power of SQLMesh: cut cloud bills with virtual data environments, understand pipelines with column-level lineage, collaborate safely with automatic data contracts, and deploy confidently with automated CI/CD.
Resources
Get started
Learn what SQLMesh is and how you can get started quickly.
Documentation
Learn how to use SQLMesh with our documentation.
Community
Interact with the SQLMesh community. Ask questions, suggest
improvements, and be productive.