NestDaddy
All servers NestDaddy MCP Blog Sign inTry it free
Other

Coalesce Transform

io.github.Coalesce-Software-Inc/coalesce-transform · v0.10.1

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_INLINE_RESPONSES=<COALESCE_MCP_INLINE_RESPONSES> -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_REQUEST_TIMEOUT_MS=<COALESCE_MCP_REQUEST_TIMEOUT_MS> -e COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS=<COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS> -e COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS=<COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS> -e COALESCE_MCP_INVENTORY_CACHE_TTL_MS=<COALESCE_MCP_INVENTORY_CACHE_TTL_MS> -e COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS=<COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS> -e COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS=<COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS> -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_INLINE_RESPONSES": "<COALESCE_MCP_INLINE_RESPONSES>",
        "COALESCE_MCP_LINEAGE_TTL_MS": "<COALESCE_MCP_LINEAGE_TTL_MS>",
        "COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "<COALESCE_MCP_MAX_REQUEST_BODY_BYTES>",
        "COALESCE_MCP_REQUEST_TIMEOUT_MS": "<COALESCE_MCP_REQUEST_TIMEOUT_MS>",
        "COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS": "<COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS>",
        "COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS": "<COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS>",
        "COALESCE_MCP_INVENTORY_CACHE_TTL_MS": "<COALESCE_MCP_INVENTORY_CACHE_TTL_MS>",
        "COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS": "<COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS>",
        "COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS": "<COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS>",
        "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_INLINE_RESPONSES": "<COALESCE_MCP_INLINE_RESPONSES>",
        "COALESCE_MCP_LINEAGE_TTL_MS": "<COALESCE_MCP_LINEAGE_TTL_MS>",
        "COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "<COALESCE_MCP_MAX_REQUEST_BODY_BYTES>",
        "COALESCE_MCP_REQUEST_TIMEOUT_MS": "<COALESCE_MCP_REQUEST_TIMEOUT_MS>",
        "COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS": "<COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS>",
        "COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS": "<COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS>",
        "COALESCE_MCP_INVENTORY_CACHE_TTL_MS": "<COALESCE_MCP_INVENTORY_CACHE_TTL_MS>",
        "COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS": "<COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS>",
        "COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS": "<COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS>",
        "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_INLINE_RESPONSES": "<COALESCE_MCP_INLINE_RESPONSES>",
        "COALESCE_MCP_LINEAGE_TTL_MS": "<COALESCE_MCP_LINEAGE_TTL_MS>",
        "COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "<COALESCE_MCP_MAX_REQUEST_BODY_BYTES>",
        "COALESCE_MCP_REQUEST_TIMEOUT_MS": "<COALESCE_MCP_REQUEST_TIMEOUT_MS>",
        "COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS": "<COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS>",
        "COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS": "<COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS>",
        "COALESCE_MCP_INVENTORY_CACHE_TTL_MS": "<COALESCE_MCP_INVENTORY_CACHE_TTL_MS>",
        "COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS": "<COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS>",
        "COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS": "<COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS>",
        "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

NameDescription
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_INLINE_RESPONSES
Optional		Forces large responses inline as text instead of auto-caching them to disk and returning a `resource_link` (and suppresses per-field cache resource links). The server already auto-enables this for clients known not to support MCP resources (e.g. Snowflake Cortex), which otherwise render the link as…
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_REQUEST_TIMEOUT_MS
Optional		Default per-request timeout for Coalesce API calls. Raise on large workspaces where paginated reads exceed the default. Defaults to 60000.
COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS
Optional		Per-page timeout for detail=true paginated fetches of large node lists. Defaults to 180000.
COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS
Optional		Deadline for the best-effort workspace-adoption node-type ranking lookup inside node creation. Advisory only — creation proceeds without a ranking suggestion if this trips. Defaults to 15000.
COALESCE_MCP_INVENTORY_CACHE_TTL_MS
Optional		In-memory TTL for the workspace node-type inventory. Set to `0` to disable. Defaults to 300000.
COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS
Optional		In-memory TTL for the workspace node-index (id/name/type/location) cache used by SQL- and intent-ref resolution. Set to `0` to disable. Defaults to 300000.
COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS
Optional		In-memory TTL for the workspace node-detail (full body) cache used by review and predecessor lookups. Set to `0` to disable. Defaults to 300000.
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 published3 Jul 2026
Last updated3 Jul 2026
Registry nameio.github.Coalesce-Software-Inc/coalesce-transform

More other servers See all

  • SalaryNet Payroll

    Gross-to-net pay and employer cost for US, PH, NG, ID, IN, BR, KE, VN with official sources.

  • Auto Öz

    Auto Öz: Kontakt, Standorte, Öffnungszeiten, Leistungen und Angebote, Freie Termine, Termin…

  • CGC Airport Transfers

    Fixed-price quotes and bookings for private airport transfers: Gold Coast, Brisbane, Byron Bay.

  • Coral

    Private, non-explicit intimacy exercises, scripts and a couples quiz for adults 18+.

  • Business valuation calculator

    Estimates what a buyer might pay for a small agency, service or SaaS business, in US dollars.

  • BuildYourWolfpack

    Roast-to-order coffee with a game built in: missions, Pack Points, and your own wolf pack.

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