Breadcrumbs

KADA MCP for Snowflake Coco / Cowork

UPDATED IN VERSION 6.1

Kada provides a MCP integration for Snowflake


Prerequisites

  1. You must have access to Snowflake and have Account Admin access

  2. You must have access to K and have Admin access

  3. Kada MCP Client ID / Secret Value .

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


You must request access to the Kada MCP. Reach out to your Kada account manager for access.


Step 1: Creating the K Agent in Copilot Studio

  1. Open Snowflake in your Browser

  2. Click on your avatar and select Settings

  3. Go to Account Agent Settings

  4. Select Add Custom

  5. Add the following details then click Add

    1. Location: Select a database where the MCP connector will be deployed to

    2. Name: Give the MCP connector name e.g. K MCP

    3. Description: Give the MCP connector a description: MCP for K platform

    4. Authentication type: Use Standard OAuth

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

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

    7. Oauth Client ID: Ask your Kada account manager

    8. Oauth Client Secret: Ask your Kada account manager

    9. Authorisation endpoint: https://<your-kada-domain>/keycloak/auth/realms/kada/protocol/openid-connect/auth

    10. Scopes: openid profile kada-mcp

      image-20261112-072240.png




Step 2: Add the Redirect URI to your Kada MCP

  1. Open K in your Browser

  2. Go to Settings → Customisation → Configure Single Sign On

  3. Go to Clients. Click on to mcp-oauth

  4. In Access Settings. Add the following to the Valid Redirect URIs. Click Save

    1. https://identity.snowflake.com/oauth2/callback


Step 3: Connect Coco to K

  1. Go back to Snowflake.

  2. Click on your avatar and select Settings

  3. Go to Personal Agent Settings

  4. Go to the MCP Connector that you added in Step 1. Click Connect

    1. You will be asked to sign in to K to complete the authentication step

  5. The K MCP will be connected after successful authentication

image-20261112-073123.png

Step 4: Testing your Agent

  1. Open up a chat with Coco

  2. Test the agent with question using the Kada tools

  3. 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?


      Please advise your Kada account manager with any feedback you may have.


Change history

Version 6.1 ·

  • NEW Enabled Oauth for MCP

Last updated: