drio
Open app

Snowflake MCP Server for Windsurf

Source

Model Context Protocol (MCP) Server for Snowflake, tailored for Windsurf

Catalog onlyCatalog onlySTDIO

Overview

Snowflake MCP Server for Windsurf is a Model Context Protocol (MCP) Server implementation that facilitates database interaction with Snowflake, specifically designed for Windsurf applications.

To use the Snowflake MCP Server, clone the repository, install the necessary dependencies, configure your Snowflake connection in the .env file, and start the server using npm.

  • Stdio Transport: Implements the required transport mechanism for Windsurf. - Keypair Authentication: Supports secure connection to Snowflake using private key authentication. - Metadata Exposure: Provides comprehensive metadata for generating SQL & Python in Windsurf. - Query Execution: Enables running SQL queries on Snowflake and returning structured results. - Insights Memo: Maintains a memo of data insights discovered during analysis.
  1. Executing SQL queries to retrieve data from Snowflake databases.
  2. Managing database schemas and tables in Snowflake.
  3. Analyzing data insights and maintaining a memo of findings.

Add to your AI client

Use these steps to connect Snowflake MCP Server for Windsurf in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "snowflake-mcp-server-matt-atadata": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-snowflake-mcp-server-matt-atadata"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "snowflake-mcp-server-matt-atadata": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-snowflake-mcp-server-matt-atadata"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "snowflake-mcp-server-matt-atadata": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-snowflake-mcp-server-matt-atadata"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "snowflake-mcp-server-matt-atadata": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-snowflake-mcp-server-matt-atadata"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "snowflake-mcp-server-matt-atadata": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-snowflake-mcp-server-matt-atadata"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "snowflake-mcp-server-matt-atadata": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-snowflake-mcp-server-matt-atadata"
      ]
    }
  }
}

FAQ

**What is the purpose of the Snowflake MCP Server?**

It provides a structured way to interact with Snowflake databases for Windsurf applications.

**How do I install the Snowflake MCP Server?**

Clone the repository, install dependencies, configure your Snowflake connection, and start the server.

**Can I test the server?**

Yes, you can test the server using the MCP Inspector.7:["$","div",null,{"className":"container mx-auto flex flex-col gap-4","children":["$L26","$L27",["$","$L28",null,{"currentProject":{"id":2212,"uuid":"438c7260-c9b6-42a4-98e5-93efbdb1aa62","name":"snowflake-mcp-server","title":"Snowflake MCP Server for Windsurf","description":"Model Context Protocol (MCP) Server for Snowflake, tailored for Windsurf","avatar_url":"https://avatars.githubusercontent.com/u/1971581?v=4","created_at":"$D2025-03-09T04:10:26.171Z","updated_at":"$D2025-03-12T10:20:34.143Z","status":"created","author_name":"matt-atadata","author_avatar_url":"https://avatars.githubusercontent.com/u/1971581?v=4","tags":"[]","category":"developer-tools","is_featured":false,"sort":1,"url":"https://github.com/matt-atadata/snowflake-mcp-server","target":"_self","content":"$29","summary":"$2a","img_url":null,"type":null,"metadata":"{\"star\":\"0\",\"license\":\"\",\"language\":\"JavaScript\",\"is_official\":false,\"latest_commit_time\":\"2025-03-09 09:34:03\"}","user_uuid":null,"tools":null,"sse_url":null,"sse_provider":null,"sse_params":null,"is_official":false,"server_command":null,"server_params":null,"server_config":null,"allow_call":false,"is_innovation":false,"is_dxt":false,"dxt_manifest":null,"dxt_file_url":null,"is_audit":false},"randomProjects":[],"currentServerKey":"$undefined"}]]}]

Developer tools