io.github.jessemarshall/coalesce-transform

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

Quality Score

/100

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

Repository →

§01 Install

Claude Desktop (claude_desktop_config.json)

{
  "mcpServers": {
    "coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "coalesce-transform-mcp"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "<your-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": "<your-snowflake_pat>",
        "SNOWFLAKE_KEY_PAIR_PASS": "<your-snowflake_key_pair_pass>",
        "SNOWFLAKE_WAREHOUSE": "<snowflake_warehouse>",
        "SNOWFLAKE_ROLE": "<snowflake_role>"
      }
    }
  }
}

Cursor (.cursor/mcp.json)

{
  "mcpServers": {
    "coalesce-transform": {
      "command": "npx",
      "args": [
        "-y",
        "coalesce-transform-mcp"
      ],
      "env": {
        "COALESCE_ACCESS_TOKEN": "<your-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": "<your-snowflake_pat>",
        "SNOWFLAKE_KEY_PAIR_PASS": "<your-snowflake_key_pair_pass>",
        "SNOWFLAKE_WAREHOUSE": "<snowflake_warehouse>",
        "SNOWFLAKE_ROLE": "<snowflake_role>"
      }
    }
  }
}

Cline (cline_mcp_settings.json)

npx -y coalesce-transform-mcp

§02 Environment variables

COALESCE_ACCESS_TOKEN

secret

Bearer token from the Coalesce Deploy tab. Optional when `~/.coa/config` provides a `token`.

COALESCE_PROFILE

Selects which `~/.coa/config` profile to load. Defaults to default.

COALESCE_BASE_URL

Region-specific base URL. Defaults to https://app.coalescesoftware.io (US).

COALESCE_ORG_ID

Fallback org ID for cancel-run. Also readable from `orgID` in the active ~/.coa/config profile.

COALESCE_REPO_PATH

Local repo root for repo-backed tools and pipeline planning. Also readable from `repoPath` in the active ~/.coa/config profile.

COALESCE_CACHE_DIR

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

JSON size threshold before auto-caching to disk. Defaults to 32768.

COALESCE_MCP_LINEAGE_TTL_MS

In-memory lineage cache TTL in milliseconds. Defaults to 1800000.

COALESCE_MCP_MAX_REQUEST_BODY_BYTES

Max outbound API request body size. Defaults to 524288.

COALESCE_MCP_READ_ONLY

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

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

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

Snowflake account username (required for run tools)

SNOWFLAKE_KEY_PAIR_KEY

Path to PEM-encoded private key (required if SNOWFLAKE_PAT not set)

SNOWFLAKE_PAT

secret

Snowflake Programmatic Access Token (alternative to key pair)

SNOWFLAKE_KEY_PAIR_PASS

secret

Passphrase for encrypted keys

SNOWFLAKE_WAREHOUSE

Snowflake compute warehouse (required for run tools)