Describe MySQL table
mysql_describe_tableInspect one MySQL table or view to retrieve column types, nullability, defaults, comments, and ordered index columns for schema checks and query planning.
Instructions
Inspect columns and indexes for one exact MySQL table or view. Returns types, nullability, defaults, comments, and ordered index columns. This tool is read-only in every environment.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Exact table or view name. | |
| schema | No | Schema name. Defaults to the connection's configured database. | |
| connection_id | Yes | Configured connection ID, for example prod-main or test-main. | |
| response_format | No | Response rendering: markdown for humans or json for programmatic processing. | markdown |