Mcp Snowflake Service

MCP server implementation for Snowflake integration

Catalog onlyCatalog onlySTDIO

Overview

The MCP Server for Snowflake is an implementation of the Model Context Protocol (MCP) designed for interacting with Snowflake databases, allowing for efficient data operations.

To use the MCP Server, clone the repository, install the required dependencies, configure your Snowflake credentials in a .env file, and start the server to listen for client connections.

Seamless connection to Snowflake databases using MCP. - Simple setup with dependency installation and configuration. - Ability to handle multiple client connections.

Integrating Snowflake as a backend for data retrieval applications.
Building data pipelines that require real-time access to Snowflake data.
Enhancing data processing workflows in cloud-based architectures.

Add to your AI client

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

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

Claude Code

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

.mcp.json (project root)

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

VS Code (Copilot)

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

.vscode/mcp.json

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

Windsurf

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

~/.codeium/windsurf/mcp_config.json

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

Cline

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

Cline MCP Settings (via UI)

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

FAQ

What programming language is used?

The server is implemented in Python, relying on standard libraries and Snowflake's API.

Is the server open source?

Yes! The MCP Server for Snowflake is open source and available under the MIT License.

How do I configure my Snowflake credentials?

You can configure your Snowflake credentials by creating a `.env` file with the necessary details as outlined in the installation instructions.

Cloud platforms