Agent skill · data analytics · github
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.
Why this skill is useful
Adds an executable script for SQL Server table reconciliation that automates data validation and schema comparison across instances.
What it needs
Requires mssql-python, pandas, pyarrow installed locally. About 3k tokens when loaded. Last updated 2026-08-07. 37,534 stars on the source repository.
What this skill does
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 Subset of columns, or all non-PK columns Chunk size 100000 Rows per batch for large tables Output format console console, csv, parquet, or json Bundled Script The reconciliation logic is provided as a standalone script at scripts/reconcile.py. Invoke it with the appropriate arguments based on user inputs: Optional arguments Argument Description ---------- ------------- --primary-key Comma-separated PK column(s). Omit to auto-detect. --columns Comma-separated columns to compare. Omit to compare all non-PK columns. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills github/sql-server-table-reconciliation