Connect UN Comtrade (Trade Statistics) to Copilot Studio
Query UN Comtrade (Trade Statistics) 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 the UN Comtrade API (comtradeapi.un.org), the United Nations Statistics Division's database of official international merchandise trade statistics reported by 200+ countries and areas since 1962.
Tools:
- get_trade_data: imports/exports (USD value, net weight) by reporter, partner (0 = World), HS code (TOTAL / AG2 / AG4 / AG6 or specific headings), flow (M / X / RM / RX) and period (annual YYYY or monthly YYYYMM).
- list_reporters / list_partners: numeric M49 codes with names and ISO codes, filterable by name.
- search_hs_codes: HS commodity codes by code prefix or English keyword.
Access: without a key the public preview API is used (limited rows per call, about one request per second). Registering at the UN Comtrade Developer Portal gives a free subscription key (Free APIs product); set it as COMTRADE_SUBSCRIPTION_KEY to use the full data API. Every response names the source (UN Comtrade Database) for attribution.
How to connect UN Comtrade (Trade Statistics) to Copilot Studio
- 1
In the Arlet dashboard, open Data tools, find UN Comtrade (Trade Statistics) 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.