sfmc-mcp-server
An MCP server for Salesforce Marketing Cloud that allows agents to validate SQL queries for Automation Studio before execution, explore Data Extensions metadata, and query records directly. It reduces the feedback loop for query errors from minutes to seconds by checking dialect rules and schema existence.
Package and access
Local package with source-attributed installation metadata. Koskamo does not execute packages during review.
What you can do with it
- Validate SQL queries for Automation Studio before execution
- List Data Extensions with metadata and schema
- Query records from Data Extensions with filtering and pagination
Source and maintenance
- Maintenance checked
Packages and installation
Source-provided package data. Koskamo has not executed or live-probed this package.
sfmc-mcp-server 0.2.1
{
"version": "0.2.1",
"transport": "stdio",
"identifier": "sfmc-mcp-server",
"registryType": "npm",
"environmentVariables": [
{
"name": "SFMC_SUBDOMAIN",
"format": "string",
"isRequired": true,
"description": "Subdomínio da instância SFMC (a parte antes de .auth.marketingcloudapis.com)"
},
{
"name": "SFMC_CLIENT_ID",
"format": "string",
"isRequired": true,
"description": "Client ID do Installed Package (API Integration Server-to-Server)"
},
{
"name": "SFMC_CLIENT_SECRET",
"format": "string",
"isRequired": true,
"description": "Client Secret do Installed Package"
},
{
"name": "SFMC_ACCOUNT_ID",
"format": "string",
"description": "MID da Business Unit alvo (opcional; usa a BU padrão do package se omitido)"
},
{
"name": "SFMC_MODE",
"format": "string",
"description": "Modo de operação: \"read\" (padrão) ou \"write\""
}
]
}Tools
Reported by the attributed source; not independently observed by Koskamo.
Connect from your client
Each snippet configures the same source-provided package; replace placeholders before use.
Cursor
{
"mcpServers": {
"sfmc-mcp-server": {
"command": "npx",
"args": [
"-y",
"sfmc-mcp-server@0.2.1"
],
"env": {
"SFMC_SUBDOMAIN": "<YOUR_SFMC_SUBDOMAIN>",
"SFMC_CLIENT_ID": "<YOUR_SFMC_CLIENT_ID>",
"SFMC_CLIENT_SECRET": "<YOUR_SFMC_CLIENT_SECRET>",
"SFMC_ACCOUNT_ID": "<YOUR_SFMC_ACCOUNT_ID>",
"SFMC_MODE": "<YOUR_SFMC_MODE>"
}
}
}
}Cline
{
"mcpServers": {
"sfmc-mcp-server": {
"command": "npx",
"args": [
"-y",
"sfmc-mcp-server@0.2.1"
],
"env": {
"SFMC_SUBDOMAIN": "<YOUR_SFMC_SUBDOMAIN>",
"SFMC_CLIENT_ID": "<YOUR_SFMC_CLIENT_ID>",
"SFMC_CLIENT_SECRET": "<YOUR_SFMC_CLIENT_SECRET>",
"SFMC_ACCOUNT_ID": "<YOUR_SFMC_ACCOUNT_ID>",
"SFMC_MODE": "<YOUR_SFMC_MODE>"
}
}
}
}VS Code
{
"servers": {
"sfmc-mcp-server": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"sfmc-mcp-server@0.2.1"
],
"env": {
"SFMC_SUBDOMAIN": "<YOUR_SFMC_SUBDOMAIN>",
"SFMC_CLIENT_ID": "<YOUR_SFMC_CLIENT_ID>",
"SFMC_CLIENT_SECRET": "<YOUR_SFMC_CLIENT_SECRET>",
"SFMC_ACCOUNT_ID": "<YOUR_SFMC_ACCOUNT_ID>",
"SFMC_MODE": "<YOUR_SFMC_MODE>"
}
}
}
}Claude Desktop
{
"mcpServers": {
"sfmc-mcp-server": {
"command": "npx",
"args": [
"-y",
"sfmc-mcp-server@0.2.1"
],
"env": {
"SFMC_SUBDOMAIN": "<YOUR_SFMC_SUBDOMAIN>",
"SFMC_CLIENT_ID": "<YOUR_SFMC_CLIENT_ID>",
"SFMC_CLIENT_SECRET": "<YOUR_SFMC_CLIENT_SECRET>",
"SFMC_ACCOUNT_ID": "<YOUR_SFMC_ACCOUNT_ID>",
"SFMC_MODE": "<YOUR_SFMC_MODE>"
}
}
}
}Let your agent find its tools
Find servers like sfmc-mcp-server from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.