{"report":"{\"v\":1,\"package\":\"@cyanheads/faostat-mcp-server\",\"version\":\"0.7.0\",\"ranAt\":\"2026-11-16T11:55:19.337Z\",\"install\":{\"ok\":true,\"integrity\":\"sha512-U7ni/qnikyIrCE/Le3G13WC2+wpAnGgxFltMCRO1bsQGk80lxYmn3AxlxCO1hu+1Los4Moa9jPxqs+tOSH7tpg==\",\"deps\":51,\"scripts\":[],\"bins\":[\"faostat-mcp-server\"],\"license\":\"Apache-2.0\",\"engines\":\"node >=24.0.0\",\"repository\":\"git+https://github.com/cyanheads/faostat-mcp-server.git\",\"bin\":\"faostat-mcp-server\"},\"start\":{\"ok\":true,\"ms\":426,\"serverName\":\"faostat-mcp-server\",\"serverVersion\":\"0.7.0\",\"protocol\":\"2025-06-18\",\"stderr\":\"n\\\":\\\"0.7.0\\\",\\\"pid\\\":60,\\\"operation\\\":\\\"StorageService.get\\\",\\\"requestId\\\":\\\"Q6255-UGI89\\\",\\\"tenantId\\\":\\\"default\\\",\\\"timestamp\\\":\\\"2026-11-16T11:55:34.678Z\\\",\\\"jsonRpcId\\\":4,\\\"toolName\\\":\\\"faostat_dataframe_describe\\\",\\\"key\\\":\\\"canvas-id\\\",\\\"msg\\\":\\\"[StorageService] get operation\\\"}\\n{\\\"level\\\":20,\\\"time\\\":1794830134682,\\\"env\\\":\\\"development\\\",\\\"version\\\":\\\"0.7.0\\\",\\\"pid\\\":60,\\\"operation\\\":\\\"HandleToolRequest\\\",\\\"requestId\\\":\\\"Q6255-UGI89\\\",\\\"tenantId\\\":\\\"default\\\",\\\"timestamp\\\":\\\"2026-11-16T11:55:34.678Z\\\",\\\"jsonRpcId\\\":4,\\\"toolName\\\":\\\"faostat_dataframe_describe\\\",\\\"msg\\\":\\\"[InMemoryProvider] Getting key: canvas-id for tenant: default\\\"}\\n{\\\"level\\\":20,\\\"time\\\":1794830134682,\\\"env\\\":\\\"development\\\",\\\"version\\\":\\\"0.7.0\\\",\\\"pid\\\":60,\\\"operation\\\":\\\"StorageService.list\\\",\\\"requestId\\\":\\\"Q6255-UGI89\\\",\\\"tenantId\\\":\\\"default\\\",\\\"timestamp\\\":\\\"2026-11-16T11:55:34.678Z\\\",\\\"jsonRpcId\\\":4,\\\"toolName\\\":\\\"faostat_dataframe_describe\\\",\\\"prefix\\\":\\\"df-meta/\\\",\\\"hasCursor\\\":false,\\\"msg\\\":\\\"[StorageService] list operation\\\"}\\n{\\\"level\\\":20,\\\"time\\\":1794830134682,\\\"env\\\":\\\"development\\\",\\\"version\\\":\\\"0.7.0\\\",\\\"pid\\\":60,\\\"operation\\\":\\\"HandleToolRequest\\\",\\\"requestId\\\":\\\"Q6255-UGI89\\\",\\\"tenantId\\\":\\\"default\\\",\\\"timestamp\\\":\\\"2026-11-16T11:55:34.678Z\\\",\\\"jsonRpcId\\\":4,\\\"toolName\\\":\\\"faostat_dataframe_describe\\\",\\\"options\\\":{},\\\"msg\\\":\\\"[InMemoryProvider] Listing keys with prefix: df-meta/ for tenant: default\\\"}\\n{\\\"level\\\":30,\\\"time\\\":1794830134684,\\\"env\\\":\\\"development\\\",\\\"version\\\":\\\"0.7.0\\\",\\\"pid\\\":60,\\\"operation\\\":\\\"HandleToolRequest\\\",\\\"requestId\\\":\\\"Q6255-UGI89\\\",\\\"timestamp\\\":\\\"2026-11-16T11:55:34.678Z\\\",\\\"jsonRpcId\\\":4,\\\"toolName\\\":\\\"faostat_dataframe_describe\\\",\\\"metrics\\\":{\\\"durationMs\\\":5.38,\\\"isSuccess\\\":true,\\\"inputBytes\\\":23,\\\"outputBytes\\\":13},\\\"msg\\\":\\\"Tool execution finished.\\\"}\\n\"},\"tools\":[{\"name\":\"faostat_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.\",\"params\":[\"code\",\"topic\",\"indexed_only\",\"limit\",\"offset\"]},{\"name\":\"faostat_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.\",\"params\":[\"domain\",\"dimension\",\"query\",\"name_contains\",\"code\",\"code_text\",\"item_codes\",\"item_codes_text\",\"limit\",\"offset\"]},{\"name\":\"faostat_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.\",\"params\":[\"domain\",\"area_codes\",\"item_codes\",\"element_codes\",\"item_codes_text\",\"source_codes\",\"year_start\",\"year_end\",\"include_aggregates\",\"limit\",\"offset\",\"canvas_id\"]},{\"name\":\"faostat_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.\",\"params\":[\"item_code\",\"item_query\",\"year_start\",\"year_end\",\"top_n\",\"canvas_id\"]},{\"name\":\"faostat_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.\",\"params\":[\"canvas_id\",\"sql\",\"row_limit\"]},{\"name\":\"faostat_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.\",\"params\":[\"canvas_id\",\"name\",\"limit\",\"offset\"]}],\"toolsHash\":\"0e88dffada262a540a803802016febad7eee3d8b4559186db56e25f8c19f809c\",\"wrote\":[],\"callsAt\":\"2026-11-16T11:55:33.460Z\",\"calls\":[{\"tool\":\"faostat_list_domains\",\"ok\":false,\"ms\":216,\"bytes\":0,\"error\":\"tool reported an error: Error: Failed to open mirror store \\\"domain-FBS.db\\\".\\n\\nRecovery: The server could not use its local mirror store, and changing the request will not help. Try again later, and report the failure to the s\"},{\"tool\":\"faostat_dataframe_describe\",\"ok\":true,\"ms\":9,\"bytes\":277}],\"host\":{\"commit\":\"eaaffffaf52255d1b77dc4aacffdfaf353f0c12c\",\"run\":\"https://github.com/itsHaddad/bragproof/actions/runs/43857070216\"},\"network\":{\"names\":[\"registry.npmjs.org\"],\"conns\":[],\"callNames\":[\"bulks-faostat.fao.org\"],\"callConns\":[]}}","token":"eyJhbGciOiJSUzI1NiIsImtpZCI6IjM4ODI2YjE3LTZhMzAtNWY5Yi1iMTY5LThiZWI4MjAyZjcyMyIsInR5cCI6IkpXVCIsIng1dCI6InlrTmFZNHFNX3RhNGsyVGdaT0NFWUxrY1lsQSJ9.eyJhY3RvciI6Iml0c0hhZGRhZCIsImFjdG9yX2lkIjoiMTE0NzMyNjEiLCJhdWQiOiJicmFncHJvb2YtcmVwb3J0OjUzYjBmMDcwMzM1YzU5YjNlMDg5OTA3YTFiMWQ2YzBhZmE2Yjc1ZWZmYTM1ODU0Y2MxZThmMTkxOWRmMmM4MzYiLCJiYXNlX3JlZiI6IiIsImNoZWNrX3J1bl9pZCI6IjEzMzI2Mzk5NTMyMSIsImV2ZW50X25hbWUiOiJzY2hlZHVsZSIsImV4cCI6MTc5NDgzMDQzOSwiaGVhZF9yZWYiOiIiLCJpYXQiOjE3OTQ4MzAxMzksImlzcyI6Imh0dHBzOi8vdG9rZW4uYWN0aW9ucy5naXRodWJ1c2VyY29udGVudC5jb20iLCJqb2Jfd29ya2Zsb3dfcmVmIjoiaXRzSGFkZGFkL2JyYWdwcm9vZi8uZ2l0aHViL3dvcmtmbG93cy9yZXBvcnQueW1sQHJlZnMvaGVhZHMvbWFpbiIsImpvYl93b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIiwianRpIjoiZDdlODY0ZDEtZmY0OS00MzE0LWI3ODUtNjQ1NGNkYzg4N2I2IiwibmJmIjoxNzk0ODI5ODM5LCJyZWYiOiJyZWZzL2hlYWRzL21haW4iLCJyZWZfcHJvdGVjdGVkIjoiZmFsc2UiLCJyZWZfdHlwZSI6ImJyYW5jaCIsInJlcG9zaXRvcnkiOiJpdHNIYWRkYWQvYnJhZ3Byb29mIiwicmVwb3NpdG9yeV9pZCI6IjE0NTQ2MjExODMiLCJyZXBvc2l0b3J5X293bmVyIjoiaXRzSGFkZGFkIiwicmVwb3NpdG9yeV9vd25lcl9pZCI6IjExNDczMjYxIiwicmVwb3NpdG9yeV92aXNpYmlsaXR5IjoicHVibGljIiwicnVuX2F0dGVtcHQiOiIxIiwicnVuX2lkIjoiNDM4NTcwNzAyMTYiLCJydW5fbnVtYmVyIjoiMjQiLCJydW5uZXJfZW52aXJvbm1lbnQiOiJnaXRodWItaG9zdGVkIiwic2hhIjoiZWFhZmZmZmFmNTIyNTVkMWI3N2RjNGFhY2ZmZGZhZjM1M2YwYzEyYyIsInN1YiI6InJlcG86aXRzSGFkZGFkQDExNDczMjYxL2JyYWdwcm9vZkAxNDU0NjIxMTgzOnJlZjpyZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvdyI6InJlcG9ydCIsIndvcmtmbG93X3JlZiI6Iml0c0hhZGRhZC9icmFncHJvb2YvLmdpdGh1Yi93b3JrZmxvd3MvcmVwb3J0LnltbEByZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIn0.PYcYSfEGDcsul9fWGaJzgHU9yr69Whc5BE2w--w5ocwqJe3BIbtsDmdl7PtjNQLjjFUUAv5xFIG4vAMpFeYBKayn5wdd14Mayq2JR_JjiCjEoiupWc5c0HUB3L52rlhXiqr86tkMryNqB62ie2Z31uk5XwKP2HiIVEGiRfBXEFKtrGrjrFESk6NeCi8c4DK9-hse5LfeOpDPkIMfgzQ8MPPWJxZ-1W9lR_sCIHAFwPVqDHw8b7Se_7M1p_YpMrF7pJe6G3XLpy3bkaoIgZLKt8uSZPMHoSlpNxzXLrrkBrCMeYUh4ILqUR_pYtsS3JakozBFTnoMclK6ZrVi3CMw2g"}