SQLMesh

When to Use

Activate this skill when the task involves:

• Writing SQLMesh models (FULL, incremental, SCD, seeds, views)
• Understanding the plan/apply workflow and virtual environments
• Migrating from dbt to SQLMesh
• Setting up SQLMesh CI/CD pipelines
• Writing audits and unit tests for SQLMesh models
• Configuring adapters (DuckDB, Spark, Trino, PostgreSQL, BigQuery)
• Diagnosing breaking vs. non-breaking changes

Core Concepts