Connect
Salesforce to
VS Code
- Can you update the KPI doc?
https://mcp.lemonado.io/mcpAsk GitHub Copilot in VS Code to find where opportunities stall, with live Salesforce data in agent mode. Lemonado connects them in about 2 minutes, no API keys needed.
https://mcp.lemonado.io/mcpWhy connect Salesforce to VS Code (GitHub Copilot)?
Copilot's agent mode can call MCP tools inside your workspace, so it can read live numbers while it edits code and docs. Connected through Lemonado, it reads your Salesforce leads, opportunities, campaigns and accounts, so it can find where opportunities stall with today's numbers.
All your Salesforce data
Leads and their lead source, ready to ask about.
Always today's numbers
Opportunities, stages, amounts and close dates, synced from Salesforce automatically, so answers use today's numbers.
Connect all your tools
Questions like "What does an opportunity cost?" use Salesforce and HubSpot, LinkedIn Ads at once.
How to connect Salesforce to VS Code (GitHub Copilot)
Before you start
- A Salesforce account you can sign in to
- VS Code installed
- A Lemonado account (the free trial works)
- 1
Connect Salesforce in Lemonado
In Lemonado, open Connectors, find Salesforce and sign in. Connect with a Salesforce login whose profile can view leads, opportunities and campaigns. Sandbox orgs work too, if you want to try it there first.
- 2
Turn on external access
In the company's settings, open External tools, turn the connection on, choose which sources it can reach and copy the server URL.
texthttps://mcp.lemonado.io/mcp - 3
Add the server
With AI features on and a project open, run MCP: Add Server from the command palette. Choose HTTP, paste the server URL and name it lemonado.
texthttps://mcp.lemonado.io/mcp - 4
Choose where it lives
For your personal Copilot setup, choose Global → Copilot Global. That writes to ~/.copilot/mcp-config.json unless COPILOT_HOME says otherwise.
- 5
Trust and sign in
Accept the trust prompt and sign in to Lemonado. Turn the tools on under Chat: Open Customizations → Tools.
- 6
Ask VS Code (GitHub Copilot) about Salesforce
Try "Update the table in docs/kpis.md with last month's Salesforce numbers and add one line on what changed." Or ask: "What did each source bring?" or "How long from lead to opportunity?"
Good to know
- The older .vscode/mcp.json format still works for the local harness, but VS Code now marks that destination as deprecated. It uses a servers key with type http and the same URL.
What can VS Code (GitHub Copilot) do with Salesforce?
Copilot reads your Salesforce data in agent mode and works the numbers into your code, docs and notebooks in the workspace you have open.
Update the table in docs/kpis.md with last month's Salesforce numbers and add one line on what changed.
Updated docs/kpis.md with last month's numbers next to the month before, plus a line on the biggest change and its cause.
Source: Salesforce + your code
Save Salesforce leads created this year with lead source, status and any opportunity amount as data/salesforce_funnel.csv.
Saved 8,140 leads. 1,020 became opportunities worth $6.4M. Partner leads have the highest opportunity rate at 21%.
Source: Salesforce + your code
Write and run the query for median days from lead created to opportunity created by lead source, and save it as queries/lead_to_opp.sql.
Saved and run. Demo requests convert in a median of 3 days, content downloads in 26. The query reruns for any date range.
Source: Salesforce + your code
Compare the fields our lead webhook sends with the Salesforce lead fields that are filled on leads from the last 30 days. Which ones always arrive empty?
Two fields never fill: Industry and Employees. The webhook in api/lead.ts sends them as industry_name and size, which the mapping doesn't know.
Source: Salesforce + your code
Which Salesforce campaigns influenced the most new opportunity value this quarter, and how much of it closed?
The Q3 webinar series influenced $640k of new pipeline, more than any paid campaign. 31% of it has closed so far, against 22% for paid search.
Source: Salesforce
How many days does it take a lead to become an opportunity, by lead source, this year?
Inbound demo requests convert in 4 days on average. Paid social leads take 23 days, and only 9% of them convert at all.
Source: Salesforce
Connect Salesforce to another AI app.
Claude
Connect Salesforce to Claude
ChatGPT
Connect Salesforce to ChatGPT
Claude Code
Connect Salesforce to Claude Code
Cursor
Connect Salesforce to Cursor
Codex
Connect Salesforce to Codex
Perplexity
Connect Salesforce to Perplexity
Google Antigravity
Connect Salesforce to Google Antigravity
Windsurf (Devin Desktop)
Connect Salesforce to Windsurf (Devin Desktop)
Zed
Connect Salesforce to Zed
n8n
Connect Salesforce to n8n
Other integrations for VS Code (GitHub Copilot)
All VS Code (GitHub Copilot) integrations- HubSpot in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor which campaigns bring deals, with HubSpot next to your ad spend.
- LinkedIn Ads in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor about LinkedIn campaigns, lead forms and who converts.
- Google Ads in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor about your Google Ads campaigns, search terms and spend.
- Google Analytics in VS Code (GitHub Copilot)Ask Claude, ChatGPT or Cursor about GA4 traffic, conversions and funnels, next to your ad spend.
- Instagram organic in VS Code (GitHub Copilot)Ask Claude or ChatGPT which posts and reels grow your account, and which ones to turn into ads.
- Pinterest Ads in VS Code (GitHub Copilot)Ask Claude or ChatGPT which pins get saved, clicked and bought.
Reading this as an AI agent?
Everything an agent needs to set this up, in plain text. Paste this page's link into VS Code and ask it to connect you, or copy the block.
# Connect Salesforce to VS Code (Lemonado MCP) - Server URL: https://mcp.lemonado.io/mcp - Transport: Streamable HTTP - Auth: OAuth; the user signs in to Lemonado in the browser. No API keys. - In Lemonado: connect the Salesforce org. Connect with a Salesforce login whose profile can view leads, opportunities and campaigns. Sandbox orgs work too, if you want to try it there first. - In VS Code: Command palette: MCP: Add Server ```text https://mcp.lemonado.io/mcp ``` First question to try: "Update the table in docs/kpis.md with last month's Salesforce numbers and add one line on what changed." More: https://lemonado.io/integrations/salesforce · https://lemonado.io/llms.txt
Frequently Asked Questions
Yes, through Lemonado. Connect your Salesforce org in Lemonado, add Lemonado with MCP: Add Server in VS Code, and VS Code can find where opportunities stall with your live data.
Yes. Salesforce's hosted MCP servers is hosted, so VS Code can use it too. It covers Salesforce only. Lemonado covers Salesforce plus your ad platforms, GA4 and the rest of your stack in one connection, so VS Code can answer questions across them.
Run MCP: List Servers from the command palette. If lemonado isn't running, start it there, accept the trust prompt and sign in. In Lemonado, check that Salesforce is connected and External tools is on for the company. If records are missing, check that user's profile and sharing rules. Salesforce only shares what that user can see, and your edition needs API access.
Yes, if both are connected in Lemonado. One connection reaches every source you allow, so you can ask things like "Opportunities created from Google Ads and from LinkedIn Ads this year, by month, set against what we spent on each."
MCP is included in Lemonado's paid plans and in the free trial, so you can try it before you pay.
Still have a question?
Shoot us an email at hello@lemonado.io.
Try for freeStop fighting with data. Start feeding your AI.
Connect your data to AI and free your team from reporting and busywork.
Try Lemonado free