faostat-mcp-server
UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP
What you can do with it
Share of each task's required capabilities it coversPrefer a ready-made agent?
An MCP server is a connector for your own assistant. These finished products do the job for you: query databases in plain language.Similar tools
Listed for the same task: query databases in plain languageReviews
No review yet. Used faostat-mcp-server? Be the first to help others choose.What it does
faostat-mcp-server is an MCP server, a connector that lets an AI assistant use it as a tool. It can be used hosted (nothing to install) or installed locally.
From the publisher's description, Electra Index matched it to one capability: sql querying. That makes it a candidate for tasks such as query databases in plain language or build data pipelines.
Facts come from the Official MCP Registry, as declared by the publisher. Capabilities are matched automatically (low confidence). None of this is a test of the tool.
At a glance
How to connect
As declared in the Official MCP Registry · hosted endpoint tested by Electra Index 2d ago (live check)Hosted endpoint
https://faostat.caseyjhand.com/mcpstreamable-http
In Claude Code: claude mcp add --transport http faostat-mcp-server https://faostat.caseyjhand.com/mcp
Install packages
- NPM
@cyanheads/faostat-mcp-serverv0.7.0 · runs locally (stdio) - NPM
@cyanheads/faostat-mcp-serverv0.7.0 · runs as a server (streamable-http)
MCP settings (Claude Desktop, Cursor and other MCP clients)
{
"mcpServers": {
"faostat-mcp-server": {
"url": "https://faostat.caseyjhand.com/mcp"
}
}
}Live check
Electra Index connected to the hosted endpoint 2d agoONLINE faostat-mcp-server answered an MCP connection on 13 Nov 2026 and introduced itself as faostat-mcp-server 0.6.0 (MCP protocol 2025-06-18).
6 tools offered to AI assistants
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 ofaostat_resolve_codes· Resolve labels to the numeric codes or exact alphanumeric item identities faostat_query_observations needs: areas (countries/regions), items (commodities), and elements (metrics). Use query for full-text matching, name_contains for substrinfaostat_query_observations· Query a FAOSTAT domain's data cube by area(s), item(s), element(s), sources, and year range, returning values with units and data-quality flags. Resolve numeric codes or exact alphanumeric item identities with faostat_resolve_codes; elementfaostat_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 selefaostat_dataframe_query· Run a single-statement SELECT against canvas tables staged by faostat_query_observations and faostat_commodity_profile (faostat_xxxxxxxx). Use DuckDB joins, aggregates, window functions, and CTEs for rankings and time-series analysis. Itemfaostat_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 t
What "online" means: the server answered an MCP connection at the time of the check. It is not a guarantee of security, quality or continuous uptime. How we test: we open an MCP session and ask for the tool list, as an AI assistant would. We never run a tool and never send a key. Checked every few days. Method
Is this your server? Monitoring Pro: a check every 30 minutes and an email within the hour when it stops answering. Launch offer: $39.99 once, for life.
Facts & evidence
Each fact shows where it was seen and when.| Fact | Value | Evidence | Source | Last confirmed |
|---|---|---|---|---|
| Install package | @cyanheads/faostat-mcp-server, @cyanheads/faostat-mcp-server | DECLARED | SRC-001 Official MCP Registry | 2d ago |
| Version | 0.7.0 | DECLARED | SRC-001 Official MCP Registry | 2d ago |
| Hosted endpoint | https://faostat.caseyjhand.com/mcp | DECLARED | SRC-001 Official MCP Registry | 2d ago |
| Package registries | npm | DECLARED | SRC-001 Official MCP Registry | 2d ago |
| Local install (package) | yes | DECLARED | SRC-001 Official MCP Registry | 2d ago |
| Remote access (hosted) | yes | DECLARED | SRC-001 Official MCP Registry | 2d ago |
| Repository | https://github.com/cyanheads/faostat-mcp-server | DECLARED | SRC-001 Official MCP Registry | 2d ago |
| Registry status | active | DECLARED | SRC-001 Official MCP Registry | 2d ago |
| MCP server | yes | DECLARED | SRC-001 Official MCP Registry | 2d ago |
Change history
- VERSION13 Nov 20260.6.0 → 0.7.0
- VERSION03 Nov 20260.5.0 → 0.6.0
- VERSION28 Oct 20260.4.1 → 0.5.0
- VERSION25 Oct 20260.4.0 → 0.4.1
- VERSION18 Oct 20260.3.0 → 0.4.0
- VERSION04 Oct 20260.2.5 → 0.3.0
- VERSION30 Sept 20260.2.4 → 0.2.5
Is this page accurate?
Flag it and our robot re-checks the official source. Reports never change a score.Is faostat-mcp-server still online?
Free alerts · no account▲ 0Do you run faostat-mcp-server? Know when it stops answering
For publishers · optionalIts hosted endpoint can be monitored. Monitoring Pro connects every 30 minutes like an AI assistant, emails you within the hour when it stops answering, keeps a 90-day availability history and adds your answer rate to your badge.
Monitoring never changes a score or a rank.
Questions about faostat-mcp-server
How do I connect faostat-mcp-server?
Use the hosted endpoint https://faostat.caseyjhand.com/mcp in your assistant's MCP settings. The exact settings are in "How to connect" above, as declared in the Official MCP Registry.
What tools does faostat-mcp-server offer?
When Electra Index connected on 13 Nov 2026, it listed 6 tools: faostat_list_domains, faostat_resolve_codes, faostat_query_observations, faostat_commodity_profile, faostat_dataframe_query, faostat_dataframe_describe. The full list is in "Live check" above.
Is faostat-mcp-server online?
Yes. Its hosted endpoint answered an MCP connection from Electra Index 2d ago.
What can I use faostat-mcp-server for?
Based on its description, it is most relevant to: query databases in plain language, build data pipelines.