mssql-to-snowflake-dbt-migration SKILL.md skillA

mssql-to-snowflake-dbt-migration from altimateai/data-engineering-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add altimateai/data-engineering-skills/mssql-to-snowflake-dbt-migration@git:20261027.d6a2faa

Pins git:20261027.d6a2faa in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
altimateai/data-engineering-skills
Path
skills/dbt/mssql-to-snowflake-dbt-migration/SKILL.md
Versions recorded
1
Latest version
git:20261027.d6a2faa, committed Oct 27, 2026
Size
24,953 bytes
Repository stars
135
License
MIT

Convert MS SQL Server source code (stored procs, views, T-SQL scripts) into dbt models targeting Snowflake, with build-first-then-parity, isolated-schema deployment, and a migration dashboard. Use when: (1) User says "migrate this T-SQL to dbt on Snowflake", "convert these stored procs end-to-end", "move <schema> from SQL Server to Snowflake" (2) Source lives in a repo as `.sql` dumps OR behind a reachable MS SQL connection, AND source rows are available in Snowflake for parity…

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# mssql-to-snowflake-dbt-migration

**Pick architecture → inventory source → convert → confirm → build to isolated schema → parity → verify → dashboard.**

## When NOT to use this skill

- Source is PostgreSQL / MySQL / Oracle / BigQuery (not T-SQL) → `migrating-sql-to-dbt`.
- Target is not Snowflake → `migrating-sql-to-dbt` + the appropriate warehouse skills.
- Just one T-SQL snippet with no isolated-deploy or parity requirement → `migrating-sql-to-dbt`.
- Enhancing an existing dbt model → `dbt-model-enhancement`.

## Prerequisites

```bash
command -v altimate-code     # strongly preferred — carries MS SQL + Snowflake adapters and data-parity
command -v dbt               # required for the deploy phase
command -v git               # required
```

Must have:
- A dbt project configured for Snowflake (`dbt_project.yml` + a working
  `profiles.yml` or env-var profile).
- A Snowflake role with `CREATE SCHEMA` on the target database and
  `USAGE` on a warehouse. The skill writes to an **isolated schema**,
  not prod.
- **A dedicated migration target in `profiles.yml` with a `schema:`
  override** (see Phase 5 Method 1). The skill refuses to deploy without
…

Read the whole file at its exact version.

How to install

No tool to install first
claude plugin marketplace add https://markdownregistry.com/mp/a/art_cpfm3omv35xvqjoj/0e123e47bd5479d32c0e6e50e9cf040185c18431a4072d8b83bad60d8894a344.json

Then /plugin install mssql-to-snowflake-dbt-migration@markdownregistry-cpfm3omv35xvqjoj in Claude Code. It installs git:20261027.d6a2faa, the one graded A here, pinned to the commit it was graded at, and leaves it there.

The exact contents, by fingerprint
mdr add altimateai/data-engineering-skills/mssql-to-snowflake-dbt-migration@sha256:0e123e47bd5479d3

