io.github.cyanheads/faostat-mcp-server

io.github.cyanheads/faostat-mcp-server

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

Connect this server

Add this to your MCP client config — claude_desktop_config.json (Claude Desktop) or .cursor/mcp.json (Cursor).Suits: Claude Desktop · Cursor.

{
  "mcpServers": {
    "faostat-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@cyanheads/faostat-mcp-server@0.6.0"
      ],
      "env": {
        "FAOSTAT_DOMAINS": "QCL,TCL,FBS,FS,RL,GLE,RFN,QV",
        "FAOSTAT_MIRROR_PATH": "./.faostat-mirror",
        "FAOSTAT_BULK_BASE_URL": "https://bulks-faostat.fao.org/production",
        "CANVAS_PROVIDER_TYPE": "duckdb",
        "FAOSTAT_DATAFRAME_DROP_ENABLED": "false",
        "MCP_LOG_LEVEL": "info"
      }
    }
  }
}
Environment variables
  • FAOSTAT_DOMAINSComma-separated FAOSTAT domain codes to index into the local mirror.
  • FAOSTAT_MIRROR_PATHDirectory holding the per-domain SQLite mirror databases and the shared dimension database.
  • FAOSTAT_BULK_BASE_URLFAOSTAT bulk-download service base URL (manifest + per-domain ZIPs).
  • CANVAS_PROVIDER_TYPEDataCanvas engine for SQL over large result sets. Defaults to 'duckdb'; set 'none' to disable analytical staging.
  • FAOSTAT_DATAFRAME_DROP_ENABLEDSet to 'true' to make faostat_dataframe_drop callable, so a staged table can be dropped before its 2-hour TTL. Off by default: the tool is registered disabled.
  • MCP_LOG_LEVELSets the minimum log level for output (e.g., 'debug', 'info', 'warn').

A starting point — check the repository for exact arguments and setup. Restart your client after editing the config.

Category
Developer Tools
Version
0.6.0
Registry
active
Published
11/3/2026

Remotes

  • streamable-httphttps://faostat.caseyjhand.com/mcp
Browse all Developer Tools →

Add the badge to your site

Show visitors that io.github.cyanheads/faostat-mcp-server is listed here — it’s also the link we check for a free listing.

io.github.cyanheads/faostat-mcp-server — listed on Serverdex

HTML — for your website

<a href="https://serverdex.io/server/io-github-cyanheads-faostat-mcp-server?utm_source=badge"><img src="https://serverdex.io/brand/badge.svg" alt="io.github.cyanheads/faostat-mcp-server — listed on Serverdex" width="123" height="40" loading="lazy"></a>

Recommended. A dofollow link from your own domain is the one that counts for search engines, and it's the link we check for a free listing.

Markdown — for your README

[![io.github.cyanheads/faostat-mcp-server — listed on Serverdex](https://serverdex.io/brand/badge.svg)](https://serverdex.io/server/io-github-cyanheads-faostat-mcp-server?utm_source=badge)

Nice for visibility, but GitHub marks README links nofollow, so it doesn't pass authority. Use the HTML badge on your site as well.