dataparity_diff_tables
Compare two tables across databases to report added, removed, and modified rows, schema differences, a risk verdict, and where changes concentrate.
Instructions
Compare two tables and report what changed. Works across different databases: both sides compute the same canonical row hash, so only hashes are compared, never raw data. Returns added, removed and modified rows, schema differences, a risk verdict, and the segments of data where the changes concentrate.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"left": "<left>",
"right": "<right>",
"left_table": "<left_table>",
"right_table": "<right_table>",
"key_columns": "<key_columns>"
},
"name": "dataparity_diff_tables"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| left | Yes | The left source name. | |
| right | Yes | The right source name. | |
| where | No | A WHERE expression applied to both sides. | |
| format | No | Output format. Defaults to json. | |
| sample | No | Compare only a sample of rows. The result is marked as sampled. | |
| columns | No | Columns to compare. Defaults to every column the two tables share. | |
| left_table | Yes | The table on the left. | |
| key_columns | Yes | Columns used to match rows across the two sides. | |
| max_changes | No | Maximum number of row changes to return. Defaults to 100. | |
| right_table | Yes | The table on the right. | |
| max_attributions | No | Maximum number of attribution segments to return. Defaults to 5. |