Skip to content
MCP server

Coalesce Transform

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

Runs locallyStatus and history
Install
Pricing
Open source
Runs
Locally
Version
0.7.2
Listing updated
5 days ago

About Coalesce Transform

Coalesce Transform is an open-source MCP server. It runs locally on your machine and is started by your AI client.

Install

Run in a terminal

claude mcp add coalesce-transform --env COALESCE_ACCESS_TOKEN='<COALESCE_ACCESS_TOKEN>' --env SNOWFLAKE_PAT='<SNOWFLAKE_PAT>' --env SNOWFLAKE_KEY_PAIR_PASS='<SNOWFLAKE_KEY_PAIR_PASS>' -- npx -y coalesce-transform-mcp

Add to claude_desktop_config.json

{
  "mcpServers": {
    "coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "coalesce-transform-mcp"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "<COALESCE_ACCESS_TOKEN>",
        "SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "coalesce-transform-mcp"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "<COALESCE_ACCESS_TOKEN>",
        "SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>"
      }
    }
  }
}

Add to .vscode/mcp.json

{
  "servers": {
    "coalesce-transform": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "coalesce-transform-mcp"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "<COALESCE_ACCESS_TOKEN>",
        "SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "coalesce-transform-mcp"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "<COALESCE_ACCESS_TOKEN>",
        "SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>"
      }
    }
  }
}

Add to your client's MCP settings (most use this shape)

{
  "mcpServers": {
    "coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "coalesce-transform-mcp"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "<COALESCE_ACCESS_TOKEN>",
        "SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>"
      }
    }
  }
}

Using several servers? Build one config file with the MCP config generator.

Configuration

  • COALESCE_ACCESS_TOKENBearer token from the Coalesce Deploy tab. Optional when `~/.coa/config` provides a `token`.
  • COALESCE_PROFILESelects which `~/.coa/config` profile to load. Defaults to default.
  • COALESCE_BASE_URLRegion-specific base URL. Defaults to https://app.coalescesoftware.io (US).
  • COALESCE_ORG_IDFallback org ID for cancel-run. Also readable from `orgID` in the active ~/.coa/config profile.
  • COALESCE_REPO_PATHLocal repo root for repo-backed tools and pipeline planning. Also readable from `repoPath` in the active ~/.coa/config profile.
  • COALESCE_CACHE_DIRBase 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_BYTESJSON size threshold before auto-caching to disk. Defaults to 32768.
  • COALESCE_MCP_LINEAGE_TTL_MSIn-memory lineage cache TTL in milliseconds. Defaults to 1800000.
  • COALESCE_MCP_MAX_REQUEST_BODY_BYTESMax outbound API request body size. Defaults to 524288.
  • COALESCE_MCP_READ_ONLYWhen `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_DIRDirectory 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_ACCOUNTSnowflake 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_USERNAMESnowflake account username (required for run tools)
  • SNOWFLAKE_KEY_PAIR_KEYPath to PEM-encoded private key (required if SNOWFLAKE_PAT not set)
  • SNOWFLAKE_PATSnowflake Programmatic Access Token (alternative to key pair)
  • SNOWFLAKE_KEY_PAIR_PASSPassphrase for encrypted keys
  • SNOWFLAKE_WAREHOUSESnowflake compute warehouse (required for run tools)
  • SNOWFLAKE_ROLESnowflake user role (required for run tools)

Pricing

Open source

Coalesce Transform FAQ

Is Coalesce Transform free?

Yes. Coalesce Transform is open source, so you can use and self-host it for free.

How do I add Coalesce Transform to Claude Code?

Run this command in your terminal: claude mcp add coalesce-transform --env COALESCE_ACCESS_TOKEN='<COALESCE_ACCESS_TOKEN>' --env SNOWFLAKE_PAT='<SNOWFLAKE_PAT>' --env SNOWFLAKE_KEY_PAIR_PASS='<SNOWFLAKE_KEY_PAIR_PASS>' -- npx -y coalesce-transform-mcp

Where this comes from

  • Description: from the official MCP Registry entry.
  • Install steps: from the official MCP Registry entry.

How AIPoweredBot checks servers