{"id":"4329f7cc-9286-4425-91ba-a2ac09f5887c","shortId":"aeYZ6t","kind":"skill","title":"Plan and preview warehouse SQL model changes before rollout with SQLMesh","tagline":"Compare SQL model changes, preview backfills and downstream impact, and stage safer warehouse rollouts before execution.","description":"# Plan and preview warehouse SQL model changes before rollout with SQLMesh\n\nCompare SQL model changes, preview backfills and downstream impact, and stage safer warehouse rollouts before execution.\n\n## Prerequisites\n\nPython 3.9+, pip, SQLMesh, warehouse connection\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- pip install 'sqlmesh[lsp]' # install the sqlmesh package with extensions to work with VSCode\n\nRequirements and caveats from upstream:\n- SQLMesh is a next-generation data transformation framework designed to ship data quickly, efficiently, and without error. Data teams can run and deploy data transformations written in SQL or Python with visibility and...\n- python -m venv .venv\n- Note: You may need to run python3 or pip3 instead of python or pip, depending on your python installation.\n\nBasic usage or getting-started notes:\n- # run the unit test\n- 'new_column' AS new_column, /* non-breaking change example */\n- Track what data’s been modified and run only the necessary transformations for [incremental models](https://tobikodata.com/correctly-loading-incremental-data-at-scale.html)\n\n- Source: https://github.com/SQLMesh/sqlmesh\n- Extracted from upstream docs: https://raw.githubusercontent.com/SQLMesh/sqlmesh/HEAD/README.md\n\n## Documentation\n\n- https://sqlmesh.readthedocs.io/\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/plan-and-preview-warehouse-sql-model-changes-before-rollout-with-sqlmesh/)","tags":["plan","and","preview","warehouse","sql","model","changes","before","rollout","with","sqlmesh","skills"],"capabilities":["skill","source-agentskillexchange","skill-plan-and-preview-warehouse-sql-model-changes-before-rollout-with-sqlmesh","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/plan-and-preview-warehouse-sql-model-changes-before-rollout-with-sqlmesh","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,488 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:11:44.705Z","embedding":null,"createdAt":"2026-05-18T13:18:22.015Z","updatedAt":"2026-05-18T19:11:44.705Z","lastSeenAt":"2026-05-18T19:11:44.705Z","tsv":"'/correctly-loading-incremental-data-at-scale.html)':188 '/skills/plan-and-preview-warehouse-sql-model-changes-before-rollout-with-sqlmesh/)':208 '/sqlmesh/sqlmesh':192 '/sqlmesh/sqlmesh/head/readme.md':199 '3.9':57 'agent':203 'agentskillexchange.com':207 'agentskillexchange.com/skills/plan-and-preview-warehouse-sql-model-changes-before-rollout-with-sqlmesh/)':206 'backfil':17,44 'basic':150 'break':168 'caveat':90 'chang':7,15,34,42,169 'column':162,165 'compar':12,39 'connect':61 'data':99,105,111,117,173 'depend':145 'deploy':116 'design':102 'doc':196 'document':200 'downstream':19,46 'effici':107 'environ':73 'error':110 'exampl':170 'exchang':205 'execut':27,54 'extens':83 'extract':193 'framework':101 'generat':98 'get':154 'getting-start':153 'github.com':191 'github.com/sqlmesh/sqlmesh':190 'impact':20,47 'increment':184 'instal':62,66,75,78,149 'instead':140 'lsp':77 'm':128 'match':71 'may':133 'model':6,14,33,41,185 'modifi':176 'necessari':181 'need':134 'new':161,164 'next':97 'next-gener':96 'non':167 'non-break':166 'note':131,156 'packag':81 'path':69 'pip':58,74,144 'pip3':139 'plan':1,28 'prerequisit':55 'preview':3,16,30,43 'python':56,123,127,142,148 'python3':137 'quick':106 'raw.githubusercontent.com':198 'raw.githubusercontent.com/sqlmesh/sqlmesh/head/readme.md':197 'requir':88 'rollout':9,25,36,52 'run':114,136,157,178 'safer':23,50 'setup':68 'ship':104 'skill':204 'skill-plan-and-preview-warehouse-sql-model-changes-before-rollout-with-sqlmesh' 'sourc':189,202 'source-agentskillexchange' 'sql':5,13,32,40,121 'sqlmesh':11,38,59,76,80,93 'sqlmesh.readthedocs.io':201 'stage':22,49 'start':155 'team':112 'test':160 'tobikodata.com':187 'tobikodata.com/correctly-loading-incremental-data-at-scale.html)':186 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'track':171 'transform':100,118,182 'unit':159 'upstream':65,92,195 'usag':151 'use':63 'venv':129,130 'visibl':125 'vscode':87 'warehous':4,24,31,51,60 'without':109 'work':85 'written':119","prices":[{"id":"bf1b7275-3b2d-45b8-ac8d-12d992168787","listingId":"4329f7cc-9286-4425-91ba-a2ac09f5887c","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:18:22.015Z"}],"sources":[{"listingId":"4329f7cc-9286-4425-91ba-a2ac09f5887c","source":"github","sourceId":"agentskillexchange/skills/plan-and-preview-warehouse-sql-model-changes-before-rollout-with-sqlmesh","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/plan-and-preview-warehouse-sql-model-changes-before-rollout-with-sqlmesh","isPrimary":false,"firstSeenAt":"2026-05-18T13:18:22.015Z","lastSeenAt":"2026-05-18T19:11:44.705Z"}],"details":{"listingId":"4329f7cc-9286-4425-91ba-a2ac09f5887c","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"plan-and-preview-warehouse-sql-model-changes-before-rollout-with-sqlmesh","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"e5d5284893d2968f111f6607ec45cbdc3ba997aa","skill_md_path":"skills/plan-and-preview-warehouse-sql-model-changes-before-rollout-with-sqlmesh/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/plan-and-preview-warehouse-sql-model-changes-before-rollout-with-sqlmesh"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"Plan and preview warehouse SQL model changes before rollout with SQLMesh","description":"Compare SQL model changes, preview backfills and downstream impact, and stage safer warehouse rollouts before execution."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/plan-and-preview-warehouse-sql-model-changes-before-rollout-with-sqlmesh"},"updatedAt":"2026-05-18T19:11:44.705Z"}}