Find Customers by Name
find_customers_by_nameSearch customers by first name, last name, or partial name using LIKE queries. Retrieve matching customer records from Magento.
Instructions
Searches customer_entity by firstname, lastname, or full name (LIKE). firstname/lastname/email are static columns on customer_entity — not EAV. For exact email use find_customer_by_email.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Customer first name, last name, or partial name (LIKE search). Not for email — use find_customer_by_email. | |
| limit | No | Max customers to return (default 20). | |
| 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 |