io.github.cyanheads/faostat-mcp-server

io.github.cyanheads/faostat-mcp-serverv0.4.1Databases

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

The current version, v0.4.1, was published to the official MCP registry on 2026-10-25. It is distributed as @cyanheads/faostat-mcp-server on npm and as a hosted remote over streamable-http, filed under Databases by this index, and declares 12 environment variables. Removals and unreachable sources are measured across every server this index tracks, contract drift across the servers that answer in consecutive snapshots; the index's current counts put this record in context.

In-path gate · all MCP tools

Using io.github.cyanheads/faostat-mcp-server in Claude, Cursor, Gemini CLI, Cline, or Zed?

MCP tool contracts can change remotely with no version bump. The mcpindex gate pins each contract and HOLDs the call when it drifts-before your agent acts. Zero credentials. This is not the package install for this server itself (use Install this server for that).

Install the mcpindex gate (one command)

Rewrites your MCP host config so each server launches behind the gate. Inspect first: curl -fsSL https://mcpindex.ai/install.sh | less

uv tool install mcpindex-gate && mcpindex-config-wire

Auditable install path →Watch it hold a drift →

Trust verdict · v1 advisory · method

REVIEWstatus: PARTIALfresh until 2026-11-19 15:09 UTC

screened 2026-10-20tier: scannedgranularity: description-levelsource: registry

Semantic screen found no manipulation pattern in the description. Conformance probe not yet run.

mcpindex.integrity.descriptionpassINFO

evidence“Tool provides FAOSTAT data via local SQLite mirror.”via static_description

Limits of this verdict

- Semantic screen only - the deterministic conformance probe has not run on this server
- Confidence is reported but not yet calibrated (v1)
- Screen reads the tool description, not the live behavior
- advisory
- registry description only no input schema
- screen model 8b
- The registry listing (version, packages, links) changed after this screen ran - the description we assessed did not

Semantic screen: an LLM judge reads the tool description for hidden instructions (status PARTIAL). A pass means the description is not lying, not that the tool is safe: a high-capability tool with an honest description still warrants caution. The deterministic conformance probe has not been run on this server yet, so the screen here is semantic-only. Posture: advisory. Confidences are reported but not yet calibrated (calibrated=false at v1). Full verdict history is not shown on this page.

Own this server? Test a description on the public screen → It is a separate check from the verdict above, so the two can differ.

That verdict was true at screening time (snapshot 2026-10-27).

Contracts can change after screening, with no version bump. The gate pins io.github.cyanheads/faostat-mcp-server’s tool contracts on first sight and holds any silent change before your agent acts - the check that keeps being true on Tuesday.

See your first HOLD in 2 minutes →

Contract drift · crawler-observed · ledger

6 contract changes observedmost recent Mon, 19 Oct 2026 04:00:00 GMTsafety-relevant diff

6 changes with a version change.

what changednew optional inputinput constraint tightenedoutput shape changed

Part of a publisher-wide change of the same kind on 2026-10-19, seen on 13 servers from this publisher.

Part of a publisher-wide change of the same kind on 2026-08-26, seen on 32 servers from this publisher.

Observed by mcpindex’s crawler between daily registry snapshots - a contract diff, not a safety verdict, and not an in-path prevention (that is the gate). A “safety-relevant diff” touches a safety-relevant field; it is not a confirmed vulnerability. Shown at the server level; individual tools are not named. Absence is not a clean bill of health: only public-registry servers are crawled.

Cite this record

People vet a server before wiring it in. One line on your project site or docs answers that with an independent record: screening verdict, registry provenance, contract drift history. It stays current as new screens and drift events land.

Markdown

