@pipeworx/faostat

Connect: https://pipeworx.io/mcp — every tool in the catalog, including @pipeworx/faostat’s. Install: one-click buttons

No MCP client? Skip the connection: POST https://gateway.pipeworx.io/v1/tools/search_packs {"query":"..."} to find a tool below, GET /v1/tools/<name> for its schema, POST the same URL with arguments for the data — see For AI agents.

Tools: 3

UN Food and Agriculture Organization statistics — crop and livestock production, food balance sheets, agricultural trade, land and input use, farm emissions, food security and producer prices, for 245 countries and territories since 1961.

Tools

• faostat_domains(search?, domain_code?, limit?) — the 69 statistical domains, with last-updated date and observation count. Gives you the domain code.
• faostat_dimensions(domain_code, dimension, search?, limit?) — the valid area / element / item / year codes for a domain. Call this before the next one.
• faostat_data(domain_code, area?, element?, item?, year?, limit?) — the observations, with unit, year and data-quality flag.

Auth

faostat_domains is keyless. faostat_dimensions and faostat_data are BYO: FAO’s query API now requires a free FAOSTAT account (anonymous calls get 401). Pass _apiKey as an access token, or as email:password and the pack logs in. Without one the tools say so.

Data sources

• FAO, FAOSTAT dataset catalogue — the domain list. Carries DateUpdate and FileRows, which the query API does not.
• FAO, FAOSTAT domain definitions — dimension code lists.
• FAO, FAOSTAT domain data — observations.

Things worth knowing:

• Two hosts, and they fail independently. fenixservices (the query API) was returning Cloudflare 521 on every path, then timing out, through 2026-09-17 22:00–23:00 UTC while this pack was built; bulks-faostat was unaffected throughout. The pack surfaces that as a named upstream outage — an empty array here would read as “this country grows nothing”.
• 2026-11-14: the old query origin is dead (521 on every path); FAO’s replacement needs an account (fleet #4252). FAO’s bulk files (CC BY 4.0, 1.5 GB zipped across 69 domains, 33 MB for QCL alone) are the keyless alternative but need a stored copy.
• bulks-faostat.fao.org serves the catalogue JSON but 403s on per-domain paths such as /production/QCL/QCL_AreaCodes_E.json; only the documented catalogue and the zip bulk files are readable.
• FAOSTAT codes are numeric and domain-specific. A wrong item code returns an empty result, not an error, which is why faostat_dimensions exists and why faostat_data says so explicitly on a zero-row answer.
• Not the codex-mrl pack — that also reads fao.org but serves Codex Alimentarius maximum residue limits.

Verified

2026-09-17 — faostat_domains returned all 69 domains with update dates and row counts. faostat_dimensions and faostat_data could not be verified: the FAO query host was down for the whole build window (see above).

2026-11-14 — query API origin moved; token path verified only as far as the 401/403 responses. A live data call needs a FAOSTAT account and has not been made.

Tools

• faostat_domains — The 69 statistical domains FAOSTAT publishes, with what each covers, when it was last updated and how many observations it holds. AUTHORITATIVE starting point for any question about world agriculture,
• faostat_dimensions — The valid codes for one dimension of one FAOSTAT domain — the country/area codes, element codes (production quantity, area harvested, yield, import value, …), item codes (wheat, cattle, nitrogen fer
• faostat_data — Observations from a FAOSTAT domain — the actual numbers, with units, year and data-quality flag. AUTHORITATIVE for “how much did produce in ”, world agricultural trade flows, fe