{"data":{"name":"io.github.cyanheads/faostat-mcp-server","title":null,"description":"UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP.","version":"0.4.0","websiteUrl":null,"repositoryUrl":"https://github.com/cyanheads/faostat-mcp-server","remotes":[{"url":"https://faostat.caseyjhand.com/mcp","type":"streamable-http"}],"packages":[{"version":"0.4.0","identifier":"@cyanheads/faostat-mcp-server","runtimeHint":"stdio","registryType":"npm","runtimeArguments":null,"environmentVariables":null},{"version":"0.4.0","identifier":"@cyanheads/faostat-mcp-server","runtimeHint":"streamable-http","registryType":"npm","runtimeArguments":null,"environmentVariables":null}],"status":"active","isLatest":true,"publishedAt":"2026-10-18T06:50:14.214Z","updatedAt":"2026-10-18T06:50:14.214Z","source":"official-registry","verification":"official","confidence":100,"stars":null,"sources":[{"stars":null,"title":null,"source":"official-registry","sourceId":"io.github.cyanheads/faostat-mcp-server","updatedAt":"2026-10-18T06:50:14.214Z","confidence":100,"websiteUrl":null,"description":"UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP.","verification":"official","repositoryUrl":"https://github.com/cyanheads/faostat-mcp-server"}],"toolIndex":{"tools":[{"serverName":"io.github.cyanheads/faostat-mcp-server","endpointFingerprint":"586ea3160d1bcd56b3627dfdd0d8f3ad6f8e559ff4021dc6cf62dbca22ef49fc","name":"faostat_commodity_profile","title":"faostat-mcp-server: commodity profile","description":"Assemble a global profile for one QCL item in a single call: top-producing countries, the annual trend, and trade flows (top exporters and importers). The elements follow what the item carries: Production (5510) and tonne trade quantities (5610/5910) for an item with Production; for live-animal items, which have none, their Stocks elements and every trade quantity element they carry. ranking_elements names each ranking's elements and units. Supply item_code or item_query; code wins when both are supplied. A query selects a unique normalized exact label, otherwise a unique relevance match; ambiguous queries require an explicit code. Each ranking uses the selected item at each country's own latest year with data, grouped by unit. The trend is returned inline as year/value points. Country-level only (aggregates excluded). QCL is required; unavailable TCL yields a profile without trade, with a notice. When the merged observation set is too large to inline, it spills to a DataCanvas table (canvas_id + table_name) — call faostat_dataframe_describe for its columns, then faostat_dataframe_query for deeper SQL.","inputSchema":{"type":"object","properties":{"item_code":{"description":"Exact item code present in QCL; takes precedence over item_query. Obtain it from faostat_resolve_codes with domain QCL and dimension item.","type":"integer","minimum":1,"maximum":9007199254740991},"item_query":{"description":"Commodity label or search term (e.g. \"Wheat\"). A unique normalized exact QCL label wins, otherwise the relevance search must match exactly one item. Broad queries such as \"maize\" or \"milk\" require item_code. Supply this or item_code.","type":"string","minLength":1},"year_start":{"description":"Inclusive start year (e.g. 1990) for the rankings, the trend, and the staged rows. An area with no data from this year on drops out of the rankings; set it to a ranking's latest year to keep only current rows.","type":"integer","minimum":-9007199254740991,"maximum":9007199254740991},"year_end":{"description":"Inclusive end year (e.g. 2022) for the rankings, the trend, and the staged rows; each area then ranks at its latest year up to this one.","type":"integer","minimum":-9007199254740991,"maximum":9007199254740991},"top_n":{"default":10,"description":"Rows in each ranking (top producers, exporters, importers), at most 50 per call.","type":"integer","minimum":1},"canvas_id":{"description":"Canvas ID to stage onto, as returned by a prior faostat_query_observations / faostat_commodity_profile call — exactly 10 characters of letters, digits, hyphens, and underscores. Omit to stage onto this session’s canvas, created on the first spill and reused by every later call, so tables staged earlier in the session sit alongside this one.","type":"string","pattern":"^[A-Za-z0-9_-]{10}$"}},"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":false,"openWorldHint":false},"definitionHash":"203260e5f3185924df2e2d76310947df83f3aa011b49f7c57639e928a4834691","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T07:46:38.235Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/faostat-mcp-server","endpointFingerprint":"586ea3160d1bcd56b3627dfdd0d8f3ad6f8e559ff4021dc6cf62dbca22ef49fc","name":"faostat_dataframe_describe","title":"faostat-mcp-server: dataframe describe","description":"List the canvas tables (faostat_xxxxxxxx) staged by faostat_query_observations and faostat_commodity_profile, each with its source tool, the query parameters that produced it, creation/expiry timestamps, row count, and column schema. Call this before faostat_dataframe_query to discover the exact table and column names to reference in SQL. Tables are listed newest-first and paged: pass `name` to describe one table outright, or page with `offset` + `limit` — when the response reports `truncated`, pass the returned `nextOffset` to fetch the rest.","inputSchema":{"type":"object","properties":{"canvas_id":{"description":"Optional canvas ID as returned by a prior faostat_query_observations / faostat_commodity_profile call — exactly 10 characters of letters, digits, hyphens, and underscores. Omit to list the tables staged in this session (the common case).","type":"string","pattern":"^[A-Za-z0-9_-]{10}$"},"name":{"description":"Optional table name (faostat_xxxxxxxx) to describe a single staged table. Takes precedence over `offset` / `limit`, which are ignored for a name lookup (always single-page).","type":"string"},"limit":{"default":20,"description":"Staged tables to return on this page, at most 100 per call. Each entry carries a full column schema, so the default keeps a discovery call small.","type":"integer","minimum":1},"offset":{"default":0,"description":"Zero-based pagination offset into the staged tables (newest first). When the response reports truncated, pass the returned nextOffset here to fetch the next page. Ignored for `name` lookups.","type":"integer","minimum":0,"maximum":9007199254740991}},"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":true,"openWorldHint":false},"definitionHash":"e82d03568fe17162e5d2e229cf4266eae17afc4cb9ff96344eab460a01244c1f","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T07:46:38.235Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/faostat-mcp-server","endpointFingerprint":"586ea3160d1bcd56b3627dfdd0d8f3ad6f8e559ff4021dc6cf62dbca22ef49fc","name":"faostat_dataframe_query","title":"faostat-mcp-server: dataframe query","description":"Run a single-statement SELECT against canvas tables staged by faostat_query_observations and faostat_commodity_profile (faostat_xxxxxxxx). Use DuckDB joins, aggregates, window functions, and CTEs for rankings and time-series analysis. Item groups can overlap their members even with matching units; do not sum them together, and resolver kind=null does not establish safe-to-sum. Separate source methodologies and respect bounded values and multi-year periods. Read-only: writes, DDL, DROP, COPY, PRAGMA, ATTACH, and external-file functions are rejected; system catalogs are denied. List tables and columns with faostat_dataframe_describe. Preserve data-quality flags in projections: commonly A=Official, B=time-series break, E=Estimated, I=Imputed, M=Missing, T=Unofficial, X=international organization; unrecognized flags never establish official status.","inputSchema":{"type":"object","properties":{"canvas_id":{"description":"Optional canvas ID as returned by a prior faostat_query_observations / faostat_commodity_profile call — exactly 10 characters of letters, digits, hyphens, and underscores. Omit to query the tables staged in this session (the common case).","type":"string","pattern":"^[A-Za-z0-9_-]{10}$"},"sql":{"type":"string","minLength":1,"description":"Single-statement read-only SELECT against staged faostat_<id> tables. Columns: area_code, area, item_code, item, element_code, element, year, unit, value, flag, item_code_text, period, value_qualifier, source_code, source — plus domain (QCL or TCL) on tables staged by faostat_commodity_profile."},"row_limit":{"default":1000,"description":"Hard cap on rows in the response, at most 10000 per call.","type":"integer","minimum":1}},"required":["sql"],"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":true,"openWorldHint":false},"definitionHash":"371641743a51a3b5f444196ac7ccaaa8db642f5e26264009f1c80ffc040d42f1","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T07:46:38.235Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/faostat-mcp-server","endpointFingerprint":"586ea3160d1bcd56b3627dfdd0d8f3ad6f8e559ff4021dc6cf62dbca22ef49fc","name":"faostat_list_domains","title":"faostat-mcp-server: list domains","description":"Discover FAOSTAT statistical domains (production, trade, food balances, food security, land use, agri-emissions, prices, value) with their codes, descriptions, last-update date, upstream row count, and local index status. Every query keys on a domain code from here. The `indexed` flag tells you which domains are queryable right now; un-indexed domains exist in the catalog but must be added to FAOSTAT_DOMAINS and re-synced before faostat_query_observations can read them. The catalog runs to ~69 domains with long descriptions, so responses are paged: narrow with `topic` / `indexed_only`, pass `code` to fetch one domain outright, or page with `offset` + `limit` — when the response reports `truncated`, pass the returned `nextOffset` to fetch the rest.","inputSchema":{"type":"object","properties":{"code":{"description":"Exact domain code lookup (e.g. \"RL\"), case-insensitive. Returns that one domain's full record on a single page. Takes precedence over `topic` / `indexed_only` when provided.","type":"string"},"topic":{"description":"Case-insensitive substring filter over domain code, name, and topic (e.g. \"trade\", \"emissions\", \"QCL\"). Omit to list the full catalog.","type":"string"},"indexed_only":{"default":false,"description":"When true, return only domains indexed in the local mirror (queryable now).","type":"boolean"},"limit":{"default":20,"description":"Domains to return on this page, at most 200 per call — above the catalog size, so raise it to fetch everything at once. Domain descriptions are long; the default keeps a browse call small.","type":"integer","minimum":1},"offset":{"default":0,"description":"Zero-based pagination offset into the matching domains (code-sorted). When the response reports truncated, pass the returned nextOffset here to fetch the next page. Ignored for exact-code lookups (always single-page).","type":"integer","minimum":0,"maximum":9007199254740991}},"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":true,"openWorldHint":false},"definitionHash":"2fa66f1bcc5aaee492c671e4386d246b64a1cf2fa42dc8f01d86d02dcd585587","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T07:46:38.235Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/faostat-mcp-server","endpointFingerprint":"586ea3160d1bcd56b3627dfdd0d8f3ad6f8e559ff4021dc6cf62dbca22ef49fc","name":"faostat_query_observations","title":"faostat-mcp-server: query observations","description":"Query a FAOSTAT domain's data cube by area(s), item(s), element(s), sources, and year range, returning values with units and data-quality flags. Resolve numeric codes or exact alphanumeric item identities with faostat_resolve_codes; element resolution accepts item selectors and returns units. Empty queries with explicit items and elements list available elements for those items across the domain, without establishing area/year/source coverage. Aggregate regions are excluded by default; include_aggregates=true returns roll-ups, and explicit area_codes are honored verbatim. Item groups can overlap their members even with matching units; they remain included, and kind=null does not establish safe-to-sum. Keep source methodologies separate. Returns up to limit rows from offset, in year order; pass nextOffset back as offset for the next page, up to offset 100000, and partition a larger match by year or codes. With DataCanvas on, a first page (offset 0) whose match exceeds limit also stages the whole match to a DataCanvas table (canvas_id + table_name); call faostat_dataframe_describe for its columns, then faostat_dataframe_query for SQL over every row. Honor every row's flag: commonly A=Official, B=time-series break, E=Estimated, I=Imputed, M=Missing, T=Unofficial, X=international organization; unrecognized flags never establish official status.","inputSchema":{"type":"object","properties":{"domain":{"type":"string","minLength":1,"description":"FAOSTAT domain code (e.g. \"QCL\"). Must be indexed locally."},"area_codes":{"description":"Area codes from faostat_resolve_codes. When set, aggregates are NOT auto-excluded — the codes are honored verbatim.","type":"array","items":{"type":"integer","minimum":-9007199254740991,"maximum":9007199254740991}},"item_codes":{"description":"Item codes from faostat_resolve_codes.","type":"array","items":{"type":"integer","minimum":-9007199254740991,"maximum":9007199254740991}},"element_codes":{"description":"Element codes from faostat_resolve_codes (e.g. 5510 Production).","type":"array","items":{"type":"integer","minimum":-9007199254740991,"maximum":9007199254740991}},"item_codes_text":{"description":"Exact alphanumeric item identities from resolver code_text; mutually exclusive with item_codes. Numeric codes use item_codes.","type":"array","items":{"type":"string","pattern":"^\\d+[A-Za-z][A-Za-z0-9]*$","description":"Exact alphanumeric item code."}},"source_codes":{"description":"Exact source codes, such as 3050 or 3051 in GLE. Omit to return every methodology; choose or group sources before summing.","type":"array","items":{"type":"integer","minimum":-9007199254740991,"maximum":9007199254740991}},"year_start":{"description":"Inclusive start year (e.g. 2000).","type":"integer","minimum":-9007199254740991,"maximum":9007199254740991},"year_end":{"description":"Inclusive end year (e.g. 2022).","type":"integer","minimum":-9007199254740991,"maximum":9007199254740991},"include_aggregates":{"default":false,"description":"When false (default), exclude aggregate-region rows (codes ≥ 5000 plus a few curated sub-threshold roll-ups such as China=351) so sums are not double-counted. Set true for World/continent/grouping roll-ups. Ignored when explicit area_codes are passed.","type":"boolean"},"limit":{"default":200,"description":"Observations per page, at most 1000 per call. Rows past the page are never dropped silently: nextOffset continues from them, and with DataCanvas on a first page (offset 0) whose match exceeds limit also stages the whole match to a canvas table (canvas_id + table_name).","type":"integer","minimum":1},"offset":{"default":0,"description":"Zero-based position of the page’s first row in the match, in year order. Pass the nextOffset a previous call returned to fetch the following page; a page past the first stages nothing. At most 100000, so offset paging reaches the first 100000 rows of a match plus one page; to reach rows past that, partition the query by year (year_start/year_end) or narrower area_codes, item_codes, or element_codes, and page each part from offset 0.","type":"integer","minimum":0,"maximum":100000},"canvas_id":{"description":"Canvas ID to stage onto, as returned by a prior faostat_query_observations / faostat_commodity_profile call — exactly 10 characters of letters, digits, hyphens, and underscores. Consulted only when this call stages: a first page whose match exceeds limit, with DataCanvas on. Omit to stage onto this session’s canvas, created on the first stage and reused by every later call, so tables staged earlier in the session sit alongside this one.","type":"string","pattern":"^[A-Za-z0-9_-]{10}$"}},"required":["domain"],"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":false,"openWorldHint":false},"definitionHash":"f54199b326e8e439b0dcdcca510a9404ccc7008eeeb3b7d94ed19ec1842a0ec2","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T07:46:38.235Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/faostat-mcp-server","endpointFingerprint":"586ea3160d1bcd56b3627dfdd0d8f3ad6f8e559ff4021dc6cf62dbca22ef49fc","name":"faostat_resolve_codes","title":"faostat-mcp-server: resolve codes","description":"Resolve labels to the numeric codes or exact alphanumeric item identities faostat_query_observations needs: areas (countries/regions), items (commodities), and elements (metrics). Use query for full-text matching, name_contains for substring matching, code or code_text for exact identity, or omit them to list. Item and element matches occur in the selected domain; areas use shared vocabulary. For elements, optionally pass item_codes or item_codes_text to discover metrics and distinct units observed for those items; this does not establish area/year/source coverage. Empty item selectors match nothing. Page with offset and limit using nextOffset when truncated. Areas carry country/aggregate classification. Verified domain-specific item groups carry aggregate; null means unclassified, not safe-to-sum. Item groups can overlap their members even with matching units. Area aggregates include codes ≥ 5000 and curated roll-ups such as China=351; exclude overlapping regional and country rows when summing.","inputSchema":{"type":"object","properties":{"domain":{"type":"string","minLength":1,"description":"FAOSTAT domain code (e.g. \"QCL\"). Item and element resolution is scoped to the codes present in this domain's data; area code lists are shared across all indexed domains."},"dimension":{"type":"string","enum":["area","item","element"],"description":"Which dimension to resolve: \"area\" (countries/regions), \"item\" (commodities), or \"element\" (metrics)."},"query":{"description":"Full-text search term, FTS5-matched against the dimension labels with prefix matching (e.g. \"wheat\", \"import quantity\"). Relevance-ranked.","type":"string"},"name_contains":{"description":"Case-insensitive substring filter over the label. Used only when `query` is omitted.","type":"string"},"code":{"description":"Exact code lookup. Takes precedence over `query`/`name_contains` when provided.","type":"integer","minimum":-9007199254740991,"maximum":9007199254740991},"code_text":{"description":"Exact alphanumeric item code. Only for dimension item; mutually exclusive with code. Numeric identities use code.","type":"string","pattern":"^\\d+[A-Za-z][A-Za-z0-9]*$"},"item_codes":{"description":"For element resolution only: restrict elements and units to these items. Empty matches nothing; omit for domain-wide elements. Mutually exclusive with item_codes_text.","type":"array","items":{"type":"integer","minimum":-9007199254740991,"maximum":9007199254740991}},"item_codes_text":{"description":"For element resolution only: restrict elements and units to these exact text items. Empty matches nothing; mutually exclusive with item_codes.","type":"array","items":{"type":"string","pattern":"^\\d+[A-Za-z][A-Za-z0-9]*$","description":"Exact alphanumeric item identity."}},"limit":{"default":50,"description":"Matches to return on this page, at most 200 per call.","type":"integer","minimum":1},"offset":{"default":0,"description":"Zero-based pagination offset into the match set. When the response reports truncated, pass the returned nextOffset here to fetch the next page. Ignored for exact-code lookups (always single-page).","type":"integer","minimum":0,"maximum":9007199254740991}},"required":["domain","dimension"],"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":true,"openWorldHint":false},"definitionHash":"2bc2b926176045ed705c62336dcce877f29711352aeedb4baaa193d18b5737ae","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T07:46:38.235Z","metadataTrust":"untrusted"}],"endpoints":[{"endpointFingerprint":"586ea3160d1bcd56b3627dfdd0d8f3ad6f8e559ff4021dc6cf62dbca22ef49fc","protocol":"streamable-http","status":"indexed","toolCount":6,"observedAt":"2026-11-19T07:46:38.235Z"}],"authentication":"unknown"},"connectionConfigurations":{"status":"ready","authentication":"not embedded","clients":{"Claude Desktop":{"mcpServers":{"io.github.cyanheads/faostat-mcp-server":{"url":"https://faostat.caseyjhand.com/mcp"}}},"Cursor":{"mcpServers":{"io.github.cyanheads/faostat-mcp-server":{"url":"https://faostat.caseyjhand.com/mcp"}}},"VS Code":{"servers":{"io.github.cyanheads/faostat-mcp-server":{"type":"http","url":"https://faostat.caseyjhand.com/mcp"}}}}},"resourceType":"mcp-server","callable":true,"runtime":{"callable":true,"protocols":["mcp"]},"interfaces":[{"protocol":"mcp","transport":"streamable-http","url":"https://faostat.caseyjhand.com/mcp"},{"protocol":"mcp","package":"@cyanheads/faostat-mcp-server","registryType":"npm","version":"0.4.0"},{"protocol":"mcp","package":"@cyanheads/faostat-mcp-server","registryType":"npm","version":"0.4.0"}],"profile":{"apiVersion":"1","schemaVersion":"1","id":"mcp-server:io.github.cyanheads%2Ffaostat-mcp-server","resourceType":"mcp-server","canonicalUrl":"https://www.agentsjunction.com/api/v1/servers/io.github.cyanheads%2Ffaostat-mcp-server","name":"io.github.cyanheads/faostat-mcp-server","description":"UN FAOSTAT global food & agriculture statistics over a local SQLite mirror, via MCP.","interfaces":[{"protocol":"mcp","transport":"streamable-http","url":"https://faostat.caseyjhand.com/mcp"},{"protocol":"mcp","package":"@cyanheads/faostat-mcp-server","registryType":"npm","version":"0.4.0"},{"protocol":"mcp","package":"@cyanheads/faostat-mcp-server","registryType":"npm","version":"0.4.0"}],"capabilities":[],"identity":{"source":"official-registry","websiteUrl":null,"repositoryUrl":"https://github.com/cyanheads/faostat-mcp-server","version":"0.4.0"},"verification":{"state":"official","confidence":100},"operations":{"resourceType":"mcp-server","name":"io.github.cyanheads/faostat-mcp-server","status":"online","lastCheckedAt":"2026-11-20T09:18:04.270Z","lastSuccessfulCheck":"2026-11-20T09:18:04.270Z","latencyMs":268,"consecutiveFailures":0,"isStale":false,"checks":{"endpointReachable":true,"protocolValid":true,"agentCardValid":null,"mcpHandshakeValid":true},"lastSeen":null,"lastSuccessfulInteraction":null,"lastHealthCheck":"2026-11-20T09:18:04.270Z","source":{"type":"health-check","url":null},"observedAt":"2026-11-20T09:18:04.270Z"},"security":null,"timestamps":{"createdAt":"2026-10-18T06:50:14.214Z","updatedAt":"2026-10-18T06:50:14.214Z","observedAt":"2026-11-20T09:18:04.270Z"},"compatibility":{"serverVersion":"0.4.0","protocolVersions":[{"protocol":"mcp","version":null}]}}}}