[Independent trust record for io.github.cyanheads/faostat-mcp-server](https://mcpindex.ai/server/io-github-cyanheads-faostat-mcp-server) - screening verdict, registry provenance, and contract drift monitoring.

HTML

<a href="https://mcpindex.ai/server/io-github-cyanheads-faostat-mcp-server">Independent trust record for io.github.cyanheads/faostat-mcp-server</a> - screening verdict, registry provenance, and contract drift monitoring.

Embed this badge

A live verdict badge for your README or listing. It reflects the current screen, links back here, and updates when the verdict does.

Markdown

[![mcpindex](https://mcpindex.ai/api/v1/badge/io-github-cyanheads-faostat-mcp-server)](https://mcpindex.ai/server/io-github-cyanheads-faostat-mcp-server)

HTML

<a href="https://mcpindex.ai/server/io-github-cyanheads-faostat-mcp-server"><img src="https://mcpindex.ai/api/v1/badge/io-github-cyanheads-faostat-mcp-server" alt="mcpindex verdict" height="20" /></a>

Environment variables

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).

CANVAS_PROVIDER_TYPE

DataCanvas engine for SQL over large result sets. Defaults to 'duckdb'; set 'none' to disable analytical staging.

FAOSTAT_DATAFRAME_DROP_ENABLED

Set 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_LEVEL

Sets the minimum log level for output (e.g., 'debug', 'info', 'warn').

MCP_TRANSPORT_TYPE

Selects the HTTP transport.

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

DataCanvas engine for SQL over large result sets. Defaults to 'duckdb'; set 'none' to disable analytical staging.

FAOSTAT_DATAFRAME_DROP_ENABLED

Set 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_LEVEL

Sets the minimum log level for output (e.g., 'debug', 'info', 'warn').

MCP quality score · maturity, not trust · methodology

freshness

completeness

installability

documentation

stability

Alternatives in Databases

briq

cloud.briq/briq

Give your agent its own cloud: Postgres, Redis, a sandbox or any Docker image, in one MCP call.

WoWSQL

com.wowsql/mcp

Managed Postgres MCP: projects, SQL, docs search, and storage buckets via OAuth.

io.github.cybeleri/database-admin

Database admin MCP: schema inspection, query optimization for PostgreSQL and MySQL

Install this server

Remote endpoint

Streamable HTTP / SSE endpoint. Add to any MCP client that supports remote servers.

https://faostat.caseyjhand.com/mcp

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "faostat-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "--",
        "@cyanheads/faostat-mcp-server"
      ],
      "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",
        "MCP_TRANSPORT_TYPE": "<mcp_transport_type>",
        "MCP_HTTP_HOST": "127.0.0.1",
        "MCP_HTTP_PORT": "3010",
        "MCP_HTTP_ENDPOINT_PATH": "/mcp",
        "MCP_AUTH_MODE": "none",
        "FAOSTAT_REFRESH_CRON": "<faostat_refresh_cron>"
      }
    }
  }
}

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "faostat-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "--",
        "@cyanheads/faostat-mcp-server"
      ],
      "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",
        "MCP_TRANSPORT_TYPE": "<mcp_transport_type>",
        "MCP_HTTP_HOST": "127.0.0.1",
        "MCP_HTTP_PORT": "3010",
        "MCP_HTTP_ENDPOINT_PATH": "/mcp",
        "MCP_AUTH_MODE": "none",
        "FAOSTAT_REFRESH_CRON": "<faostat_refresh_cron>"
      }
    }
  }
}

Cline (cline_mcp_settings.json)

{
  "mcpServers": {
    "faostat-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "--",
        "@cyanheads/faostat-mcp-server"
      ],
      "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",
        "MCP_TRANSPORT_TYPE": "<mcp_transport_type>",
        "MCP_HTTP_HOST": "127.0.0.1",
        "MCP_HTTP_PORT": "3010",
        "MCP_HTTP_ENDPOINT_PATH": "/mcp",
        "MCP_AUTH_MODE": "none",
        "FAOSTAT_REFRESH_CRON": "<faostat_refresh_cron>"
      }
    }
  }
}

Zed (~/.config/zed/settings.json)

Merge into the context_servers block of your Zed settings.

{
  "context_servers": {
    "faostat-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "--",
        "@cyanheads/faostat-mcp-server"
      ],
      "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",
        "MCP_TRANSPORT_TYPE": "<mcp_transport_type>",
        "MCP_HTTP_HOST": "127.0.0.1",
        "MCP_HTTP_PORT": "3010",
        "MCP_HTTP_ENDPOINT_PATH": "/mcp",
        "MCP_AUTH_MODE": "none",
        "FAOSTAT_REFRESH_CRON": "<faostat_refresh_cron>"
      }
    }
  }
}

Claude Code (claude mcp add)

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

Gemini CLI (gemini mcp add)

gemini mcp add -s user faostat-mcp-server npx -y -- @cyanheads/faostat-mcp-server

Verdict API

curl -s mcpindex.ai/api/v1/trust/server/io-github-cyanheads-faostat-mcp-server

Free-tier verdict as JSON: decision + dimensions + severity. Call it from your agent before it invokes a tool it just discovered.

Details

version: v0.4.1
category: Databases
verdict expires: 2026-11-19
quality: 80 / 100
operator: cyanheads

Listing

Listed from the official MCP registry. Unclaimed by its maintainer. Maintainer? Verify it → · or email us →

Provenance

Each verdict is bound to a hash of the exact description it judged, so a re-crawl that changes the text produces a new record rather than silently inheriting this one. Verdict history is hash-chained and anchored to Bitcoin via OpenTimestamps (latest confirmed at block 973,343). Verify it yourself.

Links

Repository →

Remote endpoint

https://faostat.caseyjhand.com/mcp