Skip to content

Snowflake MCP Server for Zed

io.github.nsphung/mcp-snowflake-server

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

client:Zed transport:stdio runtime:pypi

Install Snowflake MCP Server in Zed

~/.config/zed/settings.json · windows: %APPDATA%\Zed\settings.json

Held in this page only — never stored, logged, or sent anywhere but back to your screen.

{
  "context_servers": {
    "mcp-snowflake-server": {
      "command": "uvx",
      "args": [
        "mcp-snowflake-server-nsp"
      ],
      "env": {
        "SNOWFLAKE_ACCOUNT": "<SNOWFLAKE_ACCOUNT>",
        "SNOWFLAKE_USER": "<SNOWFLAKE_USER>",
        "SNOWFLAKE_PASSWORD": "<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": "<SNOWFLAKE_PRIVATE_KEY_FILE_PWD>",
        "SNOWFLAKE_OAUTH_CLIENT_ID": "<SNOWFLAKE_OAUTH_CLIENT_ID>",
        "SNOWFLAKE_OAUTH_CLIENT_SECRET": "<SNOWFLAKE_OAUTH_CLIENT_SECRET>",
        "SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL": "<SNOWFLAKE_OAUTH_TOKEN_REQUEST_URL>",
        "SNOWFLAKE_OAUTH_SCOPE": "<SNOWFLAKE_OAUTH_SCOPE>",
        "SNOWFLAKE_TOKEN": "<SNOWFLAKE_TOKEN>"
      }
    }
  }
}

Merge this into your existing settings object — do not replace the file. Zed docs

Snowflake MCP Server in other clients