Connect OECD Data to Copilot Studio
Query OECD Data directly from Copilot Studio. Arlet links the two through one MCP connection and takes care of API keys.
Connects your AI client to the OECD SDMX API (sdmx.oecd.org), the backend of OECD Data Explorer.
Tools:
- search_oecd_dataflows: keyword search over OECD-provided dataflows (the full list is cached; the first call can take ~10 seconds).
- get_oecd_dataflow_dimensions: dimension order and codes for one dataflow; shows the exact key template for the data query.
- get_oecd_data: observations for a dimension key (empty segment = wildcard, or 'all'), with lastNObservations control.
Implementation note: the OECD service returns HTTP 500 unless an Accept-Language header is sent; this server handles that. Attribution: data are from OECD Data Explorer (https://data-explorer.oecd.org).
How to connect OECD Data to Copilot Studio
- 1
In the Arlet dashboard, open Data tools, find OECD Data 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.