Bring Soql Query
to VS Code Copilot
Create your Vinkius account to connect Salesforce Analytics & SOQL to VS Code Copilot and start using all 6 AI tools in minutes. Fully managed, enterprise secure, and ready to use without writing a single line of code. No hosting, no server setup — just connect and start using.
GDPR Free for SubscribersCompatible with every major AI agent and IDE
Gemini
What is the Salesforce Analytics & SOQL MCP Server?
The most powerful Salesforce integration — raw SOQL access to any data in your org.
What you can do
- SOQL — Run any query against standard or custom objects
- Reports — List and execute Salesforce reports
- Dashboards — View dashboard components and data
- Counts — Get record counts for any object
Who is this for?
- Executives — "What was our win rate last quarter?"
- RevOps — Instant data without waiting for BI
- Analysts — Ad-hoc queries through conversation
Built-in capabilities (6)
Each component includes its type, header, data values, and the source report. Dashboards provide pre-built visual summaries. Get the dashboard ID from sf_list_dashboards. Use when the user asks "show me the sales dashboard" or wants a visual summary of specific metrics. Get all component data from a specific Salesforce dashboard — charts, metrics, and tables with their underlying data
Returns dashboard title, folder, last referenced date, and dashboard ID. Dashboards contain visual components (charts, tables, metrics) built from reports. Use to find dashboard IDs before fetching their component data with sf_get_dashboard. List available Salesforce dashboards with title, folder, and last referenced date to discover visualization assets
Returns report name, folder path, report format (Tabular/Summary/Matrix), last run date, and report ID. Use when the user asks about available reports, wants to find a specific one, or needs report IDs before running them with sf_run_report. List available Salesforce reports with name, folder, format, and last run date to discover reporting assets
Returns the total number of records. Use for quick data volume checks: "how many leads do we have?", "total number of accounts", or capacity planning. Accepts any standard or custom object API name. Get the total record count for any Salesforce object — Account, Contact, Lead, Opportunity, Case, or any custom object
Get the report ID from sf_list_reports first. This is the read-only equivalent of clicking "Run Report" in the Salesforce UI. Returns up to 2000 rows. Use when the user asks for specific report data or wants to extract insights from a saved report. Execute a specific Salesforce report by ID and return its full data — all rows, columns, and groupings
This is the most powerful and flexible tool — you can query any standard or custom object, apply filters, use aggregate functions, and join related objects. Example: SELECT Id, Name, Amount, StageName FROM Opportunity WHERE StageName = 'Closed Won' AND Amount > 10000 LIMIT 10. Use when no other tool covers the specific data need, or when the user requests a custom query. Execute a raw SOQL query against your Salesforce org to retrieve any data from standard or custom objects
Why VS Code Copilot?
GitHub Copilot Agent mode brings Salesforce Analytics & SOQL data directly into your VS Code workflow. With a project-scoped config, the entire team shares access to 6 tools. Copilot queries live data, generates typed code, and writes tests from actual API responses, all without leaving the editor.
- —
VS Code is used by over 70% of developers. adding MCP tools to Copilot means your team can leverage external data without leaving their primary editor
- —
Project-scoped MCP configs (
.vscode/mcp.json) let you commit server configurations to your repository, ensuring the entire team shares the same tool access - —
Copilot's Agent mode integrates MCP tools seamlessly with file editing, terminal commands, and workspace search in a single agentic loop
- —
GitHub's enterprise compliance and audit features extend to MCP tool usage, providing visibility into how AI interacts with external services
Salesforce Analytics & SOQL in VS Code Copilot
Why run Salesforce Analytics & SOQL with Vinkius?
The Salesforce Analytics & SOQL connection runs on our fully managed, secure cloud infrastructure. We handle the hosting, maintenance, and security so you don't have to deal with servers or code. All 6 tools are ready to work instantly without any complex setup.
You stay in complete control of your data. Your AI only accesses the information you approve, keeping your sensitive passwords and private details completely safe. Plus, with automatic optimizations, your AI works faster and more efficiently.
* Every connection is hosted and maintained by Vinkius. We handle the security, updates, and infrastructure so you don't have to write code or manage servers. See our infrastructure
Over 4,000 integrations ready for AI agents
Explore a vast library of pre-built integrations, optimized and ready to deploy.
Connect securely in under 30 seconds
Generate tokens to authenticate and link external services in a single step.
Complete visibility into every agent action
Audit live requests, latency, success rates, and active security compliance policies.
Optimize spending and track token ROI
Analyze real-time token consumption and cost metrics detailed by connection.
Explore our live AI Agents Analytics dashboard to see it all working
This dashboard is included when you connect Salesforce Analytics & SOQL using Vinkius. You will never be left in the dark about what your AI agents are doing with your tools.
Salesforce Analytics & SOQL and 4,000+ other AI tools. No hosting, no code, ready to use.
Professionals who connect Salesforce Analytics & SOQL to VS Code Copilot through Vinkius don't need to write code, manage servers, or worry about security. Everything is pre-configured, secure, and runs automatically in the background.
Raw MCP | Vinkius | |
|---|---|---|
| Ready-to-use MCPs | Find and configure each manually | 4,000+ MCPs ready to use |
| Connection Setup | Manual coding & server setup | 1-click instant connection |
| Server Hosting | You host it yourself (needs 24/7 uptime) | 100% hosted & managed by Vinkius |
| Security & Privacy | Stored in plaintext config files | Bank-grade encrypted vault |
| Activity Visibility | Blind execution (no logs or tracking) | Live dashboard with real-time logs |
| Cost Control | Runaway AI token spend risk | Automatic budget limits |
| Revoking Access | Must delete files or code to stop | 1-click disconnect button |
How Vinkius secures
Salesforce Analytics & SOQL for VS Code Copilot
Every request between VS Code Copilot and Salesforce Analytics & SOQL is protected by our secure gateway. We automatically keep your sensitive data private, prevent unauthorized access, and let you disconnect instantly at any time.
Frequently asked questions
Can I run any SOQL query?
Yes! Any valid SOQL query against standard or custom objects, respecting your field-level security.
Can I run existing Salesforce reports?
Yes — list all reports, then run any by ID. Returns full row data.
Is this safe to use?
All queries are read-only and respect your Salesforce permissions. The SOQL tool only reads data — it cannot modify records.
Which VS Code version supports MCP?
MCP support requires VS Code 1.99 or later with the GitHub Copilot extension. Ensure both are updated to the latest version. Older versions of Copilot may not expose the Agent mode toggle.
How do I switch to Agent mode?
Open the Copilot Chat panel and look for two mode options: "Ask" and "Agent". Click "Agent" to enable autonomous tool calling. In Ask mode, Copilot provides conversational answers but cannot invoke MCP tools.
Can I restrict which MCP tools Copilot can access?
Yes. VS Code shows a tool consent dialog before any MCP tool is invoked for the first time. You can also configure tool access policies at the organization level through GitHub Copilot settings.
Does MCP work in VS Code Remote or Codespaces?
Yes. MCP servers configured via .vscode/mcp.json work in Remote SSH, WSL, and GitHub Codespaces environments. The MCP connection is established from the remote host, so ensure the server URL is accessible from that environment.
MCP tools not available
Ensure you are in Agent mode in Copilot Chat. MCP tools only appear in Agent mode.
Explore More MCP Servers
View all →
Intrinio
10 toolsAccess real-time and historical financial market data via Intrinio API.
Asaas
8 toolsManage payments, customers, and subscriptions with Asaas — the complete digital account for Brazilian businesses via AI.
Attio
14 toolsBuild powerful CRM workflows with flexible data models, relationship tracking, and deal management tailored to your process.
Mailshake
12 toolsRun cold email outreach campaigns with personalization, automated follow-ups, and reply detection that fills your sales pipeline.