Snowflake MCP Service

MCP server implementation for Snowflake integration

Catalog onlyCatalog onlySTDIO

Overview

Snowflake MCP Service is a Model Context Protocol (MCP) server that provides seamless access to Snowflake databases for any MCP-compatible client.

To use the Snowflake MCP Service, clone the repository, install the dependencies, configure the MCP client, and set up the Snowflake connection parameters. The server will start automatically when configured with your MCP client.

Execute SQL queries on Snowflake databases - Automatic handling of database connection lifecycle (connect, reconnect on timeout, close) - Robust error handling and reporting - Flexible authentication options (password or key pair) - Compatible with any MCP-compliant client

Integrating Snowflake databases with various applications using MCP protocol.
Automating database operations and queries in data analysis workflows.
Providing secure access to Snowflake databases for multiple clients.

Add to your AI client

Use these steps to connect Snowflake MCP Service 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-davidamom": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-snowflake-mcp-davidamom"
      ]
    }
  }
}

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-davidamom": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-snowflake-mcp-davidamom"
      ]
    }
  }
}

Claude Code

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

.mcp.json (project root)

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

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-davidamom": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-snowflake-mcp-davidamom"
      ]
    }
  }
}

Windsurf

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

~/.codeium/windsurf/mcp_config.json

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

Cline

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

Cline MCP Settings (via UI)

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

FAQ

What is the Model Context Protocol (MCP)?

MCP is a protocol that allows clients to interact with various data sources in a standardized way.

How do I configure authentication?

You can configure either password or key pair authentication in the .env file.

Is there a manual startup required for the server?

No, the server starts automatically when configured with your MCP client.

Developer tools