io.github.Coalesce-Software-Inc/coalesce-transform

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

Quality Score

/100

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

Repository →

§00 Trust verdict · v1 advisory · method

UNVERIFIEDno verdict on file

Verdict not yet evaluated for this tool. The hybrid eval runs adversarial cases first; coverage rolls out as the corpus expands. Until a verdict is recorded, an agent should treat this tool as not-yet-cleared and fall back to its own checks. Method: hybrid eval, four-state verdict, honest limits.

§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_REQUEST_TIMEOUT_MS": "<coalesce_mcp_request_timeout_ms>",
        "COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS": "<coalesce_mcp_detail_fetch_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": "<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_REQUEST_TIMEOUT_MS": "<coalesce_mcp_request_timeout_ms>",
        "COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS": "<coalesce_mcp_detail_fetch_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": "<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_REQUEST_TIMEOUT_MS

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

Per-page timeout for detail=true paginated fetches of large node lists. Defaults to 180000.

COALESCE_MCP_INVENTORY_CACHE_TTL_MS

In-memory TTL for the workspace node-type inventory. Set to `0` to disable. Defaults to 300000.

COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS

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

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

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)