Get EAV Attribute
get_eav_attributeLook up an EAV attribute to get its backend_type and query guidance, indicating whether to query the base entity table or EAV value tables.
Instructions
Looks up an EAV attribute by entity_type_code (alias: entity_type) and attribute_code. Returns backend_type and query guidance. static backend_type → query base entity table, not EAV value tables.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| profile | No | Override the MAGENTO_SQL_PROFILE env var for this call only. Use list_connection_profiles to see available names. | |
| entity_type | No | Alias for entity_type_code (e.g. 'customer', 'catalog_product'). | |
| magentoRoot | No | Absolute path to the Magento root (must contain app/etc/env.php). Defaults to MAGENTO_ROOT env var or auto-discovery. | |
| attribute_code | Yes | EAV attribute code (e.g. 'name', 'status', 'price', 'visibility'). | |
| entity_type_code | No | EAV entity type code (e.g. 'catalog_product', 'customer', 'catalog_category'). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | ||
| rows | Yes | ||
| sampled | No | ||
| rowCount | Yes | ||
| truncated | No |