Describe Table Structure
mysql_describe_tableRetrieve column definitions for a MySQL table, including field, type, nullability, key, default, and extra info. Supports markdown or JSON output.
Instructions
Get column definitions for a MySQL table (equivalent to DESCRIBE or SHOW COLUMNS).
Args:
table (string, required): Table name
database (string, optional): Database name. Uses MYSQL_DATABASE if omitted.
response_format ('markdown' | 'json'): Output format (default: 'markdown')
Returns column info: Field, Type, Null, Key, Default, Extra
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name to describe | |
| database | No | Database name (uses MYSQL_DATABASE env var if omitted) | |
| response_format | No | Output format: 'markdown' or 'json' | markdown |