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_sqlAsk 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_dataAsk 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.Parameters
Server URL
Honeydew exposes the MCP Server API athttps://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 formatAPI_KEY:API_SECRET.
You can use the following command to generate the Base64-encoded string:
- MacOS
- Windows
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 workspaceBranch: Set the Honeydew branch to use, such asprodordevDomain: Supply the AI-ready domain to use in all requestsHoneydew-Client: Provide a client identifier for tracking purposes (optional)
JSON configuration
Add the server to an MCP Client configuration file:Installing in specific MCP Clients
Claude Code
Command linehoneydew-mcp.json and register it with:
Cursor AI
- Open Cursor AI application
- Go to Settings -> Cursor Settings -> Tools & MCP
- Click New MCP Server
- Fill in the content of the JSON configuration above
- Click Save