Skip to main content

What is MCP?

Model Context Protocol (MCP) is an open-source standard for securely connecting AI applications to external systems and tools. Honeydew provides an MCP server that connects your AI coding assistant to the Honeydew Semantic Layer.

When to use

  • Discover and explore your warehouse tables, schemas, and semantic model definitions
  • Build and maintain your semantic model through natural conversation
  • Query your data with natural language from any MCP-compatible assistant

Installation

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: OAuth or HTTP Basic authentication. OAuth Authentication (recommended) Most clients support OAuth authentication. When you first connect, you’ll be prompted to:
  1. Log in with your Honeydew account
  2. Accept the OAuth authorization
The client then securely provides an access token for subsequent requests. 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:
echo -n '<API_KEY>:<API_SECRET>' | base64
Provide the encoded string in the Authorization header as follows: Authorization: Basic <YOUR_BASE64_ENCODED_API_KEY_AND_SECRET>

Configuration

The workspace and branch are set at the session level using the list_workspaces, list_workspace_branches and set_session_workspace_and_branch tools. You can also create new branches with create_workspace_branch. Call these tools from your AI assistant after connecting to the MCP server. You can optionally provide these headers in your MCP server configuration:
  • Workspace: Pin the workspace for all requests (optional)
  • Branch: Pin a specific workspace branch for all requests (optional, defaults to prod if workspace is set)
  • Honeydew-Client: Identify the MCP client (optional, auto-detected from the connected tool). Pass this header to provide a specific client identifier.
  • ReadonlyToolsOnly: Set to true to expose only read-only tools (optional)
The MCP server uses the Mcp-Session-Id response header to maintain session state, including the active workspace and branch. See the MCP session management specification for details.

Supported Clients

Claude Code CLI

MCP Server

Run the following command to add the Honeydew MCP server:
Using environment variables for API Key authenticationTo avoid storing sensitive values directly in configuration files, Claude Code supports environment variable expansion using the ${VAR_NAME} syntax.Set the HONEYDEW_API_KEY environment variable, then reference it in your configuration:
claude mcp add --transport http honeydew \
    https://api.honeydew.cloud/mcp/ \
    --header "Authorization: Basic ${HONEYDEW_API_KEY}"
Claude Code resolves ${VAR_NAME} references at runtime from your environment.

AI Coding Agent Plugins

Honeydew provides a plugins repository with skills and tools for building semantic models and analyzing data through natural conversation.Launch Claude Code with claude, then add the marketplace:
/plugin marketplace add honeydew-ai/honeydew-ai-coding-agents-plugins
Then install the Honeydew plugins from the marketplace:
/plugin install semantic-modeling-tools@honeydew-ai
/plugin install data-analysis-tools@honeydew-ai
Updating pluginsTo update the Honeydew marketplace plugins, launch Claude Code with claude, then:
  1. Write /plugin and select Marketplaces in the selector at the top
  2. Select honeydew-ai-claude-plugins
  3. Click Update marketplace
To receive updates automatically, select Enable auto-update in the marketplace settings.

Honeydew Documentation MCP

Give Claude Code access to the Honeydew documentation through a separate MCP server. No authentication is required.
claude mcp add --transport http honeydew-docs \
    https://honeydew.ai/docs/mcp

Claude Desktop

MCP Server

Claude Code modeFollow the Claude Code CLI instructions to set up the MCP server in Claude Code mode.Cowork mode
  1. Go to Settings -> Connectors -> Add custom connector
  2. Enter honeydew in the Name field
  3. Enter https://api.honeydew.cloud/mcp/ in the Remote MCP server URL field
  4. Click Add
You’ll be prompted to authenticate with OAuth to Honeydew when first connecting.

AI Coding Agent Plugins

Honeydew provides a plugins repository with skills and tools for building semantic models and analyzing data through natural conversation.
  1. Go to Settings -> Customize
  2. Click Browse Plugins
  3. Go to the Personal tab
  4. Click the + icon and choose Add marketplace from GitHub
  5. Enter honeydew-ai/honeydew-ai-claude-plugins in the input box
  6. Two plugins appear: Semantic modeling tools and Data analysis tools. Install both.

Honeydew Documentation MCP

