Clearinghouse
A single-auth MCP server that gives Claude unified access to deal intelligence from Salesforce, Slack, and Gong, enabling natural-language queries about deal status, activity, and pipeline health.
README
Clearinghouse
Single-auth GTM deal-intelligence MCP server for 1upHealth. One connector in
Claude (https://mcp.1uphealth.com/mcp), one "Continue with Google" sign-in,
and every deal answer the company already has in Gong, Salesforce, and Slack —
without anyone ever connecting those three systems themselves. The user's token
stops at this server; downstream systems are reached with org credentials that
never leave GCP.
PRD (v1.0 draft, 2026-08-05): the Claude artifact "Clearinghouse — PRD".
Status — Weeks 1–4 slice
- OAuth 2.1 resource server — RFC 9728 metadata at
/.well-known/oauth-protected-resource, the 401 +WWW-Authenticate: resource_metadatahandshake Claude requires, JWT verification against the rented authorization server via JWKS. find_deal— fuzzy deal name → real Salesforce opportunities.deal_status— the Salesforce picture of one deal. Itscoveragefield points at the two tools below rather than returning a silently thin answer.deal_channel_activity— a deal's synced Slack activity. Not a separate Slack API: messages arrive in Salesforce asslackv2__Slack_Message__crecords joined to the Opportunity, so there's no channel-Id concept and no separate credential. External senders are flagged, not hidden — see the live-setup note below on how that's inferred.call_details— recent Gong calls on a deal: when, how long, who was on them, and Gong's brief only once Decision D is answered (see below).recent_activity— no deal Id required: the most recently modified Salesforce opportunities in a window, each annotated with how many Slack messages and Gong calls landed on it in the same window. For "what should I catch up on."coverage_check— bulk data-hygiene sweep across open deals: which ones have no Slack activity synced, no next step, or no Gong call on file.deal_status's owncoveragefield answers this one deal at a time; this is the many-deals-at-once version.pipeline_snapshot— the read-only, Claude-facing sibling ofpipeline-pulse: same fiction detection (ghost_expansion,renewal_blindspot,stale_momentum), answered inline instead of on a schedule, and it never proposes or writes anything to Planhat.- Roster gate — Git-backed
roster.json, deny by default, denial audited. - Audit — every tool call logged as one JSON line (actor, tool, args, systems, bytes, latency) for the Cloud Logging → BigQuery sink.
- Injection guards — typed enumerated inputs, one escape path for SOQL, Salesforce Ids validated by shape, LIMIT capped server-side; free-text fields (deal descriptions, Slack messages, Gong call titles and briefs) returned inside a labeled external-data envelope.
pipeline-pulseroutine — a service-to-service job (not a Claude tool) that cross-references Salesforce opportunities against Planhat companies to flag "fictions": pipeline data that looks fine but isn't (ghost_expansion,renewal_blindspot,stale_momentum). See below./dashboard— a browser UI behind the same roster gate as/mcp, for people who want the data directly instead of asking Claude: deal lookup, a pipeline-pulse review board, and roster/audit admin. See below.
Not yet built (Week 5+): the Gong nightly index that replaces the window scan, per-person budgets, directory sync.
Run locally
npm install
cp .env.example .env # defaults: AUTH_MODE=dev, SF_MODE=mock, PLANHAT_MODE=mock
npm run dev
npm test
Smoke-test with MCP Inspector: npx @modelcontextprotocol/inspector, connect
to http://localhost:8080/mcp (streamable HTTP). In dev mode identity comes
from DEV_USER_EMAIL, which must be on roster.json. Dev mode refuses to
start when NODE_ENV=production.
Launch gates → where they live
| Gate | What | Where |
|---|---|---|
| 01 Fake-"Claude" phishing | DCR off, one pinned client, one redirect URI (https://claude.ai/api/mcp/auth_callback) |
Auth-vendor dashboard — two settings, do this the day the tenant exists |
| 02 Lookalike connector URL | Host on 1uphealth.com itself; connector-adding restricted to Claude org admins |
Decision A + Claude admin console |
| 03 Gong tenant walk | call_details reaches calls only through a resolved Salesforce opportunity; GongClient exposes no list-all and no by-call-Id path, and the live window scan is page-capped |
src/gong/types.ts, src/gong/live.ts |
| 04 PHI on sales calls | GONG_CONTENT=metadata means the call brief is never requested — no redaction pass is load-bearing. Turning it on needs GONG_PHI_REVIEW_SIGNED_OFF=true or the server refuses to start |
Decision D — src/config.ts, still unanswered |
| 05 Salesforce signing key | JWT bearer as one pre-authorized integration user (src/salesforce/client.ts, shared by LiveSalesforce and LiveSlack); key generated in Cloud Shell, never a laptop; connected app locked to that user + static egress IP |
Code + Salesforce setup runbook below |
| 06 Roster misconfiguration | Git-backed roster.json, service reads only, deny by default, denials audited |
src/roster.ts, src/http/auth.ts |
Salesforce live setup (Gate 05 runbook)
- Create integration user
clearinghouse@1uphealth.comwith a read-only profile scoped to Opportunity + Account, plus read onslackv2__Slack_Message__cifSLACK_MODE=live— Slack activity is synced in by a Slack managed package, not a separate bot API, so this one connection covers both. (isExternalon a message is a heuristic — whether it resolved to a Contact/Lead, not a real field. Verify against real messages before relying on it.) - In Cloud Shell (so the key never touches a laptop):
openssl req -x509 -newkey rsa:2048 -nodes -keyout sf.key -out sf.crt -days 730 - Connected app: upload
sf.crt, enable OAuth, scopesapi; Admin approved users are pre-authorized; assign only the integration user's profile; set Relax IP restrictions = Enforce, allowlist the Cloud Run static egress IP (via Serverless VPC connector + Cloud NAT). - Put
sf.keyin Secret Manager asSF_PRIVATE_KEY; delete the local copy. - Set
SF_MODE=live,SF_CLIENT_ID(consumer key),SF_USERNAME.
Gong live setup (Gates 03 + 04 runbook)
- Gong admin → API key for this service only; store both halves in Secret
Manager as
GONG_ACCESS_KEY/GONG_ACCESS_KEY_SECRET. - Leave
GONG_CONTENT=metadata. In this mode the content selector sent to Gong omitscontent.briefentirely, so no spoken content reaches this process, its memory, or its logs — the gate is the request, not a filter. - Before flipping to
GONG_CONTENT=summaries: confirm the BAA and retention terms covering call recordings (Decision D), then setGONG_PHI_REVIEW_SIGNED_OFF=true. Live Gong refuses to boot with summaries on while that is false — deliberately two hands, not one flag. - Verify the response shape first.
src/gong/live.tsfollows Gong's documented/v2/calls/extensivepayload (metaData,parties[].affiliation,context[].objects[]) but has never run against 1upHealth's tenant. Check one real call beforeGONG_MODE=live. GONG_LOOKBACK_DAYS(default 180) bounds the window scan. This is the direct-read stand-in for the PRD's nightly index; when call volume makes the scan slow, the index lands behind the sameGongClientinterface.
Pipeline-pulse routine (Planhat)
POST /routines/pipeline-pulse is a separate, service-to-service path — not
part of the /mcp connector Claude talks to, and not reachable by an end-user
Claude session. It's meant to be triggered by Cloud Scheduler, not a person.
What it does: pulls Salesforce opportunities and Planhat companies, then runs three deterministic detectors over them —
ghost_expansion— a Planhat expansion signal with no real health behind it (seesrc/fictions/rules/ghostExpansion.ts)renewal_blindspot— a Planhat renewal coming due (or overdue) with no open Salesforce opportunity anywhere near that datestale_momentum— a late-stage opportunity that's gone quiet in both Salesforce and Planhat
High-confidence findings can propose a [DRAFT] Planhat project as a
follow-up; everything else surfaces as a Slack nudge (suggestedAction).
ROUTINES_DRY_RUN=true by default means the routine always computes and
returns what it would create in Planhat without ever calling the write
method — the preview response and the real write share the same code path
(toProjectDraft in src/routines/pipelinePulse.ts), so the preview can't
drift from reality.
Before setting PLANHAT_MODE=live or ROUTINES_DRY_RUN=false:
src/planhat/live.ts's field mapping (RawCompany) is a best-effort guess at Planhat's schema — a real-tenant lookup was started but never finished. Verify it against one real company record first.- Generate a Planhat API token scoped to this service, store it as
PLANHAT_API_TOKEN(Secret Manager in Cloud Run, never a file in the repo). - Generate a random secret ≥16 chars for
ROUTINES_SHARED_SECRET; whoever calls the route (Cloud Scheduler) sends it asx-routines-secret. Unset = the route always 403s, independent of whether the rest of the server is configured. - Only after (1) is confirmed against real data, flip
ROUTINES_DRY_RUN=false— until then, run it in dry-run and read theproposedProjectsit returns.
Local dashboard
/dashboard is a second, human-facing surface — same server, same
bearerAuth + roster gate as /mcp, just a browser tab instead of a Claude
conversation. For anyone who wants to look something up directly, or for
demoing/debugging without going through Claude at all. Vanilla JS, no build
step, no separate deploy.
Six tabs:
- Overview — the default landing tab: a RevOps one-page rollup instead of
five separate places to look. Open pipeline value and deal count, open
pipeline by stage, fictions by severity (same detection as pipeline-pulse),
a "needs attention" list of the top fictions, coverage-check's gap count,
and upcoming Planhat renewals sorted soonest-first (overdue ones sort to
the top, not the bottom — a lapsed renewal date is still the most urgent
thing on the list). Pure rollup —
src/routines/overview.ts— no new system calls beyond what the other tabs already make, and no write path. - Deal lookup — search by name (
find_deal), pick a result, see the same combined Salesforce + Gong + Slack picturedeal_status/deal_channel_activity/call_detailsgive Claude. - Recent activity —
recent_activityas a form: an owner filter and a day count instead of a deal Id. - Coverage check —
coverage_checkas a form: which open deals have no Slack activity synced, no next step, or no Gong call. - Pipeline-pulse — a "Run pipeline-pulse (dry run)" button that lists the
fictions it finds and the Planhat projects it would propose. This button
always forces
dryRun: true, regardless ofROUTINES_DRY_RUNin config — a person clicking a button in a browser should never be the thing that writes to Planhat; only the Cloud Scheduler-triggered/routines/pipeline-pulsepath can do that, and only once (1) in that section's runbook is done. (No separate tab forpipeline_snapshot— same underlying scan, so this tab already covers it;pipeline_snapshotexists as its own MCP tool because Claude needs a read-only-only version with no proposed-projects section at all.) - Admin & audit — the roster's members, and a live tail of the most recent audit events (in-memory, capped, lost on restart — the durable trail is still Cloud Logging → BigQuery; this is a convenience view, not a second source of truth).
Free text from external systems (deal descriptions, Slack messages, Gong call
titles) is written into the page with textContent, never innerHTML — same
untrusted-data handling as everywhere else in this codebase, just for a human
reader instead of an LLM.
Auth vendor setup (Decision C — vendor-agnostic checklist)
Whichever of WorkOS AuthKit / Auth0 / Stytch / Descope is chosen, on
auth.1uphealth.com (CNAME so the vendor stays swappable):
- Federate to Google Workspace; restrict to the 1uphealth.com hosted domain.
- Disable dynamic client registration (Gate 01).
- Register exactly one client, redirect URI
https://claude.ai/api/mcp/auth_callback, PKCE required. - Access tokens: JWT, audience =
https://mcp.1uphealth.com/mcp, includeemail. Long-lived rotating refresh tokens with reuse detection — Claude's background refresh is unreliable, and a dead refresh token must return exactlyinvalid_grantor users get wedged. - Do not put a WAF in front of the IdP that blocks Anthropic egress
(
160.79.104.0/21must reach both this server and the AS). - Fill
AUTH_ISSUER+AUTH_JWKS_URL, setAUTH_MODE=oauth.
Deploy (Cloud Run)
- Stateless by construction: one MCP server instance per request, JSON responses, no sessions — safe under autoscaling.
- Public ingress; OAuth enforced in-app (Claude cannot mint Google IAM tokens, so Cloud Run IAM protection is unusable).
roster.jsonships in the image; the deploy pipeline is the only writer (Gate 06). CI syncs it from the repo — or from the restricted Google group if Decision E lands that way.
Open decisions (PRD §08)
| Decision | Recommendation | Where it lands here | |
|---|---|---|---|
| A | Domain | mcp.1uphealth.com + auth.1uphealth.com; register lookalikes |
PUBLIC_URL, AUTH_ISSUER |
| B | One access tier or two | One tier for v1, stated at consent | roster stays one flat list |
| C | Auth vendor | Any of the four; keep DNS ours | AUTH_ISSUER/AUTH_JWKS_URL only |
| D | PHI / BAA gate | Confirm Claude-plan retention terms + GCP BAA; only decision that can change the product | GONG_CONTENT + GONG_PHI_REVIEW_SIGNED_OFF. Still open — Gong ships metadata-only until it is answered |
| E | Roster ownership | One restricted Google group, synced by CI | replaces hand-edits to roster.json |
Deliberately not building
No workspace-wide Slack search, no stored Slack messages, no write tools in
the Claude-facing connector, ever, no admin tools inside the connector (PRD
§06). The one write path in this repo — pipeline-pulse creating draft
Planhat projects — is a separate service-to-service routine Claude can never
reach, dry-run by default, and still gated on an unverified field mapping
(see above).
Recommended Servers
playwright-mcp
A Model Context Protocol server that enables LLMs to interact with web pages through structured accessibility snapshots without requiring vision models or screenshots.
Magic Component Platform (MCP)
An AI-powered tool that generates modern UI components from natural language descriptions, integrating with popular IDEs to streamline UI development workflow.
Audiense Insights MCP Server
Enables interaction with Audiense Insights accounts via the Model Context Protocol, facilitating the extraction and analysis of marketing insights and audience data including demographics, behavior, and influencer engagement.
VeyraX MCP
Single MCP tool to connect all your favorite tools: Gmail, Calendar and 40 more.
graphlit-mcp-server
The Model Context Protocol (MCP) Server enables integration between MCP clients and the Graphlit service. Ingest anything from Slack to Gmail to podcast feeds, in addition to web crawling, into a Graphlit project - and then retrieve relevant contents from the MCP client.
Kagi MCP Server
An MCP server that integrates Kagi search capabilities with Claude AI, enabling Claude to perform real-time web searches when answering questions that require up-to-date information.
E2B
Using MCP to run code via e2b.
Neon Database
MCP server for interacting with Neon Management API and databases
Exa Search
A Model Context Protocol (MCP) server lets AI assistants like Claude use the Exa AI Search API for web searches. This setup allows AI models to get real-time web information in a safe and controlled way.
Qdrant Server
This repository is an example of how to create a MCP server for Qdrant, a vector search engine.