Connect

8 clients · secrets stay placeholders

JSON (mcpServers)Claude CodeCodexOpenCodeCursorVS CodeGemini CLIGoose

{
  "mcpServers": {
    "coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "${COALESCE_ACCESS_TOKEN}",
        "SNOWFLAKE_PAT": "${SNOWFLAKE_PAT}",
        "SNOWFLAKE_KEY_PAIR_PASS": "${SNOWFLAKE_KEY_PAIR_PASS}"
      }
    }
  }
}

claude mcp add coalesce-transform -e "COALESCE_ACCESS_TOKEN=${COALESCE_ACCESS_TOKEN}" -e "SNOWFLAKE_PAT=${SNOWFLAKE_PAT}" -e "SNOWFLAKE_KEY_PAIR_PASS=${SNOWFLAKE_KEY_PAIR_PASS}" -- npx -y [email protected]

[mcp_servers.coalesce-transform]
command = "npx"
args = ["-y", "[email protected]"]
env = { "COALESCE_ACCESS_TOKEN" = "${COALESCE_ACCESS_TOKEN}", "SNOWFLAKE_PAT" = "${SNOWFLAKE_PAT}", "SNOWFLAKE_KEY_PAIR_PASS" = "${SNOWFLAKE_KEY_PAIR_PASS}" }

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "coalesce-transform": {
      "type": "local",
      "command": [
        "npx",
        "-y",
        "[email protected]"
      ],
      "enabled": true,
      "environment": {
        "COALESCE_ACCESS_TOKEN": "{env:COALESCE_ACCESS_TOKEN}",
        "SNOWFLAKE_PAT": "{env:SNOWFLAKE_PAT}",
        "SNOWFLAKE_KEY_PAIR_PASS": "{env:SNOWFLAKE_KEY_PAIR_PASS}"
      }
    }
  }
}

{
  "mcpServers": {
    "coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "${COALESCE_ACCESS_TOKEN}",
        "SNOWFLAKE_PAT": "${SNOWFLAKE_PAT}",
        "SNOWFLAKE_KEY_PAIR_PASS": "${SNOWFLAKE_KEY_PAIR_PASS}"
      }
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=coalesce-transform&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsImNvYWxlc2NlLXRyYW5zZm9ybS1tY3BAMC43LjIiXSwiZW52Ijp7IkNPQUxFU0NFX0FDQ0VTU19UT0tFTiI6IiR7Q09BTEVTQ0VfQUNDRVNTX1RPS0VOfSIsIlNOT1dGTEFLRV9QQVQiOiIke1NOT1dGTEFLRV9QQVR9IiwiU05PV0ZMQUtFX0tFWV9QQUlSX1BBU1MiOiIke1NOT1dGTEFLRV9LRVlfUEFJUl9QQVNTfSJ9fQ%3D%3D"
}

{
  "servers": {
    "coalesce-transform": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "${COALESCE_ACCESS_TOKEN}",
        "SNOWFLAKE_PAT": "${SNOWFLAKE_PAT}",
        "SNOWFLAKE_KEY_PAIR_PASS": "${SNOWFLAKE_KEY_PAIR_PASS}"
      }
    }
  }
}

{
  "mcpServers": {
    "coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "${COALESCE_ACCESS_TOKEN}",
        "SNOWFLAKE_PAT": "${SNOWFLAKE_PAT}",
        "SNOWFLAKE_KEY_PAIR_PASS": "${SNOWFLAKE_KEY_PAIR_PASS}"
      }
    }
  }
}

extensions:
  "coalesce-transform":
    enabled: true
    name: "coalesce-transform"
    type: stdio
    cmd: "npx"
    args:
      - "-y"
      - "[email protected]"
    envs:
      "COALESCE_ACCESS_TOKEN": "${COALESCE_ACCESS_TOKEN}"
      "SNOWFLAKE_PAT": "${SNOWFLAKE_PAT}"
      "SNOWFLAKE_KEY_PAIR_PASS": "${SNOWFLAKE_KEY_PAIR_PASS}"
    timeout: 300

Placeholders to fill from your own secret store: ${COALESCE_ACCESS_TOKEN}, ${SNOWFLAKE_PAT}, ${SNOWFLAKE_KEY_PAIR_PASS}. The registry never accepts secret values.

This is a local package: the command runs on your machine.

Quality – / 100not scored

Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.

protocoln/a · weight 25

n/a
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)

authorizationn/a · weight 15

n/a
auth.prm, auth.as_metadata, auth.cimdno remote uses OAuth
n/a
auth.secret_in_urlno templated URL

tool hygienen/a · weight 30

n/a
tools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)

stabilityn/a · weight 15

n/a
stability.changes, stability.rug_pulltool list unknown

dependenciesn/a · weight 15

n/a
deps.known_vulns, deps.mcp_sdk_version, deps.resolvabledeps.dev does not know [email protected]

