MCP Server MCP

io.github.cyanheads/faostat-mcp-server

By github 👁 1 views ▲ 0 votes

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

Homepage Verified source GitHub

Install

npx -y @cyanheads/[email protected]

Configuration Example

{
  "remotes": [
    {
      "type": "streamable-http",
      "url": "https://faostat.caseyjhand.com/mcp"
    }
  ],
  "packages": [
    {
      "registryType": "npm",
      "registryBaseUrl": "https://registry.npmjs.org",
      "identifier": "@cyanheads/faostat-mcp-server",
      "version": "0.2.2",
      "runtimeHint": "node",
      "transport": {
        "type": "stdio"
      },
      "packageArguments": [
        {
          "value": "run",
          "type": "positional"
        },
        {
          "value": "start:stdio",
          "type": "positional"
        }
      ],
      "environmentVariables": [
        {
          "description": "Comma-separated FAOSTAT domain codes to index into the local mirror.",
          "format": "string",
          "default": "QCL,TCL,FBS,FS,RL,GLE,RFN,QV",
          "name": "FAOSTAT_DOMAINS"
        },
        {
          "description": "Directory holding the per-domain SQLite mirror databases and the shared dimension database.",
          "format": "string",
          "default": "./.faostat-mirror",
          "name": "FAOSTAT_MIRROR_PATH"
        },
        {
          "description": "FAOSTAT bulk-download service base URL (manifest + per-domain ZIPs).",
          "format": "string",
          "default": "https://bulks-faostat.fao.org/production",
          "name": "FAOSTAT_BULK_BASE_URL"
        },
        {
          "description": "Set to 'duckdb' to enable the DataCanvas SQL surface (default), or 'none' to disable analytical staging.",
          "format": "string",
          "default": "duckdb",
          "name": "CANVAS_PROVIDER_TYPE"
        },
        {
          "description": "Sets the minimum log level for output (e.g., 'debug', 'info', 'warn').",
          "format": "string",
          "default": "info",
          "name": "MCP_LOG_LEVEL"
        }
      ]
    },
    {
      "registryType": "npm",
      "registryBaseUrl": "https://registry.npmjs.org",
      "identifier": "@cyanheads/faostat-mcp-server",
      "version": "0.2.2",
      "runtimeHint": "node",
      "transport": {
        "type": "streamable-http",
        "url": "http://localhost:3010/mcp"
      },
      "packageArguments": [
        {
          "value": "run",
          "type": "positional"
        },
        {
          "value": "start:http",
          "type": "positional"
        }
      ],
      "environmentVariables": [
        {
          "description": "The hostname for the HTTP server.",
          "format": "string",
          "default": "127.0.0.1",
          "name": "MCP_HTTP_HOST"
        },
        {
          "description": "The port to run the HTTP server on.",
          "format": "string",
          "default": "3010",
          "name": "MCP_HTTP_PORT"
        },
        {
          "description": "The endpoint path for the MCP server.",
          "format": "string",
          "default": "/mcp",
          "name": "MCP_HTTP_ENDPOINT_PATH"
        },
        {
          "description": "Authentication mode to use: 'none', 'jwt', or 'oauth'.",
          "format": "string",
          "default": "none",
          "name": "MCP_AUTH_MODE"
        },
        {
          "description": "Comma-separated FAOSTAT domain codes to index into the local mirror.",
          "format": "string",
          "default": "QCL,TCL,FBS,FS,RL,GLE,RFN,QV",
          "name": "FAOSTAT_DOMAINS"
        },
        {
          "description": "Directory holding the per-domain SQLite mirror databases and the shared dimension database.",
          "format": "string",
          "default": "./.faostat-mirror",
          "name": "FAOSTAT_MIRROR_PATH"
        },
        {
          "description": "FAOSTAT bulk-download service base URL (manifest + per-domain ZIPs).",
          "format": "string",
          "default": "https://bulks-faostat.fao.org/production",
          "name": "FAOSTAT_BULK_BASE_URL"
        },
        {
          "description": "Cron expression for the in-process incremental mirror refresh (HTTP transport only). Omit to disable.",
          "format": "string",
          "name": "FAOSTAT_REFRESH_CRON"
        },
        {
          "description": "Set to 'duckdb' to enable the DataCanvas SQL surface (default), or 'none' to disable analytical staging.",
          "format": "string",
          "default": "duckdb",
          "name": "CANVAS_PROVIDER_TYPE"
        },
        {
          "description": "Sets the minimum log level for output (e.g., 'debug', 'info', 'warn').",
          "format": "string",
          "default": "info",
          "name": "MCP_LOG_LEVEL"
        }
      ]
    }
  ]
}

mcp model-context-protocol streamable-http npm