MCP Server para Salesforce Marketing Cloud: valida queries do Automation Studio antes de rodar.
Sfmc MCP server is a locally run integration for AI assistants that speak the Model Context Protocol. MCP Server para Salesforce Marketing Cloud: valida queries do Automation Studio antes de rodar.
Quem opera SFMC conhece a rotina: você escreve uma Query Activity, salva, roda a automação — e 30 minutos depois descobre que digitou EmailAdress em vez de EmailAddress. Ou que usou um ORDER BY, que o dialeto do Automation Studio não suporta. Ou que a coluna de saída não existe na DE de destino.
sfmc-mcp-server on npm is all you need. Most clients run it directly, so configuration is a few lines and a restart.
Once Sfmc is connected, these are the calls the assistant has available:
Automations — Readvalidate_sql — Valida uma Query Activity antes de executar: regras do dialeto restrito do SFMC + checagem de que as DEs e colunas realmente existemlist_data_extensions — Lista DEs com metadados, filtro por nome, paginação e schema completoquery_data_extension — Consulta registros com filtro, ordenação e paginaçãoYou will need 5 environment variables: SFMC_SUBDOMAIN, SFMC_CLIENT_ID, SFMC_CLIENT_SECRET, SFMC_MODE, SFMC_ACCOUNT_ID. The server will not start without them, which is usually why the tools fail to appear on a first run. Keep credentials in your client's env block or a secrets manager rather than in a file you might commit.
Among the developer tooling options, the useful question is rarely "what can it do" but "what does it cost you to run" — permissions, credentials, and how much of your context its toolset consumes. Sfmc's toolset — Automations, validate_sql, list_data_extensions and 1 more — is a fair guide to whether it matches your workflow. It is maintained by Inefavel; worth a glance at recent repository activity before you build anything load-bearing on it.
SyncDev reviews every entry in this directory against the project's own documentation before publishing, and revisits them as servers change.
| Tool | What it does |
|---|---|
| Automations | Read |
| validate_sql | Valida uma Query Activity **antes** de executar: regras do dialeto restrito do SFMC + checagem de que as DEs e colunas realmente existem |
| list_data_extensions | Lista DEs com metadados, filtro por nome, paginação e schema completo |
| query_data_extension | Consulta registros com filtro, ordenação e paginação |
{
"mcpServers": {
"sfmc": {
"command": "npx",
"args": ["-y", "sfmc-mcp-server"],
"env": {
"SFMC_SUBDOMAIN": "mcXXXXXXXXXXXXXXXXXXXXXX",
"SFMC_CLIENT_ID": "seu_client_id",
"SFMC_CLIENT_SECRET": "seu_client_secret",
"SFMC_MODE": "read"
}
}
}
}Configuration as documented by the project. Restart the client after saving.
| Variable | Description | Required |
|---|---|---|
| SFMC_SUBDOMAIN | Configuration value read at startup. | Optional |
| SFMC_CLIENT_ID | Configuration value read at startup. | Optional |
| SFMC_CLIENT_SECRET | Credential the server authenticates with. | Yes |
| SFMC_MODE | Configuration value read at startup. | Optional |
| SFMC_ACCOUNT_ID | Configuration value read at startup. | Optional |
Kill hallucinated APIs — version-accurate, up-to-date library documentation injected straight into context.
Microsoft's official browser automation server — drive a real browser through the accessibility tree, no screenshots needed.
GitHub's official server — repos, issues, pull requests, Actions and code security, straight from your assistant.
Issue tracking at the speed of conversation — Linear's official hosted server with OAuth and zero install.
Local repository surgery — status, diffs, commits, branches and history for any repo on disk.
Timezone sanity for AI — current time anywhere and correct conversions, without the model doing date math.