Faostat MCP Server

by cyanheads Your server? Claim it

answering

Faostat MCP Server is answering right now. Last checked 5 min ago. 242 installs a week from npm. It exposes 6 tools. Last commit 19 Sep 2026.

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

Installs per day peak 172 · avg 27 · +431% w/w

a month agotoday

Uptime history 51 days of history · worst day 0%

51 days agonow

98.9%

Uptime 24h

90 of 91 checks

Tools

read from the server

303 ms

Response time

average over 24h

242

Installs / week

npm and PyPI

What changed 13

Every tool that appeared, vanished or quietly changed what it asks for. Recorded since 25 August 2026. No other catalogue keeps this.

19 Sep 4 tools changed the parameters they ask for faostat_commodity_profile, faostat_dataframe_describe, faostat_dataframe_query and 1 more

19 Sep a tool changed version

25 Aug 6 tools changed the parameters they ask for faostat_commodity_profile, faostat_dataframe_describe, faostat_dataframe_query and 3 more

25 Aug a tool description was rewritten faostat_dataframe_describe

25 Aug a tool changed version

Faostat MCP Server does not always answer

Over the last week it answered 98.7% of our checks. We check every 15 minutes, so you hear about the next outage within the hour — not from your users.

Connect this server

Endpoint below is the one we actually reach during checks — not the one copied from a README. Last verified 5 min ago.

Claude Code Claude Desktop Codex Cursor VS Code

run in your terminal

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

~/Library/Application Support/Claude/claude_desktop_config.json

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

~/.codex/config.toml

[mcp_servers.faostat-mcp-server]
url = "https://faostat.caseyjhand.com/mcp"

.cursor/mcp.json

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

.vscode/mcp.json

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

This one needs environment variables set before it will start: MCP_HTTP_HOST (The hostname for the HTTP server.), MCP_HTTP_PORT (The port to run the HTTP server on.), MCP_HTTP_ENDPOINT_PATH (The endpoint path for the MCP server.), MCP_AUTH_MODE (Authentication mode to use: 'none', 'jwt', or 'oauth'.), FAOSTAT_DOMAINS (Comma-separated FAOSTAT domain codes to index into the local mirror.), FAOSTAT_MIRROR_PATH (Directory holding the per-domain SQLite mirror databases and the shared dimension database.), FAOSTAT_BULK_BASE_URL (FAOSTAT bulk-download service base URL (manifest + per-domain ZIPs).), FAOSTAT_REFRESH_CRON (Cron expression for the in-process incremental mirror refresh (HTTP transport only). Omit to disable.), CANVAS_PROVIDER_TYPE (Set to 'duckdb' to enable the DataCanvas SQL surface (default), or 'none' to disable analytical staging.), MCP_LOG_LEVEL (Sets the minimum log level for output (e.g., 'debug', 'info', 'warn').). The author declared them in the registry entry; get the values from the project itself.

Available tools 6

Read directly from the server with tools/list, grouped by what they act on. If a tool disappears, we record the date.

faostat

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. Each ranking is a per-country sum across the resolved items, taken at that country's own latest year with data and grouped by unit so incomparable quantities are never added. The trend is returned inline as year/value points. Country-level only (aggregates excluded). When a required domain is not indexed locally, returns a partial profile with a notice naming the gap rather than failing. The full merged observation set spills to a DataCanvas table for deeper SQL via faostat_dataframe_query.

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 table and column names to reference in SQL. Tables are listed newest-first and paged: pass `name` to describe one table outright, or page with `offset` + `limit` — when the response reports `truncated`, pass the returned `nextOffset` to fetch the rest.

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 inline preview only sampled. Standard DuckDB SQL — joins, aggregates, window functions, CTEs all work. Read-only: writes, DDL, DROP, COPY, PRAGMA, ATTACH, and external-file table functions are rejected; system catalogs (information_schema, sqlite_master, duckdb_*) are denied — list staged tables via faostat_dataframe_describe. Every row carries its data-quality `flag` — commonly A=Official, B=time-series break, E=Estimated, I=Imputed, M=Missing (value cannot exist), T=Unofficial, X=from an international organization, plus others FAOSTAT defines per domain — keep it in projections, treat any unrecognized flag as informational, and never assume it is official.

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 which domains are queryable right now; un-indexed domains exist in the catalog but must be added to FAOSTAT_DOMAINS and re-synced before faostat_query_observations can read them. The catalog runs to ~69 domains with long descriptions, so responses are paged: narrow with `topic` / `indexed_only`, pass `code` to fetch one domain outright, or page with `offset` + `limit` — when the response reports `truncated`, pass the returned `nextOffset` to fetch the rest.

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, economic groupings) are EXCLUDED by default so a naive SUM does not double-count a region with its member countries; set include_aggregates=true to get the regional roll-ups, or pass explicit area_codes to query exactly what you name. Small result sets return inline; large ones spill to a DataCanvas table (returned canvas_id + table_name) for GROUP BY / ranking / time-series analysis via faostat_dataframe_query. Every row carries its flag — commonly A=Official, B=time-series break, E=Estimated, I=Imputed, M=Missing (value cannot exist), T=Unofficial, X=from an international organization, plus others FAOSTAT defines per domain — so honor it, treat any unrecognized flag as informational, and never assume an estimated, imputed, or unrecognized value is official.

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 substring filter, or `code` for an exact-code lookup; omit all three to list the whole dimension. Item and element results are scoped to the requested domain — only codes present in that domain's cube are returned, so a resolved code is always queryable there (areas are shared across domains). Page large listings with `offset` + `limit`: when the response reports `truncated`, pass the returned `nextOffset` to fetch the next page. Every area match is flagged `country` or `aggregate` — aggregates (World, continents, economic groupings — codes ≥ 5000 plus a few curated sub-threshold roll-ups such as China=351, which sums mainland + Taiwan + Hong Kong + Macao) double-count if summed with their member countries, so resolve before querying and exclude aggregates unless you want the regional roll-up.

