io.github.cyanheads/faostat-mcp-server

up checked 2026-11-10T21:37:45.396Z

Unclaimed · Unverified

Agent searches it appeared in, last 30 days: 0. Run this server? Claim the listing: verified label, uptime alerts and analytics.

Publisher-provided description

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

Summary by lookupd

Queries UN FAOSTAT food and agriculture statistics from a local mirror, with commodity profiles, trade flows, and SQL analysis of staged…

Install

Claude Code, remote (streamable-http)

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

Claude Code, npm package (stdio)

claude mcp add faostat-mcp-server -- npx -y @cyanheads/faostat-mcp-server

Claude Code, npm package (stdio)

claude mcp add faostat-mcp-server -- npx -y @cyanheads/faostat-mcp-server

Codex, remote (streamable-http)

codex mcp add faostat-mcp-server --url https://faostat.caseyjhand.com/mcp

Codex, npm package (stdio)

codex mcp add faostat-mcp-server -- npx -y @cyanheads/faostat-mcp-server

Codex, npm package (stdio)

codex mcp add faostat-mcp-server -- npx -y @cyanheads/faostat-mcp-server

Cursor, remote (streamable-http) → .cursor/mcp.json

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

Cursor, npm package (stdio) → .cursor/mcp.json

{
  "mcpServers": {
    "faostat-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@cyanheads/faostat-mcp-server"
      ]
    }
  }
}

Cursor, npm package (stdio) → .cursor/mcp.json

{
  "mcpServers": {
    "faostat-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@cyanheads/faostat-mcp-server"
      ]
    }
  }
}

Other clients: docs. Or tell your agent: Set up lookupd for me: read https://lookupd.com/agent.md and follow it.

Tools (6 tools)

Publisher-provided text

• faostat_list_domains Discover FAOSTAT statistical domains (production, trade, food balances, food security, land use, agri-emissions, prices, value) with their codes, descriptions,
• faostat_resolve_codes Resolve labels to the numeric codes or exact alphanumeric item identities faostat_query_observations needs: areas (countries/regions), items (commodities), and
• faostat_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
• faostat_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)
• faostat_dataframe_query Run a single-statement SELECT against canvas tables staged by faostat_query_observations and faostat_commodity_profile (faostat_xxxxxxxx). Use DuckDB joins, agg
• 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 th

Details

• Version: 0.6.0
• Transports: streamable-http, stdio
• Uptime (7 days): 100%
• Median latency: 803 ms
• First indexed: 2026-11-01T09:26:01.399Z
• Last seen in registry: 2026-11-03T22:17:21.325Z
• Repository: https://github.com/cyanheads/faostat-mcp-server

Badge for your README

Shows this live status and links here; updates hourly.

[![lookupd status](https://lookupd.com/badge/io.github.cyanheads/faostat-mcp-server.svg)](https://lookupd.com/servers/io.github.cyanheads/faostat-mcp-server)

• 62092 servers
• Last crawl: 2026-11-11T17:38:11.606Z
• API base: https://api.lookupd.com
• MCP URL: https://api.lookupd.com/mcp