MySQL JSON Extract
mysql_json_extractRead-only
Extract values from JSON columns in MySQL using JSON path expressions, enabling direct access to nested data.
Instructions
Extract values from JSON columns using JSON path expressions.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| col | No | Alias for column | |
| sql | No | Alias for where | |
| name | No | Alias for table | |
| path | No | JSON path (e.g., $.name or $[0]) | |
| limit | No | Maximum rows to return | |
| query | No | Alias for where | |
| rowId | No | Alias for where (used with idColumn) | |
| table | No | Table name (Anti-Hallucination: Pass 'table', not 'tableName') | |
| where | No | WHERE clause for filtering rows | |
| column | No | JSON column name | |
| filter | No | Alias for where | |
| idColumn | No | Alias for where (used with rowId) | |
| tableName | No | Alias for table | |
| columnName | No | Alias for column |
Output Schema
TableJSON 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 |