io.github.jessemarshall

coalesce-transform

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

stdiocommunityservice

Package Details

Transportstdio

Environment Variables

COALESCE_ACCESS_TOKEN(str)
Secret

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

COALESCE_PROFILE(str)

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

COALESCE_BASE_URL(str)

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

COALESCE_ORG_ID(str)

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

COALESCE_REPO_PATH(str)

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

COALESCE_CACHE_DIR(str)

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(str)

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

COALESCE_MCP_LINEAGE_TTL_MS(str)

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

COALESCE_MCP_MAX_REQUEST_BODY_BYTES(str)

Max outbound API request body size. Defaults to 524288.

COALESCE_MCP_READ_ONLY(str)

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(str)

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(str)

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(str)

Snowflake account username (required for run tools)

SNOWFLAKE_KEY_PAIR_KEY(str)

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

SNOWFLAKE_PAT(str)
Secret

Snowflake Programmatic Access Token (alternative to key pair)

SNOWFLAKE_KEY_PAIR_PASS(str)
Secret

Passphrase for encrypted keys

SNOWFLAKE_WAREHOUSE(str)

Snowflake compute warehouse (required for run tools)

SNOWFLAKE_ROLE(str)

Snowflake user role (required for run tools)