Connect Eurostat to Copilot Studio
Query Eurostat directly from Copilot Studio. Arlet links the two through one MCP connection and takes care of API keys.
Connects your AI client to the Eurostat dissemination API.
Tools:
- search_eurostat_datasets: keyword search over the dataset catalogue. Eurostat has no server-side dataset search, so the catalogue is cached in the runtime and filtered here.
- get_eurostat_dimensions: the dimensions and codes a dataset accepts (geo, time, unit and topic-specific axes), so the next query can be filtered correctly.
- get_eurostat_data: observations filtered by dimension codes, returned with codes resolved to their English labels.
The API returns JSON-stat 2.0 (a flat index → value map); this server expands it into rows so the model does not have to decode the index arithmetic. Attribution: data are from Eurostat.
How to connect Eurostat to Copilot Studio
- 1
In the Arlet dashboard, open Data tools, find Eurostat 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.