Summary
Brings Coalesce's data transformation platform into your AI workflow through the Model Context Protocol. Connects to workspaces, nodes, pipelines, environments, jobs, and runs via Coalesce's API, and wraps the local Coalesce CLI so you can validate projects, preview DDL/DML, plan deployments, and push changes to cloud environments. Pairs well with Snowflake Cortex Code since both already understand your warehouse context and Snowflake roles. Supports token auth via environment variables or the standard ~/.coa/config file, and includes read-only modes for production safety. Useful when you're iterating on transformation pipelines and want an agent to handle the node creation, scheduling, and deployment mechanics while you focus on the logic.
Fastest browser for AI agents to run web automation tasks, always free.
Download Free life-time →
Notes, actions and memory. Without a meeting bot. First month 100% off.
Download for free →
belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →
Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →
Block distracting apps from your iPhone permanently without a 3rd party app. Free and open source.
Block now (100% free) →Featured
Fastest browser for AI agents to run web automation tasks, always free.
Download Free life-time →Notes, actions and memory. Without a meeting bot. First month 100% off.
Download for free →belt cli automatically finds the best tools and skills for your agent. image, video, music, tts...
one prompt install →Connect your Claude agent to live crypto prices and trading routes via 1inch
Get the MCP →Block distracting apps from your iPhone permanently without a 3rd party app. Free and open source.
Block now (100% free) →Configuration
COALESCE_ACCESS_TOKENsecretBearer token from the Coalesce Deploy tab. Optional when `~/.coa/config` provides a `token`.
COALESCE_PROFILESelects which `~/.coa/config` profile to load. Defaults to default.
COALESCE_BASE_URLRegion-specific base URL. Defaults to https://app.coalescesoftware.io (US).
COALESCE_ORG_IDFallback org ID for cancel-run. Also readable from `orgID` in the active ~/.coa/config profile.
COALESCE_REPO_PATHLocal repo root for repo-backed tools and pipeline planning. Also readable from `repoPath` in the active ~/.coa/config profile.
COALESCE_CACHE_DIRBase 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_BYTESJSON size threshold before auto-caching to disk. Defaults to 32768.
COALESCE_MCP_LINEAGE_TTL_MSIn-memory lineage cache TTL in milliseconds. Defaults to 1800000.
COALESCE_MCP_MAX_REQUEST_BODY_BYTESMax outbound API request body size. Defaults to 524288.
COALESCE_MCP_REQUEST_TIMEOUT_MSDefault 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_MSPer-page timeout for detail=true paginated fetches of large node lists. Defaults to 180000.
COALESCE_MCP_INVENTORY_CACHE_TTL_MSIn-memory TTL for the workspace node-type inventory. Set to `0` to disable. Defaults to 300000.
COALESCE_MCP_NODE_INDEX_CACHE_TTL_MSIn-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_MSIn-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_ONLYWhen `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_DIRDirectory 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_ACCOUNTSnowflake 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_USERNAMESnowflake account username (required for run tools)
SNOWFLAKE_KEY_PAIR_KEYPath to PEM-encoded private key (required if SNOWFLAKE_PAT not set)
SNOWFLAKE_PATsecretSnowflake Programmatic Access Token (alternative to key pair)
SNOWFLAKE_KEY_PAIR_PASSsecretPassphrase for encrypted keys
SNOWFLAKE_WAREHOUSESnowflake compute warehouse (required for run tools)
SNOWFLAKE_ROLESnowflake user role (required for run tools)
Registryactive
Packagecoalesce-transform-mcp
TransportSTDIO
AuthRequired
UpdatedMay 12, 2026