whodb_diff
Read-onlyIdempotent
Compare schema metadata between two database connections to identify drift across environments like staging and production. Returns structured diff of 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 |