# snowflake-mcp

> Use this tool when you need to integrate large language models (LLMs) with Snowflake databases, enabling direct queries and interactions to support data analysis and exploration. It solves problems related to data accessibility and manipulation, allowing for SELECT queries, schema discovery, and table operations. This tool is ideal for use cases requiring seamless communication between LLMs and Snowflake databases, facilitating efficient data-driven decision-making.

Canonical page: https://skillsregistry.net/skills/patrickfreyer-mcp-server-snowflake  
JSON: https://api.skillsregistry.net/v1/skills/patrickfreyer-mcp-server-snowflake

## Description

Enables LLMs to directly query and interact with Snowflake databases, supporting SELECT queries, schema exploration, and table operations.

## Trust

- **Trust score (0–1):** 0.68
- **Verification tier:** scanned
- **Last scanned:** 2026-08-31

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-08-31

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/dl6o11pu41)
- **Repository:** <https://github.com/patrickfreyer/mcp-server-snowflake>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "patrickfreyer-mcp-server-snowflake"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/patrickfreyer-mcp-server-snowflake` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/patrickfreyer-mcp-server-snowflake/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt