A Model Context Protocol (MCP) server for performing read-only operations against Snowflake databases. This tool enables Claude to securely query Snowflake data without modifying any information.
Features
Flexible authentication to Snowflake using either:
MCP Server for connecting to Snowflake with read-only questions
Estrelas
14
Ferramentas
—
Disponibilidade
—
Service account authentication with private key
External browser authentication for interactive sessions
Connection pooling with automatic background refresh to maintain persistent connections
Support for querying multiple views and databases in a single session
Support for multiple SQL statement types (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH)
MCP-compatible handlers for querying Snowflake data
Read-only operations with security checks to prevent data modification
Support for Python 3.12+
Stdio-based MCP server for easy integration with Claude Desktop
Available Tools
The server provides the following tools for querying Snowflake:
list_databases: List all accessible Snowflake databases
list_views: List all views in a specified database and schema
describe_view: Get detailed information about a specific view including columns and SQL definition
query_view: Query data from a view with an optional row limit
execute_query: Execute custom read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN, WITH) with results formatted as markdown tables
Installation
Prerequisites
Python 3.12 or higher
A Snowflake account with either:
A configured service account (username + private key), or
A regular user account for browser-based authentication
Ainda não há lista de ferramentas. Servidores remotos recebem uma após a primeira verificação de saúde.
Perguntas frequentes
Perguntas
Como instalo Snowflake?
Copie nesta página a configuração stdio para Cursor, Claude Desktop, Claude Code ou VS Code. Ela usa a instalação do publicador, não um proxy do PlugMCP.
Snowflake precisa de uma chave de API?
Este registro não lista nenhuma variável de ambiente obrigatória.
Qual transporte Snowflake usa?
Snowflake roda localmente via stdio.
Quando Snowflake foi verificado pela última vez?
Última verificação: 2026-10-28. MCP Server for connecting to Snowflake with read-only questions