Tool list unknown · checked 2026-10-20 06:49 UTC

Tool changes

No tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.

Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.

Trust 76 / 100

provenance80

livenessn/a

freshness45

hygiene100

+repository +namespace-matches-repo ~liveness-unmeasured -stale-183d

Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.

Dependencies

[email protected] npmthis version is not known to the dependency resolver

Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.

Endpoints

package	registry	version	runtime	secrets
`coalesce-transform-mcp`	npm	0.7.2	–	`COALESCE_ACCESS_TOKEN`, `SNOWFLAKE_PAT`, `SNOWFLAKE_KEY_PAIR_PASS`

Tools (0)

No tools observed. Local packages are never executed by the registry.

Schemas: list_tools.

Similar MCP servers

Official server.json

{
  "name": "io.github.jessemarshall/coalesce-transform",
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "version": "0.7.2",
  "packages": [
    {
      "version": "0.7.2",
      "transport": {
        "type": "stdio"
      },
      "identifier": "coalesce-transform-mcp",
      "registryType": "npm",
      "environmentVariables": [
        {
          "name": "COALESCE_ACCESS_TOKEN",
          "format": "string",
          "isSecret": true,
          "description": "Bearer token from the Coalesce Deploy tab. Optional when `~/.coa/config` provides a `token`."
        },
        {
          "name": "COALESCE_PROFILE",
          "format": "string",
          "description": "Selects which `~/.coa/config` profile to load. Defaults to default."
        },
        {
          "name": "COALESCE_BASE_URL",
          "format": "string",
          "description": "Region-specific base URL. Defaults to https://app.coalescesoftware.io (US)."
        },
        {
          "name": "COALESCE_ORG_ID",
          "format": "string",
          "description": "Fallback org ID for cancel-run. Also readable from `orgID` in the active ~/.coa/config profile."
        },
        {
          "name": "COALESCE_REPO_PATH",
          "format": "string",
          "description": "Local repo root for repo-backed tools and pipeline planning. Also readable from `repoPath` in the active ~/.coa/config profile."
        },
        {
          "name": "COALESCE_CACHE_DIR",
          "format": "string",
          "description": "Base directory for the local data cache. When set, cache files are written here instead of the working directory. Also readable from `cacheDir` in the active ~/.coa/config profile."
        },
        {
          "name": "COALESCE_MCP_AUTO_CACHE_MAX_BYTES",
          "format": "string",
          "description": "JSON size threshold before auto-caching to disk. Defaults to 32768."
        },
        {
          "name": "COALESCE_MCP_LINEAGE_TTL_MS",
          "format": "string",
          "description": "In-memory lineage cache TTL in milliseconds. Defaults to 1800000."
        },
        {
          "name": "COALESCE_MCP_MAX_REQUEST_BODY_BYTES",
          "format": "string",
          "description": "Max outbound API request body size. Defaults to 524288."
        },
        {
          "name": "COALESCE_MCP_READ_ONLY",
          "format": "string",
          "description": "When `true`, hides all write/mutation tools during registration. Only read, list, search, cache, analyze, review, diagnose, and plan tools are exposed. Defaults to false."
        },
        {
          "name": "COALESCE_MCP_SKILLS_DIR",
          "format": "string",
          "description": "Directory for customizable AI skill resources. When set, reads context resources from this directory and seeds defaults on first run. Users can augment or override any skill."
        },
        {
          "name": "SNOWFLAKE_ACCOUNT",
          "format": "string",
          "description": "Snowflake account identifier (e.g., `abc12345.us-east-1`). Required by the local `coa` CLI and `coa doctor`; not used by the MCP's REST run path. (required for run tools)"
        },
        {
          "name": "SNOWFLAKE_USERNAME",
          "format": "string",
          "description": "Snowflake account username (required for run tools)"
        },
        {
          "name": "SNOWFLAKE_KEY_PAIR_KEY",
          "format": "string",
          "description": "Path to PEM-encoded private key (required if SNOWFLAKE_PAT not set)"
        },
        {
          "name": "SNOWFLAKE_PAT",
          "format": "string",
          "isSecret": true,
          "description": "Snowflake Programmatic Access Token (alternative to key pair)"
        },
        {
          "name": "SNOWFLAKE_KEY_PAIR_PASS",
          "format": "string",
          "isSecret": true,
          "description": "Passphrase for encrypted keys"
        },
        {
          "name": "SNOWFLAKE_WAREHOUSE",
          "format": "string",
          "description": "Snowflake compute warehouse (required for run tools)"
        },
        {
          "name": "SNOWFLAKE_ROLE",
          "format": "string",
          "description": "Snowflake user role (required for run tools)"
        }
      ]
    }
  ],
  "repository": {
    "url": "https://github.com/jessemarshall/coalesce-transform-mcp",
    "source": "github"
  },
  "description": "MCP server for managing Coalesce Transform workspaces, nodes, pipelines, and runs."
}