whodb_diff
Read-onlyIdempotent
Detect schema differences between two database connections, such as staging and production, by comparing storage units, columns, and relationships.
Instructions
Compare schema metadata between two database connections.
Best for: Spotting drift between environments; comparing staging vs production; reviewing storage-unit, column, and relationship changes. Not recommended for: Row-level data comparison. Common mistakes: Forgetting to specify both connections; comparing the same connection and schema without overrides.
Usage Example:
{
"name": "whodb_diff",
"arguments": {
"from_connection": "staging",
"to_connection": "prod",
"from_schema": "public",
"to_schema": "public"
}
}Returns: A structured schema diff with storage-unit, column, and relationship summaries plus per-object changes.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| from_connection | Yes | Source connection name | |
| to_connection | Yes | Target connection name | |
| from_schema | No | Source schema override | |
| to_schema | No | Target schema override |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | No | ||
| error | No | ||
| request_id | No |