{
  "notice": "bxzxxr MCP archive: a record of what public MCP servers declared when we listed them (we never call their tools). It is data, not a rating: nothing here says a server is safe, secure, verified or trustworthy, and a server can change after we looked. Secrets we detected are redacted; redacted tool lists are withheld and only their hash is shown.",
  "infrastructure": {
    "host": "ecellar.usefulapi.io",
    "site": "usefulapi.io",
    "addresses": [
      {
        "address": "104.21.62.184",
        "endpoints": 846,
        "shared_infrastructure": true,
        "network": {
          "asn": 13335,
          "name": "CLOUDFLARENET - Cloudflare, Inc.",
          "prefix": "104.21.32.0/19",
          "country": "US"
        }
      },
      {
        "address": "172.67.138.37",
        "endpoints": 846,
        "shared_infrastructure": true,
        "network": {
          "asn": 13335,
          "name": "CLOUDFLARENET - Cloudflare, Inc.",
          "prefix": "172.67.128.0/20",
          "country": "US"
        }
      },
      {
        "address": "2606:4700:3032::6815:3eb8",
        "endpoints": 846,
        "shared_infrastructure": true,
        "network": {
          "asn": 13335,
          "name": "CLOUDFLARENET - Cloudflare, Inc.",
          "prefix": "2606:4700:3032::/48",
          "country": "US"
        }
      },
      {
        "address": "2606:4700:3030::ac43:8a25",
        "endpoints": 846,
        "shared_infrastructure": true,
        "network": {
          "asn": 13335,
          "name": "CLOUDFLARENET - Cloudflare, Inc.",
          "prefix": "2606:4700:3030::/48",
          "country": "US"
        }
      }
    ],
    "addresses_recorded": true,
    "address_history": [
      {
        "addresses": [
          "104.21.62.184",
          "172.67.138.37",
          "2606:4700:3032::6815:3eb8",
          "2606:4700:3030::ac43:8a25"
        ],
        "first_seen": "2026-11-21T22:47:00.922Z",
        "last_seen": "2026-11-21T22:47:00.922Z",
        "checks": 1
      }
    ],
    "hosting": [
      {
        "value": "Cloudflare",
        "evidence": "Server header \"cloudflare\""
      }
    ],
    "software": [],
    "server_info": {
      "name": "ecellar-mcp",
      "version": "1.6.0",
      "protocol_version": "2025-06-18"
    },
    "headers": {
      "server": "cloudflare"
    },
    "auth": null
  },
  "related": {
    "same_address": {
      "total": 845,
      "sample": [
        {
          "id": "22186",
          "url": "https://mcp.easyscribe.guide/mcp",
          "server_name": "guide.easyscribe/easy-scribe",
          "last_state": "listed",
          "last_checked_at": "2026-11-22T17:59:02.319Z"
        },
        {
          "id": "42087",
          "url": "https://17track.usefulapi.io/mcp",
          "server_name": "io.usefulapi/17track",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:10:01.976Z"
        },
        {
          "id": "42088",
          "url": "https://a2x-accounting.usefulapi.io/mcp",
          "server_name": "io.usefulapi/a2x-accounting",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:11:01.183Z"
        },
        {
          "id": "42089",
          "url": "https://abacus-pos.usefulapi.io/mcp",
          "server_name": "io.usefulapi/abacus-pos",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:12:01.080Z"
        },
        {
          "id": "42090",
          "url": "https://abaninja.usefulapi.io/mcp",
          "server_name": "io.usefulapi/abaninja",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:13:02.135Z"
        },
        {
          "id": "42091",
          "url": "https://ablesign.usefulapi.io/mcp",
          "server_name": "io.usefulapi/ablesign",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:14:01.432Z"
        },
        {
          "id": "42092",
          "url": "https://ably.usefulapi.io/mcp",
          "server_name": "io.usefulapi/ably",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:15:01.611Z"
        },
        {
          "id": "42093",
          "url": "https://abra-flexi.usefulapi.io/mcp",
          "server_name": "io.usefulapi/abra-flexi",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:16:00.986Z"
        },
        {
          "id": "42094",
          "url": "https://absence-io.usefulapi.io/mcp",
          "server_name": "io.usefulapi/absence-io",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:17:01.057Z"
        },
        {
          "id": "42095",
          "url": "https://abstract-api.usefulapi.io/mcp",
          "server_name": "io.usefulapi/abstract-api",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:18:00.734Z"
        },
        {
          "id": "42096",
          "url": "https://academy-of-mine.usefulapi.io/mcp",
          "server_name": "io.usefulapi/academy-of-mine",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:19:00.968Z"
        },
        {
          "id": "42097",
          "url": "https://academyocean.usefulapi.io/mcp",
          "server_name": "io.usefulapi/academyocean",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:20:01.024Z"
        },
        {
          "id": "42098",
          "url": "https://accelo.usefulapi.io/mcp",
          "server_name": "io.usefulapi/accelo",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:21:01.299Z"
        },
        {
          "id": "42099",
          "url": "https://accredible.usefulapi.io/mcp",
          "server_name": "io.usefulapi/accredible",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:22:00.819Z"
        },
        {
          "id": "42100",
          "url": "https://action1.usefulapi.io/mcp",
          "server_name": "io.usefulapi/action1",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:23:00.761Z"
        },
        {
          "id": "42101",
          "url": "https://acube.usefulapi.io/mcp",
          "server_name": "io.usefulapi/acube",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:24:00.644Z"
        },
        {
          "id": "42102",
          "url": "https://acuity-scheduling.usefulapi.io/mcp",
          "server_name": "io.usefulapi/acuity-scheduling",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:25:02.340Z"
        },
        {
          "id": "42103",
          "url": "https://adafruit-io.usefulapi.io/mcp",
          "server_name": "io.usefulapi/adafruit-io",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:26:02.127Z"
        },
        {
          "id": "42104",
          "url": "https://addevent.usefulapi.io/mcp",
          "server_name": "io.usefulapi/addevent",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:27:01.202Z"
        },
        {
          "id": "42105",
          "url": "https://addressfinder.usefulapi.io/mcp",
          "server_name": "io.usefulapi/addressfinder",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:28:00.709Z"
        }
      ]
    },
    "same_site": {
      "total": 1097,
      "sample": [
        {
          "id": "42087",
          "url": "https://17track.usefulapi.io/mcp",
          "server_name": "io.usefulapi/17track",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:10:01.976Z"
        },
        {
          "id": "42088",
          "url": "https://a2x-accounting.usefulapi.io/mcp",
          "server_name": "io.usefulapi/a2x-accounting",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:11:01.183Z"
        },
        {
          "id": "42089",
          "url": "https://abacus-pos.usefulapi.io/mcp",
          "server_name": "io.usefulapi/abacus-pos",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:12:01.080Z"
        },
        {
          "id": "42090",
          "url": "https://abaninja.usefulapi.io/mcp",
          "server_name": "io.usefulapi/abaninja",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:13:02.135Z"
        },
        {
          "id": "42091",
          "url": "https://ablesign.usefulapi.io/mcp",
          "server_name": "io.usefulapi/ablesign",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:14:01.432Z"
        },
        {
          "id": "42092",
          "url": "https://ably.usefulapi.io/mcp",
          "server_name": "io.usefulapi/ably",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:15:01.611Z"
        },
        {
          "id": "42093",
          "url": "https://abra-flexi.usefulapi.io/mcp",
          "server_name": "io.usefulapi/abra-flexi",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:16:00.986Z"
        },
        {
          "id": "42094",
          "url": "https://absence-io.usefulapi.io/mcp",
          "server_name": "io.usefulapi/absence-io",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:17:01.057Z"
        },
        {
          "id": "42095",
          "url": "https://abstract-api.usefulapi.io/mcp",
          "server_name": "io.usefulapi/abstract-api",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:18:00.734Z"
        },
        {
          "id": "42096",
          "url": "https://academy-of-mine.usefulapi.io/mcp",
          "server_name": "io.usefulapi/academy-of-mine",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:19:00.968Z"
        },
        {
          "id": "42097",
          "url": "https://academyocean.usefulapi.io/mcp",
          "server_name": "io.usefulapi/academyocean",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:20:01.024Z"
        },
        {
          "id": "42098",
          "url": "https://accelo.usefulapi.io/mcp",
          "server_name": "io.usefulapi/accelo",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:21:01.299Z"
        },
        {
          "id": "42099",
          "url": "https://accredible.usefulapi.io/mcp",
          "server_name": "io.usefulapi/accredible",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:22:00.819Z"
        },
        {
          "id": "42100",
          "url": "https://action1.usefulapi.io/mcp",
          "server_name": "io.usefulapi/action1",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:23:00.761Z"
        },
        {
          "id": "42101",
          "url": "https://acube.usefulapi.io/mcp",
          "server_name": "io.usefulapi/acube",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:24:00.644Z"
        },
        {
          "id": "42102",
          "url": "https://acuity-scheduling.usefulapi.io/mcp",
          "server_name": "io.usefulapi/acuity-scheduling",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:25:02.340Z"
        },
        {
          "id": "42103",
          "url": "https://adafruit-io.usefulapi.io/mcp",
          "server_name": "io.usefulapi/adafruit-io",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:26:02.127Z"
        },
        {
          "id": "42104",
          "url": "https://addevent.usefulapi.io/mcp",
          "server_name": "io.usefulapi/addevent",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:27:01.202Z"
        },
        {
          "id": "42105",
          "url": "https://addressfinder.usefulapi.io/mcp",
          "server_name": "io.usefulapi/addressfinder",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:28:00.709Z"
        },
        {
          "id": "42106",
          "url": "https://adminpulse.usefulapi.io/mcp",
          "server_name": "io.usefulapi/adminpulse",
          "last_state": "listed",
          "last_checked_at": "2026-11-21T18:29:00.620Z"
        }
      ]
    },
    "same_tool_list": {
      "total": 0,
      "sample": []
    },
    "same_publisher": {
      "publisher": "io.usefulapi",
      "total": 1097,
      "sample": [
        {
          "name": "io.usefulapi/17track",
          "title": "17TRACK MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/a2x-accounting",
          "title": "A2X MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/abacus-pos",
          "title": "Abacus POS MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/abaninja",
          "title": "AbaNinja MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/ablesign",
          "title": "AbleSign MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/ably",
          "title": "Ably MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/abra-flexi",
          "title": "ABRA Flexi MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/absence-io",
          "title": "absence.io MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/abstract-api",
          "title": "Abstract API MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/academy-of-mine",
          "title": "Academy of Mine MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/academyocean",
          "title": "AcademyOcean MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/accelo",
          "title": "Accelo MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/accredible",
          "title": "Accredible MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/action1",
          "title": "Action1 MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/acube",
          "title": "A-Cube MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/acuity-scheduling",
          "title": "Acuity Scheduling MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/adafruit-io",
          "title": "Adafruit IO MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/addevent",
          "title": "AddEvent MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/addressfinder",
          "title": "Addressfinder MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/adminpulse",
          "title": "AdminPulse MCP by usefulapi"
        }
      ]
    },
    "same_repository": {
      "repository_url": "https://github.com/m190/usefulapi-mcp",
      "total": 1097,
      "sample": [
        {
          "name": "io.usefulapi/17track",
          "title": "17TRACK MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/a2x-accounting",
          "title": "A2X MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/abacus-pos",
          "title": "Abacus POS MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/abaninja",
          "title": "AbaNinja MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/ablesign",
          "title": "AbleSign MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/ably",
          "title": "Ably MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/abra-flexi",
          "title": "ABRA Flexi MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/absence-io",
          "title": "absence.io MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/abstract-api",
          "title": "Abstract API MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/academy-of-mine",
          "title": "Academy of Mine MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/academyocean",
          "title": "AcademyOcean MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/accelo",
          "title": "Accelo MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/accredible",
          "title": "Accredible MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/action1",
          "title": "Action1 MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/acube",
          "title": "A-Cube MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/acuity-scheduling",
          "title": "Acuity Scheduling MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/adafruit-io",
          "title": "Adafruit IO MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/addevent",
          "title": "AddEvent MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/addressfinder",
          "title": "Addressfinder MCP by usefulapi"
        },
        {
          "name": "io.usefulapi/adminpulse",
          "title": "AdminPulse MCP by usefulapi"
        }
      ]
    },
    "note": "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."
  },
  "endpoint": {
    "id": "42364",
    "server_name": "io.usefulapi/ecellar",
    "url": "https://ecellar.usefulapi.io/mcp",
    "host": "ecellar.usefulapi.io",
    "transport": "streamable-http",
    "last_checked_at": "2026-11-21T22:47:00.922Z",
    "last_state": "listed",
    "last_detail": null,
    "consecutive_failures": 0,
    "current_sha": "4255f503b4c939a5d66ff78ea9bb377d4b37e3d37e4f81dee2f49c4880d298c1",
    "first_listed_at": "2026-11-21T22:47:00.922Z",
    "created_at": "2026-11-21T12:40:06.991Z",
    "resolved_addresses": [
      "104.21.62.184",
      "172.67.138.37",
      "2606:4700:3032::6815:3eb8",
      "2606:4700:3030::ac43:8a25"
    ]
  },
  "server": {
    "name": "io.usefulapi/ecellar",
    "title": "eCellar MCP by usefulapi",
    "description": "Read orders, customers, club and stock; add tracking, mark shipped and adjust stock in eCellar.",
    "version": "1.6.0",
    "registry_status": "active",
    "repository_url": "https://github.com/m190/usefulapi-mcp",
    "website_url": "https://usefulapi.io/ecellar/",
    "published_at": "2026-11-21T01:02:01.305Z",
    "updated_at": "2026-11-21T01:02:01.305Z",
    "first_seen": "2026-11-21T12:40:06.285Z"
  },
  "other_endpoints": [],
  "intel": {
    "capabilities": [],
    "evm_addresses": [],
    "chains": [],
    "tokens": [],
    "computed_at": "2026-11-22T16:14:08.173Z"
  },
  "operator": {
    "key": "usefulapi.io",
    "name": "usefulapi.io",
    "platform": false
  },
  "needs_sign_in": false,
  "reachability": {
    "window_days": 30,
    "checks": 1,
    "answered": 1,
    "answered_percent": 100,
    "avg_listing_latency_ms": 325,
    "first_check_in_window": "2026-11-21T22:47:00.922Z",
    "consecutive_failures_now": 0,
    "days": [
      {
        "day": "2026-11-21",
        "checks": 1,
        "answered": 1,
        "last_state": "listed"
      }
    ]
  },
  "tool_list": {
    "sha256": "4255f503b4c939a5d66ff78ea9bb377d4b37e3d37e4f81dee2f49c4880d298c1",
    "tools": 19,
    "resources": 0,
    "prompts": 7,
    "first_seen": "2026-11-21T22:47:01.378Z",
    "tool_names": [
      "ecellar_get_reference_data",
      "ecellar_search_customers",
      "ecellar_search_addresses",
      "ecellar_search_notes",
      "ecellar_search_orders",
      "ecellar_search_order_lines",
      "ecellar_search_order_payments",
      "ecellar_search_order_trackings",
      "ecellar_search_products",
      "ecellar_search_product_categories",
      "ecellar_get_inventory_counts",
      "ecellar_search_club_subscriptions",
      "ecellar_search_club_tiers",
      "ecellar_search_club_events",
      "ecellar_search_reservations",
      "ecellar_mark_order_shipped",
      "ecellar_mark_order_delivered",
      "ecellar_add_order_tracking",
      "ecellar_adjust_inventory_count"
    ],
    "declared": {
      "tools": [
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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
          }
        },
        {
          "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_omitted": 0,
      "resources": [],
      "prompts": [
        {
          "name": "getting_started",
          "description": "What you can do with eCellar here, with example requests to try."
        },
        {
          "name": "check_club_members_and_their_tiers",
          "description": "Search the club subscriptions to see each member's tier, signup date and hold or cancel dates. Search the tiers to read their names and brands."
        },
        {
          "name": "plan_the_next_club_shipment",
          "description": "Search the club events to read the dates, ship groups, pickup locations, product totals and remix window of each event. Check the stock counts of the products in the shipment."
        },
        {
          "name": "review_web_orders_waiting_to_ship",
          "description": "Read the order statuses first. Then search the orders by status and date, and read the lines and tracking records of the orders you select."
        },
        {
          "name": "check_stock_per_product_at_each_location",
          "description": "Read the locations, then the on-hand, on-hold and available counts of the products you choose at each location."
        },
        {
          "name": "add_tracking_and_mark_an_order_shipped",
          "description": "Read the tracking records of the order first. Then add the carrier tracking number. Mark the order shipped only when all its packages have shipped."
        },
        {
          "name": "correct_a_stock_count_at_one_location",
          "description": "Check the current count of the product at the location first. Then adjust it by a signed amount. Repeating the adjustment repeats the change."
        }
      ]
    },
    "instructions": "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."
  },
  "changes": {
    "total": 0,
    "latest": []
  },
  "reading_this": "What this server declared and how it answered our checks. Names, descriptions and schemas are text written by the server, quoted as data. Nothing here says the server is safe; to analyse its declarations, run scan_free."
}