The line at the top of this page pins the label git:20261027.d6a2faa, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_cpfm3omv35xvqjoj.svg)](https://markdownregistry.com/a/art_cpfm3omv35xvqjoj)

2 badge image fetches in 30 days. What the badge shows.

Ask from your agent
claude mcp add --transport http markdownregistry https://markdownregistry.com/mcp/registry

Then ask it: what changed in altimateai/data-engineering-skills/mssql-to-snowflake-dbt-migration since the version I have? It reads every saved version here, no key and no account. Any agent that speaks MCP can add it.

Got a copy of mssql-to-snowflake-dbt-migration from somewhere else? Ask it: where did my mssql-to-snowflake-dbt-migration come from, and what was changed? It names the public original, the version yours is closest to and every changed line. The text is not kept.

Versions

The registry has recorded 1 version of this file, committed on Oct 27, 2026.

Watch this file (sign in, one email per new version)

versioncommittedcommitsizeaudit
git:20261027.d6a2faa latest2026-10-27 d6a2faa 24,953 BA view
Keep it current by itself, install once

Committed this skill to a repository? Install the markdownregistry skill updates app on it, or on all of them. When the registry saves a newer version, a pull request brings your copy to it within minutes, the newest version first, then what changed and any check it newly trips. A copy you edited is never touched, and nothing is deleted.

Install on GitHub

It asks to read and write contents and pull requests, and to read metadata. No workflow file, no Actions setting, nothing runs on your runners. Uninstall it and everything the registry kept about your repository is deleted.

Keep it current by itself

Committed this skill to a repository? Add one workflow file, and when a newer version is saved, a pull request brings your copy to it, the newest version first, then what changed and any check it newly trips. A copy you edited is never touched, and nothing is deleted.

mkdir -p .github/workflows && curl -fsSL https://markdownregistry.com/ci/skill-updates.yml -o .github/workflows/skill-updates.yml

It runs daily on GitHub Actions, no key and no account. Read the workflow before you add it.

Check a whole project

From the root of your project, one line hashes each installed skill's SKILL.md, your AGENTS.md and your CLAUDE.md, and asks the registry once. Only the fingerprints and paths are sent.

sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --data-binary @- https://markdownregistry.com/api/v1/check-copies

In CI, add --fail-with-body: the answer is 409 when any file is behind, so the step fails and still prints which files.

sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --fail-with-body --data-binary @- https://markdownregistry.com/api/v1/check-copies

No sha256sum on your machine? shasum -a 256 prints the same lines.

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (24953 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

altimateai/data-engineering-skills · 135 stars · license MIT · pushed 2026-10-27 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_cpfm3omv35xvqjoj
GET https://markdownregistry.com/api/v1/resolve?ref=altimateai/data-engineering-skills/mssql-to-snowflake-dbt-migration
GET https://markdownregistry.com/api/v1/blob/0e123e47bd5479d32c0e6e50e9cf040185c18431a4072d8b83bad60d8894a344

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from altimateai/data-engineering-skills

data-engineering-skills Plugin marketplace
altimateai/data-engineering-skills · .claude-plugin/marketplace.json · Skills for data engineering workflows (4 plugins: dbt-skills, snowflake-skills, databricks-skills and more)
v1.0.0 · audit A · 135 stars
altimate-code SKILL.md skill
altimateai/data-engineering-skills · skills/altimate-code/SKILL.md · Delegates dbt and warehouse work to altimate-code, a specialized CLI agent with 100+ purpose-built data tools. USE THIS…
git:20260615.a13847e · audit A · 135 stars
optimizing-databricks-sql SKILL.md skill
altimateai/data-engineering-skills · skills/databricks/optimizing-databricks-sql/SKILL.md · Analyze DBSQL queries, including SQL embedded in notebooks (`spark.sql(...)`, `%sql` cells), for anti-patterns, lint…
git:20260925.705c68b · audit A · 135 stars
creating-dbt-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/creating-dbt-models/SKILL.md · Creates dbt models following project conventions. Use when working with dbt models for: (1) Creating new models (any…
git:20260121.476f750 · audit A · 135 stars
dbt-model-enhancement SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/dbt-model-enhancement/SKILL.md · Scoped enhancement of ONE existing dbt model from a ticket, with a validated PR as the deliverable. Use when: (1) User…
git:20261027.d6a2faa · audit A · 135 stars
debugging-dbt-errors SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/debugging-dbt-errors/SKILL.md · Debugs and fixes dbt errors systematically. Use when working with dbt errors for: (1) Task mentions "fix", "error"…
git:20260121.476f750 · audit A · 135 stars
developing-incremental-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/developing-incremental-models/SKILL.md · Develops and troubleshoots dbt incremental models. Use when working with incremental materialization for: (1) Creating…
git:20260206.c45120a · audit A · 135 stars
documenting-dbt-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/documenting-dbt-models/SKILL.md · Documents dbt models and columns in schema.yml. Use when working with dbt documentation for: (1) Adding model…
git:20260121.476f750 · audit A · 135 stars
migrating-sql-to-dbt SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/migrating-sql-to-dbt/SKILL.md · Converts legacy SQL to modular dbt models. Use when migrating SQL to dbt for: (1) Converting stored procedures, views…
git:20260121.476f750 · audit A · 135 stars
refactoring-dbt-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/refactoring-dbt-models/SKILL.md · Safely refactors dbt models with downstream impact analysis. Use when restructuring dbt models for: (1) Task mentions…
git:20260121.476f750 · audit A · 135 stars
testing-dbt-models SKILL.md skill
altimateai/data-engineering-skills · skills/dbt/testing-dbt-models/SKILL.md · Adds schema tests and data quality validation to dbt models. Use when working with dbt tests for: (1) Adding or…
git:20260121.476f750 · audit A · 135 stars
end-to-end-snowflake-pipeline SKILL.md skill
altimateai/data-engineering-skills · skills/snowflake/end-to-end-snowflake-pipeline/SKILL.md · Build an end-to-end Snowflake pipeline — ticket → dbt models + orchestration DAG → PR → self-review → ticket comment…
git:20261027.d6a2faa · audit A · 135 stars

Every file in altimateai/data-engineering-skills

Browse by kind, by grade A, or by owner.