Give Claude Desktop access to the Honeydew documentation through a separate MCP server. No authentication is required.
  1. Go to Settings -> Connectors -> Add custom connector
  2. Enter honeydew-docs in the Name field
  3. Enter https://honeydew.ai/docs/mcp in the Remote MCP server URL field
  4. Click Add

Claude.ai

MCP Server

  1. Go to Settings -> Connectors -> Add custom connector
  2. Enter honeydew in the Name field
  3. Enter https://api.honeydew.cloud/mcp/ in the Remote MCP server URL field
  4. Click Add
You’ll be prompted to authenticate with OAuth to Honeydew when first connecting.

Honeydew Documentation MCP

Give Claude.ai access to the Honeydew documentation through a separate MCP server. No authentication is required.
  1. Go to Settings -> Connectors -> Add custom connector
  2. Enter honeydew-docs in the Name field
  3. Enter https://honeydew.ai/docs/mcp in the Remote MCP server URL field
  4. Click Add

Cortex Code CLI

MCP Server

Run the following command to add the Honeydew MCP server:

Honeydew Documentation MCP

Give Cortex Code CLI access to the Honeydew documentation through a separate MCP server. No authentication is required.
cortex mcp add honeydew-docs \
    https://honeydew.ai/docs/mcp \
    --type http

Cursor

MCP Server

  1. Open the Cursor application
  2. Go to Settings -> Cursor Settings -> Tools & MCP
  3. Click New MCP Server
  4. Add the following configuration:
  5. Click Save

AI Coding Agent Plugins

Honeydew provides a plugins repository with skills and tools for building semantic models and analyzing data through natural conversation.
  1. Go to Cursor Settings > Rules, Skills, Subagents
  2. Click the +New button next to Rules
  3. Select Add from GitHub
  4. Enter the repository URL: https://github.com/honeydew-ai/honeydew-ai-coding-agents-plugins.git

Honeydew Documentation MCP

Give Cursor access to the Honeydew documentation through a separate MCP server. No authentication is required.
  1. Go to Settings -> Cursor Settings -> Tools & MCP
  2. Click New MCP Server
  3. Add the following configuration:
    {
      "name": "honeydew-docs",
      "type": "http",
      "url": "https://honeydew.ai/docs/mcp"
    }
    
  4. Click Save

GitHub Copilot CLI

MCP Server

  1. Launch GitHub Copilot CLI with copilot
  2. Type /mcp add to open the server configuration form
  3. Fill in the following fields:
    • Name: honeydew
    • Type: http
    • URL: https://api.honeydew.cloud/mcp/
    • HTTP Headers:
  4. Press Ctrl+S to save
Use /mcp show to verify the server is connected.

AI Coding Agent Plugins

Honeydew provides a plugins repository with skills and tools for building semantic models and analyzing data through natural conversation.Add the marketplace to Copilot CLI:
/plugin marketplace add honeydew-ai/honeydew-ai-coding-agents-plugins
Then install the Honeydew plugins from the marketplace:
/plugin install semantic-modeling-tools@honeydew-ai-github-copilot-plugins
/plugin install data-analysis-tools@honeydew-ai-github-copilot-plugins

Honeydew Documentation MCP

Give Copilot CLI access to the Honeydew documentation through a separate MCP server. No authentication is required.
  1. Launch GitHub Copilot CLI with copilot
  2. Type /mcp add to open the server configuration form
  3. Fill in the following fields:
    • Name: honeydew-docs
    • Type: http
    • URL: https://honeydew.ai/docs/mcp
  4. Press Ctrl+S to save

Gemini CLI

MCP Server

Run the following command to add the Honeydew MCP server:

AI Coding Agent Skills

Honeydew provides a skills repository with skills for building semantic models and analyzing data through natural conversation.Run the following command to install the Honeydew skills:
gemini skills install \
    https://github.com/honeydew-ai/honeydew-ai-coding-agents-plugins.git \
    --path .gemini/skills

Honeydew Documentation MCP

Give Gemini CLI access to the Honeydew documentation through a separate MCP server. No authentication is required.
gemini mcp add --transport http honeydew-docs \
    https://honeydew.ai/docs/mcp

VS Code and GitHub Copilot

