Faostat MCP Server
UnclaimedGlobal food & agriculture statistics from the UN FAOSTAT bulk-download corpus, served from a local SQLite mirror with a DataCanvas SQL surface, over MCP. STDIO & Streamable HTTP.
Install
docker run --rm -p 3010:3010 -v faostat-mirror:/usr/src/app/.faostat-mirror faostat-mcp-serverSet up this server
More in Databases
Browse the full directoryUnclaimed listing
Is this your MCP server?
This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.
Claim this serverSecurity profile
Claimed and verified servers get a weekly static scan that shows what the code can reach: external services, environment variables, shell commands, agent configuration folders, plus any dependencies with known advisories. Claim this listing to get one. How the security profile works
8 of 8 tools
Documented tools (8)
From project documentation. A server handshake does not verify each tool’s description or behavior.
canvas_id
is optional on both tools — omit it to operate on the tables staged in the current session (the common case).
faostat_commodity_profile
Workflow: assemble top producers, the production trend, and trade flows for one commodity from the production and trade domains in a single call.
faostat_dataframe_describe
List the canvas tables staged this session, each with provenance, row count, and column schema.
faostat_dataframe_query
Run a read-only SQL SELECT against the canvas tables staged by the analytical tools.
faostat_list_domains
Discover FAOSTAT statistical domains with codes, descriptions, last-update date, upstream row count, and local index status. The entry point — every query keys on a domain code.
faostat_query_observations
Query a domain's cube by area(s), item(s), element(s), and year range. Inline preview for small results; large sets spill to a DataCanvas table.
faostat_resolve_codes
Resolve human terms to the opaque integer codes a query needs (areas, items, elements), flagging each area as a country or an aggregate region.
Read-only.
Writes, DDL, DROP, COPY, PRAGMA, ATTACH, and external-file table functions are rejected by the framework SQL gate. System catalogs (informationschema, sqlitemaster, duckdb) are denied so a caller can't enumerate staged tables it doesn't hold a handle for — list them via faostatdataframedescribe.
Tool change history
FAQ
Questions about Faostat MCP Server
- How do I connect Faostat MCP Server to Claude?
- The listing records `docker run --rm -p 3010:3010 -v faostat-mirror:/usr/src/app/.faostat-mirror faostat-mcp-server` as its setup step. Run it, then follow the repository's instructions for the client configuration; the listing names Claude Desktop, Cursor, VS Code as compatible clients.
- Is Faostat MCP Server free?
- The listed licence is Apache-2.0. Check the upstream terms for permitted use and commercial requirements; a public repository does not by itself mean the software is free or open source. Connected APIs and hosted services may have separate charges.
- What can Faostat MCP Server do?
- Faostat MCP Server documents 8 tools to the agent, including canvas_id, faostat_commodity_profile, faostat_dataframe_describe. The descriptions above come from project documentation. A live handshake does not test individual tool behavior.