Prerequisites
Before you can configure and use Microsoft Foundry with Connect AI, you must do the following:- Connect a data source to your Connect AI account if you have not done so already. See Sources for more information.
- Generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.
-
Base64 encode your Connect AI credentials in the following format:
Base64("email:PAT").
Connect Microsoft Foundry to the Connect AI MCP
1
Create a project in Microsoft Foundry.
2
Click Create Agent.

3
Provide a name for your agent, and then click Create.

4
After naming your agent, click Save. Add instructions (optional). Under Tools, click Add.

5
In the Select a tool dialog, click the Custom tab, and then click Model Context Protocol.

6
In the Add Model Context Protocol dialog, enter the following:
- Name–the name of your MCP server, for example, ConnectAIMCPServer.
- Remote MCP Server endpoint–https://mcp.cloud.cdata.com/mcp.
- Authentication–select Key-based.
- Credential–enter Basic, followed by your Base64-encoded email:PAT.

7
Click Connect. You should see the MCP server listed under Tools.
8
Click Save again to save your agent.
9
You can confirm your connection by clicking the YAML tab. You should see the following:

10
Click the Chat tab and ask the agent a question about your data. The agent shows the tools used to arrive at an answer.
