compare_schemas
Compare schemas between two SQL Server databases to identify differences in tables, columns, and indexes, supporting dev vs prod analysis.
Instructions
Compare schemas between two databases — shows tables, columns, and indexes that differ (useful for dev vs prod comparison)
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_database": "<source_database>",
"target_database": "<target_database>"
},
"name": "compare_schemas"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| source_database | Yes | Source database name (e.g. 'DevDB') | |
| target_database | Yes | Target database name (e.g. 'ProdDB') | |
| schema | No | Schema filter (default: compare all schemas) | |
| server | No | Target server name (uses default if omitted) |