Describe Table
describe_tableRetrieve column definitions (name, type, nullable, keys, default) for any Magento table from INFORMATION_SCHEMA to plan JOINs accurately. Check structure before writing queries.
Instructions
Returns column definitions (name, type, nullable, keys, default) for a Magento table from INFORMATION_SCHEMA. Use before writing JOINs. Use list_tables if you don't know the exact table name.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Magento database table name (e.g. sales_order, catalog_product_entity). | |
| profile | No | Override the MAGENTO_SQL_PROFILE env var for this call only. Use list_connection_profiles to see available names. | |
| magentoRoot | No | Absolute path to the Magento root (must contain app/etc/env.php). Defaults to MAGENTO_ROOT env var or auto-discovery. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | ||
| rows | Yes | ||
| sampled | No | ||
| rowCount | Yes | ||
| truncated | No |