Salesforce Analytics & SOQL MCP. Query Accounts, Contacts, and Opportunities with Code-Grade Precision.
Salesforce Analytics & SOQL gives your AI client direct access to the raw data in your Salesforce environment. It lets you run complex queries (SOQL) against any object, check record counts across accounts or leads, and pull full datasets from saved reports and dashboards using natural language conversation.
Give Claude and any AI agent real-world access
Quickly determine how many records exist for any object type, such as accounts, contacts, or leads.
Execute raw SOQL queries to pull specific combinations of fields and objects that aren't available in standard reports.
Pull the underlying component data—charts, tables, and metrics—from a specified Salesforce dashboard ID.
Retrieve a list of all existing reports in your organization, including their format and last run date.
Execute established Salesforce reports to get full datasets, returning up to 2000 rows for deep analysis.
Ask an AI about this
Waiting for input…
What AI agents can do with Salesforce Analytics & SOQL: 6 Available Tools
These tools give your agent the specific functions it needs to query records, run reports, list available assets, and retrieve complex dashboard metrics from Salesforce.
Make your AI actually useful.
Add this MCP to Claude, Cursor, or Windsurf and your AI stops guessing. It gets real tools to look things up, take action, and handle the stuff you keep doing by hand.
Start using Salesforce Analytics & SOQL MCPSf Get Dashboard
Retrieves all component data—charts, metrics, and tables—from a specific Salesforce dashboard ID.
Sf Record Count
Returns the total number of records for any specified Salesforce object type like...
Sf List Dashboards
Lists all available Salesforce dashboards, providing their title and ID so you know...
Sf List Reports
Provides a list of existing reports, showing their name, folder path, format, and...
Sf Run Report
Executes a specific saved report by ID, returning its full dataset with all rows and...
Sf Run Soql
Runs any custom query against standard or custom objects, allowing you to select fields and apply filters across the entire CRM dataset.
Security and governance baked right in.
Pick your AI client below to get set up. Just create a Vinkius account, subscribe, and you're instantly up and running. We handle the entire backend infrastructure, delivering out-of-the-box support for HTTPS Streamable, SSE, and OAuth2—zero messy routing required.
Choose How to Get Started
Build a custom MCP for your own tools, or connect a ready-made integration from our catalog.
Build Your Own
Turn any API into an MCP. Import a spec, define Agent Skills, or deploy with MCPFusion.
- Import from OpenAPI, Swagger, or YAML specs
- Create Agent Skills with progressive disclosure
- Deploy to edge with MCPFusion framework
- Built in DLP, auth, and compliance on each call
- Real time usage dashboard and cost metering
- Publish to catalog or keep private
Make Your AI Do More
Start with Salesforce Analytics & SOQL, then connect any of our 5,200+ other servers whenever your AI needs more. One click, no limits.
- Use this MCP plus 5,200+ others, all in one place
- Add new capabilities to your AI anytime you want
- Connections are secured and governed automatically
- Track usage and costs across all your servers
- Works with Claude, ChatGPT, Cursor, and more
- New servers added to the catalog weekly
Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Salesforce. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.
VINKIUS CLOUD
Cloud Hosted
Managed infra
V8 Isolated
Sandboxed per request
Zero-Trust Proxy
No stored credentials
DLP Enforced
Policy on each call
GDPR Compliant
EU data residency
Token Compression
~60% cost reduction
The Pain Point: Navigating Salesforce by Menu
Today, getting a complete picture of sales performance means logging into the platform and clicking through tabs. You might run a report for 'Pipeline,' then have to copy an ID, go find the associated dashboard, click on the chart component data, and finally check a separate list view just to count records. It's a frustrating loop of context switching and manual copying.
With this MCP, you ask your agent what you need in plain English. The tool handles the entire sequence—listing reports, identifying dashboards, running SOQL queries, and pulling component data—and delivers one clean answer. You get the insight instantly; no more tedious clicks.
Getting Precise Insights with Salesforce Analytics & SOQL
The specific manual steps that disappear include locating the correct report ID, navigating to the dashboard component structure, and running ad-hoc queries just to validate a single number. These tasks used to take minutes of clicking and pasting.
Now, you treat your entire CRM dataset like a conversation partner. You speak your business question, and the MCP executes the necessary backend code (like sf_run_soql) to give you the precise answer, every time.
What Salesforce Analytics & SOQL MCP does for your AI
Need sales numbers but don't want to jump through three different menus? This MCP connects your AI client directly into the data layer of your Salesforce org. Instead of clicking around to find a dashboard component or running multiple separate queries, you just ask the question—like, "What was our win rate last quarter by industry?"
Your agent handles the complexity. It runs the necessary queries against standard and custom objects, pulling back structured data whether you need an aggregate total, a detailed report list, or a simple record count. You can also discover available visualizations using tools like sf_list_dashboards before having your agent pull all component metrics with sf_get_dashboard.
If you're managing sales operations, this access means instant answers without waiting for the BI team to build a dashboard. Connecting through Vinkius ensures that whether you use Claude or Cursor, you get one single entry point to everything in your CRM data.
019d7601-f1df-73ab-825a-692ecf747173 How to set up Salesforce Analytics & SOQL MCP
The bottom line is: you get immediate access to precise CRM data without leaving the conversation with your AI client.
Ask your AI client a data question (e.g., "Show me all open opportunities over $50k").
The MCP translates that request into the correct Salesforce query, whether it’s running raw SOQL or executing an existing report.
Your agent receives structured results—a clean table of data points—which you can then use in your workflow.
Who uses Salesforce Analytics & SOQL MCP
This MCP is essential for anyone who needs business intelligence but can't wait for a formal report. It serves analysts, sales ops teams, and executives who need instant answers to complex questions using raw CRM data.
Uses this MCP to check record counts (sf_record_count) or run reports (sf_list_reports) to track capacity and ensure reporting consistency across the team.
Writes complex, ad-hoc queries using raw SOQL (sf_run_soql) to test hypotheses on data relationships that aren't covered by standard dashboard views.
Quickly checks the status of a key metric or pipeline total with conversational prompts, accessing visualized summaries via sf_get_dashboard.
Benefits of connecting Salesforce Analytics & SOQL MCP
Get immediate data volume checks. Instead of guessing how many leads you have, use sf_record_count to get an exact, current total for any object in seconds.
Bypass standard reporting limits. With raw SOQL access (sf_run_soql), you write the exact query needed—combining objects and applying filters that no pre-built report can handle.
Understand your existing metrics better. Use sf_list_dashboards first, then sf_get_dashboard to pull all component data from a specific visualization for detailed analysis.
Never wait for a rerun. When you need fresh numbers, use sf_run_report after finding the report ID with sf_list_reports. It's like clicking 'Run Report' instantly.
Simplify discovery. Need to know what reports exist? sf_list_reports gives you the full manifest of available reporting assets in one clean list.
Salesforce Analytics & SOQL MCP use cases
Determining quarterly revenue trends
The CFO needs to compare 'Closed Won' deals across four different product lines but no single dashboard shows that breakdown. They ask the agent, and it runs a custom query using sf_run_soql to group and sum the amounts exactly as requested.
Auditing data completeness
The team lead needs to know if any accounts have zero associated contacts. They use sf_record_count to check the number of accounts, then run a specific query using sf_run_soql to find unmatched IDs.
Reviewing old campaign performance
A marketer wants to see how leads from a specific 2023 campaign performed. They first use sf_list_reports to find the historical report ID, then execute it with sf_run_report to extract all raw data points.
Quickly checking object health
A manager needs an immediate count of open cases across three regional teams. They don't want a full dashboard; they just ask the agent, and it runs sf_record_count for each specified custom object.
Salesforce Analytics & SOQL MCP tradeoffs
What to watch out for, and the recommended way to handle each one.
Asking the AI to 'just know'
Prompting: "Tell me why our Q2 win rate dropped." The agent responds vaguely, citing general data trends but offering no actionable numbers.
Don't ask for vague insights. Instead, use sf_run_soql to execute a focused query like SELECT... WHERE StageName = 'Closed Lost' AND CloseDate = THIS_QUARTER LIMIT 10. This forces the agent to retrieve specific, measurable data.
Relying on single dashboards
Assuming that because a dashboard exists for 'Pipeline,' it contains every necessary metric like historical conversion rates or average deal size.
Don't trust the visual summary. Use sf_list_dashboards to find the ID, then use sf_get_dashboard to pull all underlying component data and inspect the source reports before making a decision.
Forgetting which report is current
Running an outdated report that was saved last month but contains old criteria, leading to incorrect analysis.
Always start by using sf_list_reports. Check the 'Last Run Date' field to ensure you are querying a reporting asset that has been refreshed recently.
When to use Salesforce Analytics & SOQL MCP
Use this MCP if your core problem is data accessibility and structure. Specifically, use it when your question requires joining multiple Salesforce objects (like Accounts with Opportunities) or calculating metrics that require raw code like SELECT SUM(Amount).... If you just need to know the number of records in one object, sf_record_count works fine. Don't use this if you are trying to build a multi-step workflow outside of data retrieval—for that, look at specialized automation or integration tools. Never use this MCP for viewing documents; it only handles structured CRM data.
Frequently asked questions about Salesforce Analytics & SOQL MCP
How does sf_run_soql work with multiple objects? +
sf_run_soql allows you to join related standard or custom objects (e.g., Account and Opportunity) in a single query, letting you select fields from both sources at once.
Is sf_get_dashboard the same as running a report? +
No. A report (sf_run_report) provides raw data rows. sf_get_dashboard pulls specific metrics and component data that are already designed for visualization on a dashboard.
What if I don't know the name of my custom object? +
You can use general prompts, but providing the API name helps. The MCP supports running queries against both standard and custom objects as long as you provide the correct object type.
Do I need to run sf_list_reports before using sf_run_report? +
It's best practice. Use sf_list_reports first to confirm the exact report name and ID, which you then pass to sf_run_report for accurate execution.
Can I just ask for a count without using sf_record_count? +
You can. However, sf_record_count is the dedicated tool designed specifically and reliably to return the total number of records for any object type quickly.