Coalesce Transform

io.github.jessemarshall/coalesce-transform · v0.7.2

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

Source code Set it up

Connect Runs on your machine

Terminal

claude mcp add coalesce-transform -e COALESCE_ACCESS_TOKEN=<COALESCE_ACCESS_TOKEN> -e COALESCE_PROFILE=<COALESCE_PROFILE> -e COALESCE_BASE_URL=<COALESCE_BASE_URL> -e COALESCE_ORG_ID=<COALESCE_ORG_ID> -e COALESCE_REPO_PATH=<COALESCE_REPO_PATH> -e COALESCE_CACHE_DIR=<COALESCE_CACHE_DIR> -e COALESCE_MCP_AUTO_CACHE_MAX_BYTES=<COALESCE_MCP_AUTO_CACHE_MAX_BYTES> -e COALESCE_MCP_LINEAGE_TTL_MS=<COALESCE_MCP_LINEAGE_TTL_MS> -e COALESCE_MCP_MAX_REQUEST_BODY_BYTES=<COALESCE_MCP_MAX_REQUEST_BODY_BYTES> -e COALESCE_MCP_READ_ONLY=<COALESCE_MCP_READ_ONLY> -e COALESCE_MCP_SKILLS_DIR=<COALESCE_MCP_SKILLS_DIR> -e SNOWFLAKE_ACCOUNT=<SNOWFLAKE_ACCOUNT> -e SNOWFLAKE_USERNAME=<SNOWFLAKE_USERNAME> -e SNOWFLAKE_KEY_PAIR_KEY=<SNOWFLAKE_KEY_PAIR_KEY> -e SNOWFLAKE_PAT=<SNOWFLAKE_PAT> -e SNOWFLAKE_KEY_PAIR_PASS=<SNOWFLAKE_KEY_PAIR_PASS> -e SNOWFLAKE_WAREHOUSE=<SNOWFLAKE_WAREHOUSE> -e SNOWFLAKE_ROLE=<SNOWFLAKE_ROLE> -- npx -y [email protected]

claude_desktop_config.json

{
  "mcpServers": {
    "coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "<COALESCE_ACCESS_TOKEN>",
        "COALESCE_PROFILE": "<COALESCE_PROFILE>",
        "COALESCE_BASE_URL": "<COALESCE_BASE_URL>",
        "COALESCE_ORG_ID": "<COALESCE_ORG_ID>",
        "COALESCE_REPO_PATH": "<COALESCE_REPO_PATH>",
        "COALESCE_CACHE_DIR": "<COALESCE_CACHE_DIR>",
        "COALESCE_MCP_AUTO_CACHE_MAX_BYTES": "<COALESCE_MCP_AUTO_CACHE_MAX_BYTES>",
        "COALESCE_MCP_LINEAGE_TTL_MS": "<COALESCE_MCP_LINEAGE_TTL_MS>",
        "COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "<COALESCE_MCP_MAX_REQUEST_BODY_BYTES>",
        "COALESCE_MCP_READ_ONLY": "<COALESCE_MCP_READ_ONLY>",
        "COALESCE_MCP_SKILLS_DIR": "<COALESCE_MCP_SKILLS_DIR>",
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USERNAME": "<SNOWFLAKE_USERNAME>",
        "SNOWFLAKE_KEY_PAIR_KEY": "<SNOWFLAKE_KEY_PAIR_KEY>",
        "SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>",
        "SNOWFLAKE_WAREHOUSE": "<SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_ROLE": "<SNOWFLAKE_ROLE>"
      }
    }
  }
}

~/.cursor/mcp.json

{
  "mcpServers": {
    "coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "<COALESCE_ACCESS_TOKEN>",
        "COALESCE_PROFILE": "<COALESCE_PROFILE>",
        "COALESCE_BASE_URL": "<COALESCE_BASE_URL>",
        "COALESCE_ORG_ID": "<COALESCE_ORG_ID>",
        "COALESCE_REPO_PATH": "<COALESCE_REPO_PATH>",
        "COALESCE_CACHE_DIR": "<COALESCE_CACHE_DIR>",
        "COALESCE_MCP_AUTO_CACHE_MAX_BYTES": "<COALESCE_MCP_AUTO_CACHE_MAX_BYTES>",
        "COALESCE_MCP_LINEAGE_TTL_MS": "<COALESCE_MCP_LINEAGE_TTL_MS>",
        "COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "<COALESCE_MCP_MAX_REQUEST_BODY_BYTES>",
        "COALESCE_MCP_READ_ONLY": "<COALESCE_MCP_READ_ONLY>",
        "COALESCE_MCP_SKILLS_DIR": "<COALESCE_MCP_SKILLS_DIR>",
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USERNAME": "<SNOWFLAKE_USERNAME>",
        "SNOWFLAKE_KEY_PAIR_KEY": "<SNOWFLAKE_KEY_PAIR_KEY>",
        "SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>",
        "SNOWFLAKE_WAREHOUSE": "<SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_ROLE": "<SNOWFLAKE_ROLE>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "coalesce-transform": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "[email protected]"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "<COALESCE_ACCESS_TOKEN>",
        "COALESCE_PROFILE": "<COALESCE_PROFILE>",
        "COALESCE_BASE_URL": "<COALESCE_BASE_URL>",
        "COALESCE_ORG_ID": "<COALESCE_ORG_ID>",
        "COALESCE_REPO_PATH": "<COALESCE_REPO_PATH>",
        "COALESCE_CACHE_DIR": "<COALESCE_CACHE_DIR>",
        "COALESCE_MCP_AUTO_CACHE_MAX_BYTES": "<COALESCE_MCP_AUTO_CACHE_MAX_BYTES>",
        "COALESCE_MCP_LINEAGE_TTL_MS": "<COALESCE_MCP_LINEAGE_TTL_MS>",
        "COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "<COALESCE_MCP_MAX_REQUEST_BODY_BYTES>",
        "COALESCE_MCP_READ_ONLY": "<COALESCE_MCP_READ_ONLY>",
        "COALESCE_MCP_SKILLS_DIR": "<COALESCE_MCP_SKILLS_DIR>",
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USERNAME": "<SNOWFLAKE_USERNAME>",
        "SNOWFLAKE_KEY_PAIR_KEY": "<SNOWFLAKE_KEY_PAIR_KEY>",
        "SNOWFLAKE_PAT": "<SNOWFLAKE_PAT>",
        "SNOWFLAKE_KEY_PAIR_PASS": "<SNOWFLAKE_KEY_PAIR_PASS>",
        "SNOWFLAKE_WAREHOUSE": "<SNOWFLAKE_WAREHOUSE>",
        "SNOWFLAKE_ROLE": "<SNOWFLAKE_ROLE>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

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

Details

Package	`[email protected]` (NPM, stdio)
First published	20 Apr 2026
Last updated	20 Apr 2026
Registry name	`io.github.jessemarshall/coalesce-transform`

More other servers See all

Live status

Local install

Installed and run on your own machine, so there is no public endpoint to check.

Pair it with live search

Agents that use Coalesce Transform often also need current facts. NestDaddy MCP gives your AI today's internet: web search, real-time breaking news and full page reading in one connector.

See NestDaddy MCP

For maintainers

[![NestDaddy MCP](https://nestdaddy.com/mcp/servers/io-github-jessemarshall-coalesce-transform/badge.svg)](https://nestdaddy.com/mcp/servers/io-github-jessemarshall-coalesce-transform)

Add the badge to your README. It turns green while your server passes our daily check. Listing details come from the official MCP registry; update them there.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.