# Snowflake

> Use this tool when you need to securely access and query Snowflake databases using SQL, with features like robust connection management and authentication. It solves problems of manual query execution and context switching, ideal for data analysis, reporting, and exploration workflows. The tool takes SQL queries as input and outputs query results, making it suitable for AI assistants interacting with Snowflake data warehouses.

Canonical page: https://skillsregistry.net/skills/davidamom-snowflake  
JSON: https://api.skillsregistry.net/v1/skills/davidamom-snowflake

## Description

Snowflake MCP Server provides secure access to Snowflake databases for any MCP-compatible client, enabling SQL query execution with robust connection management. Built by David Amom, it handles database connection lifecycle (connect, reconnect on timeout, close), supports both password and key pair authentication methods, and processes query results safely. The implementation is particularly valuable for AI assistants that need to interact with Snowflake data warehouses without requiring users to switch contexts or manually execute queries, making it ideal for data analysis, reporting, and exploration workflows.

## Trust

- **Trust score (0–1):** 0.63
- **Verification tier:** scanned
- **Last scanned:** 2026-09-02

## Facts

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

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/davidamom-snowflake)
- **Repository:** <https://github.com/davidamom/snowflake-mcp>

## 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": "davidamom-snowflake"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/davidamom-snowflake` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/davidamom-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