Snowflake Database Connector MCP Server

Overview

The Snowflake Database Connector allows Claude to interact directly with your Snowflake data warehouse. It provides tools for executing SQL queries, exploring database schemas, and analyzing data.

Installation Options

Option 1: Install via Smithery (Recommended)

The easiest way to install is through Smithery:

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

Option 2: Install via UVX

Add the following configuration to your Claude Desktop config file:

"mcpServers": {
  "snowflake_pip": {
    "command": "uvx",
    "args": [
      "--python=3.12",
      "mcp_snowflake_server",
      "--account", "your_account",
      "--warehouse", "your_warehouse",
      "--user", "your_user",
      "--password", "your_password",
      "--role", "your_role",
      "--database", "your_database",
      "--schema", "your_schema"
    ]
  }
}

Option 3: Manual Installation

1. Install the UV package manager:

   curl -LsSf https://astral.sh/uv/install.sh | sh
   

2. Create a .env file with your Snowflake credentials:

   SNOWFLAKE_USER="your_email@example.com"
   SNOWFLAKE_ACCOUNT="your_account"
   SNOWFLAKE_ROLE="your_role"
   SNOWFLAKE_DATABASE="your_database"
   SNOWFLAKE_SCHEMA="your_schema"
   SNOWFLAKE_WAREHOUSE="your_warehouse"
   SNOWFLAKE_PASSWORD="your_password"
   

3. Add the server to your Claude Desktop configuration:

   "mcpServers": {
     "snowflake_local": {
       "command": "/path/to/uv",
       "args": [
         "--python=3.12",
         "--directory", "/path/to/mcp_snowflake_server",
         "run", "mcp_snowflake_server"
       ]
     }
   }
   

Configuration Options

The server supports several configuration options:

• --allow-write: Enable write operations (disabled by default for safety)
• --log_dir: Specify a directory for logs
• --log_level: Set logging level (DEBUG/INFO/WARNING/ERROR/CRITICAL)
• --exclude_tools: Disable specific tools

You can also customize database/schema/table exclusion patterns by modifying the runtime_config.json file.

Usage Examples

Once installed, you can ask Claude to:

1. Query your Snowflake database: "Show me the top 10 customers by revenue from our sales database"

2. Explore database schema: "What tables are available in the marketing schema?"

3. Analyze data and collect insights: "Analyze the customer_orders table and tell me about any interesting patterns"

4. Create new tables (if write access enabled): "Create a new table to store customer feedback data"

Security Notes

• By default, write operations are disabled for safety. Enable them only when needed.
• Consider using role-based access control in Snowflake to limit the permissions of the account used.
• Sensitive credentials should be stored securely and not shared in prompts.
• The server supports external browser authentication as an alternative to password-based login.