A curated list of awesome SQLMesh libraries, tools, and resources.
SQLMesh is a next-generation data transformation framework for shipping data quickly, efficiently, and without error.
All contributions related to SQLMesh are welcome! Please check the contribution guidelines first. Add new entries at the bottom of each category.
- Official Resources
- Sample Projects
- Community Projects
- Tools
- Newsletters
- Blog Posts
- Videos
- Talks
- Contributors
- Contribute
Docs, Slack, and core repositories.
- Official Documentation - Official SQLMesh documentation.
- Slack - Tobiko Slack community; the team is highly responsive.
- SQLMesh Repository - Core SQLMesh source code.
- SQLGlot Repository - Python SQL parser and transpiler used by SQLMesh.
Official examples and community demos to learn from.
- Examples from the main repo - Built-in example projects in the SQLMesh repository.
- Custom Materializations - Example of defining custom materializations.
- Ibis - A Python SQLMesh model with Ibis.
- Multi Repo - Multiple SQLMesh projects.
- Multi dbt - Multiple dbt projects in a single project.
- Multi Hybrid - dbt project alongside SQLMesh in a single project.
- Sushi - Canonical SQLMesh demo project.
- Sushi dbt - Sushi demo implemented with dbt.
- Sushi dlt - Sushi demo with dlt integration.
- Wursthall - Restaurant analytics example project.
- Official Example projects - Additional official SQLMesh example projects.
- sqlmesh-demos - Community demos and walkthroughs for SQLMesh.
End-to-end projects built with SQLMesh.
- arcane-insight - An analytics, ingestion, and transformation project built with SQLMesh and DuckDB on Blizzard's Hearthstone API.
- portable-analytics-stack - End-to-end portable analytics template: dlt ingests NYC Open Data into DuckLake (Postgres catalog + Cloudflare R2), SQLMesh transforms with DuckDB (including Python/Polars models), and GitHub Actions handles CI/CD plus scheduled runs—no warehouse required.
Editors, proxies, integrations, and utilities around SQLMesh.
- vscode-sqlmeshui - Embedded SQLMesh UI in VS Code.
- buenavista - A fork of a Postgres/DuckDB proxy exposing both the PG and Trino protocols with a SQLMesh metric rewriter.
- tff - Fitness functions engine and linter for transformation projects, with a dedicated SQLMesh plugin.
- sqlmesh-openlineage - OpenLineage integration for SQLMesh that emits table and column lineage events.
- datavault4sqlmesh - Automates data vault load patterns with SQLMesh
- acryl-datahub[sqlmesh] - Datahub integration for SQLMesh that ingests project metadata
Newsletters with recurring SQLMesh coverage.
- The Data Toolbox - Yuki’s Substack on modern data tools; several SQLMesh guides and comparisons.
- davidj.substack - David Jayatillake’s Substack; hands-on SQLMesh series covering dbt migration, plan/apply, testing, and ops.
Articles, guides, and write-ups about SQLMesh.
- Unlocking Data Insights with Ibis and SQLMesh - Using Ibis with SQLMesh for analytical workflows.
- SQLMesh for DBT Users 1 - Introduction to SQLMesh for dbt users.
- SQLMesh for DBT Users 2 - Continued guide to SQLMesh for dbt users.
- Efficient Development with the SQLMesh Browser UI - Developing with the SQLMesh browser UI.
- Why SQLMesh Might be The Best dbt Alternative - Comparison of SQLMesh and dbt and when to choose SQLMesh.
- Getting Started with SQLMesh: A Comprehensive Starter Guide - Hands-on walkthrough for getting started with SQLMesh.
- SQLMesh Makes Your Data Validation Easy - Guide to using SQLMesh table diff for data validation.
- A Portable Analytics Stack - Building a portable analytics stack with dlt, SQLMesh, DuckDB, and DuckLake.
- SQLMesh for dummies - Approachable overview of SQLMesh for people curious about the dbt alternative.
- SQLMesh (ssp.sh Second Brain) - Curated notes on SQLMesh concepts, features, history, and comparisons to dbt.
- What if dbt and SQLMesh were weapons - Entertaining 2025 comparison of dbt and SQLMesh as competing transformation tools.
- sqlmesh init -t dbt - Running an existing dbt project with SQLMesh.
- sqlmesh plan - Walkthrough of SQLMesh plan/apply and virtual data environments.
- sqlmesh migrate - Migrating from dbt to SQLMesh in practice.
- SQLMesh in Production - pt1 - Config - Explaining SQLMesh configuration for production use
- SQLMesh in Production - pt2 - Commands - Explaining SQLMesh commands for production use
- SQLMesh in Production - pt3 - CI/CD - Explaining how to setup CI/CD for SQLMesh production use
- SQLMesh in Production - pt4 - Checklist - List of main components needed for SQLMesh production use
- SQLMesh Multi-Engine Data Stack - Running models on Polars and DuckDB while materializing to a shared catalog.
Tutorial and explainer videos about SQLMesh.
- Tobiko Data Youtube - Official Tobiko Data YouTube channel.
- Evolving Data Pipelines at Scale - Talk on evolving data pipelines at scale with SQLMesh.
- Building SQLMesh Macros like dbt macros - How to build SQLMesh macros similar to dbt macros.
- SQLMesh Quickstart Guide - Quickstart walkthrough for SQLMesh.
- Running dbt Jaffle shop in SQLMesh - Running the dbt Jaffle Shop example in SQLMesh.
- A Deep Dive into SQLMesh: Structured Query Validation and Safe Pipeline Testing - Deep dive into SQLMesh validation and safe pipeline testing.
- Exploring SQLmesh - Exploratory overview of SQLMesh.
- Introduction to SQLMesh! How to Use SQLMesh, the dbt Alternative! - Intro guide to using SQLMesh as a dbt alternative.
- dbt Core Vs. SQLMesh for SQL Transformations! - Side-by-side comparison of dbt Core and SQLMesh for SQL transformations.
- How to Get Started with SQLMesh, a dbt Alternative! - Getting-started walkthrough for SQLMesh.
- DBT Costs Too Much? Why SQL Mesh Cuts Data Stack Costs in Half - Cost-focused look at how SQLMesh can reduce data stack spend.
Conference talks, interviews, and fireside chats.
- Beyond dbt: Modern SQL Transformation and Lineage with sqlglot and sqlmesh - Tomas Peluritis on modern SQL transformation and lineage with SQLGlot and SQLMesh.
- SQL Mesh as a DataOps Framework - Talk on using SQLMesh as a DataOps framework.
- Toby Mao - SQLMesh, Simplifying Data Transformations, and more - Toby Mao on SQLMesh and simplifying data transformations.
- Let's Talk SQLMesh With Tobiko Data's Co-Founder, Toby Mao - Full interview with Toby Mao on Data With Josue.
- SQLMesh & SYNQ fireside chat - Fireside chat covering SQLMesh and SYNQ.
Thanks for all the great resources! Can't see your avatar? Check the contribution guidelines on how you can submit your resources to the community!
Contributions welcome! Read the contribution guidelines first.