Live Salesforce Checks With MCP

Created by David Morris

Connect an MCP-capable AI assistant to live Salesforce data, so your daily leadership checks run from prompts instead of spreadsheet exports. You’ll learn how tool discovery and schema discovery actually work, how to force reliable tool execution, and how to debug when the assistant guesses instead of querying.

Requirements

Basic Salesforce objects and reporting vocabulary
Comfort with the idea of API tokens and least-privilege access
High-level understanding of OAuth and Salesforce API limits (no walkthrough needed)
Comfort editing a small config file (JSON) with help if needed

What you'll learn

Explain the MCP handshake: tool discovery, schema exposure, and structured tool calls, and spot when the assistant is guessing versus querying.
Run a local Salesforce-connected MCP server, attach it to an MCP-capable client, and validate the connection using visible tools and a small live query.
Apply exec-friendly credential hygiene: keep tokens out of prompts/logs, use safer storage, and limit exposed tools for least privilege.

Learning path

9 modules • Each builds on the previous one

MCP handshake, discovery, and tool calls

Learn the behind-the-scenes sequence: your AI client discovers MCP tools and schemas, selects a tool, sends a structured call, and uses the returned data to answer. This targets the two common failure points: “it guessed instead of calling” and “it doesn’t know my fields.” ([modelcontextprotocol.io](https://modelcontextprotocol.io/specification/2025-11-25/basic?utm_source=openai))

3 videos17 min

Set up Salesforce MCP locally

Set up a local Salesforce-connected MCP server and attach it to an MCP-capable AI client so you can query live CRM data without exporting spreadsheets. You’ll learn how to validate that the connection is real by checking visible tools and running a simple “describe/query then summarize” loop. ([github.com](https://github.com/salesforcecli/mcp))

1 video6 min

Secure tokens for MCP access

Learn practical credential hygiene for MCP: where tokens end up, how to store them safely, how to rotate/revoke them, and what not to paste into prompts or logs. You’ll also learn why MCP tool-chains increase the impact of prompt injection and how to apply simple guardrails as a non-technical operator. ([techradar.com](https://www.techradar.com/pro/security/anthropics-official-git-mcp-server-had-some-worrying-security-flaws-this-is-what-happened-next?utm_source=openai))

2 videos16 min

Map Salesforce objects to questions

Translate your daily VP questions into the Salesforce objects, fields, and relationships that actually hold the data (including custom objects and “activity” fields). You’ll learn lightweight schema discovery techniques so your prompts reference the right API names and relationships. ([developer.salesforce.com](https://developer.salesforce.com/docs/atlas.en-us.mobile_sdk.meta/mobile_sdk/ref_rest_apis_describe.htm?utm_source=openai))

3 videos32 min

Make prompts trigger the right tools

Learn how to phrase requests so the AI reliably chooses the correct MCP tool, passes the right parameters, and shows its work with retrieved records. You’ll also learn quick “sanity checks” to detect when the model answered without calling Salesforce at all. ([modelcontextprotocol.io](https://modelcontextprotocol.io/specification/2025-11-25/basic?utm_source=openai))

1 video15 min

Prompt templates for daily checks

Design reusable prompt templates for your “preemptive checks” (pipeline hygiene, account coverage, rep follow-through) that produce structured outputs you can act on quickly. You’ll learn how to request consistent tables, thresholds, and exceptions so results are comparable day to day.

1 video8 min

Cross-object pipeline metrics and rollups

Learn beginner-friendly patterns for cross-object aggregation (Account ↔ Opportunities ↔ Activities) to answer “health” questions that single reports miss. You’ll focus on the concepts behind relationship queries and aggregate summaries like counts and sums, not on becoming a Salesforce developer. ([trailhead.salesforce.com](https://trailhead.salesforce.com/content/learn/modules/soql-for-admins/use-bind-variables-and-aggregate-functions?utm_source=openai))

1 video10 min

Debug MCP connectivity and query errors

Create a simple troubleshooting playbook for when the AI can’t connect, can’t see fields, or returns query errors. You’ll learn what evidence to capture (without leaking secrets) so a Salesforce admin or RevOps partner can fix issues quickly. ([developer.salesforce.com](https://developer.salesforce.com/docs/platform/einstein-for-devs/guide/devagent-mcpservers.html))

1 video7 min

Run a repeatable VP check workflow

Turn your prompts into a repeatable operating rhythm: daily checks, exception-based follow-ups, and a consistent handoff format for reps or RevOps. You’ll set expectations for accuracy (what must be verified) and speed (what can be trusted from a summary).

2 videos11 min

Start Learning

Begin your learning journey

Modules9

Duration117 min

Science-backed learning

In-video quizzes and scaffolded content to maximize retention.

Key concepts

MCP Tool Discovery And Execution SignalsLocal Salesforce MCP Setup And ValidationSecure Token Storage And Practical Guardrails

Loading course…