Back to MCP Servers

Hex MCP Server

Official MCP server for the Hex collaborative data workspace. Search projects, kick off Threads, and analyze data with SQL and Python from your AI client.

Analytics by Hex Technologies OAuth2 active
Overview

Hex is a collaborative data workspace that combines SQL, Python, and no-code analytics. The official Hex MCP server (currently in beta) lets AI assistants like Claude Desktop, Claude Code, and Cursor connect securely to a Hex workspace, search for existing projects, and run natural language data analysis through Hex Threads (Hex's agentic data exploration interface).

The server exposes four tools: search_projects, create_thread, get_thread, and continue_thread. When you ask a question, Hex's agent automatically picks accessible data connections based on your workspace permissions and produces charts, tables, and SQL/Python analysis. Authentication runs through OAuth on first use, so credentials stay scoped to the user's Hex workspace role rather than a shared API key.

Because it is provider-hosted, there is no package to install: MCP clients simply point at the Hex server URL (or a custom subdomain for single-tenant, EU, or HIPAA deployments). The server requires a Team or Enterprise Hex plan and an Explorer (or higher) workspace role. File uploads are not currently supported; the server only accepts text prompts.

Tools

Tool Description
search_projects Find projects in your Hex workspace by title or other attributes. Returns matching projects with descriptions and direct links.
create_thread Start a new Hex Thread conversation. The Hex agent automatically picks accessible data connections, runs SQL/Python, and produces analysis, charts, and tables.
get_thread Retrieve the current status, messages, charts, tables, and results from an existing Thread.
continue_thread Add a follow-up question to an existing Thread for deeper exploration of a prior analysis.
Setup Guide

Prerequisites

  • A Hex Team or Enterprise plan
  • Explorer workspace role or higher
  • An MCP-compatible client (Claude Desktop, Claude Code, Cursor, or another standard MCP client)

Server URL

Default: https://app.hex.tech/mcp

For custom deployments, replace the host:

  • Single-tenant: https://your-company.hex.tech/mcp
  • EU multi-tenant: https://eu.hex.tech/mcp
  • HIPAA multi-tenant: https://hc.hex.tech/mcp

Cursor

Add to ~/.cursor/mcp.json:

{
  "mcpServers": {
    "hex": {
      "url": "https://app.hex.tech/mcp"
    }
  }
}

Open Cursor Settings, click Connect next to the Hex server to initiate OAuth, then enable the desired tools under "Tools & MCP".

Claude Desktop / Claude Code

  1. Open Settings, choose Connectors, then Browse Connectors.
  2. Find the Hex connector and add it to your workspace.
  3. Set the server URL to https://app.hex.tech/mcp (or your custom deployment URL).
  4. Click Connect to complete OAuth.
  5. In a new chat, toggle the Hex connector on via the '+' icon.

Other MCP clients

Use the same JSON configuration as Cursor. Restart the client, then authenticate via the OAuth flow on first use.

Use Cases
  • Ask natural language questions against your warehouse and have Hex generate SQL, Python, and charts inside a Thread without leaving your editor.
  • Locate existing Hex projects (dashboards, notebooks, apps) by topic before building new analysis.
  • Continue a previous Thread with follow-up questions to drill deeper into a metric or anomaly.
  • Use Cursor or Claude Code to draft data exploration workflows, then hand off to a Hex Thread for execution against governed data connections.
  • Let an AI agent answer ad hoc analytics questions while respecting each user's Hex workspace permissions and default data connection.
Example Prompts
  • "Search Hex for projects related to monthly active users."
  • "Start a Hex Thread to break down last quarter's revenue by product line and region."
  • "Get the latest results from the Hex Thread I started about churn cohorts."
  • "Continue the Hex Thread about pipeline conversion and add a chart comparing this quarter to last."
  • "Find any Hex project that touches the Stripe payments table and link me to it."
Pros
  • Official, provider-hosted server with no install or local process to maintain.
  • OAuth authentication respects each user's Hex workspace role and data connection permissions.
  • Threads can produce real SQL, Python, charts, and tables, not just metadata lookups.
  • Works out of the box with Claude Desktop, Claude Code, Cursor, and standard MCP clients.
Limitations
  • Currently in beta and requires a Team or Enterprise plan plus Explorer-or-higher workspace role.
  • File uploads are not supported; prompts are text only.
  • Small surface area (four tools), focused on search and Threads rather than full project CRUD or admin operations.
Alternatives
  • franccesco/hex-mcp: Community-built MCP server that wraps Hex's public REST API for project orchestration and run management.
  • tomnagengast/mcp-server-hex: Another community MCP server for the Hex analytics platform.
  • Hex's public REST API directly, for use cases not covered by the official MCP server.