MCP server

Faostat

io.github.cyanheads/faostat-mcp-server

Checked 26 Oct 2026, 08:29 UTC · Connected to it and listed its tools

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

Source

At a glance

Type

MCP server

Publisher

Not verified

Status

Working at last check

Tools

6

Token cost

About 4,096 tokens per request

Sets up in

Claude Code, Claude Desktop, Codex, Gemini CLI, Cursor, VS Code, Antigravity, ChatGPT, OpenAI API, Grok

Last checked

26 Oct 2026, 08:29 UTC

Connect it to your agent

Add to CursorAdd to VS CodeVS Code Insiders

Opens the app, which shows the server and asks you to confirm. For other apps, copy the setup below.

Claude Code

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

Claude Desktop

Settings → Connectors → Add custom connector, and paste the URL.

Codex (config.toml)

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

Gemini CLI

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

Cursor

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

VS Code

{"servers":{"faostat-mcp-server":{"type":"http","url":"https://faostat.caseyjhand.com/mcp"}}}

Antigravity

agy mcp add faostat-mcp-server https://faostat.caseyjhand.com/mcp

ChatGPT

Settings → Apps & Connectors → Advanced settings: turn on Developer mode, then Create a connector and paste the URL. Which plans can do this varies.

OpenAI API (Responses tools)

{"type":"mcp","server_label":"faostat-mcp-server","server_url":"https://faostat.caseyjhand.com/mcp","require_approval":"always"}

Grok (xAI API tools)

{"type":"mcp","server_label":"faostat-mcp-server","server_url":"https://faostat.caseyjhand.com/mcp"}

Tools

• faostat_commodity_profile ~691 tokens
  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_describe ~508 tokens
  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
• faostat_dataframe_query ~550 tokens
  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_list_domains ~589 tokens
  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_query_observations ~1002 tokens
  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_resolve_codes ~756 tokens
  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

Browse

• GitHub tools
• Pragma tools
• GitHub and code hosting
• Databases
• Government and public data

Related MCP servers

• Faostat
  FAOSTAT MCP — the UN Food and Agriculture Organization's statistics service.
• Theaslangroupllc Pulsenetwork
  914 paid market-data & token-safety endpoints — keyless x402 USDC: Base, Solana, XRPL, +8 chains
• USDA Food Access
  SNAP participation, food insecurity indicators, and agricultural statistics
• Refnusa
  Indonesia reference data: holidays, wages, regions, postal codes, tax, food prices, KBLI, BPS stats
• Nass
  NASS MCP — USDA National Agricultural Statistics Service (Quick Stats)
• SendGrid MCP by usefulapi
  Send email and read templates, marketing contacts, lists, stats, bounces and unsubscribes.
• Lokal
  Norwegian local-food MCP: 1,500+ farms, shops, markets + umbrellas (Bondens marked, Hanen, REKO).
• Development Indicators MCP
  Open-source MCP for official development indicators with provenance and citations.

Badge for your README

[![AptLynx](https://aptlynx.net/badge/io.github.cyanheads/faostat-mcp-server.svg)](https://aptlynx.net/servers/io.github.cyanheads/faostat-mcp-server)

Listing text is written by the maker; AptLynx lists tools and does not vouch for them. Find another tool · Browse by topic · For agents