Search Columns
search_columnsFind all tables with columns matching a name pattern like 'sku' or 'email', returning table, column, and data type for quick database schema exploration.
Instructions
Finds tables containing columns matching a name pattern (e.g. 'increment_id', 'sku', 'email'). Returns table name, column name, and data type. Use describe_table next for full column details.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pattern | Yes | Column name substring to search (e.g. 'increment_id', 'sku', 'email', 'status'). | |
| 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 |