coalesce-transform-mcp
OfficialServer Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| SNOWFLAKE_PAT | No | Snowflake Programmatic Access Token (alternative to key pair) | |
| SNOWFLAKE_ROLE | No | Snowflake user role | |
| COALESCE_ORG_ID | No | Fallback org ID for cancel-run. Also readable from orgID in the active ~/.coa/config profile. | |
| COALESCE_PROFILE | No | Selects which ~/.coa/config profile to load. | default |
| COALESCE_BASE_URL | No | Region-specific base URL. | https://app.coalescesoftware.io (US) |
| SNOWFLAKE_ACCOUNT | No | 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. | |
| COALESCE_CACHE_DIR | No | 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_REPO_PATH | No | Local repo root for repo-backed tools and pipeline planning. Also readable from repoPath in the active ~/.coa/config profile. | |
| SNOWFLAKE_USERNAME | No | Snowflake account username | |
| SNOWFLAKE_WAREHOUSE | No | Snowflake compute warehouse | |
| COALESCE_ACCESS_TOKEN | No | Bearer token from the Coalesce Deploy tab. Optional when ~/.coa/config provides a token. | |
| COALESCE_MCP_READ_ONLY | No | When true, hides all write/mutation tools during registration. Only read, list, search, cache, analyze, review, diagnose, and plan tools are exposed. | false |
| SNOWFLAKE_KEY_PAIR_KEY | No | Path to PEM-encoded private key (required if SNOWFLAKE_PAT not set) | |
| COALESCE_MCP_SKILLS_DIR | No | 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_KEY_PAIR_PASS | No | Passphrase for encrypted keys | |
| COALESCE_MCP_LINEAGE_TTL_MS | No | In-memory lineage cache TTL in milliseconds. | 1800000 |
| COALESCE_MCP_REQUEST_TIMEOUT_MS | No | Default per-request timeout for Coalesce API calls. Raise on large workspaces where paginated reads exceed the default. | 60000 |
| COALESCE_MCP_AUTO_CACHE_MAX_BYTES | No | JSON size threshold before auto-caching to disk. | 32768 |
| COALESCE_MCP_INVENTORY_CACHE_TTL_MS | No | In-memory TTL for the workspace node-type inventory. Set to 0 to disable. | 300000 |
| COALESCE_MCP_MAX_REQUEST_BODY_BYTES | No | Max outbound API request body size. | 524288 |
| COALESCE_MCP_DETAIL_FETCH_TIMEOUT_MS | No | Per-page timeout for detail=true paginated fetches of large node lists. | 180000 |
| COALESCE_MCP_NODE_INDEX_CACHE_TTL_MS | No | 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. | 300000 |
| COALESCE_MCP_NODE_DETAIL_CACHE_TTL_MS | No | In-memory TTL for the workspace node-detail (full body) cache used by review and predecessor lookups. Set to 0 to disable. | 300000 |
Capabilities
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
No tools | |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Latest Blog Posts
MCP directory API
We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/Coalesce-Software-Inc/coalesce-transform-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server