Connect e-Stat to Copilot Studio
Query e-Stat 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 e-Stat API (Version 3.0), the official gateway to Japanese government statistics operated by the Statistics Bureau of the Ministry of Internal Affairs and Communications. It covers population, households, labour, prices, industry, trade, education and every other survey published on e-Stat.
Key features:
- Find statistical tables by keyword (AND / OR / NOT supported), survey year, publication year, government statistics code, field code, or area granularity, and get each table's stats_data_id.
- Inspect a table's dimensions and codes: measurement item (tab), time axis (time), region (area) and up to 15 classification axes (cat01..cat15), together with the exact filter keys to use next.
- Fetch the actual figures for a table, narrowed by dimension codes. Values come back with codes replaced by their Japanese labels, plus units, annotations, footnotes, and a next_start_position for paging.
A single e-Stat table can hold millions of cells, so requests are capped and paged rather than dumped: filter with the codes from the metadata tool and follow next_start_position for more. Arlet obtains and manages the e-Stat application ID, so there is nothing for you to register or configure - just switch the server on. (Under the upstream terms of use, heavy bursts of requests on a single ID may be throttled.)
How to connect e-Stat to Copilot Studio
- 1
In the Arlet dashboard, open Data tools, find e-Stat 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.