Connect FAOSTAT (FAO) to Codex
Query FAOSTAT (FAO) directly from Codex. Arlet links the two through one MCP connection and takes care of API keys.
This server connects your AI client to two FAO data services.
FAOSTAT domains (REST API; free Developer Portal account required):
- list_faostat_domains: find datasets such as QCL (crops and livestock production), TCL (trade), FBS (food balances), PP (producer prices), RL (land use).
- list_faostat_dimensions: see a domain's dimensions (area, item, element, year, ...).
- list_faostat_codes: look up area / item / element / year codes by keyword.
- get_faostat_data: fetch observations filtered by those codes, with units and FAO flags.
SDG indicators (SDMX API; no account):
- search_sdg_dataflows: the 27 FAO-custodied SDG indicator dataflows (2.1.1 undernourishment, 2.1.2 food insecurity, 2.4.1 sustainable agriculture, 6.4.2 water stress, 15.1.1 forest area, ...).
- get_sdg_dimensions / get_sdg_data: inspect a dataflow's dimensions and fetch observations by dimension key.
Since 2025 the FAOSTAT REST API requires a login: register for free at the FAOSTAT Developer Portal and set FAOSTAT_USERNAME (account e-mail) and FAOSTAT_PASSWORD. The server signs in for each request and never stores the token. Data are licensed under CC BY 4.0 (FAO Statistical Database Terms of Use); every response carries the required attribution line.
How to connect FAOSTAT (FAO) to Codex
- 1
In the Arlet dashboard, open Data tools, find FAOSTAT (FAO) and switch it on. No API key setup is needed.
- 2
In your terminal, run codex mcp add arlet --url https://mcp.arlet.dev/mcp/ to add Arlet as an MCP server.
- 3
Codex detects OAuth support and opens your browser. Sign in with Google and click Allow on the consent screen.
- 4
Once connected, both the CLI and the IDE extension can call Arlet tools (the configuration is shared).
If the browser does not open, run codex mcp login arlet to redo the authentication.