MCP Server
MCP
OSS Snowflake MCP Server
By MCP Server for Snowflake from Snowflake Labs
Install
uvx snowflake-labs-mcpConfiguration Example
{
"remotes": [],
"packages": [
{
"registryType": "pypi",
"registryBaseUrl": "https://pypi.org",
"identifier": "snowflake-labs-mcp",
"version": "1.3.5",
"transport": {
"type": "stdio"
},
"packageArguments": [
{
"description": "Path to service specification file",
"isRequired": true,
"type": "named",
"name": "--service-config-file"
},
{
"description": "Account identifier (e.g. xy12345.us-east-1)",
"type": "named",
"name": "--account"
},
{
"description": "Snowflake host URL",
"type": "named",
"name": "--host"
},
{
"description": "Username for authentication",
"type": "named",
"name": "--user"
},
{
"description": "Password or programmatic access token",
"type": "named",
"name": "--password"
},
{
"description": "Role to use for connection",
"type": "named",
"name": "--role"
},
{
"description": "Warehouse to use for queries",
"type": "named",
"name": "--warehouse"
},
{
"description": "Whether passcode is embedded in password",
"type": "named",
"name": "--passcode-in-password"
},
{
"description": "MFA passcode for authentication",
"type": "named",
"name": "--passcode"
},
{
"description": "Private key for key pair authentication",
"type": "named",
"name": "--private-key"
},
{
"description": "Path to private key file",
"type": "named",
"name": "--private-key-file"
},
{
"description": "Password for encrypted private key",
"type": "named",
"name": "--private-key-file-pwd"
},
{
"description": "Authentication type",
"default": "snowflake",
"type": "named",
"name": "--authenticator"
},
{
"description": "Name of connection from connections.toml (or config.toml) file",
"type": "named",
"name": "--connection-name"
},
{
"description": "Transport for the MCP server",
"default": "stdio",
"choices": [
"stdio",
"http",
"sse",
"streamable-http"
],
"type": "named",
"name": "--transport"
},
{
"description": "Host address to bind the server to (default: 0.0.0.0)",
"default": "0.0.0.0",
"type": "named",
"name": "--server-host"
},
{
"description": "Port number for the server to listen on (default: 9000)",
"default": "9000",
"type": "named",
"name": "--port"
},
{
"description": "Custom endpoint path for HTTP transports",
"default": "/mcp",
"type": "named",
"name": "--endpoint"
}
],
"environmentVariables": [
{
"description": "Account identifier (e.g. xy12345.us-east-1)",
"format": "string",
"name": "SNOWFLAKE_ACCOUNT"
},
{
"description": "Snowflake host URL",
"format": "string",
"name": "SNOWFLAKE_HOST"
},
{
"description": "Username for authentication",
"format": "string",
"name": "SNOWFLAKE_USER"
},
{
"description": "Password or programmatic access token",
"format": "string",
"isSecret": true,
"name": "SNOWFLAKE_PASSWORD"
},
{
"description": "Role to use for connection",
"format": "string",
"name": "SNOWFLAKE_ROLE"
},
{
"description": "Warehouse to use for queries",
"format": "string",
"name": "SNOWFLAKE_WAREHOUSE"
},
{
"description": "MFA passcode for authentication",
"format": "string",
"name": "SNOWFLAKE_PASSCODE"
},
{
"description": "Private key for key pair authentication",
"format": "string",
"isSecret": true,
"name": "SNOWFLAKE_PRIVATE_KEY"
},
{
"description": "Path to private key file",
"format": "string",
"name": "SNOWFLAKE_PRIVATE_KEY_FILE"
},
{
"description": "Password for encrypted private key",
"format": "string",
"name": "SNOWFLAKE_PRIVATE_KEY_FILE_PWD"
},
{
"description": "Host address to bind the server to (default: 0.0.0.0)",
"format": "string",
"name": "SNOWFLAKE_MCP_HOST"
},
{
"description": "Port number for the server to listen on (default: 9000)",
"format": "number",
"name": "SNOWFLAKE_MCP_PORT"
},
{
"description": "Endpoint path for the MCP server (default: /mcp)",
"format": "string",
"name": "SNOWFLAKE_MCP_ENDPOINT"
}
]
}
]
}
mcp
model-context-protocol
pypi
Comments
Sign in to leave a comment