Salesforce - Data Cloud

Connect to Salesforce’s official Hosted MCP Data Cloud server to retrieve Salesforce Data Cloud metadata and run SQL queries.

Key Features

• Retrieve Salesforce Data Cloud metadata
• Run Data Cloud SQL queries
• Analyze and explore unified customer data

Basic Information

Authentication Method

Uses Salesforce OAuth authentication.

Input Parameters

• consumerKey (Required): Consumer Key of the Salesforce External Client App (ECA)
• consumerSecret (Required): Consumer Secret of the Salesforce External Client App (ECA)
• useSandbox (Optional): Whether to connect to a Salesforce Sandbox environment

Salesforce Setup Method

This Integration requires a Salesforce External Client App (ECA) and an activated Hosted MCP server.

1. Create an External Client App by following the Salesforce official guide .
2. Register the Callback URL shown in the AIP OAuth setup screen as the External Client App Callback URL.
3. Enter the External Client App Consumer Key and Consumer Secret in the AIP consumerKey and consumerSecret fields.
4. Activate the data-cloud-queries server under Salesforce Setup → API Catalog → MCP Servers. See the Salesforce MCP server activation guide  for details.

Supported MCP Tools

Data Cloud Tools

post_dc_query_sql

Runs a SQL query against Salesforce Data Cloud.

get_dc_metadata

Retrieves metadata available in Salesforce Data Cloud.

Usage Examples

For example,

• if you enter a prompt like “Show me the data models available in Data Cloud”,
• the LLM calls the get_dc_metadata tool through MCP,
• and responds in the chat based on the tool result.

Other example prompts:

• “Query recent customer activity data in Data Cloud with SQL”
• “Check the Data Cloud metadata before writing a query”

Notes

• Available data and executable queries depend on your Salesforce Data Cloud permissions.
• SQL queries are subject to Data Cloud limits and policies.