Skip to content
Squatch MCP
Sign in

io.github.cyanheads/faostat-mcp-server

io.github.cyanheads/faostat-mcp-server

by io.github.cyanheads· v0.7.0Source: Official MCP Registry
Sign in to watchSign in to claim this server

All versions

VersionRegistry status
0.7.0latestActive
0.6.0Active
0.5.0Active
0.4.1Active
0.4.0Active
0.3.0Active
0.2.5Active
0.2.4Active
0.2.3Active
0.2.2Active
0.2.1Active
0.2.0Active
0.1.9Active
0.1.8Active
0.1.7Active
0.1.6Active
0.1.5Active
0.1.4Active
0.1.3Active
0.1.2Active
0.1.11Active
0.1.10Active
0.1.1Active
0.1.0Active

Version details

Version
0.7.0
Source
Source: Official MCP Registry
Published
Registry last updated
First observed by Squatch
Content fingerprint
16ed219e39d408dd74a984518c55f7205d27294cb24beb89d465f42d28154b57

Transports in this version

  • remotestreamable-httphttps://faostat.caseyjhand.com/mcpNo authentication
  • packagestdionpm @cyanheads/faostat-mcp-serverUnknown
  • packagestreamable-httpnpm @cyanheads/faostat-mcp-serverUnknown
Registry metadata (server.json, sanitized)
{
  "_meta": {
    "io.modelcontextprotocol.registry/official": {
      "status": "active",
      "isLatest": true,
      "updatedAt": "2026-11-13T19:20:25.982572Z",
      "publishedAt": "2026-11-13T19:20:25.982572Z",
      "statusChangedAt": "2026-11-13T19:20:25.982572Z"
    }
  },
  "server": {
    "name": "io.github.cyanheads/faostat-mcp-server",
    "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
    "remotes": [
      {
        "url": "https://faostat.caseyjhand.com/mcp",
        "type": "streamable-http"
      }
    ],
    "version": "0.7.0",
    "packages": [
      {
        "version": "0.7.0",
        "transport": {
          "type": "stdio"
        },
        "identifier": "@cyanheads/faostat-mcp-server",
        "runtimeHint": "npx",
        "registryType": "npm",
        "registryBaseUrl": "https://registry.npmjs.org",
        "environmentVariables": [
          {
            "name": "FAOSTAT_DOMAINS",
            "format": "string",
            "default": "QCL,TCL,FBS,FS,RL,GLE,RFN,QV",
            "description": "Comma-separated FAOSTAT domain codes to index into the local mirror."
          },
          {
            "name": "FAOSTAT_MIRROR_PATH",
            "format": "string",
            "default": "./.faostat-mirror",
            "description": "Directory holding the per-domain SQLite mirror databases and the shared dimension database."
          },
          {
            "name": "FAOSTAT_BULK_BASE_URL",
            "format": "string",
            "default": "https://bulks-faostat.fao.org/production",
            "description": "FAOSTAT bulk-download service base URL (manifest + per-domain ZIPs)."
          },
          {
            "name": "CANVAS_PROVIDER_TYPE",
            "format": "string",
            "default": "duckdb",
            "description": "DataCanvas engine for SQL over large result sets. Defaults to 'duckdb'; set 'none' to disable analytical staging."
          },
          {
            "name": "FAOSTAT_DATAFRAME_DROP_ENABLED",
            "format": "boolean",
            "default": "false",
            "description": "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."
          },
          {
            "name": "FAOSTAT_CLAMP_LIMITS",
            "format": "boolean",
            "default": "true",
            "description": "A 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."
          },
          {
            "name": "MCP_LOG_LEVEL",
            "format": "string",
            "default": "info",
            "description": "Sets the minimum log level for output (e.g., 'debug', 'info', 'warn')."
          }
        ]
      },
      {
        "version": "0.7.0",
        "transport": {
          "url": "http://localhost:3010/mcp",
          "type": "streamable-http"
        },
        "identifier": "@cyanheads/faostat-mcp-server",
        "runtimeHint": "npx",
        "registryType": "npm",
        "registryBaseUrl": "https://registry.npmjs.org",
        "environmentVariables": [
          {
            "name": "MCP_TRANSPORT_TYPE",
            "value": "http",
            "format": "string",
            "description": "Selects the HTTP transport."
          },
          {
            "name": "MCP_HTTP_HOST",
            "format": "string",
            "default": "127.0.0.1",
            "description": "The hostname for the HTTP server."
          },
          {
            "name": "MCP_HTTP_PORT",
            "format": "string",
            "default": "3010",
            "description": "The port to run the HTTP server on."
          },
          {
            "name": "MCP_HTTP_ENDPOINT_PATH",
            "format": "string",
            "default": "/mcp",
            "description": "The endpoint path for the MCP server."
          },
          {
            "name": "MCP_AUTH_MODE",
            "format": "string",
            "default": "none",
            "description": "Authentication mode to use: 'none', 'jwt', or 'oauth'."
          },
          {
            "name": "FAOSTAT_DOMAINS",
            "format": "string",
            "default": "QCL,TCL,FBS,FS,RL,GLE,RFN,QV",
            "description": "Comma-separated FAOSTAT domain codes to index into the local mirror."
          },
          {
            "name": "FAOSTAT_MIRROR_PATH",
            "format": "string",
            "default": "./.faostat-mirror",
            "description": "Directory holding the per-domain SQLite mirror databases and the shared dimension database."
          },
          {
            "name": "FAOSTAT_BULK_BASE_URL",
            "format": "string",
            "default": "https://bulks-faostat.fao.org/production",
            "description": "FAOSTAT bulk-download service base URL (manifest + per-domain ZIPs)."
          },
          {
            "name": "FAOSTAT_REFRESH_CRON",
            "format": "string",
            "description": "Cron expression for the in-process incremental mirror refresh (HTTP transport only). Omit to disable."
          },
          {
            "name": "CANVAS_PROVIDER_TYPE",
            "format": "string",
            "default": "duckdb",
            "description": "DataCanvas engine for SQL over large result sets. Defaults to 'duckdb'; set 'none' to disable analytical staging."
          },
          {
            "name": "FAOSTAT_DATAFRAME_DROP_ENABLED",
            "format": "boolean",
            "default": "false",
            "description": "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."
          },
          {
            "name": "FAOSTAT_CLAMP_LIMITS",
            "format": "boolean",
            "default": "true",
            "description": "A 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."
          },
          {
            "name": "MCP_LOG_LEVEL",
            "format": "string",
            "default": "info",
            "description": "Sets the minimum log level for output (e.g., 'debug', 'info', 'warn')."
          }
        ]
      }
    ],
    "repository": {
      "url": "https://github.com/cyanheads/faostat-mcp-server",
      "source": "github"
    },
    "description": "UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP."
  }
}