{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.cyanheads/faostat-mcp-server","description":"UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP.","repository":{"url":"https://github.com/cyanheads/faostat-mcp-server","source":"github"},"version":"0.3.0","packages":[{"registryType":"npm","registryBaseUrl":"https://registry.npmjs.org","identifier":"@cyanheads/faostat-mcp-server","version":"0.3.0","runtimeHint":"npx","transport":{"type":"stdio"},"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":"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.","format":"boolean","default":"false","name":"FAOSTAT_DATAFRAME_DROP_ENABLED"},{"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.3.0","runtimeHint":"npx","transport":{"type":"streamable-http","url":"http://localhost:3010/mcp"},"environmentVariables":[{"description":"Selects the HTTP transport.","format":"string","value":"http","name":"MCP_TRANSPORT_TYPE"},{"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":"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.","format":"boolean","default":"false","name":"FAOSTAT_DATAFRAME_DROP_ENABLED"},{"description":"Sets the minimum log level for output (e.g., 'debug', 'info', 'warn').","format":"string","default":"info","name":"MCP_LOG_LEVEL"}]}],"remotes":[{"type":"streamable-http","url":"https://faostat.caseyjhand.com/mcp"}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-10-04T06:52:01.669144Z","publishedAt":"2026-10-04T06:52:01.669144Z","updatedAt":"2026-10-04T06:52:01.669144Z","isLatest":true}}}