Description

This MCP server, developed by datawiz168, provides seamless integration with Snowflake databases. It implements a Python-based interface for executing SQL queries, retrieving results, and managing database connections through the Snowflake connector. The server exposes tools for running queries, fetching data, and interacting with Snowflake objects like tables and views. By leveraging Snowflake's powerful cloud data platform, this implementation enables AI assistants to easily incorporate large-scale data analysis and business intelligence capabilities. It is particularly useful for scenarios requiring real-time access to enterprise data warehouses, such as generating reports, performing ad-hoc analysis, or integrating Snowflake data into AI-powered applications.

Installation 

git clone https://github.com/datawiz168/mcp-snowflake-service

Claude Desktop Configuration

Add this configuration to your Claude Desktop config file to enable this MCP server:

Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json

Config file location: %APPDATA%\Claude\claude_desktop_config.json

Config file location: ~/.config/Claude/claude_desktop_config.json

claude_desktop_config.json 
{
  "mcpServers": {
    "snowflake": {
      "command": "node",
      "args": [
        "path/to/server.js"
      ]
    }
  }
}