`eu_pesticides_list`

Pack: eu-pesticides · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/eu_pesticides_list for the schema, then POST the same URL with its arguments for the data.

List EU pesticide active substances by approval status and dates — e.g. approvals expiring before a date (expiring_before), all substances still Approved, Not approved, or Pending, candidates for substitution, low-risk substances, or one category (fungicide, herbicide, insecticide…). Each row carries status, approval_state (flags Approved entries whose expiry date has passed), first-approval date and expiry date. Sorted by expiry date for date filters, otherwise by name. Source: European Commission EU Pesticides Database; data_as_of in every answer. Keyless.

Parameters

Name	Type	Required	Description
`status`	string	no	Approval status filter.
`expiring_before`	string	no	ISO date YYYY-MM-DD: only Approved substances whose expiry date is on or before it (includes ones already lapsed).
`expiring_after`	string	no	ISO date YYYY-MM-DD: only substances whose expiry date is on or after it.
`category`	string	no	Substance category text, e.g. “fungicide”, “herbicide”, “insecticide”, “plant growth regulator”.
`candidate_for_substitution`	boolean	no	Only substances flagged as candidates for substitution.
`low_risk`	boolean	no	Only low-risk active substances.
`query`	string	no	Substring of the substance name.
`limit`	number	no	Rows to return (default 25, max 200).
`offset`	number	no	Rows to skip, for paging.

Example call

Arguments

{
  "status": "Approved",
  "expiring_before": "2027-12-31",
  "limit": 5
}

curl

curl -X POST https://gateway.pipeworx.io/eu-pesticides/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"eu_pesticides_list","arguments":{"status":"Approved","expiring_before":"2027-12-31","limit":5}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('eu_pesticides_list', {
  "status": "Approved",
  "expiring_before": "2027-12-31",
  "limit": 5
});

Response shape

Field	Type	Description
`total_matching`	number
`returned`	number
`offset`	number
`substances`	array
`index_size`	object
`source`	string
`data_as_of`	string
`data_note`	string

Full JSON Schema

{
  "type": "object",
  "properties": {
    "total_matching": {
      "type": "number"
    },
    "returned": {
      "type": "number"
    },
    "offset": {
      "type": "number"
    },
    "substances": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "substance_id": {
            "type": "number"
          },
          "name": {
            "type": "string"
          },
          "cas_number": {
            "type": "string"
          },
          "status": {
            "type": "string"
          },
          "approval_state": {
            "type": "string"
          },
          "approval_date_first": {
            "type": "string"
          },
          "expiry_date": {
            "type": "string"
          },
          "categories": {
            "type": "array",
            "items": {
              "type": [
                "string",
                null
              ]
            }
          },
          "candidate_for_substitution": {
            "type": "boolean"
          },
          "low_risk": {
            "type": "boolean"
          }
        },
        "additionalProperties": true
      }
    },
    "index_size": {
      "type": "object",
      "properties": {
        "substances": {
          "type": "number"
        },
        "source_rows": {
          "type": "number"
        }
      },
      "additionalProperties": true
    },
    "source": {
      "type": "string"
    },
    "data_as_of": {
      "type": "string"
    },
    "data_note": {
      "type": "string"
    }
  },
  "additionalProperties": true
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}

Connect to just the eu-pesticides pack

{
  "mcpServers": {
    "eu-pesticides": {
      "url": "https://gateway.pipeworx.io/eu-pesticides/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

eu_pesticides_list