All servers · Markets & trading · Databases · Datasets & public data

io.github.cyanheads/faostat-mcp-server

io.github.cyanheads/faostat-mcp-server · v0.4.0

Measured by MCP Station

Description written by the publisher, not verified

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

Connect

claude mcp add --transport http faostat-mcp-server https://faostat.caseyjhand.com/mcp

{
  "mcpServers": {
    "faostat-mcp-server": {
      "url": "https://faostat.caseyjhand.com/mcp"
    }
  }
}

Tools as reported by the server

• 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

Tool changes

• 2026-10-18: faostat_list_domains, faostat_resolve_codes, faostat_query_observations, faostat_commodity_profile, faostat_dataframe_query, faostat_dataframe_describe
• 2026-10-16: faostat_list_domains, faostat_resolve_codes, faostat_query_observations, faostat_commodity_profile, faostat_dataframe_query, faostat_dataframe_describe

Repository · JSON · Text for agents · Registry updated 2026-10-18