Endpoints

URL	Transport	State	Latency	Checked
https://faostat.caseyjhand.com/mcp	streamable-http	answering	430 ms	5 min ago

Alternatives to Faostat MCP Server

same job, measured the same way

MCP Sqlite Tools

by spences10

MCP server for local SQLite database operations

108 installs/wk local only

Better Stack MCP

by servosity

Every Better Stack Uptime feature, plus an offline SQLite mirror and cross-resource fleet analytics

local only

Domotz MCP

by servosity

Every Domotz endpoint, plus a local SQLite fleet mirror that answers cross-site questions.

local only

Autotask MCP

by servosity

Every Autotask entity at the command line, plus a local SQLite mirror that answers ticket-aging

local only

Datto RMM MCP

by servosity

Every Datto RMM API operation, plus a local SQLite fleet store and fleet-wide analytics no other

local only

Atera MCP

by servosity

Every Atera RMM + PSA endpoint, plus a local SQLite mirror that answers fleet-health, SLA, and

local only

Huntress MCP

by servosity

Every Huntress endpoint, plus a local SQLite mirror that delivers fleet-wide incident, coverage

local only

LLM Kosh

by rastogivaibhav

Local-first AI memory cartridge with persistent MCP memory for Claude via SQLite FTS5.

85 installs/wk local only

Faostat MCP Server — questions

Answers built from our own checks of this server.

What can Faostat MCP Server do?

It exposes 6 tools, read directly from the server on our last check. Among them: faostat_commodity_profile, faostat_dataframe_describe, faostat_dataframe_query, faostat_list_domains, faostat_query_observations, faostat_resolve_codes. The full list with descriptions is on this page — we take it from the server itself via tools/list, not from a README. How MCP servers expose tools in the first place →

Is Faostat MCP Server working right now?

We send a real MCP handshake every 15 minutes. Over the last 24 hours 90 of 91 checks got a reply (98.9%), average response time 303 ms. The bar chart above shows every period we have measured.

How do I connect Faostat MCP Server?

Copy the ready config from this page — we generate it for Claude Code, Claude Desktop, Codex, Cursor and VS Code, each with the file path that client actually reads. It is a remote server, so there is nothing to install — the client connects to the address.

Does Faostat MCP Server need an API key?

No. Faostat MCP Server completed a full MCP handshake with us as an anonymous client and listed its tools without asking for anything. All 6 of them are readable on this page. This is what we observed, not what the docs claim.

How fast is Faostat MCP Server?

It answers our handshake in 303 ms on average, which is faster than 52% of all working MCP servers we measure. The comparison comes from our own checks across the whole registry, every 15 minutes.

How many people use Faostat MCP Server?

The npm package @cyanheads/faostat-mcp-server was installed 242 times in the last week. Week over week that is +431%. We show installs rather than GitHub stars on purpose: a star is a bookmark, an install is someone actually running it.

Is Faostat MCP Server open source?

Yes — it is published under the Apache-2.0 licence, written in TypeScript, 2 stars on GitHub and 5 open issues. The source link is on this page, so you can read exactly what it does with your data before you connect it.