Skip to main content
Honeydew MCP (Model Context Protocol) Server can be used for integration with AI assistants like Claude Code and Cursor, as well as any MCP-compatible clients.

What is MCP?

Model Context Protocol (MCP) is an open-source standard for securely connecting AI applications to external systems and tools. Honeydew MCP Server allows you to build AI assistants that can leverage the Honeydew Semantic Layer to ask data questions and get answers.

Tools Available

  • ask_question_get_sql Ask a data question in natural language and get the sql query that would provide the data answer. You can then run the query in Snowflake to get the results.
  • ask_question_get_data Ask a data question in natural language and get the data answer.

Installation

Overview

Each MCP client connection to the Honeydew MCP Server needs to specify the Honeydew workspace, branch and domain to use.
You can register multiple MCP servers in your MCP client configuration. Each server can point to a different Honeydew workspace, branch, or domain. This allows you to easily switch between different environments, as needed.

Parameters

Server URL

Honeydew exposes the MCP Server API at https://api.honeydew.cloud/mcp/
If your organization uses a custom Honeydew hostname, replace the default URL with your tenant hostname. You can find the hostname in the Honeydew UI under Settings > MCP Server.

Authentication

There are two ways to authenticate with the Honeydew MCP Server: HTTP Basic authentication or OAuth. HTTP Basic Authentication The MCP Server in HTTP Basic authentication mode requires an API Key for authentication. You need to provide a Base64-encoded string of your API Key and API Secret in the format API_KEY:API_SECRET.
If creating a new API Key for MCP Server access, you can copy the Base64-encoded string from the Honeydew Studio UI at the time of creation.
You can use the following command to generate the Base64-encoded string:
  • MacOS
  • Windows
echo "<API_KEY>:<API_SECRET>" | base64
Provide the encoded string in the Authentication header as follows: Authentication: Basic <YOUR_BASE64_ENCODED_API_KEY_AND_SECRET> OAuth Authentication The MCP Client in OAuth authentication mode redirects the user to authenticate with Honeydew, and then securely provides an access token for subsequent requests.
OAuth authentication is not enabled by default. To enable OAuth authentication, please contact support@honeydew.ai.

Configuration

Each MCP Server request must include additional headers to specify the Honeydew workspace, branch and domain to use.
  • Workspace: Set the Honeydew workspace
  • Branch: Set the Honeydew branch to use, such as prod or dev
  • Domain: Supply the AI-ready domain to use in all requests
  • Honeydew-Client: Provide a client identifier for tracking purposes (optional)

JSON configuration

Add the server to an MCP Client configuration file:
{
  "name": "honeydew",
  "type": "http",
  "url": "https://api.honeydew.cloud/mcp/",
  "headers": {
    "Authorization": "Basic <YOUR_BASE64_ENCODED_API_KEY_AND_SECRET>",
    "Workspace": "your_workspace",
    "Branch": "prod",
    "Domain": "llm_testing",
    "Honeydew-Client": "My-MCP-Client"
  }
}

Installing in specific MCP Clients

Claude Code

Command line
claude mcp add --transport http honeydew https://api.honeydew.cloud/mcp/ \
    --header "Authorization: Basic <YOUR_BASE64_ENCODED_API_KEY_AND_SECRET>" \
    --header "Workspace: your_workspace" \
    --header "Branch: prod" \
    --header "Domain: llm_testing" \
    --header "Honeydew-Client: My-MCP-Client"
JSON configuration Save the JSON configuration to honeydew-mcp.json and register it with:
claude mcp add honeydew ./honeydew-mcp.json
You can use the Claude Code variable expansion feature. This will allow you to avoid hardcoding sensitive information like API keys in the configuration file.

Cursor AI

  1. Open Cursor AI application
  2. Go to Settings -> Cursor Settings -> Tools & MCP
  3. Click New MCP Server
  4. Fill in the content of the JSON configuration above
  5. Click Save

Using the MCP Server

You can now use the Honeydew MCP Server in your MCP-compatible AI assistant