Snowflake MCP Server for VS Code
io.github.nsphung/mcp-snowflake-server
A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants
client:VS Code
transport:stdio
runtime:pypi
Install Snowflake MCP Server in VS Code
.vscode/mcp.json
{
"inputs": [
{
"type": "promptString",
"id": "snowflake-account",
"description": "SNOWFLAKE_ACCOUNT",
"password": true
},
{
"type": "promptString",
"id": "snowflake-user",
"description": "SNOWFLAKE_USER",
"password": true
},
{
"type": "promptString",
"id": "snowflake-password",
"description": "SNOWFLAKE_PASSWORD",
"password": true
},
{
"type": "promptString",
"id": "snowflake-warehouse",
"description": "SNOWFLAKE_WAREHOUSE",
"password": true
},
{
"type": "promptString",
"id": "snowflake-database",
"description": "SNOWFLAKE_DATABASE",
"password": true
},
{
"type": "promptString",
"id": "snowflake-schema",
"description": "SNOWFLAKE_SCHEMA",
"password": true
},
{
"type": "promptString",
"id": "snowflake-role",
"description": "SNOWFLAKE_ROLE",
"password": true
},
{
"type": "promptString",
"id": "snowflake-authenticator",
"description": "SNOWFLAKE_AUTHENTICATOR",
"password": true
},
{
"type": "promptString",
"id": "snowflake-private-key-file",
"description": "SNOWFLAKE_PRIVATE_KEY_FILE",
"password": true
},
{
"type": "promptString",
"id": "snowflake-private-key-file-pwd",
"description": "SNOWFLAKE_PRIVATE_KEY_FILE_PWD",
"password": true
},
{
"type": "promptString",
"id": "snowflake-oauth-client-id",
"description": "SNOWFLAKE_OAUTH_CLIENT_ID",
"password": true
},
{
"type": "promptString",
"id": "snowflake-oauth-client-secret",
"description": "SNOWFLAKE_OAUTH_CLIENT_SECRET",
"password": true
},
{
"type": "promptString",
"id": "snowflake-oauth-token-request-url",
"description": "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL",
"password": true
},
{
"type": "promptString",
"id": "snowflake-oauth-scope",
"description": "SNOWFLAKE_OAUTH_SCOPE",
"password": true
},
{
"type": "promptString",
"id": "snowflake-token",
"description": "SNOWFLAKE_TOKEN",
"password": true
}
],
"servers": {
"mcp-snowflake-server": {
"type": "stdio",
"command": "uvx",
"args": [
"mcp-snowflake-server-nsp"
],
"env": {
"SNOWFLAKE_ACCOUNT": "${input:snowflake-account}",
"SNOWFLAKE_USER": "${input:snowflake-user}",
"SNOWFLAKE_PASSWORD": "${input:snowflake-password}",
"SNOWFLAKE_WAREHOUSE": "${input:snowflake-warehouse}",
"SNOWFLAKE_DATABASE": "${input:snowflake-database}",
"SNOWFLAKE_SCHEMA": "${input:snowflake-schema}",
"SNOWFLAKE_ROLE": "${input:snowflake-role}",
"SNOWFLAKE_AUTHENTICATOR": "${input:snowflake-authenticator}",
"SNOWFLAKE_PRIVATE_KEY_FILE": "${input:snowflake-private-key-file}",
"SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "${input:snowflake-private-key-file-pwd}",
"SNOWFLAKE_OAUTH_CLIENT_ID": "${input:snowflake-oauth-client-id}",
"SNOWFLAKE_OAUTH_CLIENT_SECRET": "${input:snowflake-oauth-client-secret}",
"SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "${input:snowflake-oauth-token-request-url}",
"SNOWFLAKE_OAUTH_SCOPE": "${input:snowflake-oauth-scope}",
"SNOWFLAKE_TOKEN": "${input:snowflake-token}"
}
}
}
}
VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs