coalesce-transform

Name: coalesce-transform
Author: jessemarshall

本地服务

github.com/jessemarshall数据库

代码仓库

关于 coalesce-transform

用于管理 Coalesce Transform 工作区、节点、流水线和运行的 MCP 服务。

配置

本地服务的配置在各客户端中通用，复制后粘贴到客户端的 MCP 配置文件即可。

mcp.json · 通用配置

{
  "mcpServers": {
    "jessemarshall-coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "coalesce-transform-mcp"
      ],
      "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>"
      }
    }
  }
}

启动命令npx -y coalesce-transform-mcp

需要配置的环境变量

COALESCE_ACCESS_TOKEN密钥Bearer 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_KEY密钥Path to PEM-encoded private key (required if SNOWFLAKE_PAT not set)

SNOWFLAKE_PAT密钥Snowflake Programmatic Access Token (alternative to key pair)

SNOWFLAKE_KEY_PAIR_PASS密钥Passphrase for encrypted keys

SNOWFLAKE_WAREHOUSESnowflake compute warehouse (required for run tools)

SNOWFLAKE_ROLESnowflake user role (required for run tools)

本地服务需要在你的电脑上安装运行环境（如 Node.js 18+）。各客户端的配置文件位置不同，请参考客户端文档。

安装包

npmcoalesce-transform-mcp0.7.2stdio