coalesce-transform

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

build.protocol_tooling.mcp

Install coalesce-transform in your MCP client

coalesce-transform is a Model Context Protocol server. Add it to your MCP client config once, restart, and the server's tools become available to your AI assistant. The same JSON snippet below works across all four major clients — only the config file path differs.

  1. Locate your client's MCP config file.
    • Cursor: ~/.cursor/mcp.json
    • Claude Desktop (macOS): ~/Library/Application Support/Claude/claude_desktop_config.json
    • Claude Desktop (Windows): %APPDATA%\Claude\claude_desktop_config.json
    • VS Code: Settings → Extensions → MCP
    • Windsurf: Settings → MCP Servers
  2. Add coalesce-transform to the mcpServers map — paste the snippet below into your config file. If you already have other MCP servers, merge the entry into the existing mcpServers object.
  3. Restart your client so it picks up the new server.
  4. Verify — ask the assistant to list available tools; coalesce-transform's tools should appear.
{
  "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_REQUEST_TIMEOUT_MS": "<your-coalesce-mcp-request-timeout-ms>",
        "COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS": "<your-coalesce-mcp-detail-fetch-timeout-ms>",
        "COALESCE_MCP_INVENTORY_CACHE_TTL_MS": "<your-coalesce-mcp-inventory-cache-ttl-ms>",
        "COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS": "<your-coalesce-mcp-node-index-cache-ttl-ms>",
        "COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS": "<your-coalesce-mcp-node-detail-cache-ttl-ms>",
        "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>"
      }
    }
  }
}

Install coalesce-transform in Cursor

Open ~/.cursor/mcp.json in your editor, paste the snippet above into mcpServers, save, and restart Cursor. coalesce-transform will show up in the assistant's tool list on next launch.

Install coalesce-transform in Claude Desktop (macOS)

Open ~/Library/Application Support/Claude/claude_desktop_config.json in your editor, paste the snippet above into mcpServers, save, and restart Claude Desktop (macOS). coalesce-transform will show up in the assistant's tool list on next launch.

Install coalesce-transform in Claude Desktop (Windows)

Open %APPDATA%\Claude\claude_desktop_config.json in your editor, paste the snippet above into mcpServers, save, and restart Claude Desktop (Windows). coalesce-transform will show up in the assistant's tool list on next launch.

Install coalesce-transform in VS Code

Open Settings → Extensions → MCP in your editor, paste the snippet above into mcpServers, save, and restart VS Code. coalesce-transform will show up in the assistant's tool list on next launch.

npm package: coalesce-transform-mcp

Required environment variables

coalesce-transform needs the following environment variables set before it can run. Add them to the env block of your mcpServers entry, or export them in your shell before launching the client.

  • COALESCE_ACCESS_TOKEN
  • COALESCE_PROFILE
  • COALESCE_BASE_URL
  • COALESCE_ORG_ID
  • COALESCE_REPO_PATH
  • COALESCE_CACHE_DIR
  • COALESCE_MCP_AUTO_CACHE_MAX_BYTES
  • COALESCE_MCP_LINEAGE_TTL_MS
  • COALESCE_MCP_MAX_REQUEST_BODY_BYTES
  • COALESCE_MCP_REQUEST_TIMEOUT_MS
  • COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS
  • COALESCE_MCP_INVENTORY_CACHE_TTL_MS
  • COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS
  • COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS
  • COALESCE_MCP_READ_ONLY
  • COALESCE_MCP_SKILLS_DIR
  • SNOWFLAKE_ACCOUNT
  • SNOWFLAKE_USERNAME
  • SNOWFLAKE_KEY_PAIR_KEY
  • SNOWFLAKE_PAT
  • SNOWFLAKE_KEY_PAIR_PASS
  • SNOWFLAKE_WAREHOUSE
  • SNOWFLAKE_ROLE

Transport

coalesce-transform supports the following MCP transports. Most AI clients use stdio by default for locally-installed servers.

stdio

Other Model Context Protocol servers in the same space as coalesce-transform. Each one adds different capabilities to your AI assistant — pick based on the data sources or workflows you need.

Browse the full MCP server directory or use Stork's one-line install to let your agent pick the right server automatically.