MCP Server

io.github.jessemarshall/coalesce-transform MCP Server

io.github.jessemarshall/coalesce-transform

Repository Registry

What is the io.github.jessemarshall/coalesce-transform MCP server?

MCP server for managing Coalesce Transform workspaces, nodes, pipelines, and runs.

How to install io.github.jessemarshall/coalesce-transform

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

COALESCE_ACCESS_TOKEN
secret
Bearer token from the Coalesce Deploy tab. Optional when `~/.coa/config` provides a `token`.
COALESCE_PROFILE
Selects which `~/.coa/config` profile to load. Defaults to default.
COALESCE_BASE_URL
Region-specific base URL. Defaults to https://app.coalescesoftware.io (US).
COALESCE_ORG_ID
Fallback org ID for cancel-run. Also readable from `orgID` in the active ~/.coa/config profile.
COALESCE_REPO_PATH
Local repo root for repo-backed tools and pipeline planning. Also readable from `repoPath` in the active ~/.coa/config profile.
COALESCE_CACHE_DIR
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.
COALESCE_MCP_AUTO_CACHE_MAX_BYTES
JSON size threshold before auto-caching to disk. Defaults to 32768.
COALESCE_MCP_LINEAGE_TTL_MS
In-memory lineage cache TTL in milliseconds. Defaults to 1800000.
COALESCE_MCP_MAX_REQUEST_BODY_BYTES
Max outbound API request body size. Defaults to 524288.
COALESCE_MCP_READ_ONLY
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.
COALESCE_MCP_SKILLS_DIR
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.
SNOWFLAKE_ACCOUNT
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)
SNOWFLAKE_USERNAME
Snowflake account username (required for run tools)
SNOWFLAKE_KEY_PAIR_KEY
Path to PEM-encoded private key (required if SNOWFLAKE_PAT not set)
SNOWFLAKE_PAT
secret
Snowflake Programmatic Access Token (alternative to key pair)
SNOWFLAKE_KEY_PAIR_PASS
secret
Passphrase for encrypted keys
SNOWFLAKE_WAREHOUSE
Snowflake compute warehouse (required for run tools)
SNOWFLAKE_ROLE
Snowflake user role (required for run tools)

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "coalesce-transform-mcp"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "<YOUR_COALESCE_ACCESS_TOKEN>",
        "COALESCE_PROFILE": "<YOUR_COALESCE_PROFILE>",
        "COALESCE_BASE_URL": "<YOUR_COALESCE_BASE_URL>",
        "COALESCE_ORG_ID": "<YOUR_COALESCE_ORG_ID>",
        "COALESCE_REPO_PATH": "<YOUR_COALESCE_REPO_PATH>",
        "COALESCE_CACHE_DIR": "<YOUR_COALESCE_CACHE_DIR>",
        "COALESCE_MCP_AUTO_CACHE_MAX_BYTES": "<YOUR_COALESCE_MCP_AUTO_CACHE_MAX_BYTES>",
        "COALESCE_MCP_LINEAGE_TTL_MS": "<YOUR_COALESCE_MCP_LINEAGE_TTL_MS>",
        "COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "<YOUR_COALESCE_MCP_MAX_REQUEST_BODY_BYTES>",
        "COALESCE_MCP_READ_ONLY": "<YOUR_COALESCE_MCP_READ_ONLY>",
        "COALESCE_MCP_SKILLS_DIR": "<YOUR_COALESCE_MCP_SKILLS_DIR>",
        "SNOWFLAKE_ACCOUNT": "<YOUR_SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USERNAME": "<YOUR_SNOWFLAKE_USERNAME>",
        "SNOWFLAKE_KEY_PAIR_KEY": "<YOUR_SNOWFLAKE_KEY_PAIR_KEY>",
        "SNOWFLAKE_PAT": "<YOUR_SNOWFLAKE_PAT>",
        "SNOWFLAKE_KEY_PAIR_PASS": "<YOUR_SNOWFLAKE_KEY_PAIR_PASS>",
        "SNOWFLAKE_WAREHOUSE": "<YOUR_SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_ROLE": "<YOUR_SNOWFLAKE_ROLE>"
      }
    }
  }
}