Brainforge Knowledge

hex-mcp-setup

2 min read

Hex MCP Setup for Cursor

Version: 1.0
Date: February 2026
Owner: AI Team

1. Purpose

This guide enables Cursor AI agents to query Hex apps (e.g. GTM Daily Metrics Tracker) for ARR and other metrics. Use this when reconciling Snowflake/dbt numbers with Hex dashboards or when the user asks about metrics from a Hex app.

2. When to Use

  • Reconciling ARR or other metrics between Snowflake and Hex (e.g. GTM Daily Metrics Tracker)
  • User asks: “what does Hex show for ARR?”, “compare Hex GTM metrics to dbt”
  • Verifying client-reported numbers against Hex app output

Agent behavior: Use Hex MCP tools to search projects, create threads, and query app logic. Compare results to Snowflake queries (e.g. fct_stripe__subscription_daily_arr).

3. Installation & Configuration

Already configured in brainforge-platform

The brainforge-platform repo includes .cursor/mcp.json with the Hex MCP. When you open this repo as your Cursor workspace, the MCP is loaded automatically.

Location: .cursor/mcp.json (at repo root)

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

OAuth Authentication

  1. After adding Hex to mcp.json, reload Cursor: Developer: Reload Window.
  2. Go to Cursor Settings → Tools & MCP.
  3. Click Connect next to Hex to complete OAuth (redirects to Hex; select workspace if multiple).
  4. Ensure the Hex workspace has a default data connection configured (required for create_thread).
  5. Note: In Cursor, agents invoke Hex via server project-0-brainforge-platform-hex (not hex).

4. Key Hex App: GTM Daily Metrics Tracker

  • URL: GTM Daily Metrics Tracker
  • Workspace: 019a02c4-f929-7111-b8a2-5ffed5d510ab
  • Use case: ARR verification (compare to PROD_MARTS.REVENUE.FCT_STRIPE__SUBSCRIPTION_DAILY_ARR)

5. ARR Reconciliation Workflow

  1. Snowflake: Run knowledge/clients/hedra/resources/snowflake-verify/arr_verification_2026_01_26.sql (from repo root) or query FCT_STRIPE__SUBSCRIPTION_DAILY_ARR for the target date.
  2. Hex: Use create_thread with a prompt such as: “What is the total ARR as of January 26, 2026 from the subscription data? Break down by product/tier if possible.”
  3. Compare: Document Hex ARR vs Snowflake ARR; if they differ, use continue_thread to ask how ARR is calculated in the app.

6. Reference

  • Hex MCP URL: https://app.hex.tech/mcp
  • Config location: mcp.json (repo root)
  • Hedra ARR verification: FINDINGS.md §5

Graph View

Backlinks