Connect FAOSTAT (FAO) to Copilot Studio
Query FAOSTAT (FAO) directly from Copilot Studio. 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 Copilot Studio
- 1
In the Arlet dashboard, open Data tools, find FAOSTAT (FAO) and switch it on. No API key setup is needed.
- 2
Sign in to Copilot Studio with your work account, create a new agent (or open an existing one), and in the Build tab choose Tools → + → Add → Model Context Protocol (MCP) in the right panel.
- 3
In the Add MCP server form, enter "Arlet" as the Server name, https://mcp.arlet.dev/mcp/ as the Server URL, choose OAuth 2.0 for Authentication and "Dynamic (detected)" for Configuration type, then click Add. No Client ID / Secret is needed.
- 4
On the Select a connection screen, choose Create new connection → Create, then sign in with Google on the Arlet authorization screen and click Allow. Click Add to attach the tool to the agent, then Publish to use it from Microsoft 365 Copilot.
Requires a Microsoft work account and a Copilot Studio license (or trial). MCP is available only for agents using generative orchestration and not in Copilot Studio in Teams.