sql-server-table-reconciliation
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.
Profile →npx skills add github/awesome-copilot --skill sql-server-table-reconciliation --agent copilot
Same command for any agent — swap --agent for claude-code, codex, cursor.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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. | | Columns to compare | All | Subse
- Workflow
- Collect Inputs
- Bundled Script
- Optional arguments
- Example invocations
- Prerequisites
- Comparison Rules
- Hash-Based Optimization (for large tables)
- Report Format
- Performance Considerations
- Constraints
python scripts/reconcile.py \ pip install mssql-python pyarrow pandas
What does the sql-server-table-reconciliation skill do?
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.
How do I install it?
Run `npx skills add github/awesome-copilot --skill sql-server-table-reconciliation --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From github/awesome-copilot, a repository with 37,432 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.