Snowflake Server

Local

API Integration

Integrate this MCP server into your applications.

Get your API Key

You'll need to login and generate a Smithery API key to connect to this server.

Installation

Install the Smithery and MCP SDKs using npm:

npm install @smithery/sdk @modelcontextprotocol/sdk

TypeScript SDK

Use Smithery's TypeScript SDK to connect to this MCP server:

typescript


import { StdioClientTransport } from "@modelcontextprotocol/sdk/client/stdio.js"

const transport = new StdioClientTransport({
  "command": "uvx",
  "args": [
    "mcp_snowflake_server"
  ],
  "env": {
    "SNOWFLAKE_WAREHOUSE": "your_warehouse",
    "SNOWFLAKE_DATABASE": "your_database",
    "SNOWFLAKE_ACCOUNT": "your_account_identifier",
    "SNOWFLAKE_USER": "your_username",
    "SNOWFLAKE_ROLE": "your_role",
    "SNOWFLAKE_SCHEMA": "your_schema",
    "SNOWFLAKE_PASSWORD": "your_password"
  }
})

// Create MCP client
import { Client } from "@modelcontextprotocol/sdk/client/index.js"

const client = new Client({
	name: "Test client",
	version: "1.0.0"
})
await client.connect(transport)

// Use the server tools with your LLM application
const tools = await client.listTools()
console.log(`Available tools: ${tools.map(t => t.name).join(", ")}`)

// Example: Call a tool
// const result = await client.callTool("tool_name", { param1: "value1" })

Configuration Schema

Full JSON Schema for server configuration:

json

{
  "type": "object",
  "required": [
    "snowflakeWarehouse",
    "snowflakeDatabase",
    "snowflakeAccount",
    "snowflakeUser",
    "snowflakeRole",
    "snowflakeSchema",
    "snowflakePassword"
  ],
  "properties": {
    "snowflakeRole": {
      "type": "string",
      "description": "The Snowflake role."
    },
    "snowflakeUser": {
      "type": "string",
      "description": "The Snowflake username."
    },
    "snowflakeSchema": {
      "type": "string",
      "description": "The Snowflake schema."
    },
    "snowflakeAccount": {
      "type": "string",
      "description": "The Snowflake account identifier."
    },
    "snowflakeDatabase": {
      "type": "string",
      "description": "The Snowflake database to use."
    },
    "snowflakePassword": {
      "type": "string",
      "description": "The Snowflake password."
    },
    "snowflakeWarehouse": {
      "type": "string",
      "description": "The Snowflake warehouse to connect to."
    }
  }
}