# mcp-snowflake-server

> MCP Server

This repository provides a Model Context Protocol (MCP) server for interacting with Snowflake databases, offering tools for querying, schema exploration, and appending data insights to a dynamic memo resource.

## Overview

- **Category:** Database
- **Language:** Python
- **Stars:** 185
- **Forks:** 6
- **Owner:** isaacwasserman
- **GitHub:** https://github.com/isaacwasserman/mcp-snowflake-server
- **Created:** 2024-12-13T20:30:59+00:00
- **Updated:** 2025-03-28T01:56:59+00:00
- **Source:** https://model-context-protocol.com/servers/mcp-snowflake-database-query-insights-server

## Setup

## Setup

To install Snowflake Server for Claude Desktop automatically via [Smithery](https://smithery.ai/server/mcp_snowflake_server):

```bash
npx -y @smithery/cli install mcp_snowflake_server --client claude
```

To install via UVX, add the server to your `claude_desktop_config.json`:

```json
"mcpServers": {
  "snowflake_pip": {
      "command": "uvx",
      "args": [
          "mcp_snowflake_server",
          "--account",
          "the_account",
          "--warehouse",
          "the_warehouse",
          "--user",
          "the_user",
          "--password",
          "their_password",
          "--role",
          "the_role"
          "--database",
          "the_database",
          "--schema",
          "the_schema",
          # Optionally: "--allow_write" (but not recommended)
          # Optionally: "--log_dir", "/absolute/path/to/logs"
          # Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
          # Optionally: "--exclude_tools", "{tool name}", ["{other tool name}"]
      ]
  }
}
```

To install locally, add the server to your `claude_desktop_config.json`:

```json
"mcpServers": {
  "snowflake_local": {
      "command": "uv",
      "args": [
          "--directory",
          "/absolute/path/to/mcp_snowflake_server",
          "run",
          "mcp_snowflake_server",
          "--account",
          "the_account",
          "--warehouse",
          "the_warehouse",
          "--user",
          "the_user",
          "--password",
          "their_password",
          "--role",
          "the_role"
          "--database",
          "the_database",
          "--schema",
          "the_schema",
          # Optionally: "--allow_write" (but not recommended)
          # Optionally: "--log_dir", "/absolute/path/to/logs"
          # Optionally: "--log_level", "DEBUG"/"INFO"/"WARNING"/"ERROR"/"CRITICAL"
          # Optionally: "--exclude_tools", "{tool name}", ["{other tool name}"]
      ]
  }
}
```

## Tools

## Available Tools

1.  `read_query` (Execute SELECT queries to read data from the database.)
2.  `write_query` (Execute INSERT, UPDATE, or DELETE queries.)
3.  `create_table` (Create new tables in the database.)
4.  `list_tables` (Get a list of all tables in the database.)
5.  `describe-table` (View column information for a specific table.)
6.  `append_insight` (Add new data insights to the memo resource.)