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 a Python framework for building and interacting with Model Context Protocol (MCP) servers. It provides client and server capabilities, enabling the creation of AI agents and services through definable tools, resources, and prompts. It supports various transports, authentication methods, logging, and background task execution, with strong integration for OpenAPI specifications.
mcp-interviewer
A Python CLI tool designed to evaluate, test, and generate reports on Model Context Protocol (MCP) servers to ensure compatibility and quality for LLM agent use cases.
MCP-PostgreSQL-Ops
This MCP server provides comprehensive PostgreSQL database operations, monitoring, and management through 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.