Home/faostat-mcp-server
Hybrid

faostat-mcp-server

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

io.github.cyanheads/faostat-mcp-serverSource repository
Version0.4.0latest catalog version
ConnectionHybridstreamable-http · npm
PublishedOct 18, 2026catalog
UpdatedOct 18, 2026catalog
Overview

What this server provides

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

Connect

Remote endpoints

1
Remote endpoint 1streamable-http
https://faostat.caseyjhand.com/mcp
Open endpoint
Install

Packages

2
Package 1npm
@cyanheads/faostat-mcp-server0.4.0
Runtime npxTransport stdio
  • FAOSTAT_DOMAINS

    Comma-separated FAOSTAT domain codes to index into the local mirror.

    Format: string · Default: QCL,TCL,FBS,FS,RL,GLE,RFN,QV
    Optional
  • FAOSTAT_MIRROR_PATH

    Directory holding the per-domain SQLite mirror databases and the shared dimension database.

    Format: string · Default: ./.faostat-mirror
    Optional
  • FAOSTAT_BULK_BASE_URL

    FAOSTAT bulk-download service base URL (manifest + per-domain ZIPs).

    Format: string · Default: https://bulks-faostat.fao.org/production
    Optional
  • CANVAS_PROVIDER_TYPE

    Set to 'duckdb' to enable the DataCanvas SQL surface (default), or 'none' to disable analytical staging.

    Format: string · Default: duckdb
    Optional
  • 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.

    Format: boolean · Default: false
    Optional
  • MCP_LOG_LEVEL

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

    Format: string · Default: info
    Optional
Package 2npm
@cyanheads/faostat-mcp-server0.4.0
Runtime npxTransport streamable-http
http://localhost:3010/mcp
  • MCP_HTTP_HOST

    The hostname for the HTTP server.

    Format: string · Default: 127.0.0.1
    Optional
  • MCP_HTTP_PORT

    The port to run the HTTP server on.

    Format: string · Default: 3010
    Optional
  • MCP_HTTP_ENDPOINT_PATH

    The endpoint path for the MCP server.

    Format: string · Default: /mcp
    Optional
  • MCP_AUTH_MODE

    Authentication mode to use: 'none', 'jwt', or 'oauth'.

    Format: string · Default: none
    Optional
  • FAOSTAT_DOMAINS

    Comma-separated FAOSTAT domain codes to index into the local mirror.

    Format: string · Default: QCL,TCL,FBS,FS,RL,GLE,RFN,QV
    Optional
  • FAOSTAT_MIRROR_PATH

    Directory holding the per-domain SQLite mirror databases and the shared dimension database.

    Format: string · Default: ./.faostat-mirror
    Optional
  • FAOSTAT_BULK_BASE_URL

    FAOSTAT bulk-download service base URL (manifest + per-domain ZIPs).

    Format: string · Default: https://bulks-faostat.fao.org/production
    Optional
  • FAOSTAT_REFRESH_CRON

    Cron expression for the in-process incremental mirror refresh (HTTP transport only). Omit to disable.

    Format: string
    Optional
  • CANVAS_PROVIDER_TYPE

    Set to 'duckdb' to enable the DataCanvas SQL surface (default), or 'none' to disable analytical staging.

    Format: string · Default: duckdb
    Optional
  • 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.

    Format: boolean · Default: false
    Optional
  • MCP_LOG_LEVEL

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

    Format: string · Default: info
    Optional
View server metadata