MCP Server

  1. Open the Command Palette with CMD+Shift+P (macOS) or Ctrl+Shift+P (Windows/Linux)
  2. Select MCP: Add Server…
  3. Choose HTTP (HTTP or Server-Sent Events)
  4. Enter the Honeydew MCP server URL: https://api.honeydew.cloud/mcp/
  5. Enter honeydew as the server name
This adds the server to your .vscode/mcp.json file. Open the file and add headers as needed:

Honeydew Documentation MCP

Give VS Code access to the Honeydew documentation through a separate MCP server. No authentication is required.Add the following to your .vscode/mcp.json:
{
  "servers": {
    "honeydew-docs": {
      "type": "http",
      "url": "https://honeydew.ai/docs/mcp"
    }
  }
}

Codex CLI

MCP Server

Command line
codex mcp add honeydew \
    --url https://api.honeydew.cloud/mcp/
Then launch Codex with codex. You’ll be prompted to authenticate with OAuth to Honeydew.After adding the server, open the configuration file at ~/.codex/config.toml and add headers to the [mcp_servers.honeydew] section as needed.TOML configurationAdd the following to ~/.codex/config.toml (or .codex/config.toml in a trusted project):
[mcp_servers.honeydew]
url = "https://api.honeydew.cloud/mcp/"

[mcp_servers.honeydew.env_http_headers]
Authorization = "HONEYDEW_AUTH"
Set the HONEYDEW_AUTH environment variable to Basic <YOUR_BASE64_ENCODED_API_KEY_AND_SECRET> (see Authentication).

AI Coding Agent Skills

Honeydew provides a skills repository with skills for building semantic models and analyzing data through natural conversation.Launch Codex with codex, then run:
$skill-installer Sync my local skills with
https://github.com/honeydew-ai/honeydew-ai-coding-agents-plugins.git:
1) Enumerate repo skills
2) For skills that already exist locally, back them up and replace them with the repo version
3) Install any missing skills
4) Show updated/installed/skipped summary
5) Ask before any destructive overwrite

Honeydew Documentation MCP

Give Codex CLI access to the Honeydew documentation through a separate MCP server. No authentication is required.
codex mcp add honeydew-docs \
    --url https://honeydew.ai/docs/mcp

Codex

MCP Server

  1. Open the Codex application
  2. Go to Settings -> MCP Servers
  3. Under Custom servers, click Add Server
  4. Set the server name to honeydew
  5. Choose Streamable HTTP as the transport type
  6. Set the URL to https://api.honeydew.cloud/mcp/
  7. Leave the Bearer token environment variable field empty
  8. Configure authentication as follows: OAuth authentication Codex redirects you to authenticate with Honeydew when connecting. No additional configuration is needed. HTTP Basic authentication Add an Authorization header to the headers list above with the value Basic <YOUR_BASE64_ENCODED_API_KEY_AND_SECRET> (see Authentication).
Troubleshooting MCP authenticationIf the Honeydew MCP server is not authenticated in Codex and the “Authenticate” option does not appear:
  1. Install the Codex CLI
  2. Run codex mcp login honeydew

AI Coding Agent Skills

Honeydew provides a skills repository with skills for building semantic models and analyzing data through natural conversation.Launch Codex, then run:
$skill-installer Sync my local skills with
https://github.com/honeydew-ai/honeydew-ai-coding-agents-plugins.git:
1) Enumerate repo skills
2) For skills that already exist locally, back them up and replace them with the repo version
3) Install any missing skills
4) Show updated/installed/skipped summary
5) Ask before any destructive overwrite

Honeydew Documentation MCP

Give Codex access to the Honeydew documentation through a separate MCP server. No authentication is required.
  1. Go to Settings -> MCP Servers
  2. Under Custom servers, click Add Server
  3. Set the server name to honeydew-docs
  4. Choose Streamable HTTP as the transport type
  5. Set the URL to https://honeydew.ai/docs/mcp

Antigravity

MCP Server

  1. Open the Antigravity editor
  2. Click the dropdown at the top of the agent panel
  3. Click Manage MCP Servers
  4. Click View raw config
  5. Add the following to mcp_config.json:
  6. Save the file

Honeydew Documentation MCP

Give Antigravity access to the Honeydew documentation through a separate MCP server. No authentication is required.
  1. Open the Antigravity editor
  2. Click the dropdown at the top of the agent panel
  3. Click Manage MCP Servers
  4. Click View raw config
  5. Add the following to mcp_config.json:
    {
      "name": "honeydew-docs",
      "type": "http",
      "url": "https://honeydew.ai/docs/mcp"
    }
    
  6. Save the file

OpenCode

MCP Server

Run the following command and follow the interactive prompts:
opencode mcp add
When prompted, enter the following values:
  1. Location: Choose your preferred scope (current project or global)
  2. MCP server name: honeydew
  3. MCP server type: Remote
  4. MCP server URL: https://api.honeydew.cloud/mcp/
  5. OAuth authentication: Yes
  6. Preregistered client ID: No
Re-authenticationTo re-authenticate, check your status and log out first:
opencode mcp auth list
opencode mcp logout honeydew
opencode mcp auth honeydew

Honeydew Documentation MCP

Give OpenCode access to the Honeydew documentation through a separate MCP server. No authentication is required.
Run opencode mcp add and enter the following values:
  1. MCP server name: honeydew-docs
  2. MCP server type: Remote
  3. MCP server URL: https://honeydew.ai/docs/mcp
  4. OAuth authentication: No

Other Clients

Any MCP-compatible client can connect to the Honeydew MCP Server using the standard HTTP transport. Use the following JSON configuration as a starting point: See Server URL, Authentication, and Configuration for details on each parameter.

Example Usage

Once connected, you can prompt your AI assistant with questions like:
  • “What entities are available in the semantic model?”
  • “Show me the attributes and metrics for the orders entity”
  • “What domains are defined in the model?”
  • “What tables are in the analytics schema?”
  • “How many orders were placed last month?”
  • “Create a new metric for total revenue on the orders entity”
  • “What is the average order value by region for the last quarter?”

Troubleshooting

OAuth Authentication Problems

Verify your client supports OAuth, ensure you have the necessary Honeydew workspace permissions, and attempt re-authentication through your client’s MCP management interface. Re-authenticating in Claude Code Type /mcp, select the Honeydew MCP from the list, choose “Clear authentication” or “Authenticate”, then follow the browser OAuth prompts to reconnect to Honeydew.

Connection Issues

Confirm the MCP server URL matches https://api.honeydew.cloud/mcp/ and verify your client’s MCP configuration syntax is correct. If your organization uses a custom hostname, check that the URL matches your tenant hostname that appears in Settings > MCP Server in Honeydew Studio.

Missing Tools

Verify authentication succeeded, check your Honeydew workspace access permissions, and review your client’s console for error messages. For additional support, contact Honeydew support at support@honeydew.ai.

Tools Available

Tools marked as read-only do not modify the semantic model or the data warehouse.
To expose only read-only tools, set the ReadonlyToolsOnly: true header in your MCP server configuration. When enabled, the server returns only tools that do not modify the semantic model or the data warehouse.

Session & Workspace

list_workspaces

read-only List all available workspaces. Returns the workspace name, and the data warehouse type (snowflake, databricks, or bigquery). Use the data warehouse type to inform semantic model implementation.

list_workspace_branches

read-only List all branches available for a workspace.
workspace_id
string
required
The name of the workspace.

get_session_workspace_and_branch

read-only Get the workspace and branch set for the current session.

set_session_workspace_and_branch

Set the workspace and branch to use for the current session. All subsequent tool calls in the session use this workspace and branch.
workspace_id
string
required
The name of the workspace.
branch_id
string
default:"prod"
The branch to use.

create_workspace_branch

Create a new branch for an existing workspace. The branch is created from the current state of the workspace’s prod branch. If no workspace is pinned via headers, the session switches to the new branch automatically.
workspace_id
string
required
Name of the workspace to create a branch for.
branch_name
string
required
Name of the new branch to create.

Question & Analysis

ask_question_get_data

read-only Ask a data question in natural language and get the data results.
question
string
required
The natural language question to ask.
max_rows
number
Maximum number of rows to return.
domain
string
The domain to query against.

ask_question_get_sql

read-only Ask a data question in natural language and get the SQL query. You can then run the query in your data warehouse to get the results.
question
string
required
The natural language question to ask.
domain
string
The domain to query against.

