惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

博客园 - 司徒正美
月光博客
月光博客
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
美团技术团队
WordPress大学
WordPress大学
罗磊的独立博客
Last Week in AI
Last Week in AI
人人都是产品经理
人人都是产品经理
爱范儿
爱范儿
MongoDB | Blog
MongoDB | Blog
J
Java Code Geeks
H
Hackread – Cybersecurity News, Data Breaches, AI and More
H
Help Net Security
S
SegmentFault 最新的问题
C
Check Point Blog
酷 壳 – CoolShell
酷 壳 – CoolShell
腾讯CDC
Engineering at Meta
Engineering at Meta
The GitHub Blog
The GitHub Blog
F
Fortinet All Blogs
D
DataBreaches.Net
雷峰网
雷峰网
GbyAI
GbyAI
宝玉的分享
宝玉的分享

DEV Community

Authentication Security Deep Dive: From Brute Force to Salted Hashing (With Java Examples) Why AI Systems Don’t Fail — They Drift Spilling beans for how i learn for exam😁"Reinforcement Learning Cheat Sheet" I Replaced Chrome with Safari for AI Browser Automation. Here's What Broke (and What Finally Worked) How Python Borrows Other People's Work The $40 Architecture: Processing 1 Billion API Requests with 99.99% Uptime Vibe Coding: A Workflow Guide (From Zero to SaaS) Most webhook security guides protect the wrong side. The scary part is delivery. Headless CMS for TanStack Start: Build a Blog with Cosmic EU Age Verification App "Hacked in 2 Minutes" — What Actually Happened Comfy Cloud’s delete function does not actually remove files Running AI Models on GPU Cloud Servers: A Beginner Guide Event-driven media intelligence with AWS Step Functions and Bedrock I scored 500 AI prompts across 8 quality dimensions — here's what broke How to Call Google Gemini API from Next.js (Free Tier, No Backend Needed) The Portal Protocol: Reclaiming Human Connection in the Age of AI How to Fix Your Team's Scattered Knowledge Problem With a Self-Hosted Forum Intro to tc Cloud Functors: A Graph-First Mental Model for the Modern Cloud Designing Multi-Tenant Backends With Both Ownership and Team Access I Built a Neumorphic CSS Library with 77+ Components — Here's What I Learned PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale Cómo construí un SaaS multi-rubro para gestionar expensas en Argentina con FastAPI + Vue 3 🚀 I Built an Ethical Hacking Scanner Tool – Open Source Project I Replaced /usage and /context in Claude Code With a Single Statusline A Pythonic Way to Handle Emails (IMAP/SMTP) with Auto-Discovery and AI-Ready Design I Collected 8.9 Million Polymarket Price Points — Here's What I Found About How Markets Really Move EcoTrack AI — Carbon Footprint Tracker & Dashboard Everyone's Using AI. No One Agrees How. 5 self-hosted ebook managers worth trying in 2026 Building Your First AI Agent with LangChain: From Chatbot to Autonomous Assistant
How I Connected Claude Desktop to Live Salesforce CRM Dat...
Yogi · 2026-06-25 · via DEV Community

Yogi


I recently deployed a real-time integration between Claude Desktop and Salesforce CRM using Model Context Protocol (MCP) — and it changed how I think about AI in enterprise operations.

Here's a practical walkthrough of what I built, the security architecture behind it, and what I learned along the way.

The problem I was trying to solve

As part of my work, I was spending too much time manually navigating Salesforce to answer questions

Every answer required logging into Salesforce, running a report, cross-referencing opportunities, and building a mental model of the data. I wanted to just ask the question in plain English and get the answer — against live CRM data, not a stale export.

Enter Model Context Protocol (MCP).

What is MCP?

MCP (Model Context Protocol) is an open standard from Anthropic that lets AI models like Claude connect to external data sources and tools through a standardized interface.

Instead of building custom APIs for every data source, MCP defines:

  • A server (the data source, in this case Salesforce)
  • A client (Claude Desktop)
  • A protocol for tool discovery, invocation, and response

Salesforce now ships a Hosted MCP Server, which means the connection layer is managed for you — you just need to configure authentication and define your connected app.

