# Simple Snowflake

> Use this tool when you need to access Snowflake data warehouses from behind corporate proxies, execute SQL queries, and manage database views with a simplified interface. It solves problems of complex setup requirements and proxy limitations, providing reliable data access for AI assistants, data analysis, and business intelligence tasks. The tool takes SQL queries and authentication details as inputs and outputs results in raw JSON or markdown format.

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

## Description

This Snowflake MCP server, developed by Yann Barraud, provides AI assistants with direct access to Snowflake data warehouses through a simplified interface designed to work behind corporate proxies where existing servers may fail. Built with Python using the snowflake-connector-python library and MCP framework, it offers essential tools for SQL query execution, warehouse and database listing, view management with detailed schema information, and both raw JSON and markdown-formatted result output. The implementation emphasizes reliability in corporate environments with proxy support, includes optional read-only mode configuration, and supports flexible authentication through environment variables, making it valuable for data analysis workflows, business intelligence tasks, and building AI assistants that need reliable access to Snowflake data without complex setup requirements.

## Trust

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

## Facts

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

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/yannbrrd-simple-snowflake)
- **Repository:** <https://github.com/yannbrrd/simple_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": "yannbrrd-simple-snowflake"
    }
  }
}
```

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