drio
Open app

Snowflake MCP Server

Source

Mirror of

Catalog onlyCatalog onlySTDIO

Overview

The Snowflake MCP Server is a Model Context Protocol (MCP) server implementation that facilitates database interaction with Snowflake, allowing users to run SQL queries and interact with a memo of data insights.

To use the Snowflake MCP Server, install it via Smithery and configure it in your Claude Desktop setup. You can execute SQL queries directly through the provided tools without needing to clone the repository.

  • Execute SELECT, INSERT, UPDATE, and DELETE SQL queries. - Create new tables in the database. - Continuously updated memo resource for data insights. - Tools for listing tables and describing table schemas.
  1. Running complex SQL queries against Snowflake databases.
  2. Managing database schemas and structures.
  3. Aggregating and analyzing data insights dynamically.

Add to your AI client

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

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

Claude Code

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

.mcp.json (project root)

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

VS Code (Copilot)

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

.vscode/mcp.json

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

Windsurf

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

~/.codeium/windsurf/mcp_config.json

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

Cline

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

Cline MCP Settings (via UI)

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

FAQ

Can I run any SQL query with this server?

Yes, you can run SELECT, INSERT, UPDATE, and DELETE queries as well as create tables.

Is there a way to see the current tables in my database?

Yes, you can use the `list_tables` tool to get a list of all tables in the database.

How do I add new insights to the memo?

You can use the `append_insight` tool to add new data insights, which will automatically update the memo resource.7:["$","div",null,{"className":"container mx-auto flex flex-col gap-4","children":["$L26","$L27",["$","$L28",null,{"currentProject":{"id":643,"uuid":"61e8a551-e8ff-49a8-b79d-f541702482c7","name":"isaacwasserman_mcp-snowflake-server","title":"Snowflake MCP Server","description":"Mirror of","avatar_url":"https://avatars.githubusercontent.com/u/192820360?v=4","created_at":"2024-12-30T03:25:04.097Z","updated_at":"2025-02-23T07:15:14.377Z","status":"created","author_name":"MCP-Mirror","author_avatar_url":"https://avatars.githubusercontent.com/u/192820360?v=4","tags":"mcp,snowflake,database,sql,data-insights","category":"research-and-data","is_featured":false,"sort":1,"url":"https://github.com/MCP-Mirror/isaacwasserman_mcp-snowflake-server","target":"_self","content":"$29","summary":"$2a","img_url":"https://camo.githubusercontent.com/1292ce1351de0b50e67f0abc68883b1650662cedb5f338eceb546731e494ec70/68747470733a2f2f736d6974686572792e61692f62616467652f6d63705f736e6f77666c616b655f736572766572","type":null,"metadata":null,"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"}]]}]

Research and data