eCellar MCP by usefulapi is an MCP server published by io.usefulapi, hosted at ecellar.usefulapi.io. When last checked on 2026-11-21 it was working: it answers and lists its tools. It declares 19 tools, including ecellar_get_reference_data, ecellar_search_customers, ecellar_search_addresses, ecellar_search_notes, ecellar_search_orders.
Read orders, customers, club and stock; add tracking, mark shipped and adjust stock in eCellar.
4,123 connections through 5 shared values. Tap any node.
Inferred from the host name and headers: what a server runs on, not who runs it.
Lookup lists of the winery's eCellar account: brands = brands (brand_key + name); locations = locations (location_id, name, timezone); customer_types = customer types; customer_sources = customer sources; customer_tags = customer tags; order_tags = order tags (tag groups and tags); reservation_types = reservation types; terminals = POS terminals; billing_statuses = billing statuses (enum values for the orders filter billing_statuses); purchase_statuses = order statuses (enum values for the orders filter purchase_statuses); purchase_sources = order sources (Web, POS, club, phone...); carriers = carriers (enum values for ecellar_add_order_tracking carrier_enum); payment_types = payment types; card_types = card types; note_types = customer note types; product_availabilities = product availabilities; product_statuses = product statuses; reservation_statuses = reservation statuses; fulfillment_companies = fulfillment companies; state_codes = state codes; country_codes = country codes. Use brands first: the brand_key values filter orders, club tiers, events and reservations. GET /client/* or /types/*.
| Parameter | Type | Description |
|---|---|---|
| kind * |
None yet. Changes appear after a server's second daily check.
Squares are this server's values; dots are other servers sharing them. A shared address or publisher is a lead, not proof of a common operator.
| string |
| Which list to return. |
{
"name": "ecellar_get_reference_data",
"title": "Get reference data",
"description": "Lookup lists of the winery's eCellar account: brands = brands (brand_key + name); locations = locations (location_id, name, timezone); customer_types = customer types; customer_sources = customer sources; customer_tags = customer tags; order_tags = order tags (tag groups and tags); reservation_types = reservation types; terminals = POS terminals; billing_statuses = billing statuses (enum values for the orders filter billing_statuses); purchase_statuses = order statuses (enum values for the orders filter purchase_statuses); purchase_sources = order sources (Web, POS, club, phone...); carriers = carriers (enum values for ecellar_add_order_tracking carrier_enum); payment_types = payment types; card_types = card types; note_types = customer note types; product_availabilities = product availabilities; product_statuses = product statuses; reservation_statuses = reservation statuses; fulfillment_companies = fulfillment companies; state_codes = state codes; country_codes = country codes. Use brands first: the brand_key values filter orders, club tiers, events and reservations. GET /client/* or /types/*.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"kind"
],
"properties": {
"kind": {
"enum": [
"brands",
"locations",
"customer_types",
"customer_sources",
"customer_tags",
"order_tags",
"reservation_types",
"terminals",
"billing_statuses",
"purchase_statuses",
"purchase_sources",
"carriers",
"payment_types",
"card_types",
"note_types",
"product_availabilities",
"product_statuses",
"reservation_statuses",
"fulfillment_companies",
"state_codes",
"country_codes"
],
"type": "string",
"description": "Which list to return."
}
}
},
"annotations": {
"title": "Get reference data",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Customers (club members and buyers) with contact details, type, source, tags, email consent and default addresses. Personal data: use only what the task needs. POST /customers. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).
| Parameter | Type | Description |
|---|---|---|
| page | integer | Page number, from 1 (default 1). Pass the previous reply's next_page. |
| page_size | integer | Rows per page (default 25, max 200). |
| customer_ids | array | Only these customer ids. |
| signup_date_end | string | signup date end (inclusive range bound). |
| customer_type_ids | array | Only these customer type ids. |
| modified_date_end | string | modified date end (inclusive range bound). |
| signup_date_start | string | signup date start (inclusive range bound). |
| modified_date_start | string | modified date start (inclusive range bound). |
{
"name": "ecellar_search_customers",
"title": "Search customers",
"description": "Customers (club members and buyers) with contact details, type, source, tags, email consent and default addresses. Personal data: use only what the task needs. POST /customers. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"page": {
"type": "integer",
"maximum": 100000,
"description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
"exclusiveMinimum": 0
},
"page_size": {
"type": "integer",
"maximum": 200,
"minimum": 1,
"description": "Rows per page (default 25, max 200)."
},
"customer_ids": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"exclusiveMinimum": 0
},
"maxItems": 500,
"minItems": 1,
"description": "Only these customer ids."
},
"signup_date_end": {
"type": "string",
"maxLength": 40,
"description": "signup date end (inclusive range bound)."
},
"customer_type_ids": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"exclusiveMinimum": 0
},
"maxItems": 500,
"minItems": 1,
"description": "Only these customer type ids."
},
"modified_date_end": {
"type": "string",
"maxLength": 40,
"description": "modified date end (inclusive range bound)."
},
"signup_date_start": {
"type": "string",
"maxLength": 40,
"description": "signup date start (inclusive range bound)."
},
"modified_date_start": {
"type": "string",
"maxLength": 40,
"description": "modified date start (inclusive range bound)."
}
}
},
"annotations": {
"title": "Search customers",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Customer billing and shipping addresses. POST /addresses. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).
| Parameter | Type | Description |
|---|---|---|
| page | integer | Page number, from 1 (default 1). Pass the previous reply's next_page. |
| page_size | integer | Rows per page (default 25, max 200). |
| address_ids | array | Only these address ids. |
| customer_ids | array | Only these customer ids. |
| create_date_end | string | create date end (inclusive range bound). |
| create_date_start | string | create date start (inclusive range bound). |
| modified_date_end | string | modified date end (inclusive range bound). |
| modified_date_start | string | modified date start (inclusive range bound). |
{
"name": "ecellar_search_addresses",
"title": "Search customer addresses",
"description": "Customer billing and shipping addresses. POST /addresses. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"page": {
"type": "integer",
"maximum": 100000,
"description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
"exclusiveMinimum": 0
},
"page_size": {
"type": "integer",
"maximum": 200,
"minimum": 1,
"description": "Rows per page (default 25, max 200)."
},
"address_ids": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"exclusiveMinimum": 0
},
"maxItems": 500,
"minItems": 1,
"description": "Only these address ids."
},
"customer_ids": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"exclusiveMinimum": 0
},
"maxItems": 500,
"minItems": 1,
"description": "Only these customer ids."
},
"create_date_end": {
"type": "string",
"maxLength": 40,
"description": "create date end (inclusive range bound)."
},
"create_date_start": {
"type": "string",
"maxLength": 40,
"description": "create date start (inclusive range bound)."
},
"modified_date_end": {
"type": "string",
"maxLength": 40,
"description": "modified date end (inclusive range bound)."
},
"modified_date_start": {
"type": "string",
"maxLength": 40,
"description": "modified date start (inclusive range bound)."
}
}
},
"annotations": {
"title": "Search customer addresses",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Notes on customer records (type, text, dates). POST /notes. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).
| Parameter | Type | Description |
|---|---|---|
| page | integer | Page number, from 1 (default 1). Pass the previous reply's next_page. |
| page_size | integer | Rows per page (default 25, max 200). |
| customer_ids | array | Only these customer ids. |
| create_date_end | string | create date end (inclusive range bound). |
| create_date_start | string | create date start (inclusive range bound). |
| modified_date_end | string | modified date end (inclusive range bound). |
| modified_date_start | string | modified date start (inclusive range bound). |
{
"name": "ecellar_search_notes",
"title": "Search customer notes",
"description": "Notes on customer records (type, text, dates). POST /notes. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"page": {
"type": "integer",
"maximum": 100000,
"description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
"exclusiveMinimum": 0
},
"page_size": {
"type": "integer",
"maximum": 200,
"minimum": 1,
"description": "Rows per page (default 25, max 200)."
},
"customer_ids": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"exclusiveMinimum": 0
},
"maxItems": 500,
"minItems": 1,
"description": "Only these customer ids."
},
"create_date_end": {
"type": "string",
"maxLength": 40,
"description": "create date end (inclusive range bound)."
},
"create_date_start": {
"type": "string",
"maxLength": 40,
"description": "create date start (inclusive range bound)."
},
"modified_date_end": {
"type": "string",
"maxLength": 40,
"description": "modified date end (inclusive range bound)."
},
"modified_date_start": {
"type": "string",
"maxLength": 40,
"description": "modified date start (inclusive range bound)."
}
}
},
"annotations": {
"title": "Search customer notes",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Orders (web, POS, club and phone) with totals, status, billing and shipping details, and their lines, payments, tracking records and tags. Statuses are the enum values from ecellar_get_reference_data purchase_statuses / billing_statuses. Contains customer personal data. POST /orders. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).
| Parameter | Type | Description |
|---|---|---|
| page | integer | Page number, from 1 (default 1). Pass the previous reply's next_page. |
| page_size | integer | Rows per page (default 25, max 200). |
| brand_keys | array | Only these brands (brand_key values from ecellar_list_brands). |
| customer_ids | array | Only these customer ids. |
| purchase_ids | array | Only these order ids. |
| close_date_end | string | close date end (inclusive range bound). |
| create_date_end | string | create date end (inclusive range bound). |
| billing_statuses | array | Only orders with these billing statuses (enum values). |
| close_date_start | string | close date start (inclusive range bound). |
| create_date_start | string | create date start (inclusive range bound). |
| modified_date_end | string | modified date end (inclusive range bound). |
| purchase_statuses | array | Only orders in these statuses (enum values). |
| modified_date_start | string | modified date start (inclusive range bound). |
| funds_captured_date_end | string | funds captured date end (inclusive range bound). |
| funds_captured_date_start | string | funds captured date start (inclusive range bound). |
{
"name": "ecellar_search_orders",
"title": "Search orders",
"description": "Orders (web, POS, club and phone) with totals, status, billing and shipping details, and their lines, payments, tracking records and tags. Statuses are the enum values from ecellar_get_reference_data purchase_statuses / billing_statuses. Contains customer personal data. POST /orders. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"page": {
"type": "integer",
"maximum": 100000,
"description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
"exclusiveMinimum": 0
},
"page_size": {
"type": "integer",
"maximum": 200,
"minimum": 1,
"description": "Rows per page (default 25, max 200)."
},
"brand_keys": {
"type": "array",
"items": {
"type": "string",
"maxLength": 50,
"minLength": 1
},
"maxItems": 50,
"minItems": 1,
"description": "Only these brands (brand_key values from ecellar_list_brands)."
},
"customer_ids": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"exclusiveMinimum": 0
},
"maxItems": 500,
"minItems": 1,
"description": "Only these customer ids."
},
"purchase_ids": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"exclusiveMinimum": 0
},
"maxItems": 500,
"minItems": 1,
"description": "Only these order ids."
},
"close_date_end": {
"type": "string",
"maxLength": 40,
"description": "close date end (inclusive range bound)."
},
"create_date_end": {
"type": "string",
"maxLength": 40,
"description": "create date end (inclusive range bound)."
},
"billing_statuses": {
"type": "array",
"items": {
"type": "string",
"maxLength": 50,
"minLength": 1
},
"maxItems": 30,
"minItems": 1,
"description": "Only orders with these billing statuses (enum values)."
},
"close_date_start": {
"type": "string",
"maxLength": 40,
"description": "close date start (inclusive range bound)."
},
"create_date_start": {
"type": "string",
"maxLength": 40,
"description": "create date start (inclusive range bound)."
},
"modified_date_end": {
"type": "string",
"maxLength": 40,
"description": "modified date end (inclusive range bound)."
},
"purchase_statuses": {
"type": "array",
"items": {
"type": "string",
"maxLength": 50,
"minLength": 1
},
"maxItems": 30,
"minItems": 1,
"description": "Only orders in these statuses (enum values)."
},
"modified_date_start": {
"type": "string",
"maxLength": 40,
"description": "modified date start (inclusive range bound)."
},
"funds_captured_date_end": {
"type": "string",
"maxLength": 40,
"description": "funds captured date end (inclusive range bound)."
},
"funds_captured_date_start": {
"type": "string",
"maxLength": 40,
"description": "funds captured date start (inclusive range bound)."
}
}
},
"annotations": {
"title": "Search orders",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Order lines (product, SKU, quantity, price, discount, tax) across orders. POST /orders/lines. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).
| Parameter | Type | Description |
|---|---|---|
| page | integer | Page number, from 1 (default 1). Pass the previous reply's next_page. |
| page_size | integer | Rows per page (default 25, max 200). |
| purchase_ids | array | Only these order ids. |
| create_date_end | string | create date end (inclusive range bound). |
| create_date_start | string | create date start (inclusive range bound). |
| modified_date_end | string | modified date end (inclusive range bound). |
| modified_date_start | string | modified date start (inclusive range bound). |
{
"name": "ecellar_search_order_lines",
"title": "Search order lines",
"description": "Order lines (product, SKU, quantity, price, discount, tax) across orders. POST /orders/lines. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"page": {
"type": "integer",
"maximum": 100000,
"description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
"exclusiveMinimum": 0
},
"page_size": {
"type": "integer",
"maximum": 200,
"minimum": 1,
"description": "Rows per page (default 25, max 200)."
},
"purchase_ids": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"exclusiveMinimum": 0
},
"maxItems": 500,
"minItems": 1,
"description": "Only these order ids."
},
"create_date_end": {
"type": "string",
"maxLength": 40,
"description": "create date end (inclusive range bound)."
},
"create_date_start": {
"type": "string",
"maxLength": 40,
"description": "create date start (inclusive range bound)."
},
"modified_date_end": {
"type": "string",
"maxLength": 40,
"description": "modified date end (inclusive range bound)."
},
"modified_date_start": {
"type": "string",
"maxLength": 40,
"description": "modified date start (inclusive range bound)."
}
}
},
"annotations": {
"title": "Search order lines",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Order payments (amount, type, billing status, dates, card brand, last digits and expiry; no card numbers). POST /orders/payments. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).
| Parameter | Type | Description |
|---|---|---|
| page | integer | Page number, from 1 (default 1). Pass the previous reply's next_page. |
| page_size | integer | Rows per page (default 25, max 200). |
| purchase_ids | array | Only these order ids. |
| create_date_end | string | create date end (inclusive range bound). |
| billing_statuses | array | Only payments with these billing statuses (enum values). |
| create_date_start | string | create date start (inclusive range bound). |
| modified_date_end | string | modified date end (inclusive range bound). |
| modified_date_start | string | modified date start (inclusive range bound). |
| funds_captured_date_end | string | funds captured date end (inclusive range bound). |
| funds_captured_date_start | string | funds captured date start (inclusive range bound). |
{
"name": "ecellar_search_order_payments",
"title": "Search order payments",
"description": "Order payments (amount, type, billing status, dates, card brand, last digits and expiry; no card numbers). POST /orders/payments. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"page": {
"type": "integer",
"maximum": 100000,
"description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
"exclusiveMinimum": 0
},
"page_size": {
"type": "integer",
"maximum": 200,
"minimum": 1,
"description": "Rows per page (default 25, max 200)."
},
"purchase_ids": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"exclusiveMinimum": 0
},
"maxItems": 500,
"minItems": 1,
"description": "Only these order ids."
},
"create_date_end": {
"type": "string",
"maxLength": 40,
"description": "create date end (inclusive range bound)."
},
"billing_statuses": {
"type": "array",
"items": {
"type": "string",
"maxLength": 50,
"minLength": 1
},
"maxItems": 30,
"minItems": 1,
"description": "Only payments with these billing statuses (enum values)."
},
"create_date_start": {
"type": "string",
"maxLength": 40,
"description": "create date start (inclusive range bound)."
},
"modified_date_end": {
"type": "string",
"maxLength": 40,
"description": "modified date end (inclusive range bound)."
},
"modified_date_start": {
"type": "string",
"maxLength": 40,
"description": "modified date start (inclusive range bound)."
},
"funds_captured_date_end": {
"type": "string",
"maxLength": 40,
"description": "funds captured date end (inclusive range bound)."
},
"funds_captured_date_start": {
"type": "string",
"maxLength": 40,
"description": "funds captured date start (inclusive range bound)."
}
}
},
"annotations": {
"title": "Search order payments",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Carrier tracking records of orders (carrier, tracking number, shipped and delivered dates). POST /orders/trackings. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).
| Parameter | Type | Description |
|---|---|---|
| page | integer | Page number, from 1 (default 1). Pass the previous reply's next_page. |
| page_size | integer | Rows per page (default 25, max 200). |
| purchase_ids | array | Only these order ids. |
| create_date_end | string | create date end (inclusive range bound). |
| create_date_start | string | create date start (inclusive range bound). |
| modified_date_end | string | modified date end (inclusive range bound). |
| modified_date_start | string | modified date start (inclusive range bound). |
{
"name": "ecellar_search_order_trackings",
"title": "Search order tracking records",
"description": "Carrier tracking records of orders (carrier, tracking number, shipped and delivered dates). POST /orders/trackings. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"page": {
"type": "integer",
"maximum": 100000,
"description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
"exclusiveMinimum": 0
},
"page_size": {
"type": "integer",
"maximum": 200,
"minimum": 1,
"description": "Rows per page (default 25, max 200)."
},
"purchase_ids": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"exclusiveMinimum": 0
},
"maxItems": 500,
"minItems": 1,
"description": "Only these order ids."
},
"create_date_end": {
"type": "string",
"maxLength": 40,
"description": "create date end (inclusive range bound)."
},
"create_date_start": {
"type": "string",
"maxLength": 40,
"description": "create date start (inclusive range bound)."
},
"modified_date_end": {
"type": "string",
"maxLength": 40,
"description": "modified date end (inclusive range bound)."
},
"modified_date_start": {
"type": "string",
"maxLength": 40,
"description": "modified date start (inclusive range bound)."
}
}
},
"annotations": {
"title": "Search order tracking records",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Products (wines and merchandise): name, SKU, price, vintage-related fields, categories and inventory SKUs. POST /products. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).
| Parameter | Type | Description |
|---|---|---|
| page | integer | Page number, from 1 (default 1). Pass the previous reply's next_page. |
| page_size | integer | Rows per page (default 25, max 200). |
| create_date_end | string | create date end (inclusive range bound). |
| create_date_start | string | create date start (inclusive range bound). |
| modified_date_end | string | modified date end (inclusive range bound). |
| modified_date_start | string | modified date start (inclusive range bound). |
{
"name": "ecellar_search_products",
"title": "Search products",
"description": "Products (wines and merchandise): name, SKU, price, vintage-related fields, categories and inventory SKUs. POST /products. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"page": {
"type": "integer",
"maximum": 100000,
"description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
"exclusiveMinimum": 0
},
"page_size": {
"type": "integer",
"maximum": 200,
"minimum": 1,
"description": "Rows per page (default 25, max 200)."
},
"create_date_end": {
"type": "string",
"maxLength": 40,
"description": "create date end (inclusive range bound)."
},
"create_date_start": {
"type": "string",
"maxLength": 40,
"description": "create date start (inclusive range bound)."
},
"modified_date_end": {
"type": "string",
"maxLength": 40,
"description": "modified date end (inclusive range bound)."
},
"modified_date_start": {
"type": "string",
"maxLength": 40,
"description": "modified date start (inclusive range bound)."
}
}
},
"annotations": {
"title": "Search products",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Product categories (tree: parent_category_id, category_id, name). POST /products/categories. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).
| Parameter | Type | Description |
|---|---|---|
| page | integer | Page number, from 1 (default 1). Pass the previous reply's next_page. |
| page_size | integer | Rows per page (default 25, max 200). |
| create_date_end | string | create date end (inclusive range bound). |
| create_date_start | string | create date start (inclusive range bound). |
| modified_date_end | string | modified date end (inclusive range bound). |
| modified_date_start | string | modified date start (inclusive range bound). |
{
"name": "ecellar_search_product_categories",
"title": "Search product categories",
"description": "Product categories (tree: parent_category_id, category_id, name). POST /products/categories. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"page": {
"type": "integer",
"maximum": 100000,
"description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
"exclusiveMinimum": 0
},
"page_size": {
"type": "integer",
"maximum": 200,
"minimum": 1,
"description": "Rows per page (default 25, max 200)."
},
"create_date_end": {
"type": "string",
"maxLength": 40,
"description": "create date end (inclusive range bound)."
},
"create_date_start": {
"type": "string",
"maxLength": 40,
"description": "create date start (inclusive range bound)."
},
"modified_date_end": {
"type": "string",
"maxLength": 40,
"description": "modified date end (inclusive range bound)."
},
"modified_date_start": {
"type": "string",
"maxLength": 40,
"description": "modified date start (inclusive range bound)."
}
}
},
"annotations": {
"title": "Search product categories",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Current inventory per SKU and location: on_hand, on_hold, invoiced and available. Filter by SKUs and/or locations (ids or names from ecellar_get_reference_data locations); with no filter every SKU and location is returned. POST /inventory/counts.
| Parameter | Type | Description |
|---|---|---|
| skus | array | Only these SKUs. |
| location_ids | array | Only these locations (36-character location_id values). |
| location_names | array | Only these locations, by name. |
{
"name": "ecellar_get_inventory_counts",
"title": "Get inventory counts",
"description": "Current inventory per SKU and location: on_hand, on_hold, invoiced and available. Filter by SKUs and/or locations (ids or names from ecellar_get_reference_data locations); with no filter every SKU and location is returned. POST /inventory/counts.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"skus": {
"type": "array",
"items": {
"type": "string",
"maxLength": 50,
"minLength": 1
},
"maxItems": 200,
"minItems": 1,
"description": "Only these SKUs."
},
"location_ids": {
"type": "array",
"items": {
"type": "string",
"maxLength": 36,
"minLength": 36
},
"maxItems": 50,
"minItems": 1,
"description": "Only these locations (36-character location_id values)."
},
"location_names": {
"type": "array",
"items": {
"type": "string",
"maxLength": 100,
"minLength": 1
},
"maxItems": 50,
"minItems": 1,
"description": "Only these locations, by name."
}
}
},
"annotations": {
"title": "Get inventory counts",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Wine club subscriptions of customers: tier, signup/cancel/hold dates, billing and shipping address, card brand, last digits and expiry (no card numbers). POST /subscriptions. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).
| Parameter | Type | Description |
|---|---|---|
| page | integer | Page number, from 1 (default 1). Pass the previous reply's next_page. |
| page_size | integer | Rows per page (default 25, max 200). |
| customer_ids | array | Only these customer ids. |
| club_tier_ids | array | Only these club tier ids. |
| cancel_date_end | string | cancel date end (inclusive range bound). |
| signup_date_end | string | signup date end (inclusive range bound). |
| cancel_date_start | string | cancel date start (inclusive range bound). |
| modified_date_end | string | modified date end (inclusive range bound). |
| signup_date_start | string | signup date start (inclusive range bound). |
| modified_date_start | string | modified date start (inclusive range bound). |
| cc_expiration_date_end | string | cc expiration date end (inclusive range bound). |
| cc_expiration_date_start | string | cc expiration date start (inclusive range bound). |
{
"name": "ecellar_search_club_subscriptions",
"title": "Search club subscriptions",
"description": "Wine club subscriptions of customers: tier, signup/cancel/hold dates, billing and shipping address, card brand, last digits and expiry (no card numbers). POST /subscriptions. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"page": {
"type": "integer",
"maximum": 100000,
"description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
"exclusiveMinimum": 0
},
"page_size": {
"type": "integer",
"maximum": 200,
"minimum": 1,
"description": "Rows per page (default 25, max 200)."
},
"customer_ids": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"exclusiveMinimum": 0
},
"maxItems": 500,
"minItems": 1,
"description": "Only these customer ids."
},
"club_tier_ids": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"exclusiveMinimum": 0
},
"maxItems": 500,
"minItems": 1,
"description": "Only these club tier ids."
},
"cancel_date_end": {
"type": "string",
"maxLength": 40,
"description": "cancel date end (inclusive range bound)."
},
"signup_date_end": {
"type": "string",
"maxLength": 40,
"description": "signup date end (inclusive range bound)."
},
"cancel_date_start": {
"type": "string",
"maxLength": 40,
"description": "cancel date start (inclusive range bound)."
},
"modified_date_end": {
"type": "string",
"maxLength": 40,
"description": "modified date end (inclusive range bound)."
},
"signup_date_start": {
"type": "string",
"maxLength": 40,
"description": "signup date start (inclusive range bound)."
},
"modified_date_start": {
"type": "string",
"maxLength": 40,
"description": "modified date start (inclusive range bound)."
},
"cc_expiration_date_end": {
"type": "string",
"maxLength": 40,
"description": "cc expiration date end (inclusive range bound)."
},
"cc_expiration_date_start": {
"type": "string",
"maxLength": 40,
"description": "cc expiration date start (inclusive range bound)."
}
}
},
"annotations": {
"title": "Search club subscriptions",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Wine club tiers (id, name, description, brand). POST /club/tiers. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).
| Parameter | Type | Description |
|---|---|---|
| page | integer | Page number, from 1 (default 1). Pass the previous reply's next_page. |
| page_size | integer | Rows per page (default 25, max 200). |
| brand_keys | array | Only these brands (brand_key values from ecellar_list_brands). |
| create_date_end | string | create date end (inclusive range bound). |
| create_date_start | string | create date start (inclusive range bound). |
| modified_date_end | string | modified date end (inclusive range bound). |
| modified_date_start | string | modified date start (inclusive range bound). |
{
"name": "ecellar_search_club_tiers",
"title": "Search club tiers",
"description": "Wine club tiers (id, name, description, brand). POST /club/tiers. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"page": {
"type": "integer",
"maximum": 100000,
"description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
"exclusiveMinimum": 0
},
"page_size": {
"type": "integer",
"maximum": 200,
"minimum": 1,
"description": "Rows per page (default 25, max 200)."
},
"brand_keys": {
"type": "array",
"items": {
"type": "string",
"maxLength": 50,
"minLength": 1
},
"maxItems": 50,
"minItems": 1,
"description": "Only these brands (brand_key values from ecellar_list_brands)."
},
"create_date_end": {
"type": "string",
"maxLength": 40,
"description": "create date end (inclusive range bound)."
},
"create_date_start": {
"type": "string",
"maxLength": 40,
"description": "create date start (inclusive range bound)."
},
"modified_date_end": {
"type": "string",
"maxLength": 40,
"description": "modified date end (inclusive range bound)."
},
"modified_date_start": {
"type": "string",
"maxLength": 40,
"description": "modified date start (inclusive range bound)."
}
}
},
"annotations": {
"title": "Search club tiers",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Club events / shipments (name, date, ship group, tier, pickup location, product totals, remix window). POST /club/events. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).
| Parameter | Type | Description |
|---|---|---|
| page | integer | Page number, from 1 (default 1). Pass the previous reply's next_page. |
| page_size | integer | Rows per page (default 25, max 200). |
| brand_keys | array | Only these brands (brand_key values from ecellar_list_brands). |
| create_date_end | string | create date end (inclusive range bound). |
| create_date_start | string | create date start (inclusive range bound). |
| modified_date_end | string | modified date end (inclusive range bound). |
| club_event_date_end | string | club event date end (inclusive range bound). |
| modified_date_start | string | modified date start (inclusive range bound). |
| club_event_date_start | string | club event date start (inclusive range bound). |
{
"name": "ecellar_search_club_events",
"title": "Search club events",
"description": "Club events / shipments (name, date, ship group, tier, pickup location, product totals, remix window). POST /club/events. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"page": {
"type": "integer",
"maximum": 100000,
"description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
"exclusiveMinimum": 0
},
"page_size": {
"type": "integer",
"maximum": 200,
"minimum": 1,
"description": "Rows per page (default 25, max 200)."
},
"brand_keys": {
"type": "array",
"items": {
"type": "string",
"maxLength": 50,
"minLength": 1
},
"maxItems": 50,
"minItems": 1,
"description": "Only these brands (brand_key values from ecellar_list_brands)."
},
"create_date_end": {
"type": "string",
"maxLength": 40,
"description": "create date end (inclusive range bound)."
},
"create_date_start": {
"type": "string",
"maxLength": 40,
"description": "create date start (inclusive range bound)."
},
"modified_date_end": {
"type": "string",
"maxLength": 40,
"description": "modified date end (inclusive range bound)."
},
"club_event_date_end": {
"type": "string",
"maxLength": 40,
"description": "club event date end (inclusive range bound)."
},
"modified_date_start": {
"type": "string",
"maxLength": 40,
"description": "modified date start (inclusive range bound)."
},
"club_event_date_start": {
"type": "string",
"maxLength": 40,
"description": "club event date start (inclusive range bound)."
}
}
},
"annotations": {
"title": "Search club events",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}Tasting-room and experience reservations (party, times, status, host, notes, contact phone and email). POST /reservations. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).
| Parameter | Type | Description |
|---|---|---|
| page | integer | Page number, from 1 (default 1). Pass the previous reply's next_page. |
| page_size | integer | Rows per page (default 25, max 200). |
| create_date_end | string | create date end (inclusive range bound). |
| reservation_ids | array | Only these reservation ids. |
| create_date_start | string | create date start (inclusive range bound). |
| modified_date_end | string | modified date end (inclusive range bound). |
| modified_date_start | string | modified date start (inclusive range bound). |
{
"name": "ecellar_search_reservations",
"title": "Search reservations",
"description": "Tasting-room and experience reservations (party, times, status, host, notes, contact phone and email). POST /reservations. Date filters: ISO date or date-time (e.g. 2026-01-31 or 2026-01-31T14:00:00Z; a date means 00:00 UTC).",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"page": {
"type": "integer",
"maximum": 100000,
"description": "Page number, from 1 (default 1). Pass the previous reply's next_page.",
"exclusiveMinimum": 0
},
"page_size": {
"type": "integer",
"maximum": 200,
"minimum": 1,
"description": "Rows per page (default 25, max 200)."
},
"create_date_end": {
"type": "string",
"maxLength": 40,
"description": "create date end (inclusive range bound)."
},
"reservation_ids": {
"type": "array",
"items": {
"type": "integer",
"maximum": 9007199254740991,
"exclusiveMinimum": 0
},
"maxItems": 500,
"minItems": 1,
"description": "Only these reservation ids."
},
"create_date_start": {
"type": "string",
"maxLength": 40,
"description": "create date start (inclusive range bound)."
},
"modified_date_end": {
"type": "string",
"maxLength": 40,
"description": "modified date end (inclusive range bound)."
},
"modified_date_start": {
"type": "string",
"maxLength": 40,
"description": "modified date start (inclusive range bound)."
}
}
},
"annotations": {
"title": "Search reservations",
"readOnlyHint": true,
"openWorldHint": true,
"destructiveHint": false
}
}WRITE: set the shipped date and status of ONE order, to be used when ALL its packages have shipped. eCellar refuses it unless the order status is EXPORTED, HOLD_SHIP, SHIPPED, TO_PICKUP or UNSHIPPED, the date is not before the order date, and the date matches the latest tracking ship date. Check the order and its tracking records first. PATCH /order/{order_id}/shipped.
| Parameter | Type | Description |
|---|---|---|
| order_id * | integer | eCellar order id (order_id from ecellar_search_orders). |
| date_shipped * | string | Date the order fully shipped (YYYY-MM-DD). |
{
"name": "ecellar_mark_order_shipped",
"title": "Mark order shipped",
"description": "WRITE: set the shipped date and status of ONE order, to be used when ALL its packages have shipped. eCellar refuses it unless the order status is EXPORTED, HOLD_SHIP, SHIPPED, TO_PICKUP or UNSHIPPED, the date is not before the order date, and the date matches the latest tracking ship date. Check the order and its tracking records first. PATCH /order/{order_id}/shipped.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"order_id",
"date_shipped"
],
"properties": {
"order_id": {
"type": "integer",
"maximum": 9007199254740991,
"description": "eCellar order id (order_id from ecellar_search_orders).",
"exclusiveMinimum": 0
},
"date_shipped": {
"type": "string",
"description": "Date the order fully shipped (YYYY-MM-DD)."
}
}
},
"annotations": {
"title": "Mark order shipped",
"readOnlyHint": false,
"openWorldHint": true,
"idempotentHint": true,
"destructiveHint": true
}
}WRITE: set the delivered date and status of ONE order, to be used when ALL its packages were delivered. eCellar refuses it unless the order status is DELIVERED or SHIPPED and the date matches the latest tracking delivered date. PATCH /order/{order_id}/delivered.
| Parameter | Type | Description |
|---|---|---|
| order_id * | integer | eCellar order id. |
| date_delivered * | string | Date the order was fully delivered (YYYY-MM-DD). |
{
"name": "ecellar_mark_order_delivered",
"title": "Mark order delivered",
"description": "WRITE: set the delivered date and status of ONE order, to be used when ALL its packages were delivered. eCellar refuses it unless the order status is DELIVERED or SHIPPED and the date matches the latest tracking delivered date. PATCH /order/{order_id}/delivered.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"order_id",
"date_delivered"
],
"properties": {
"order_id": {
"type": "integer",
"maximum": 9007199254740991,
"description": "eCellar order id.",
"exclusiveMinimum": 0
},
"date_delivered": {
"type": "string",
"description": "Date the order was fully delivered (YYYY-MM-DD)."
}
}
},
"annotations": {
"title": "Mark order delivered",
"readOnlyHint": false,
"openWorldHint": true,
"idempotentHint": true,
"destructiveHint": true
}
}WRITE: add a carrier tracking record (carrier + tracking number, optional shipped/delivered dates) to ONE order. Adds a record each call; a duplicate tracking number on the same order is refused by eCellar. Get carrier_enum from ecellar_get_reference_data carriers. POST /order/{order_id}/tracking.
| Parameter | Type | Description |
|---|---|---|
| order_id * | integer | eCellar order id. |
| carrier_enum * | string | Carrier enum value (from the carriers reference list). |
| date_shipped | string | Date shipped via the carrier (YYYY-MM-DD). |
| date_delivered | string | Date delivered by the carrier (YYYY-MM-DD). |
| carrier_tracking_number * | string | Carrier tracking number. |
{
"name": "ecellar_add_order_tracking",
"title": "Add order tracking record",
"description": "WRITE: add a carrier tracking record (carrier + tracking number, optional shipped/delivered dates) to ONE order. Adds a record each call; a duplicate tracking number on the same order is refused by eCellar. Get carrier_enum from ecellar_get_reference_data carriers. POST /order/{order_id}/tracking.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"order_id",
"carrier_enum",
"carrier_tracking_number"
],
"properties": {
"order_id": {
"type": "integer",
"maximum": 9007199254740991,
"description": "eCellar order id.",
"exclusiveMinimum": 0
},
"carrier_enum": {
"type": "string",
"maxLength": 50,
"minLength": 1,
"description": "Carrier enum value (from the carriers reference list)."
},
"date_shipped": {
"type": "string",
"description": "Date shipped via the carrier (YYYY-MM-DD)."
},
"date_delivered": {
"type": "string",
"description": "Date delivered by the carrier (YYYY-MM-DD)."
},
"carrier_tracking_number": {
"type": "string",
"maxLength": 255,
"minLength": 1,
"description": "Carrier tracking number."
}
}
},
"annotations": {
"title": "Add order tracking record",
"readOnlyHint": false,
"openWorldHint": true,
"idempotentHint": false,
"destructiveHint": false
}
}WRITE: change the on-hand count of ONE SKU at ONE location by a signed amount (+12 adds, -3 removes; it is a delta, not a new total, so repeating it repeats the change). Pass location_id or location_name; eCellar refuses an unknown or ambiguous location, a SKU that is not at that location, or a result below zero. Check ecellar_get_inventory_counts first. PATCH /inventory/counts/{SKU}.
| Parameter | Type | Description |
|---|---|---|
| sku * | string | The SKU (SKU from ecellar_search_products inventory_skus or ecellar_get_inventory_counts). |
| location_id | string | Inventory location id (36 characters). |
| location_name | string | Inventory location name (use instead of location_id). |
| on_hand_adjustment * | integer | Signed change of the on-hand count. |
{
"name": "ecellar_adjust_inventory_count",
"title": "Adjust inventory count",
"description": "WRITE: change the on-hand count of ONE SKU at ONE location by a signed amount (+12 adds, -3 removes; it is a delta, not a new total, so repeating it repeats the change). Pass location_id or location_name; eCellar refuses an unknown or ambiguous location, a SKU that is not at that location, or a result below zero. Check ecellar_get_inventory_counts first. PATCH /inventory/counts/{SKU}.",
"inputSchema": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"sku",
"on_hand_adjustment"
],
"properties": {
"sku": {
"type": "string",
"maxLength": 50,
"minLength": 1,
"description": "The SKU (SKU from ecellar_search_products inventory_skus or ecellar_get_inventory_counts)."
},
"location_id": {
"type": "string",
"maxLength": 36,
"minLength": 36,
"description": "Inventory location id (36 characters)."
},
"location_name": {
"type": "string",
"maxLength": 100,
"minLength": 1,
"description": "Inventory location name (use instead of location_id)."
},
"on_hand_adjustment": {
"type": "integer",
"maximum": 1000000,
"minimum": -1000000,
"description": "Signed change of the on-hand count."
}
}
},
"annotations": {
"title": "Adjust inventory count",
"readOnlyHint": false,
"openWorldHint": true,
"idempotentHint": false,
"destructiveHint": true
}
}Tools for eCellar, hosted by usefulapi.io. If the user is new or asks what this server can do, suggest requests such as: "Which club members signed up in the last 30 days, and which tier did each join?"; "List this week's unshipped web orders with their shipping states."; "How many bottles of each SKU are available at the Tasting Room right now?". Read-only tools never change data; ask the user before a tool that creates, changes or deletes eCellar data. Free plan: 50 tool calls per month. Run ecellar_usage_status to see the calls used this month. If the user asks for something none of these tools can do, tell the user and, with their OK, run ecellar_request_feature to record the request. Paid plans: Pro (10,000 tool calls a month, $9/month or $90/year, for normal use) and Pro+ (100,000 tool calls a month, $39/month or $390/year, for automations and heavy use). A plan can be cancelled at any time and then runs to the end of the paid period, so it also suits a one-time job. When the user wants more calls or reaches the limit, run ecellar_upgrade without a plan: it returns both plans, each with a payment link for the user to open. ecellar_cancel_subscription cancels Pro at the end of the paid period.
Names, descriptions and schemas were written by the server and are shown as data.
Shared addresses on big platforms (Cloudflare, Vercel and the like) put unrelated servers together; those are marked shared_infrastructure. A match is a pivot, not a link between operators.