table_diff
Compare two tables or environments and return structured schema/row differences.
Instructions
Compare two tables or environments and return structured schema/row differences.
When comparing environments, pass select_models to choose the models to compare. SQLMesh's console output is suppressed because MCP clients receive the JSON result.
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": {
"source": "<source>",
"target": "<target>"
},
"name": "table_diff"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| on | No | ||
| limit | No | ||
| where | No | ||
| source | Yes | ||
| target | Yes | ||
| skip_columns | No | ||
| select_models | No |