sql-server-table-reconciliation SKILL.md skillA
sql-server-table-reconciliation from okhp3/skillz is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add okhp3/skillz/sql-server-table-reconciliation@git:20261022.733ef20Pins git:20261022.733ef20 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- okhp3/skillz
- Path
community/sql-server-table-reconciliation/SKILL.md- Versions recorded
- 3
- Latest version
- git:20261022.733ef20, committed Oct 22, 2026
- First version recorded
- Aug 28, 2026
- Size
- 7,232 bytes
- Repository stars
- 3
- License
- MIT
Use when: comparing SQL Server tables across instances, data migration validation, ETL verification, row mismatch detection, schema drift, reconciliation report, production vs staging comparison. Uses mssql-python driver with Apache Arrow for fast columnar data transfer and comparison.
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
# SQL Server Table Reconciliation Compare identical tables across two SQL Server instances using Python with `mssql-python` driver and Apache Arrow. Detect missing rows, column mismatches, schema drift, and produce a reconciliation report. ## Workflow 1. Collect connection details for source and target 2. Identify primary key / composite key 3. Detect schema differences 4. Extract data via Arrow for efficient columnar transfer 5. Compare rows and columns 6. Generate reconciliation report ## Collect Inputs | Parameter | Required | Description | |-----------|----------|-------------| | Source server | Yes | Source SQL Server (e.g. `prod-server.database.windows.net`) | | Source database | Yes | Source database name | | Target server | Yes | Target SQL Server (e.g. `staging-server.database.windows.net`) | | Target database | Yes | Target database name | | Tables | Yes | Comma-separated `schema.table` names, or `schema.*` wildcard (e.g. `dbo.Orders,dbo.Items` or `dbo.*`) | | Auth mode | Yes | `sql` (user/password) or `entra` (Azure AD/token) | | Primary key | Auto-detect | Column(s) forming the row identity. Auto-detect from metadata if not provided. | …
Read the whole file at its exact version.
How to install
mdr add okhp3/skillz/sql-server-table-reconciliation@sha256:aa00fe049b5ecddbThe line at the top of this page pins the label git:20261022.733ef20, 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.
[](https://markdownregistry.com/a/art_gitvkvvaqay4kbfv)
4 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 3 versions of this file, between Aug 28, 2026 and Oct 22, 2026, about one every 27 days.
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| git:20261022.733ef20 latest | 2026-10-22 | 733ef20 | 7,232 B | A | view · diff |
| git:20261022.7ccba36 | 2026-10-22 | 7ccba36 | 6,191 B | A | view · diff |
| git:20260828.866dec6 | 2026-08-28 | 866dec6 | 5,811 B | A | view |
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (7232 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
okhp3/skillz · 3 stars · license MIT · pushed 2026-11-06 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_gitvkvvaqay4kbfv GET https://markdownregistry.com/api/v1/resolve?ref=okhp3/skillz/sql-server-table-reconciliation GET https://markdownregistry.com/api/v1/blob/aa00fe049b5ecddbee6659e384906514e50643423607b05f49634b633c8563d1
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.