# io.github.Inefavel/sfmc-mcp-server (npm · sfmc-mcp-server)

MCP Server para Salesforce Marketing Cloud: valida queries do Automation Studio antes de rodar.

- Trust score: 67/100 (medium)
- Change this week: +22
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-08-03

## Components

- npm · `sfmc-mcp-server`: 67/100 (this document), [markdown](https://verifymcp.io/servers/inefavel-sfmc-mcp-server/sfmc-mcp-server.md), [page](https://verifymcp.io/servers/inefavel-sfmc-mcp-server/sfmc-mcp-server)

## Channel facts

- Registry: `npm`
- Package: `sfmc-mcp-server`
- Version: `0.2.1`
- Transport: `stdio`

## Trust breakdown

How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-08-03.

- **Supply Chain Security**: 87/100
  - No malware found by supply-chain analysis.
  - Only part of the dependency tree could be resolved (95 of 99), so this covers what we could see, not the whole tree.
  - No install/post-install scripts declared.
  - Only part of the dependency tree could be resolved (95 of 99), so this covers what we could see, not the whole tree.
- **Provenance & Transparency**: 45/100
  - Source repository is publicly reachable at the declared URL.
  - Provenance check failed: no build-provenance attestation is published.
  - Clear OSI-approved license (MIT).
  - Actively maintained (last published 22 days ago).
  - Disclosure check failed: no security disclosure policy was found in the source repository.
- **Schema Quality & AI Usability**: 66/100
  - AI-judged instruction clarity (good).
  - Context-footprint check failed: tool/resource definitions use about 496 tokens (~165/item across 3 items; 3 tools + 0 resources), over budget; trim descriptions and params.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 27/100
  - Stability observed for 8 of 30 days with no destabilising changes; credit accrues until the full window elapses.
- **Tool Coverage**: 100/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 100% of tool parameters carry a description.
- **Capabilities**: 100/100
  - Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.

## Install

### Claude

```bash
claude mcp add inefavel-sfmc-mcp-server -- npx -y sfmc-mcp-server
```

### Codex

```bash
codex mcp add inefavel-sfmc-mcp-server -- npx -y sfmc-mcp-server
```

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "inefavel-sfmc-mcp-server": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "sfmc-mcp-server"
      ],
      "enabled": true
    }
  }
}
```

### OpenClaw

```bash
openclaw mcp add inefavel-sfmc-mcp-server --command npx --arg -y --arg sfmc-mcp-server
```

### Hermes

```yaml
mcp_servers:
  inefavel-sfmc-mcp-server:
    command: "npx"
    args: ["-y", "sfmc-mcp-server"]
```

### Other

```json
{
  "mcpServers": {
    "inefavel-sfmc-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "sfmc-mcp-server"
      ]
    }
  }
}
```

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-08-02 (score 67, +47)

- [security regression] Provenance: unverified → fail
- [security improvement] Known CVEs: unverified → partial
- [security improvement] Install scripts: unverified → pass
- [security improvement] Malware scan: unverified → pass
- [functional regression] Security disclosure: fail → unverified
- [functional improvement] License: unverified → pass
- [functional improvement] Dependency health: unverified → partial
- [functional improvement] Maintenance: unverified → pass
- [functional improvement] MCP protocol: unverified → pass
- [functional improvement] Stability: unverified → 0.23
- [functional improvement] Schema quality: unverified → good
- [functional] Licence: MIT

### 2026-08-01 (score 20, +14)

- [functional regression] Dependency health: partial → unverified
- [functional improvement] Tool coverage: unverified → 100

### 2026-07-31 (score 6, −39)

- [functional] We updated how we score, so this day's move reflects our rubric, not a change to the server

### 2026-07-27 (score 45)

First indexed and scored.

## MCP tools (3)

### `list_data_extensions` (~139 tokens)

Lista Data Extensions da Business Unit conectada, com nome, external key (customerKey), e opcionalmente os campos de cada uma. Suporta filtro por nome e paginação.

Input parameters:

- `includeFields` (boolean): Se true, inclui a lista de campos (nome, tipo, tamanho, PK, nullable) de cada DE.
- `nameFilter` (string): Filtro parcial por nome da DE (case-insensitive). Ex: 'master' encontra 'Master_Contacts'.
- `page` (integer): Página de resultados (começa em 1).
- `pageSize` (integer): Itens por página (máx 100).

### `query_data_extension` (~179 tokens)

Consulta registros de uma Data Extension pelo external key (customerKey). Suporta filtro simples (ex: "Status eq 'Active'"), ordenação e paginação. Retorna no máximo 50 linhas por chamada para não estourar o contexto.

Input parameters:

- `externalKey` (string, required): External key (customerKey) da Data Extension.
- `filter` (string): Filtro no formato do SFMC: campo operador valor. Operadores: eq, ne, gt, lt, ge, le, like. Ex: "EmailAddress like '%gmail%'" ou "SubscriberKey eq '12345'".
- `orderBy` (string): Campo e direção de ordenação. Ex: 'CreatedDate desc'.
- `page` (integer): Página de resultados.
- `pageSize` (integer): Linhas por página (máx 50).

### `validate_sql` (~178 tokens)

Valida uma Query Activity do SFMC Automation Studio antes de executá-la. Checa construções não suportadas pelo dialeto restrito do SFMC (ORDER BY, CTE, MERGE, variáveis, temp tables, funções indisponíveis) e — se possível — confere se as Data Extensions e colunas referenciadas realmente existem. Retorna erros bloqueantes, avisos e sugestões.

Input parameters:

- `checkSchema` (boolean): Se true, consulta as Data Extensions referenciadas via API para validar nomes de tabelas e colunas.
- `sql` (string, required): A query SQL do Automation Studio a ser validada.
- `targetDataExtension` (string): External key da DE de destino da Query Activity. Se informada, valida se as colunas do SELECT cabem no schema de destino (nomes e tipos).

## Diagnostics

Captured diagnostic sections: Provenance, Dependencies. The full working is on the page: https://verifymcp.io/servers/inefavel-sfmc-mcp-server/sfmc-mcp-server#diagnostics

## Score history

- 2026-08-03: 67
- 2026-08-02: 67
- 2026-08-01: 20
- 2026-07-31: 6
- 2026-07-30: 45
- 2026-07-28: 45
- 2026-07-27: 45

## Links

- npm package: https://www.npmjs.com/package/sfmc-mcp-server
- Socket report: https://socket.dev/npm/package/sfmc-mcp-server
- Repository: https://github.com/Inefavel/sfmc-mcp-server
- Changelog RSS feed: https://verifymcp.io/servers/inefavel-sfmc-mcp-server/sfmc-mcp-server/changelog.xml
- Changelog JSON feed: https://verifymcp.io/servers/inefavel-sfmc-mcp-server/sfmc-mcp-server/changelog.json
- HTML version of this page: https://verifymcp.io/servers/inefavel-sfmc-mcp-server/sfmc-mcp-server