faostat_commodity_profile
ActiveTool of io.github.cyanheads/faostat-mcp-server
declared in 0.1.5
Assemble a global profile for one commodity in a single call: top-producing countries, the multi-decade production trend, and trade flows (top exporters and importers). Accepts a commodity name, resolves it to item codes, then queries the production (QCL) and trade (TCL) domains and merges the results. Country-level only (aggregates excluded). When a required domain is not indexed locally, returns a partial profile with a notice naming the gap rather than failing. The full merged observation set spills to a DataCanvas table for deeper SQL via faostat_dataframe_query.
Parameters schema
{
"type": "object",
"$schema": "http://json-schema.org/draft-07/schema#",
"required": [
"item_query"
],
"properties": {
"top_n": {
"type": "integer",
"default": 10,
"maximum": 50,
"minimum": 1,
"description": "Number of top producers / exporters / importers to return. Max 50."
},
"year_end": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Inclusive end year for the trend (e.g. 2022)."
},
"canvas_id": {
"type": "string",
"description": "Canvas ID from a prior call to stage onto. Omit to start a fresh canvas."
},
"item_query": {
"type": "string",
"minLength": 1,
"description": "Commodity name to profile (e.g. \"maize\", \"wheat\", \"coffee green\")."
},
"year_start": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Inclusive start year for the trend (e.g. 1990)."
}
}
}Parent server
io.github.cyanheads/faostat-mcp-server
https://github.com/cyanheads/faostat-mcp-server
1/7 registries