Faostat MCP Server - install, status & alternatives [2026]

01 · Install Faostat MCP Server

before you install - you'll need

Set MCP_TRANSPORT_TYPE, MCP_LOG_LEVEL before connecting.

Claude Code

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

Claude Desktop / Cursor / VS Code - add to config

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

Same JSON for Cursor. For VS Code, rename the top-level key from `mcpServers` to `servers`.

Using another client? Same JSON, different key

Claude Desktop · mcpServers

Cursor · mcpServers

VS Code · servers

Windsurf · mcpServers

Zed · context_servers

Cline · mcpServers

Roo Code · mcpServers

Continue · mcpServers

LibreChat · mcpServers

Gemini CLI · mcpServers

Codex CLI · mcp_servers

Full setup guides: every client.

02 · Evidence

https://faostat.caseyjhand.com/mcp

transport: streamable-http

endpoint alive - responded to MCP initialize · probed 2026-09-17

Security posture

What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.

runs as local process (stdio) - runs on your machine with your user's permissions · remote - your agent's requests go to faostat.caseyjhand.com

endpoint auth accepted our unauthenticated MCP initialize - no credentials needed to connect

license Apache-2.0 - declared in the repository

npm package @cyanheads/faostat-mcp-server - published under the repo owner's npm scope (@cyanheads)

registry namespace io.github.cyanheads is GitHub-verified and matches the repo owner

03 · What Faostat MCP Server can do

Prose above is summarized from the project's README and registry record - no invented capabilities.

What you can build

With this server connected, an agent can query a domain's cube by area(s), item(s), element(s), and year range. Inline preview for small results, run a read-only SQL SELECT against the canvas tables staged by the analytical tools, and list the canvas tables staged this session, each with provenance, row count, and column schema.

The 6 tools it gives your agent

Extracted from the project's README - what faostat-mcp-server lets an agent do.

faostat_list_domains: - Discover FAOSTAT statistical domains with codes, descriptions, last-update date, upstream row count, and local index status. The entry point - every query keys
faostat_resolve_codes: - Resolve human terms to the opaque integer codes a query needs (areas, items, elements), flagging each area as a country or an aggregate region.
faostat_query_observations: - Query a domain's cube by area(s), item(s), element(s), and year range. Inline preview for small results; large sets spill to a DataCanvas table.
faostat_commodity_profile: - Workflow: assemble top producers, the production trend, and trade flows for one commodity from the production and trade domains in a single call.
faostat_dataframe_query: - Run a read-only SQL SELECT against the canvas tables staged by the analytical tools.
faostat_dataframe_describe: - List the canvas tables staged this session, each with provenance, row count, and column schema.

Latest releases

v0.2.3 · 2026-08-25

SDK v2 migration, dataframe_describe pagination · MCP 2026-07-28 protocol support alongside 2025-era clients · Tool contracts reject undeclared root inputs and advertise valid structured error envelopes…

v0.2.2 · 2026-07-27

ANALYZE gate reliability fixes · a failed ANALYZE attempt is no longer memoized as success - a domain now retries on the next read, bounded at 3 attempts (#21) · faostat_resolve_codes no longer triggers the statistics…

v0.2.1 · 2026-07-27

Query-planner statistics + limit enforcement for faostat_query_observations · ANALYZE runs on a domain's cube table on first read and after any sync applies rows, so the composite indexes are actually chosen for the…

04 · Who maintains Faostat MCP Server

faostat-mcp-server is maintained by cyanheads. We track 125 MCP servers from cyanheads - 119 actively maintained, 1,816 combined GitHub stars, oldest repo from Dec 2024. Full record: all servers from cyanheads.

05 · Facts

repository: github.com/cyanheads/faostat-mcp-server
category: database - ranked #75 of 168 actively-maintained database servers as of 2026-09-18.
release cadence: 10+ releases in the last 90 days (latest 2026-08-25)
registry: io.github.cyanheads/faostat-mcp-server (active, first published 2026-06-13 · 16 versions)
packages: npm:@cyanheads/faostat-mcp-server · npm:@cyanheads/faostat-mcp-server

06 · Faostat MCP Server FAQ

Is Faostat MCP Server still maintained?

Yes - as of 2026-09-18, its last commit was 2026-08-25 and it shipped 10+ releases in the last 90 days. We re-verify nightly.

What can Faostat MCP Server do?

With this server connected, an agent can query a domain's cube by area(s), item(s), element(s), and year range. Inline preview for small results, run a read-only SQL SELECT against the canvas tables staged by the analytical tools, and list the canvas tables staged this session, each with provenance, row count, and column schema.

How do I install Faostat MCP Server?

Run `npx -y @cyanheads/faostat-mcp-server`. The README documents 2 environment variables (MCP_TRANSPORT_TYPE, MCP_LOG_LEVEL) to set first. Set MCP_TRANSPORT_TYPE, MCP_LOG_LEVEL before connecting. You can also paste the ready-made client config above.

Does Faostat MCP Server require authentication?

No - the endpoint accepted our unauthenticated MCP initialize when probed on 2026-09-17; you can connect without credentials.

07 · Alternatives to Faostat MCP Server

Alternatives to Faostat MCP Server

Maintained database servers if Faostat MCP Server isn't the fit.

Pairs well with

Servers that cover what Faostat MCP Server doesn't - only shown when the pairing reason fits the companion.

More database MCP servers · Data Charter · Dbatools MCP Server · Dbtrail · Mcpg · ClickHouse

More TypeScript MCP servers · Gdelt MCP Server · Git MCP Server · Guardian MCP Server · Gutenberg MCP Server · Hn MCP Server · see all