mcp_server
Verified Safeby NitinTalluri
Overview
An MCP server that enables LLM models to query live Snowflake architecture data tables for application structure analysis, dependencies, and relationships.
Installation
python mcp_snowflake_server.pyEnvironment Variables
- AWS_ACCESS_KEY_ID
- AWS_SECRET_ACCESS_KEY
- AWS_REGION
- AWS_PROFILE
Security Notes
The server uses an external `common.sec` module for Snowflake credential management, which is a good practice, preventing hardcoded secrets. Table names in queries are validated against an allowed list, mitigating table enumeration. However, the `where_clause` parameter in `query_architecture_table` is directly inserted into the SQL string via f-string before being passed to `sqlalchemy.text()`. While `sqlalchemy.text()` usually helps with parameterized queries, direct f-string interpolation of a user-provided `where_clause` can introduce a SQL injection vulnerability if the input is not sanitized by the LLM or the calling framework.
Similar Servers
fastmcp
FastMCP is an ergonomic interface for the Model Context Protocol (MCP), providing a comprehensive framework for building and interacting with AI agents, tools, resources, and prompts across various transports and authentication methods.
mcp-interviewer
A Python CLI tool to evaluate Model Context Protocol (MCP) servers for agentic use-cases, by inspecting capabilities, running functional tests, and providing LLM-as-a-judge evaluations.
MCP-PostgreSQL-Ops
The MCP server provides professional operations, monitoring, and management capabilities for PostgreSQL databases using natural language queries.
zeromcp
A minimal, pure Python Model Context Protocol (MCP) server for exposing tools, resources, and prompts via HTTP/SSE and Stdio transports.