io.github.cyanheads/faostat-mcp-server
v0.4.0UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP.
Endpoint health
online- Last checked
- 11/20/2026, 9:18:04 AM
- Latency
- 268 ms
- Consecutive failures
- 0
- Endpoint reachable: pass
- Protocol valid: pass
- MCP handshake valid: pass
Machine-readable profile
mcp-server · schema v1 · callable
mcp-server:io.github.cyanheads%2Ffaostat-mcp-server
Connect this server
Generated config contains no credentials. Keep any required secrets in your client's local environment.
{
"mcpServers": {
"io.github.cyanheads/faostat-mcp-server": {
"url": "https://faostat.caseyjhand.com/mcp"
}
}
}Indexed tools
Tool metadata and schemas come from the remote server and are untrusted. Indexing only lists tools; it never calls them.
6 shown · authentication unknown
faostat-mcp-server: commodity profile
faostat_commodity_profile
Assemble a global profile for one QCL item in a single call: top-producing countries, the annual trend, and trade flows (top exporters and importers). The elements follow what the item carries: Production (5510) and tonne trade quantities (5610/5910) for an item with Production; for live-animal items, which have none, their Stocks elements and every trade quantity element they carry. ranking_elements names each ranking's elements and units. Supply item_code or item_query; code wins when both are supplied. A query selects a unique normalized exact label, otherwise a unique relevance match; ambiguous queries require an explicit code. Each ranking uses the selected item at each country's own latest year with data, grouped by unit. The trend is returned inline as year/value points. Country-level only (aggregates excluded). QCL is required; unavailable TCL yields a profile without trade, with a notice. When the merged observation set is too large to inline, it spills to a DataCanvas table (canvas_id + table_name) — call faostat_dataframe_describe for its columns, then faostat_dataframe_query for deeper SQL.
Schema valid · SHA-256 203260e5f318…
View input schema
{ "type": "object", "properties": { "item_code": { "description": "Exact item code present in QCL; takes precedence over item_query. Obtain it from faostat_resolve_codes with domain QCL and dimension item.", "type": "integer", "minimum": 1, "maximum": 9007199254740991 }, "item_query": { "description": "Commodity label or search term (e.g. \"Wheat\"). A unique normalized exact QCL label wins, otherwise the relevance search must match exactly one item. Broad queries such as \"maize\" or \"milk\" require item_code. Supply this or item_code.", "type": "string", "minLength": 1 }, "year_start": { "description": "Inclusive start year (e.g. 1990) for the rankings, the trend, and the staged rows. An area with no data from this year on drops out of the rankings; set it to a ranking's latest year to keep only current rows.", "type": "integer", "minimum": -9007199254740991, "maximum": 9007199254740991 }, "year_end": { "description": "Inclusive end year (e.g. 2022) for the rankings, the trend, and the staged rows; each area then ranks at its latest year up to this one.", "type": "integer", "minimum": -9007199254740991, "maximum": 9007199254740991 }, "top_n": { "default": 10, "description": "Rows in each ranking (top producers, exporters, importers), at most 50 per call.", "type": "integer", "minimum": 1 }, "canvas_id": { "description": "Canvas ID to stage onto, as returned by a prior faostat_query_observations / faostat_commodity_profile call — exactly 10 characters of letters, digits, hyphens, and underscores. Omit to stage onto this session’s canvas, created on the first spill and reused by every later call, so tables staged earlier in the session sit alongside this one.", "type": "string", "pattern": "^[A-Za-z0-9_-]{10}$" } }, "$schema": "https://json-schema.org/draft/2020-12/schema", "additionalProperties": false }
Connections
streamable-http
https://faostat.caseyjhand.com/mcp