Local-Snowflake-MCP-Server
by asingh49-cmd
Overview
Enables Claude Desktop to interact with a Snowflake database using natural-language SQL via a local Model Context Protocol (MCP) server.
Installation
python server/snowflake_mcp_server.pyEnvironment Variables
- SF_ACCOUNT
- SF_USER
- SF_PASSWORD
- SF_WH
- SF_DB
- SF_SCHEMA
Security Notes
The `run_sql` tool directly executes the `query` string received from the LLM without any sanitization or validation. This poses a significant SQL injection vulnerability if an adversarial user can prompt the LLM to generate malicious SQL, potentially leading to unauthorized data access, modification, or deletion. No other obvious 'eval' or malicious patterns were found, and credentials are handled via environment variables, but the direct SQL execution is a critical flaw.
Similar Servers
mcp-node
Enables natural language interaction with Algolia data through Claude Desktop by exposing Algolia APIs via the Model Context Protocol (MCP).
consult-llm-mcp
An MCP server that allows AI agents like Claude Code to consult stronger, more capable AI models (e.g., GPT-5.2, Gemini 3.0 Pro) for complex code analysis, debugging, and architectural advice.
aws-sa-tools-mcp-server
A Model Context Protocol (MCP) server that provides tools to interact with AWS services and an optional vector store for document search, primarily designed for integration with Claude Desktop.
waldur-mcp-server
Integrates Waldur instances with Claude Desktop via Model Context Protocol for API access and management.