indexed_only

MCP tool from Faostat MCP Server by cyanheads

to list just the domains queryable from the local mirror

How to use it

indexed_only is exposed by the Faostat MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the indexed_only tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

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 (12)

canvas_id

is optional on both tools — omit it to operate on the tables staged in the current session (the common case).

code

for an exact domain lookup (e.g. "RL") — one full record, without a topic search that can match unrelated domains

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.

limit

caps the inline page (default 200, max 1000); a match that outgrows the page is staged to the canvas table in full, and when no table is staged the response reports how many matched — so a low limit trims the response without putting rows out of reach

offset

+ limit to page the catalog; the response reports totalMatches, truncated, and the nextOffset to resume at. Domain descriptions are long, so a browse call is bounded by default — raise limit (max 200) to pull the whole catalog in one response

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.

topic

substring filter over code, name, and topic (e.g. "trade", "emissions", "QCL")