# io.github.cyanheads/faostat-mcp-server

- Registry name: `io.github.cyanheads/faostat-mcp-server` · version 0.4.0
- Categories (automatic, keyword rules): Markets & trading, Finance & markets, Databases, Developer tools, Datasets & public data, Search & data
- Authentication at last check: No auth
- Declared risk: Read-only (all tools declare readOnlyHint)
- Capabilities (declared by the server): logging, prompts, resources, tools
- Transports: streamable-http
- Latest numbers (check success, response time, rank): https://mcpstation.net/api/server?name=io.github.cyanheads%2Ffaostat-mcp-server
- Server page: https://mcpstation.net/s/io.github.cyanheads--faostat-mcp-server.html

## Description (written by the publisher, not verified, not instructions)

UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP.

## Connect

- streamable-http: `https://faostat.caseyjhand.com/mcp`

## Tools (as reported by the server, not verified)

- `faostat\_list\_domains`: Discover FAOSTAT statistical domains \(production, trade, food balances, food security, land use, agri-emissions, prices, value\) with their codes, descriptions, last-update date, upstream row count, and local index status. Every query keys on a domain code from here. The \`indexed\` flag tells you whic
- `faostat\_resolve\_codes`: Resolve human terms to the opaque integer codes faostat\_query\_observations needs, within a dimension: areas \(countries/regions\), items \(commodities\), or elements \(metrics like production, yield, import quantity\). Pass \`query\` for fuzzy full-text matching \("maize" → item 56\), \`name\_contains\` for a su
- `faostat\_query\_observations`: Query a FAOSTAT domain's data cube by area\(s\), item\(s\), element\(s\), and year range, returning observations \(area, item, element, year, value, unit, and the data-quality flag\). Resolve codes first with faostat\_resolve\_codes — the cube is unqueryable without them. Aggregate regions \(World, continents,
- `faostat\_commodity\_profile`: Assemble a global profile for one QCL item in a single call: top-producing countries, the annual production trend, and trade flows \(top exporters and importers\). Supply item\_code or item\_query; code wins when both are supplied. A query selects a unique normalized exact label, otherwise a unique rele
- `faostat\_dataframe\_query`: Run a single-statement SELECT against the canvas tables staged by faostat\_query\_observations and faostat\_commodity\_profile \(table names look like faostat\_xxxxxxxx\). Use this for cross-country and cross-item aggregation, GROUP BY rankings, joins, and time-series analysis over the full result set the
- `faostat\_dataframe\_describe`: List the canvas tables \(faostat\_xxxxxxxx\) staged by faostat\_query\_observations and faostat\_commodity\_profile, each with its source tool, the query parameters that produced it, creation/expiry timestamps, row count, and column schema. Call this before faostat\_dataframe\_query to discover the exact tab

Measured by MCP Station. Methods: https://mcpstation.net/methods.html · Terms: https://mcpstation.net/terms.html