KADA MCP for Copilot Studio

Kada provides a MCP integration for M365 Copilot and Teams.

The Kada agent can be deployed via Copilot Studio

Prerequisites

1. You must have access to Copilot Studio and licensed for Microsoft 365 Copilot

2. Kada MCP API key (For API) / Secret Value (For Oauth). Oauth is recommended for user MCP access to K.

3. Kada MCP Server URL endpoint (e.g., https://demo.kada.ai/mcp)

4. Kada MCP Skills files

   1. Discovery Skill

   2. Code Extract Skill

Step 1: Creating the K Agent in Copilot Studio

1. Log into Copilot studio - copilotstudio.microsoft.com/

2. On the Home Tab, click Agent

3. Give your Agent a name and an icon - e.g. K

4. Add the following instructions

   Always answer data catalog questions by calling the KADA MCP SERVER.
   Follow the attached KADA skills: use the kada-discovery skill to search and explain catalog assets, and the kada-code-extract skill to retrieve the code that builds or uses an asset.
   Do not explain your approach.
   Always return the response to the question asked by using the result from Kada.
   Do not include citation references in your response. When including hyperlinks, do **not** display the full URL. Instead, use Markdown link syntax with the word **LINK** as the display text.
   

5. In the Right panel click

   1. Model: Select a model for the Agent to use. Current recommendation is Claude Sonnet 5

   2. Add Skill. Upload the Skills files provided.

6. Click Save in the header to save your Agent settings

Step 2: Connecting your Agent to K MCP

1. Click on Tools

2. The Add Tool modal will open. Click Add and select Model Context Protocol
   
   

   

   
   

3. Add the following details

   1. Name: Give the Tool a name: e.g. Kada MCP Oauth or Kada MCP API

   2. Description: Give the Tool a description: KADA MCP connection via Oauth

   3. Server URL: https://<your-deployed-server-url>/mcp

   4. Authentication: Select Oauth or API based on your preferred method method
      

      

      
      

4. For Oauth authentication fill in the following details

   1. Configuration Type: Manual

   2. Client ID: mcp-oauth

   3. Client Secret: Provided by Kada

   4. Authroisation URL: https://<your-kada-domain>/keycloak/auth/realms/kada/protocol/openid-connect/auth

   5. Token URL: https://<your-kada-domain>/keycloak/auth/realms/kada/protocol/openid-connect/token

   6. Refresh URL: https://<your-kada-domain>/keycloak/auth/realms/kada/protocol/openid-connect/token

   7. Scopes: openid profile kada-mcp

   8. Click Add
      

      

      
      

5. For API method fill in the following details

   1. Parameter type: Head

   2. Header name: x-api-key

   3. Key value: Provided by Kada

   4. Click Add
      

      

      
      
      

6. Connect your Tool: Initially your tool will not be connected.
   Click Not Connected and Select the Create new connection option
   
   

   

7. If Oauth authentication is used, you will be redirected to K to authenticate. If you are already logged into K, the connection will complete without requiring a login.
   
   If API authentication is used, it will connected and confirm the connection has been established.
   
   Click Add after the connection has been completed
   

   

   
   

8. Click Save in the Header to save your Agent settings
   
   

Step 3: Testing your Agent

1. Go to the Preview tab

2. Test the agent with questions about your data ecosystem. Examples:

   1. What report should I use for [use case]

   2. Who is the owner of this report?

   3. How is [table name] built? Show the SQL that loads it

3. If the agent provides inaccurate responses, consider tuning the instructions.

   
   Please advise your Kada account manager with any feedback can be incorporated in the MCP / Skills files in future releases.

Step 4: Deploying your agent to Teams

1. Once you are comfortable with your Agent responses, you can publish the Agent

2. In the top right corner click Publish

3. Click Add Channel

4. Select Teams & Microsoft 365 Copilot

5. Go to the Channels tab. Click on Teams & Microsoft 365 Copilot

6. Select Teams, Microsoft 365 Copilot or both

7. Click Publish Agent
   

   

Step 11: Adding your agent in Teams

1. Open your Microsoft Teams application

2. Click on Apps in the left navigation pane

3. Click on the Agent you deployed. It will be located in the Built for your organisation section
   

Troubleshooting

Permission Required

When the agent is initially deployed you may be asked to approve the permission to connect the MCP server. Click Allow to allow the connection

Connection Required

On occasion you may be required to authenticate. Click Set up connection and follow the prompts to authenticate your access to K

Last updated: August 28, 2026