Snowflake MCP Server
A Snowflake MCP server — SQL queries, schema exploration, and data insights for AI assistants
{
"mcpServers": {
"mcp-snowflake-server": {
"command": "uvx",
"args": [
"mcp-snowflake-server-nsp"
],
"env": {
"SNOWFLAKE_ACCOUNT": "<snowflake_account>",
"SNOWFLAKE_USER": "<snowflake_user>",
"SNOWFLAKE_PASSWORD": "<your-snowflake_password>",
"SNOWFLAKE_WAREHOUSE": "<snowflake_warehouse>",
"SNOWFLAKE_DATABASE": "<snowflake_database>",
"SNOWFLAKE_SCHEMA": "<snowflake_schema>",
"SNOWFLAKE_ROLE": "<snowflake_role>",
"SNOWFLAKE_AUTHENTICATOR": "<snowflake_authenticator>",
"SNOWFLAKE_PRIVATE_KEY_FILE": "<snowflake_private_key_file>",
"SNOWFLAKE_PRIVATE_KEY_FILE_PWD": "<your-snowflake_private_key_file_pwd>",
"SNOWFLAKE_OAUTH_CLIENT_ID": "<snowflake_oauth_client_id>",
"SNOWFLAKE_OAUTH_CLIENT_SECRET": "<your-snowflake_oauth_client_secret>",
"SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<snowflake_oauth_token_request_url>",
"SNOWFLAKE_OAUTH_SCOPE": "<snowflake_oauth_scope>",
"SNOWFLAKE_TOKEN": "<your-snowflake_token>"
}
}
}
}SNOWFLAKE_ACCOUNTSnowflake account identifier
SNOWFLAKE_USERSnowflake username
SNOWFLAKE_PASSWORDPassword (not required for key-pair / SSO)
SNOWFLAKE_WAREHOUSEVirtual warehouse to use
SNOWFLAKE_DATABASEDefault database
SNOWFLAKE_SCHEMADefault schema
SNOWFLAKE_ROLERole to assume
SNOWFLAKE_AUTHENTICATORAuthentication method. Defaults to 'snowflake' if not set. Valid values: snowflake, externalbrowser, snowflake_jwt, oauth, oauth_client_credentials
SNOWFLAKE_PRIVATE_KEY_FILEAbsolute path to .p8 private key file
SNOWFLAKE_PRIVATE_KEY_FILE_PWDPassphrase for encrypted private key
SNOWFLAKE_OAUTH_CLIENT_IDOAuth 2.0 client ID (required for oauth_client_credentials authenticator)
SNOWFLAKE_OAUTH_CLIENT_SECRETOAuth 2.0 client secret (required for oauth_client_credentials authenticator)
SNOWFLAKE_OAUTH_TOKEN_REQUEST_URLOAuth 2.0 token endpoint URL (required for oauth_client_credentials authenticator)
SNOWFLAKE_OAUTH_SCOPEOAuth 2.0 scope (optional, e.g. session:role:MY_ROLE)
SNOWFLAKE_TOKENPre-fetched OAuth bearer token (required for oauth authenticator)
Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite
Manage Supabase projects end to end across database, auth, storage, realtime, and migrations. Moni…
Explore your Messages SQLite database to browse tables and inspect schemas with ease. Run flexible…