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 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: OAuth or HTTP Basic authentication. OAuth Authentication (recommended) Most clients support OAuth authentication. When you first connect, you’ll be prompted to:- Log in with your Honeydew account
- Accept the OAuth authorization
API_KEY:API_SECRET.
You can use the following command
to generate the Base64-encoded string:
- MacOS
- Windows
Authorization header as follows:
Authorization: Basic <YOUR_BASE64_ENCODED_API_KEY_AND_SECRET>
Configuration
Each MCP Server request must include additional headers to specify the Honeydew workspace and branch to use.Workspace: Set the Honeydew workspaceBranch: Set the Honeydew branch to use, such asprodordevHoneydew-Client: Provide a client identifier for tracking purposes (optional)ReadonlyToolsOnly: Set totrueto expose only read-only tools (optional)
Supported Clients
Claude Code
Setup instructions
Setup instructions
MCP Server
- Command line
- JSON configuration
- .mcp.json
Run the following command to add the Honeydew MCP server:Launch Claude Code with
- OAuth (recommended)
- API Key
claude.
You’ll be prompted to authenticate with OAuth to Honeydew.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 Claude Code:Honeydew Documentation MCP
Give Claude Code access to the Honeydew documentation through a separate MCP server. No authentication is required.Claude Desktop
Setup instructions
Setup instructions
MCP Server
- Open Claude Desktop
- Go to Settings -> Developer
- Click Edit Config
- Add the following to
claude_desktop_config.json:
- OAuth (recommended)
- API Key
AI Coding Agent Plugins
Honeydew provides a plugins repository with skills and tools for building semantic models and analyzing data through natural conversation.- Go to Settings -> Customize
- Click Browse Plugins
- Go to the Personal tab
- Click the + icon and choose Add marketplace from GitHub
- Enter
honeydew-ai/honeydew-ai-claude-pluginsin the input box - 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.Add the following toclaude_desktop_config.json
alongside the main Honeydew MCP server:Cortex Code CLI
Setup instructions
Setup instructions
MCP Server
- Command line
- JSON configuration
- mcp.json
Run the following command to add the Honeydew MCP server:Launch Cortex Code CLI with
- OAuth (recommended)
- API Key
cortex.
You’ll be prompted to authenticate
with OAuth to Honeydew.Honeydew Documentation MCP
Give Cortex Code CLI access to the Honeydew documentation through a separate MCP server. No authentication is required.Cursor
Setup instructions
Setup instructions
MCP Server
- Open the Cursor application
- Go to Settings -> Cursor Settings -> Tools & MCP
- Click New MCP Server
-
Add the following configuration:
- OAuth (recommended)
- API Key
- 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.- Go to Cursor Settings > Rules, Skills, Subagents
- Click the +New button next to Rules
- Select Add from GitHub
- 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.- Go to Settings -> Cursor Settings -> Tools & MCP
- Click New MCP Server
- Add the following configuration:
- Click Save
GitHub Copilot CLI
Setup instructions
Setup instructions
MCP Server
-
Launch GitHub Copilot CLI with
copilot -
Type
/mcp addto open the server configuration form -
Fill in the following fields:
- Name:
honeydew - Type:
http - URL:
https://api.honeydew.cloud/mcp/ - HTTP Headers:
- OAuth (recommended)
- API Key
- Name:
-
Press
Ctrl+Sto save
/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:Honeydew Documentation MCP
Give Copilot CLI access to the Honeydew documentation through a separate MCP server. No authentication is required.- Launch GitHub Copilot CLI with
copilot - Type
/mcp addto open the server configuration form - Fill in the following fields:
- Name:
honeydew-docs - Type:
http - URL:
https://honeydew.ai/docs/mcp
- Name:
- Press
Ctrl+Sto save
VS Code and GitHub Copilot
Setup instructions
Setup instructions
MCP Server
- Open the Command Palette with
CMD+Shift+P(macOS) orCtrl+Shift+P(Windows/Linux) - Select MCP: Add Server…
- Choose HTTP (HTTP or Server-Sent Events)
- Enter the Honeydew MCP server URL:
https://api.honeydew.cloud/mcp/ - Enter
honeydewas the server name
.vscode/mcp.json file.
Open the file and add the required headers:- OAuth (recommended)
- API Key
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:Codex CLI
Setup instructions
Setup instructions
MCP Server
Command linecodex.
You’ll be prompted to authenticate
with OAuth to Honeydew.After adding the server,
open the configuration file
at ~/.codex/config.toml and add the required
headers to the [mcp_servers.honeydew] section.TOML configurationAdd the following to ~/.codex/config.toml
(or .codex/config.toml in a trusted project):HONEYDEW_AUTH environment variable to
Basic <YOUR_BASE64_ENCODED_API_KEY_AND_SECRET>
(see Authentication).Honeydew Documentation MCP
Give Codex CLI access to the Honeydew documentation through a separate MCP server. No authentication is required.Codex (Desktop)
Setup instructions
Setup instructions
MCP Server
- Open the Codex application
- Go to Settings -> MCP Servers
- Under Custom servers, click Add Server
-
Set the server name to
honeydew - Choose Streamable HTTP as the transport type
-
Set the URL to
https://api.honeydew.cloud/mcp/ - Leave the Bearer token environment variable field empty
-
Add the following headers:
Workspace:<workspace name>Branch:<branch name, e.g. prod or dev>Honeydew-Client:Codex
-
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
Authorizationheader to the headers list above with the valueBasic <YOUR_BASE64_ENCODED_API_KEY_AND_SECRET>(see Authentication).
Honeydew Documentation MCP
Give Codex access to the Honeydew documentation through a separate MCP server. No authentication is required.- Go to Settings -> MCP Servers
- Under Custom servers, click Add Server
- Set the server name to
honeydew-docs - Choose Streamable HTTP as the transport type
- Set the URL to
https://honeydew.ai/docs/mcp
Antigravity
Setup instructions
Setup instructions
MCP Server
- Open the Antigravity editor
- Click the … dropdown at the top of the agent panel
- Click Manage MCP Servers
- Click View raw config
-
Add the following to
mcp_config.json:- OAuth (recommended)
- API Key
- Save the file
Honeydew Documentation MCP
Give Antigravity access to the Honeydew documentation through a separate MCP server. No authentication is required.- Open the Antigravity editor
- Click the … dropdown at the top of the agent panel
- Click Manage MCP Servers
- Click View raw config
- Add the following to
mcp_config.json: - Save the file
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:- OAuth (recommended)
- API Key
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
ordersentity” - “What tables are in the
analyticsschema?” - “How many orders were placed last month?”
- “Create a new metric for total revenue
on the
ordersentity” - “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 matcheshttps://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.Question & Analysis
ask_question_get_data
read-only
Ask a data question in natural language
and get the data results.
The natural language question to ask.
Maximum number of rows to return.
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.
The natural language question to ask.
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.
The natural language question to ask.
The domain to query against.
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.
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.
The name of the entity containing the field.
The name of the field.
search_model
read-only
Search the semantic model for entities, attributes, metrics, datasets,
dynamic datasets and domains, matching a query string.
The search query string.
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.
The database name.
list_tables
read-only
List tables/views in a specific database and schema in the connected data warehouse.
The database name.
The schema name.
get_table_info
read-only
Get detailed information about a warehouse table/view, including its columns and metadata.
The database name.
The schema name.
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.
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.
The YAML definition for the entity.
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.
The YAML definition of the object.
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.
The YAML definition of the object.
The key of the object to update.
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.
The YAML definition to validate.
The key of the object to validate against.
delete_object
Delete a semantic model object by its key.
The key of the object to delete.
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.
List of attribute names to include.
List of metric names to include.
List of filter expressions.
List of fields to order by.
The domain to query against.
get_data_from_fields
read-only
Execute a semantic layer query defined by attributes, metrics, and filters,
and return the resulting data.
List of attribute names to include.
List of metric names to include.
List of filter expressions.
List of fields to order by.
The domain to query against.
Maximum number of rows to return.
Number of rows to skip for pagination.