UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP.
Faostat-mcp-server is an MCP integration. UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP.
The registry lists a streamable-http connection at https://faostat.caseyjhand.com/mcp.
The published npm package is @cyanheads/faostat-mcp-server, version 0.3.0. Its declared MCP transport is stdio.
The package declares 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: Set to 'duckdb' to enable the DataCanvas SQL surface (default), or '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')..
The published npm package is @cyanheads/faostat-mcp-server, version 0.3.0. Its declared MCP transport is streamable-http.
The package declares 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: Set to 'duckdb' to enable the DataCanvas SQL surface (default), or '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')..
Check the maintainer’s instructions for account access, authentication and the supported client configuration. Once connected, inspect the tools your client receives and try a small task that matches the server’s stated purpose. The registry description does not include a verified, complete tool list.
View the publisher’s registry entry · Project repository. This profile uses version 0.3.0 from the registry. Registration identifies the publisher namespace; it does not establish that this is a first-party integration for every service it connects.
Browse related developer tools MCP servers for tools that cover the same kind of work.
| Variable | Description | Required |
|---|---|---|
| FAOSTAT_DOMAINS | Comma-separated FAOSTAT domain codes to index into the local mirror. | Optional |
| FAOSTAT_MIRROR_PATH | Directory holding the per-domain SQLite mirror databases and the shared dimension database. | Optional |
| FAOSTAT_BULK_BASE_URL | FAOSTAT bulk-download service base URL (manifest + per-domain ZIPs). | Optional |
| CANVAS_PROVIDER_TYPE | Set to 'duckdb' to enable the DataCanvas SQL surface (default), or 'none' to disable analytical staging. | 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. | Optional |
| MCP_LOG_LEVEL | Sets the minimum log level for output (e.g., 'debug', 'info', 'warn'). | Optional |
Inspect PostgreSQL schemas and run read-only queries with the archived MCP reference server. Review its maintenance status before choosing it.
Connect the Notion MCP server to search workspace content and work with pages and databases through Notion’s hosted OAuth service.
CData JDBC Driver connects to QuickBooks Online by exposing them as relational SQL models.
Local-first memory for AI coding agents — Markdown + SQLite FTS5, shared across editors via MCP.
Connects Elasticsearch data to any Model Context Protocol (MCP) Client, enabling natural language interaction.
MCP Server for Project Zomboid mod development