compare_schemas
Compare database schemas between two SQL Server databases to identify differences in tables, columns, and indexes. Pinpoint schema drift for dev vs prod alignment.
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 |
|---|---|---|---|
| schema | No | Schema filter (default: compare all schemas) | |
| server | No | Target server name (uses default if omitted) | |
| source_database | Yes | Source database name (e.g. 'DevDB') | |
| target_database | Yes | Target database name (e.g. 'ProdDB') |