Back to Browse
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 RiskValid 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 identifier
Environment variable: SNOWFLAKE_ACCOUNT
Snowflake username
Environment variable: SNOWFLAKE_USER
Password (not required for key-pair / SSO)Required
Environment variable: SNOWFLAKE_PASSWORD
Virtual warehouse to use
Environment variable: SNOWFLAKE_WAREHOUSE
Default database
Environment variable: SNOWFLAKE_DATABASE
Default schema
Environment variable: SNOWFLAKE_SCHEMA
Role to assume
Environment variable: SNOWFLAKE_ROLE
Authentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials
Environment variable: SNOWFLAKE_AUTHENTICATOR
Absolute path to .p8 private key file
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)
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)
Environment variable: SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL
OAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)
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!
More Data & Analytics MCP Servers
Toleno
Freeby Toleno · Developer Tools
Toleno Network MCP Server — Manage your Toleno mining account with Claude AI using natural language.
137
Stars
503
Installs
8.0
Security
4.8
Local
mcp-creator-python
Freeby mcp-marketplace · Developer Tools
Create, build, and publish Python MCP servers to PyPI — conversationally.
-
Stars
68
Installs
10.0
Security
4.6
Local
MarkItDown
Freeby Microsoft · Content & Media
Convert files (PDF, Word, Excel, images, audio) to Markdown for LLM consumption
120.0K
Stars
24
Installs
6.0
Security
5.0
Local