MySQL JSON Diff
mysql_json_diffCompare two JSON documents to identify differences. Analyzes changes between raw JSON data structures.
Instructions
Compare two JSON documents and identify differences.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| doc1 | No | Alias for json1 | |
| doc2 | No | Alias for json2 | |
| json1 | No | First JSON document. Note: This tool compares two raw JSON documents, it does NOT compare database rows. | |
| json2 | No | Second JSON document | |
| source | No | Alias for json2 | |
| target | No | Alias for json1 |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| code | No | Error code (e.g. VALIDATION_ERROR, QUERY_ERROR) | |
| data | No | ||
| error | No | Error message if operation failed | |
| details | No | Additional error context | |
| metrics | No | Token estimation metrics | |
| success | Yes | Whether the operation succeeded | |
| category | No | Error category (validation, query, connection, internal) | |
| suggestion | No | Suggested fix for the error | |
| recoverable | No | Whether the error is recoverable |