faostat_dataframe_query

MCP tool from Faostat MCP Server by cyanheads

Run a read-only SQL SELECT against the canvas tables staged by the analytical tools.

How to use it

Project documentation lists faostat_dataframe_query for the Faostat MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

Install Faostat MCP Server

$docker run --rm -p 3010:3010 -v faostat-mirror:/usr/src/app/.faostat-mirror faostat-mcp-server

FULL FAOSTAT MCP SERVER LISTING

Other tools in Faostat MCP Server (7)

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_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.