Back to Browse

Snowflake Server MCP Server

Data & AnalyticsLow Risk10.0MCP RegistryLocal
Free

Server data from the Official MCP Registry

A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants

About

A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants

Security Report

10.0
Low Risk10.0Low Risk

Valid MCP server (2 strong, 1 medium validity signals). No known CVEs in dependencies. Package registry verified. Imported from the Official MCP Registry.

4 files analyzed · 1 issue found

Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.

What You'll Need

Set these up before or after installing:

Snowflake account identifierOptional

Environment variable: SNOWFLAKE_ACCOUNT

Snowflake usernameOptional

Environment variable: SNOWFLAKE_USER

Password (not required for key-pair / SSO)Required

Environment variable: SNOWFLAKE_PASSWORD

Virtual warehouse to useOptional

Environment variable: SNOWFLAKE_WAREHOUSE

Default databaseOptional

Environment variable: SNOWFLAKE_DATABASE

Default schemaOptional

Environment variable: SNOWFLAKE_SCHEMA

Role to assumeOptional

Environment variable: SNOWFLAKE_ROLE

Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentialsOptional

Environment variable: SNOWFLAKE_AUTHENTICATOR

Absolute path to .p8 private key fileOptional

Environment variable: SNOWFLAKE_PRIVATE_KEY_FILE

Passphrase for encrypted private keyRequired

Environment variable: SNOWFLAKE_PRIVATE_KEY_FILE_PWD

OAuth 2.0 client ID (required for oauth_client_credentials authenticator)Optional

Environment variable: SNOWFLAKE_OAUTH_CLIENT_ID

OAuth 2.0 client secret (required for oauth_client_credentials authenticator)Required

Environment variable: SNOWFLAKE_OAUTH_CLIENT_SECRET

OAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)Optional

Environment variable: SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL

OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)Optional

Environment variable: SNOWFLAKE_OAUTH_SCOPE

Pre-fetched OAuth bearer token (required for oauth authenticator)Required

Environment variable: SNOWFLAKE_TOKEN

How to Install

Add this to your MCP configuration file:

{
  "mcpServers": {
    "io-github-nsphung-mcp-snowflake-server": {
      "env": {
        "SNOWFLAKE_ROLE": "your-snowflake-role-here",
        "SNOWFLAKE_USER": "your-snowflake-user-here",
        "SNOWFLAKE_TOKEN": "your-snowflake-token-here",
        "SNOWFLAKE_SCHEMA": "your-snowflake-schema-here",
        "SNOWFLAKE_ACCOUNT": "your-snowflake-account-here",
        "SNOWFLAKE_DATABASE": "your-snowflake-database-here",
        "SNOWFLAKE_PASSWORD": "your-snowflake-password-here",
        "SNOWFLAKE_WAREHOUSE": "your-snowflake-warehouse-here",
        "SNOWFLAKE_OAUTH_SCOPE": "your-snowflake-oauth-scope-here",
        "SNOWFLAKE_AUTHENTICATOR": "your-snowflake-authenticator-here",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "your-snowflake-oauth-client-id-here",
        "SNOWFLAKE_PRIVATE_KEY_FILE": "your-snowflake-private-key-file-here",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "your-snowflake-oauth-client-secret-here",
        "SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "your-snowflake-private-key-file-pwd-here",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "your-snowflake-oauth-token-request-url-here"
      },
      "args": [
        "--rm",
        "-i",
        "mcp-snowflake-server-nsp"
      ],
      "command": "uvx"
    }
  }
}

Reviews

No reviews yet

Be the first to review this server!

Snowflake Server MCP Server - A Snowflake MCP server — SQL queries, schema exploration, | MCP Marketplace