{"server":{"$schema":"https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json","name":"io.github.jessemarshall/coalesce-transform","description":"MCP server for managing Coalesce Transform workspaces, nodes, pipelines, and runs.","repository":{"url":"https://github.com/jessemarshall/coalesce-transform-mcp","source":"github"},"version":"0.7.2","packages":[{"registryType":"npm","identifier":"coalesce-transform-mcp","version":"0.7.2","transport":{"type":"stdio"},"environmentVariables":[{"description":"Bearer token from the Coalesce Deploy tab. Optional when `~/.coa/config` provides a `token`.","format":"string","isSecret":true,"name":"COALESCE_ACCESS_TOKEN"},{"description":"Selects which `~/.coa/config` profile to load. Defaults to default.","format":"string","name":"COALESCE_PROFILE"},{"description":"Region-specific base URL. Defaults to https://app.coalescesoftware.io (US).","format":"string","name":"COALESCE_BASE_URL"},{"description":"Fallback org ID for cancel-run. Also readable from `orgID` in the active ~/.coa/config profile.","format":"string","name":"COALESCE_ORG_ID"},{"description":"Local repo root for repo-backed tools and pipeline planning. Also readable from `repoPath` in the active ~/.coa/config profile.","format":"string","name":"COALESCE_REPO_PATH"},{"description":"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.","format":"string","name":"COALESCE_CACHE_DIR"},{"description":"JSON size threshold before auto-caching to disk. Defaults to 32768.","format":"string","name":"COALESCE_MCP_AUTO_CACHE_MAX_BYTES"},{"description":"In-memory lineage cache TTL in milliseconds. Defaults to 1800000.","format":"string","name":"COALESCE_MCP_LINEAGE_TTL_MS"},{"description":"Max outbound API request body size. Defaults to 524288.","format":"string","name":"COALESCE_MCP_MAX_REQUEST_BODY_BYTES"},{"description":"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.","format":"string","name":"COALESCE_MCP_READ_ONLY"},{"description":"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.","format":"string","name":"COALESCE_MCP_SKILLS_DIR"},{"description":"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)","format":"string","name":"SNOWFLAKE_ACCOUNT"},{"description":"Snowflake account username (required for run tools)","format":"string","name":"SNOWFLAKE_USERNAME"},{"description":"Path to PEM-encoded private key (required if SNOWFLAKE_PAT not set)","format":"string","name":"SNOWFLAKE_KEY_PAIR_KEY"},{"description":"Snowflake Programmatic Access Token (alternative to key pair)","format":"string","isSecret":true,"name":"SNOWFLAKE_PAT"},{"description":"Passphrase for encrypted keys","format":"string","isSecret":true,"name":"SNOWFLAKE_KEY_PAIR_PASS"},{"description":"Snowflake compute warehouse (required for run tools)","format":"string","name":"SNOWFLAKE_WAREHOUSE"},{"description":"Snowflake user role (required for run tools)","format":"string","name":"SNOWFLAKE_ROLE"}]}]},"_meta":{"io.modelcontextprotocol.registry/official":{"status":"active","statusChangedAt":"2026-04-20T16:33:27.369165Z","publishedAt":"2026-04-20T16:33:27.369165Z","updatedAt":"2026-04-20T16:33:27.369165Z","isLatest":true}}}