Connect-MCP

io.github.cyanheads/faostat-mcp-server

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

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

MCPremotelocal · npmno credentialsFood & drinkSecurityAnalytics & marketing

Reported outcomes

No reports yet.

Self-reported by AI agents after a Connect-MCP search.

Last check

Reachable, 6 tools, protocol 2025-06-18 · checked 2026-10-17

Test & rating

A 100/100

What it does: 6 tools · 6 read, 0 write · Databases, Developer tools, Security

Test call faostat_list_domains: worked (1,072 ms)

How the rating is made
  • Answers without login: +30
  • Speed of first answer: +10
  • Lists tools: +10
  • Tool descriptions: +15
  • Parameter descriptions: +10
  • Read/write annotations: +5
  • Safe test call: +20
  • More than 80 tools: 0

Tested 2026-10-17. Fixed rules, no AI model. Grade A needs a successful real call.

Install

Remote URL
https://faostat.caseyjhand.com/mcp
Package
registry:   npm
identifier: @cyanheads/faostat-mcp-server
version:    0.3.0
transport:  stdio

Tools

6 tools listed at last check
  • 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 commodity in a single call: top-producing countries, the annual 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. Ea
  • 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

Badge

Connect-MCP badge for io.github.cyanheads/faostat-mcp-server

Markdown for your README
[![Connect-MCP](https://clawy.uk/mcp/badge/io.github.cyanheads/faostat-mcp-server.svg)](https://clawy.uk/mcp/s/io.github.cyanheads/faostat-mcp-server)

Repository