Skip the install. Get this working in under 2 minutes.
Start a free trial on cloud.anythingmcp.com, add the Destatis GENESIS Statistics in one click, then point your AI client (Claude, ChatGPT, Copilot or Cursor) at the generated MCP endpoint. No Docker, no git clone, zero engineering experience required.
Summary
Connect German federal statistics (Destatis) to Copilot using MCP. Access population, trade, and economic data with natural language.
Try asking
Example prompts for Destatis GENESIS Statistics
Click any prompt to copy it. Paste into Claude, ChatGPT, Cursor, Gemini, Copilot or OpenClaw to run it against this connector.
Claude is AI and can make mistakes. Please double-check responses.
Connect Destatis GENESIS to Copilot
Destatis (Statistisches Bundesamt) provides official German federal statistics via the GENESIS API. With AnythingMCP, you can connect Destatis data to Copilot and explore statistical tables using natural language.
What You Can Do
- "What was the population of München (Landkreis) on 31.12.2025 according to Destatis?"
- "Compare unemployment rate trends 2022–2025 for Bayern, Niedersachsen and Sachsen; highlight the highest and fastest change."
- "I need 2025 import value for machinery from Destatis: find the trade category, locate the table for machine imports and fetch the 2025 value."
- "Use Destatis population figures for Ostwestfalen-Lippe to inform our headcount forecast: what's the population change 2020→2025 and what hiring adjustment would you recommend?"
Setup
curl -fsSL https://raw.githubusercontent.com/HelpCode-ai/anythingmcp/main/docker-compose.quickstart.yml -o docker-compose.yml
printf 'JWT_SECRET=%s\nENCRYPTION_KEY=%s\n' "$(openssl rand -hex 32)" "$(openssl rand -hex 32)" > .env
docker compose up -d
- Open
http://localhost:3000/connectors/storeand import the Destatis GENESIS Statistics adapter - Enter your Destatis GENESIS username and password (register at genesis.destatis.de)
- Assign the connector to an MCP server
Connect Microsoft Copilot
The quickstart above listens on localhost only. For Microsoft Copilot, install the connector on AnythingMCP Cloud instead, or on an instance with a public HTTPS address.
Your server URL: in AnythingMCP, open MCP Servers → the server this connector is on, and copy its URL (
https://cloud.anythingmcp.com/mcp/…). Use it wherever this guide showsYOUR_SERVER_ID.
Microsoft Copilot uses MCP servers through agents built in Copilot Studio: you add AnythingMCP to an agent as a tool, then publish the agent to Microsoft 365 Copilot and Teams. Copilot Studio connects from Microsoft's cloud over Streamable HTTP, which AnythingMCP supports.
- In Copilot Studio, open your agent (or create one), go to Tools and choose Add a tool → New tool → Model Context Protocol.
- Enter a Server name (for example
AnythingMCP), a Server description that says what the connector does, and the Server URLhttps://cloud.anythingmcp.com/mcp/YOUR_SERVER_ID. Copilot Studio uses the description to decide when to call the server. - Under authentication, choose API key, set Type to Header and the header name to
X-API-Key, then select Create. - In Add tool, choose Create a new connection, paste an MCP API key from AnythingMCP (MCP Servers → your server → API keys) and select Add to agent.
- Try it in the agent's Test pane: ask for something that needs the
Destatis GENESIStools. - Select Publish, then Channels → Microsoft 365 and Microsoft Teams, keep Make agent available in Microsoft Copilot selected and choose Add channel. See agent in Teams installs it for you; in Microsoft 365 Copilot, type @ and pick the agent.
Prefer per-user sign-in? Choose OAuth 2.0 → Dynamic discovery instead of an API key: each user then signs in to AnythingMCP the first time the agent calls it.
Self-hosting? Use your instance's public HTTPS address instead of https://cloud.anythingmcp.com. Copilot Studio connects from Microsoft's cloud, so localhost does not work.
Available Tools
| Tool | Description |
|---|---|
destatis_search_tables | Search for statistical tables by keyword |
destatis_get_table | Retrieve data from a specific table |
destatis_get_table_metadata | Get table structure and dimensions |
destatis_list_statistics | Browse available statistics categories |
destatis_login_check | Verify that the configured GENESIS credentials work and report which account the API sees |
FAQ
Which Copilot is this for? Microsoft 365 Copilot at work, through agents built in Copilot Studio. The Microsoft Copilot app for personal accounts has no option to add your own MCP server.
What do I need? A work account with access to Copilot Studio (a license or a trial) to build the agent. People who use it in Microsoft 365 Copilot or Teams need access to the agent: share it with them, or ask an admin to publish it to the organization. If your organization applies data policies to Power Platform connectors, they cover MCP servers too.
The agent doesn't call the tools. Check that the header name is exactly X-API-Key and that the key belongs to the same MCP server as the URL, and make the server description specific: Copilot Studio uses it to decide when to call the server. Publish the agent again after each change; in an open chat, type "start over" to get the new version.
Next steps
- Connector landing page
- Connect to Claude
- Connect to ChatGPT
- Connect to Cursor
- Connect to Gemini
- Connect to Meta Muse
Was this guide helpful?