io.github.cyanheads

faostat-mcp-server

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

communityknowledge

Package Details

Transportstdio
Runtimenode

Package Arguments

Positional
Position 0
run
Position 1
start:stdio

Environment Variables

FAOSTAT_DOMAINS(str)
Default:QCL,TCL,FBS,FS,RL,GLE,RFN,QV

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

FAOSTAT_MIRROR_PATH(str)
Default:./.faostat-mirror

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

FAOSTAT_BULK_BASE_URL(str)
Default:https://bulks-faostat.fao.org/production

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

CANVAS_PROVIDER_TYPE(str)
Default:duckdb

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

MCP_LOG_LEVEL(str)
Default:info

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

TransportStreamable HTTP
Runtimenode

Package Arguments

Positional
Position 0
run
Position 1
start:http

Environment Variables

MCP_HTTP_HOST(str)
Default:127.0.0.1

The hostname for the HTTP server.

MCP_HTTP_PORT(str)
Default:3010

The port to run the HTTP server on.

MCP_HTTP_ENDPOINT_PATH(str)
Default:/mcp

The endpoint path for the MCP server.

MCP_AUTH_MODE(str)
Default:none

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

FAOSTAT_DOMAINS(str)
Default:QCL,TCL,FBS,FS,RL,GLE,RFN,QV

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

FAOSTAT_MIRROR_PATH(str)
Default:./.faostat-mirror

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

FAOSTAT_BULK_BASE_URL(str)
Default:https://bulks-faostat.fao.org/production

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

FAOSTAT_REFRESH_CRON(str)

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

CANVAS_PROVIDER_TYPE(str)
Default:duckdb

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

MCP_LOG_LEVEL(str)
Default:info

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