Coalesce Transform

What you can do with it

We have not written a plain-language summary for this one yet. Below are the facts we read from the registry.

• Connection: Runs on your computer
• Transport: stdio
• Category: Other
• You need to fill in: COALESCE_ACCESS_TOKEN, SNOWFLAKE_PAT, SNOWFLAKE_KEY_PAIR_PASS

Install

Pick the AI app you use, then copy the settings.

You need

• npmNode.js installed (for the npx command)

Which app do you use?

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

claude mcp add coalesce-transform --env COALESCE_ACCESS_TOKEN=your-value --env COALESCE_PROFILE=your-value --env COALESCE_BASE_URL=your-value --env COALESCE_ORG_ID=your-value --env COALESCE_REPO_PATH=your-value --env COALESCE_CACHE_DIR=your-value --env COALESCE_MCP_AUTO_CACHE_MAX_BYTES=your-value --env COALESCE_MCP_LINEAGE_TTL_MS=your-value --env COALESCE_MCP_MAX_REQUEST_BODY_BYTES=your-value --env COALESCE_MCP_READ_ONLY=your-value --env COALESCE_MCP_SKILLS_DIR=your-value --env SNOWFLAKE_ACCOUNT=your-value --env SNOWFLAKE_USERNAME=your-value --env SNOWFLAKE_KEY_PAIR_KEY=your-value --env SNOWFLAKE_PAT=your-value --env SNOWFLAKE_KEY_PAIR_PASS=your-value --env SNOWFLAKE_WAREHOUSE=your-value --env SNOWFLAKE_ROLE=your-value -- npx -y coalesce-transform-mcp

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

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

Your choice stays on this device in a cookie; no account needed.

Values you fill in

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

These settings are generated from the maker’s registry entry. If the README says otherwise, follow the README.

What it can do

Runs on your computer; the tool list appears in your AI app after you install it.

Basic checksi

We check information anyone can see; we have not read the code. Checks that do not apply are left out of the count. · Checked Nov 7, 2026

• ✓ Pass

  Maker matches the repo

  The registry name was verified with the GitHub account jessemarshall, which owns the repo

• … Not checked yet

  Still maintained

  We have not read this repo from GitHub yet

• … Not checked yet

  Has a licence

  We have not read this repo from GitHub yet

• – Not applicable

  Endpoint responds

  This one runs on your computer; there is no internet endpoint

• – Not applicable

  Sign-in with OAuth

  Runs on your computer and uses local settings instead

• … Not checked yet

  No hidden instructions in tool descriptions

  Runs on your computer; we can only read tool lists from internet endpoints

Compared with others in Otheri

• More stars than 0% of the other 32602 servers in this category
• Published to the registry more recently than 7% of the other 32602 servers in this category
• Basic checks equal to or better than 100% of the other 32602 servers in this category

Compared with every active server in this category in the registry. Stars count only when the publisher owns the repo.

Alternatives

Servers in the same category from other makers, sorted by stars.

Reading a card:★ GitHub starsiThree pillars: reviews · checks · usageiUpdated = latest version published to the registryi

README from the maker

No README found in the repo