snowflake-mcp-server
Verified Safeby mikdanjey
Overview
The Snowflake MCP Server acts as a bridge, enabling LLM agents to securely connect to and execute SQL queries against Snowflake databases using the Model Context Protocol (MCP).
Installation
npx -y snowflake-mcp-serverEnvironment Variables
- SNOWFLAKE_ACCOUNT
- SNOWFLAKE_USER
- SNOWFLAKE_DATABASE
- SNOWFLAKE_SCHEMA
- SNOWFLAKE_WAREHOUSE
- SNOWFLAKE_ROLE
- SNOWFLAKE_AUTHENTICATOR
- SNOWFLAKE_PASSWORD
- LOG_LEVEL
Security Notes
The server demonstrates strong security practices: comprehensive SQL validation with Zod schemas and custom pattern matching to prevent SQL injection, secure handling of credentials via environment variables and redaction in logs, and communication primarily over STDIO for its core MCP function, reducing direct network attack surface. Dependencies are standard and well-vetted.
Similar Servers
dbt-mcp
Provides a Model Context Protocol (MCP) server that exposes various dbt-related functionalities (CLI, Semantic Layer, Discovery, Admin API, Code Generation, LSP) as tools for AI agents to interact with dbt projects in Core, Fusion, and Platform environments.
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
sfguide-getting-started-with-snowflake-mcp-server
Enables organizations to leverage AI agents for secure, natural language querying and activation of vast financial services data within Snowflake to derive insights and actions.
dx-mcp-server
Empowers AI applications to interact with and query a user-provided Postgres database via the Model Context Protocol (MCP).