Architecture overview

The integration has three layers:
┌─────────────────────────────────────────────┐
│ AI Layer │
│ Claude Desktop → MCP Client → SFDX CLI │
└──────────────────┬──────────────────────────┘
│ tool calls
┌──────────────────▼──────────────────────────┐
│ Auth Layer — OAuth 2.0 / PKCE │
│ Auth Server → Salesforce Hosted MCP Server │
│ → Connected App (scopes) │
└──────────────────┬──────────────────────────┘
│ REST API
┌──────────────────▼──────────────────────────┐
│ Data Layer — Salesforce CRM │
│ Opportunities · Accounts · Reports · SOQL │
└─────────────────────────────────────────────┘

Request flow

  1. You type a natural language question in Claude Desktop
  2. Claude identifies the right MCP tool to call (e.g. query_opportunities)
  3. The MCP client translates the request into a Salesforce API call
  4. The Salesforce Hosted MCP Server executes the query via SOQL
  5. Results return to Claude, which synthesizes a natural language answer

The security architecture — OAuth 2.0 + PKCE

This is where most guides gloss over the hard part. Getting enterprise AI-to-CRM security right requires careful attention to token flows, scopes, and least-privilege access — especially when an AI model has live read access to customer data.

Why PKCE matters

PKCE (Proof Key for Code Exchange) is essential for public client integrations where you cannot safely store a client secret. Claude Desktop running locally is a public client — there's no server-side secret storage. PKCE solves this by:

Generating a random code_verifier on the client at the start of each auth flow
Hashing it to create a code_challenge sent with the authorization request
Sending the original code_verifier when exchanging the authorization code for tokens
The auth server verifies the hash matches — proving the token request came from the same client that initiated the flow

Without PKCE, an intercepted authorization code could be exchanged for tokens by a different client. With PKCE, the code is useless without the verifier that only the originating client holds.

Salesforce Connected App setup

`bash# Create Connected App in Salesforce Setup with:

- OAuth 2.0 enabled

- PKCE required

- Callback URL: http://localhost:{PORT}/callback

- Scopes: api, refresh_token (principle of least privilege)

- No client secret (public client flow)`

MCP server configuration (claude_desktop_config.json)

json{
  "mcpServers": {
    "salesforce": {
      "command": "sf",
      "args": ["mcp", "start"],
      "env": {
        "SALESFORCE_ORG_ALIAS": "your-org-alias",
        "MCP_AUTH_TYPE": "oauth2-pkce"
      }
    }
  }
}

Authentication flow

Claude Desktop Auth Server Salesforce
│ │ │
│── generate code_verifier ──▶│ │
│── code_challenge (S256) ───▶│ │
│ │── validate ───────────▶│
│◀─── authorization code ─────│ │
│── code_verifier + code ─────▶│ │
│◀─── access token ───────────│ │
│ │
│── REST API calls with Bearer token ──────────────────▶│
│◀── SOQL query results ────────────────────────────────│

What it enables

Claude queries the live data, reasons over it, and gives you a synthesized answer — no manual report-building required.

Key learnings

  1. MCP is becoming the standard for enterprise AI integration

The pattern MCP establishes — standardized tool definitions, structured request/response, discoverable capabilities — is exactly what enterprise AI needs. It's analogous to how REST APIs standardized web service integration in the 2000s.

  1. Least-privilege access is non-negotiable

Only grant the scopes your use case requires. For read-only pipeline reviews, api scope with read-only profiles is sufficient. Don't grant write access unless you specifically need it — an AI with write access to your CRM is a very different risk profile.

  1. Token lifecycle management matters

Refresh token rotation, expiry handling, and re-authentication flows need to be part of your implementation plan. Salesforce's default refresh token expiry is org-configurable — make sure it aligns with your operational workflow.

  1. SFDX CLI session management simplifies operations

Using sf org login web to establish authenticated sessions and letting the MCP server inherit those sessions reduces the auth complexity significantly compared to managing tokens directly.


Follow for more posts on enterprise AI integration, MCP, and operational AI tooling.