MCP Marketplace
Sign inSign up
Back to Browse

Coalesce Transform MCP Server

by Coalesce Software Inc
Developer ToolsModerate5.2MCP 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

5.2
Moderate5.2Moderate Risk

This is a well-structured MCP server for the Coalesce platform with appropriate authentication via API tokens and proper credential handling. Permissions align with its purpose (managing pipelines, nodes, and runs). Minor code quality and documentation concerns exist around input validation and error handling, but no critical security vulnerabilities were identified. Supply chain analysis found 1 known vulnerability in dependencies (1 critical, 0 high severity). Package verification found 1 issue.

2 files analyzed · 8 issues 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.

env_vars

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

File System Read

Reads files on your machine. Normal for tools that analyze or process local data.

File System Write

Writes or modifies files on your machine. Check that this is expected for the tool.

HTTP Network Access

Connects to external APIs or services over the internet.

process_spawn

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

Forces large responses inline as text instead of auto-caching them to disk and returning a `resource_link` (and suppresses per-field cache resource links). The server already auto-enables this for clients known not to support MCP resources (e.g. Snowflake Cortex), which otherwise render the link as unreadable "binary data" and retry in a loop. Set `true` to force it on for an unrecognised client, or `false` to disable auto-detection. Leave unset for Claude/Cursor to keep large payloads out of context. Defaults to false (auto-enabled for resource-less clients).Optional

Environment variable: COALESCE_MCP_INLINE_RESPONSES

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

Default per-request timeout for Coalesce API calls. Raise on large workspaces where paginated reads exceed the default. Defaults to 60000.Optional

Environment variable: COALESCE_MCP_REQUEST_TIMEOUT_MS

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

Environment variable: COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS

Deadline for the best-effort workspace-adoption node-type ranking lookup inside node creation. Advisory only — creation proceeds without a ranking suggestion if this trips. Defaults to 15000.Optional

Environment variable: COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS

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

Environment variable: COALESCE_MCP_INVENTORY_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.Optional

Environment variable: COALESCE_MCP_NODE_INDEX_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.Optional

Environment variable: COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS

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-coalesce-software-inc-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_INLINE_RESPONSES": "your-coalesce-mcp-inline-responses-here",
        "COALESCE_MCP_REQUEST_TIMEOUT_MS": "your-coalesce-mcp-request-timeout-ms-here",
        "COALESCE_MCP_AUTO_CACHE_MAX_BYTES": "your-coalesce-mcp-auto-cache-max-bytes-here",
        "COALESCE_MCP_INVENTORY_CACHE_TTL_MS": "your-coalesce-mcp-inventory-cache-ttl-ms-here",
        "COALESCE_MCP_MAX_REQUEST_BODY_BYTES": "your-coalesce-mcp-max-request-body-bytes-here",
        "COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS": "your-coalesce-mcp-detail-fetch-timeout-ms-here",
        "COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS": "your-coalesce-mcp-node-index-cache-ttl-ms-here",
        "COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS": "your-coalesce-mcp-node-detail-cache-ttl-ms-here",
        "COALESCE_MCP_NODE_TYPE_RANKING_TIMEOUT_MS": "your-coalesce-mcp-node-type-ranking-timeout-ms-here"
      },
      "args": [
        "-y",
        "coalesce-transform-mcp"
      ],
      "command": "npx"
    }
  }
}

Reviews

No reviews yet

Be the first to review this server!

More Developer Tools MCP Servers

Git

Free

by Modelcontextprotocol · Developer Tools

Read, search, and manipulate Git repositories programmatically

80.0K
Stars
11
Installs
6.5
Security
No ratings yet
Local

Fetch

Free

by Modelcontextprotocol · Developer Tools

Web content fetching and conversion for efficient LLM usage

80.0K
Stars
12
Installs
5.3
Security
No ratings yet
Local

Toleno

Free

by Toleno · Developer Tools

Toleno Network MCP Server — Manage your Toleno mining account with Claude AI using natural language.

180
Stars
616
Installs
8.0
Security
4.7
Local

mcp-creator-python

Free

by mcp-marketplace · Developer Tools

Create, build, and publish Python MCP servers to PyPI — conversationally.

-
Stars
98
Installs
10.0
Security
4.6
Local

MarkItDown

Free

by Microsoft · Content & Media

Convert files (PDF, Word, Excel, images, audio) to Markdown for LLM consumption

168.6K
Stars
69
Installs
4.2
Security
5.0
Local

MCP Marketplace

Free

by mcp-marketplace · Developer Tools

Search and install MCP servers from inside your AI client.

-
Stars
66
Installs
10.0
Security
5.0
Remote
Coalesce Transform MCP Server - MCP server for managing Coalesce Transform workspaces, | MCP Marketplace