Skip to content
MCP server

Faostat MCP Server

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

Install
Pricing
Open source
Runs
Locally or Remotely
Version
0.7.0
Listing updated
5 days ago

About Faostat MCP Server

Faostat MCP Server is an open-source MCP server. It can run locally on your machine or as a hosted remote server.

Install

Run in a terminal

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

Add to Settings → Connectors → Add custom connector

https://faostat.caseyjhand.com/mcp
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "faostat-mcp-server": {
      "url": "https://faostat.caseyjhand.com/mcp"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "faostat-mcp-server": {
      "type": "http",
      "url": "https://faostat.caseyjhand.com/mcp"
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "faostat-mcp-server": {
      "type": "http",
      "url": "https://faostat.caseyjhand.com/mcp"
    }
  }
}

Configuration

  • FAOSTAT_DOMAINSComma-separated FAOSTAT domain codes to index into the local mirror.
  • FAOSTAT_MIRROR_PATHDirectory holding the per-domain SQLite mirror databases and the shared dimension database.
  • FAOSTAT_BULK_BASE_URLFAOSTAT bulk-download service base URL (manifest + per-domain ZIPs).
  • CANVAS_PROVIDER_TYPEDataCanvas engine for SQL over large result sets. Defaults to 'duckdb'; set 'none' to disable analytical staging.
  • FAOSTAT_DATAFRAME_DROP_ENABLEDSet 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.
  • FAOSTAT_CLAMP_LIMITSA count input (limit, top_n, row_limit) above its cap is served at the cap with a notice. Set to 'false' to advertise each cap as a schema maximum and reject a larger value instead.
  • MCP_LOG_LEVELSets the minimum log level for output (e.g., 'debug', 'info', 'warn').
  • MCP_TRANSPORT_TYPESelects the HTTP transport.
  • MCP_HTTP_HOSTThe hostname for the HTTP server.
  • MCP_HTTP_PORTThe port to run the HTTP server on.
  • MCP_HTTP_ENDPOINT_PATHThe endpoint path for the MCP server.
  • MCP_AUTH_MODEAuthentication mode to use: 'none', 'jwt', or 'oauth'.
  • FAOSTAT_DOMAINSComma-separated FAOSTAT domain codes to index into the local mirror.
  • FAOSTAT_MIRROR_PATHDirectory holding the per-domain SQLite mirror databases and the shared dimension database.
  • FAOSTAT_BULK_BASE_URLFAOSTAT bulk-download service base URL (manifest + per-domain ZIPs).
  • FAOSTAT_REFRESH_CRONCron expression for the in-process incremental mirror refresh (HTTP transport only). Omit to disable.
  • CANVAS_PROVIDER_TYPEDataCanvas engine for SQL over large result sets. Defaults to 'duckdb'; set 'none' to disable analytical staging.
  • FAOSTAT_DATAFRAME_DROP_ENABLEDSet 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.
  • FAOSTAT_CLAMP_LIMITSA count input (limit, top_n, row_limit) above its cap is served at the cap with a notice. Set to 'false' to advertise each cap as a schema maximum and reject a larger value instead.
  • MCP_LOG_LEVELSets the minimum log level for output (e.g., 'debug', 'info', 'warn').

Pricing

Open source

Faostat MCP Server FAQ

Is Faostat MCP Server free?

Yes. Faostat MCP Server is open source, so you can use and self-host it for free.

How do I add Faostat MCP Server to Claude Code?

Run this command in your terminal: claude mcp add --transport http faostat-mcp-server https://faostat.caseyjhand.com/mcp