Back to Browse

Coalesce Transform MCP Server

Developer ToolsLow Risk10.0MCP RegistryLocal
Free

Server data from the Official MCP Registry

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

About

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

Security Report

10.0
Low Risk10.0Low Risk

Valid MCP server (1 strong, 1 medium validity signals). No known CVEs in dependencies. Package registry verified. Imported from the Official MCP Registry.

4 files analyzed · 1 issue found

Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.

Permissions Required

This plugin requests these system permissions. Most are normal for its category.

file_system

Check that this permission is expected for this type of plugin.

What You'll Need

Set these up before or after installing:

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

Environment variable: COALESCE_ACCESS_TOKEN

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

Environment variable: COALESCE_PROFILE

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

Environment variable: COALESCE_BASE_URL

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

Environment variable: COALESCE_ORG_ID

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

Environment variable: COALESCE_REPO_PATH

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.Optional

Environment variable: COALESCE_CACHE_DIR

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

Environment variable: COALESCE_MCP_AUTO_CACHE_MAX_BYTES

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

Environment variable: COALESCE_MCP_LINEAGE_TTL_MS

Max outbound API request body size. Defaults to 524288.Optional

Environment variable: COALESCE_MCP_MAX_REQUEST_BODY_BYTES

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.Optional

Environment variable: COALESCE_MCP_READ_ONLY

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.Optional

Environment variable: COALESCE_MCP_SKILLS_DIR

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)Optional

Environment variable: SNOWFLAKE_ACCOUNT

Snowflake account username (required for run tools)Optional

Environment variable: SNOWFLAKE_USERNAME

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

Environment variable: SNOWFLAKE_KEY_PAIR_KEY

Snowflake Programmatic Access Token (alternative to key pair)Required

Environment variable: SNOWFLAKE_PAT

Passphrase for encrypted keysRequired

Environment variable: SNOWFLAKE_KEY_PAIR_PASS

Snowflake compute warehouse (required for run tools)Optional

Environment variable: SNOWFLAKE_WAREHOUSE

Snowflake user role (required for run tools)Optional

Environment variable: SNOWFLAKE_ROLE

How to Install

Add this to your MCP configuration file:

{
  "mcpServers": {
    "io-github-jessemarshall-coalesce-transform": {
      "env": {
        "SNOWFLAKE_PAT": "your-snowflake-pat-here",
        "SNOWFLAKE_ROLE": "your-snowflake-role-here",
        "COALESCE_ORG_ID": "your-coalesce-org-id-here",
        "COALESCE_PROFILE": "your-coalesce-profile-here",
        "COALESCE_BASE_URL": "your-coalesce-base-url-here",
        "SNOWFLAKE_ACCOUNT": "your-snowflake-account-here",
        "COALESCE_CACHE_DIR": "your-coalesce-cache-dir-here",
        "COALESCE_REPO_PATH": "your-coalesce-repo-path-here",
        "SNOWFLAKE_USERNAME": "your-snowflake-username-here",
        "SNOWFLAKE_WAREHOUSE": "your-snowflake-warehouse-here",
        "COALESCE_ACCESS_TOKEN": "your-coalesce-access-token-here",
        "COALESCE_MCP_READ_ONLY": "your-coalesce-mcp-read-only-here",
        "SNOWFLAKE_KEY_PAIR_KEY": "your-snowflake-key-pair-key-here",
        "COALESCE_MCP_SKILLS_DIR": "your-coalesce-mcp-skills-dir-here",
        "SNOWFLAKE_KEY_PAIR_PASS": "your-snowflake-key-pair-pass-here",
        "COALESCE_MCP_LINEAGE_TTL_MS": "your-coalesce-mcp-lineage-ttl-ms-here",
        "COALESCE_MCP_AUTO_CACHE_MAX_BYTES": "your-coalesce-mcp-auto-cache-max-bytes-here",
        "COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "your-coalesce-mcp-max-request-body-bytes-here"
      },
      "args": [
        "-y",
        "coalesce-transform-mcp"
      ],
      "command": "npx"
    }
  }
}

Reviews

No reviews yet

Be the first to review this server!

Coalesce Transform MCP Server - MCP server for managing Coalesce Transform workspaces, | MCP Marketplace