MCP Server
MCP
Snowflake MCP Server
By A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants
Install
uvx mcp-snowflake-server-nspConfiguration Example
{
"remotes": [],
"packages": [
{
"registryType": "pypi",
"registryBaseUrl": "https://pypi.org",
"identifier": "mcp-snowflake-server-nsp",
"version": "0.14.1",
"runtimeHint": "uvx",
"transport": {
"type": "stdio"
},
"packageArguments": [
{
"description": "Snowflake account identifier",
"type": "named",
"name": "--account"
},
{
"description": "Snowflake username",
"type": "named",
"name": "--user"
},
{
"description": "Password (not required for key-pair / SSO)",
"type": "named",
"name": "--password"
},
{
"description": "Virtual warehouse to use",
"type": "named",
"name": "--warehouse"
},
{
"description": "Default database",
"type": "named",
"name": "--database"
},
{
"description": "Default schema",
"type": "named",
"name": "--schema"
},
{
"description": "Role to assume",
"type": "named",
"name": "--role"
},
{
"description": "Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials",
"type": "named",
"name": "--authenticator"
},
{
"description": "Absolute path to .p8 private key file",
"type": "named",
"name": "--private_key_file"
},
{
"description": "Passphrase for encrypted private key",
"type": "named",
"name": "--private_key_file_pwd"
},
{
"description": "Path to TOML connections file",
"type": "named",
"name": "--connections-file"
},
{
"description": "Connection profile name in TOML file (required with --connections-file)",
"type": "named",
"name": "--connection-name"
},
{
"description": "Enable write_query and create_table tools",
"type": "named",
"name": "--allow_write"
},
{
"description": "Pre-load table schema as context://table/* resources (disables list_tables / describe_table)",
"type": "named",
"name": "--prefetch"
},
{
"description": "Space-separated list of tool names to disable",
"type": "named",
"name": "--exclude_tools"
},
{
"description": "Omit embedded JSON resources from responses (reduces context window usage)",
"type": "named",
"name": "--exclude-json-results"
},
{
"description": "Directory for log file output",
"type": "named",
"name": "--log_dir"
},
{
"description": "Log verbosity: DEBUG, INFO, WARNING, ERROR, CRITICAL",
"default": "INFO",
"choices": [
"DEBUG",
"INFO",
"WARNING",
"ERROR",
"CRITICAL"
],
"type": "named",
"name": "--log_level"
}
],
"environmentVariables": [
{
"description": "Snowflake account identifier",
"format": "string",
"name": "SNOWFLAKE_ACCOUNT"
},
{
"description": "Snowflake username",
"format": "string",
"name": "SNOWFLAKE_USER"
},
{
"description": "Password (not required for key-pair / SSO)",
"format": "string",
"isSecret": true,
"name": "SNOWFLAKE_PASSWORD"
},
{
"description": "Virtual warehouse to use",
"format": "string",
"name": "SNOWFLAKE_WAREHOUSE"
},
{
"description": "Default database",
"format": "string",
"name": "SNOWFLAKE_DATABASE"
},
{
"description": "Default schema",
"format": "string",
"name": "SNOWFLAKE_SCHEMA"
},
{
"description": "Role to assume",
"format": "string",
"name": "SNOWFLAKE_ROLE"
},
{
"description": "Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials",
"format": "string",
"name": "SNOWFLAKE_AUTHENTICATOR"
},
{
"description": "Absolute path to .p8 private key file",
"format": "string",
"name": "SNOWFLAKE_PRIVATE_KEY_FILE"
},
{
"description": "Passphrase for encrypted private key",
"format": "string",
"isSecret": true,
"name": "SNOWFLAKE_PRIVATE_KEY_FILE_PWD"
},
{
"description": "OAuth 2.0 client ID (required for oauth_client_credentials authenticator)",
"format": "string",
"name": "SNOWFLAKE_OAUTH_CLIENT_ID"
},
{
"description": "OAuth 2.0 client secret (required for oauth_client_credentials authenticator)",
"format": "string",
"isSecret": true,
"name": "SNOWFLAKE_OAUTH_CLIENT_SECRET"
},
{
"description": "OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)",
"format": "string",
"name": "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL"
},
{
"description": "OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)",
"format": "string",
"name": "SNOWFLAKE_OAUTH_SCOPE"
},
{
"description": "Pre-fetched OAuth bearer token (required for oauth authenticator)",
"format": "string",
"isSecret": true,
"name": "SNOWFLAKE_TOKEN"
}
]
},
{
"registryType": "oci",
"identifier": "docker.io/nsphung/mcp-snowflake-server-nsp:0.14.1",
"runtimeHint": "docker",
"transport": {
"type": "stdio"
},
"runtimeArguments": [
{
"value": "--rm",
"type": "positional"
},
{
"value": "-i",
"type": "positional"
}
],
"packageArguments": [
{
"description": "Snowflake account identifier",
"type": "named",
"name": "--account"
},
{
"description": "Snowflake username",
"type": "named",
"name": "--user"
},
{
"description": "Password (not required for key-pair / SSO)",
"type": "named",
"name": "--password"
},
{
"description": "Virtual warehouse to use",
"type": "named",
"name": "--warehouse"
},
{
"description": "Default database",
"type": "named",
"name": "--database"
},
{
"description": "Default schema",
"type": "named",
"name": "--schema"
},
{
"description": "Role to assume",
"type": "named",
"name": "--role"
},
{
"description": "Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials",
"type": "named",
"name": "--authenticator"
},
{
"description": "Absolute path to .p8 private key file",
"type": "named",
"name": "--private_key_file"
},
{
"description": "Passphrase for encrypted private key",
"type": "named",
"name": "--private_key_file_pwd"
},
{
"description": "Path to TOML connections file",
"type": "named",
"name": "--connections-file"
},
{
"description": "Connection profile name in TOML file (required with --connections-file)",
"type": "named",
"name": "--connection-name"
},
{
"description": "Enable write_query and create_table tools",
"type": "named",
"name": "--allow_write"
},
{
"description": "Pre-load table schema as context://table/* resources (disables list_tables / describe_table)",
"type": "named",
"name": "--prefetch"
},
{
"description": "Space-separated list of tool names to disable",
"type": "named",
"name": "--exclude_tools"
},
{
"description": "Omit embedded JSON resources from responses (reduces context window usage)",
"type": "named",
"name": "--exclude-json-results"
},
{
"description": "Directory for log file output",
"type": "named",
"name": "--log_dir"
},
{
"description": "Log verbosity: DEBUG, INFO, WARNING, ERROR, CRITICAL",
"default": "INFO",
"choices": [
"DEBUG",
"INFO",
"WARNING",
"ERROR",
"CRITICAL"
],
"type": "named",
"name": "--log_level"
}
],
"environmentVariables": [
{
"description": "Snowflake account identifier",
"format": "string",
"name": "SNOWFLAKE_ACCOUNT"
},
{
"description": "Snowflake username",
"format": "string",
"name": "SNOWFLAKE_USER"
},
{
"description": "Password (not required for key-pair / SSO)",
"format": "string",
"isSecret": true,
"name": "SNOWFLAKE_PASSWORD"
},
{
"description": "Virtual warehouse to use",
"format": "string",
"name": "SNOWFLAKE_WAREHOUSE"
},
{
"description": "Default database",
"format": "string",
"name": "SNOWFLAKE_DATABASE"
},
{
"description": "Default schema",
"format": "string",
"name": "SNOWFLAKE_SCHEMA"
},
{
"description": "Role to assume",
"format": "string",
"name": "SNOWFLAKE_ROLE"
},
{
"description": "Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials",
"format": "string",
"name": "SNOWFLAKE_AUTHENTICATOR"
},
{
"description": "Absolute path to .p8 private key file",
"format": "string",
"name": "SNOWFLAKE_PRIVATE_KEY_FILE"
},
{
"description": "Passphrase for encrypted private key",
"format": "string",
"isSecret": true,
"name": "SNOWFLAKE_PRIVATE_KEY_FILE_PWD"
},
{
"description": "OAuth 2.0 client ID (required for oauth_client_credentials authenticator)",
"format": "string",
"name": "SNOWFLAKE_OAUTH_CLIENT_ID"
},
{
"description": "OAuth 2.0 client secret (required for oauth_client_credentials authenticator)",
"format": "string",
"isSecret": true,
"name": "SNOWFLAKE_OAUTH_CLIENT_SECRET"
},
{
"description": "OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)",
"format": "string",
"name": "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL"
},
{
"description": "OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)",
"format": "string",
"name": "SNOWFLAKE_OAUTH_SCOPE"
},
{
"description": "Pre-fetched OAuth bearer token (required for oauth authenticator)",
"format": "string",
"isSecret": true,
"name": "SNOWFLAKE_TOKEN"
}
]
}
]
}
mcp
model-context-protocol
pypi
oci
Comments
Sign in to leave a comment