ask_deep_analysis_question

read-only Ask a data question that performs a multi-step analysis. Supports follow-up questions using a conversation_id.
question
string
required
The natural language question to ask.
domain
string
required
The domain to query against.
conversation_id
string
ID of a previous conversation for follow-up questions.

Browse & Discovery

list_entities

read-only List all entities in the semantic model with their names, descriptions, and keys.

get_entity

read-only Get detailed information about an entity, including its attributes, metrics, datasets, relations, and YAML definition.
entity_name
string
required
The name of the entity.

get_field

read-only Get detailed information about a specific field (attribute or metric) within an entity, including its YAML definition.
entity_name
string
required
The name of the entity containing the field.
field_name
string
required
The name of the field.

list_domains

read-only List all domains in the semantic model with their names, descriptions, and entities.

get_domain

read-only Get detailed information about a domain, including its entities, filters, parameters, and YAML definition.
domain_name
string
required
The name of the domain.

search_model

read-only Search the semantic model for entities, attributes, metrics, datasets, dynamic datasets and domains, matching a query string.
query
string
required
The search query string.
full_match
boolean
default:"false"
Whether to require a full match.

Warehouse Discovery

list_databases

read-only List all databases available in the connected data warehouse.

list_schemas

read-only List all schemas in a specific database in the connected data warehouse.
database
string
required
The database name.

list_tables

read-only List tables/views in a specific database and schema in the connected data warehouse.
database
string
required
The database name.
schema
string
required
The schema name.

get_table_info

read-only Get detailed information about a warehouse table/view, including its columns and metadata.
database
string
required
The database name.
schema
string
required
The schema name.
table
string
required
The table name.

Semantic Model

import_tables

Import tables from the connected data warehouse into the semantic model. Each table becomes an entity with its columns as attributes.
tables
string[]
required
List of fully qualified table names in the format database.schema.table.

create_entity

Create a new entity in the semantic model from YAML definitions.
entity_yaml
string
required
The YAML definition for the entity.
dataset_yaml
string
required
The YAML definition for the dataset.

create_object

Create a new semantic model object from a YAML definition. Supported types: attribute, metric, dynamic dataset, domain, and global parameter.
yaml_text
string
required
The YAML definition of the object.
force_with_error
boolean
Create the object even if validation produces errors.

update_object

Update an existing semantic model object from a YAML definition. Supported types: entity, attribute, metric, dataset, dynamic dataset, domain, and global parameter.
yaml_text
string
required
The YAML definition of the object.
object_key
string
The key of the object to update.
force_with_error
boolean
Update the object even if validation produces errors.

validate_object

read-only Validate a semantic model object YAML definition without creating or updating it. Supported types: entity, attribute, metric, dataset, dynamic dataset, domain, and global parameter.
yaml_text
string
required
The YAML definition to validate.
object_key
string
The key of the object to validate against.

delete_object

Delete a semantic model object by its key.
object_key
string
required
The key of the object to delete.
force_with_error
boolean
Delete the object even if validation produces errors.

Query & Preview

get_sql_from_fields

read-only Generate the SQL query for a semantic layer query defined by attributes, metrics, and filters. Returns the SQL without executing it.
attributes
string[]
List of attribute names to include.
metrics
string[]
List of metric names to include.
filters
string[]
List of filter expressions.
order_by
string[]
List of fields to order by. Field names must be wrapped in double quotes. Use "entity.field_name" or "entity.field_name" DESC. When using aliases, order by the alias name.
domain
string
The domain to query against.
limit
number
default:"100"
Maximum number of rows to return.
offset
number
default:"0"
Number of rows to skip for pagination.

get_data_from_fields

read-only Execute a semantic layer query defined by attributes, metrics, and filters, and return the resulting data.
attributes
string[]
List of attribute names to include.
metrics
string[]
List of metric names to include.
filters
string[]
List of filter expressions.
order_by
string[]
List of fields to order by. Field names must be wrapped in double quotes. Use "entity.field_name" or "entity.field_name" DESC. When using aliases, order by the alias name.
domain
string
The domain to query against.
limit
number
default:"100"
Maximum number of rows to return.
offset
number
default:"0"
Number of rows to skip for pagination.