igloo-mcp
Verified Safeby Evan-Kim2028
Overview
AI-first operations and analytics for Snowflake via Model Context Protocol (MCP), including SQL query execution, metadata cataloging, dependency graph building, and managing 'living reports' with AI assistance.
Installation
uv run mcp-serverEnvironment Variables
- SNOWFLAKE_PROFILE
- IGLOO_MCP_QUERY_HISTORY
- IGLOO_MCP_ARTIFACT_ROOT
- IGLOO_MCP_CACHE_MODE
- IGLOO_MCP_CACHE_ROOT
- IGLOO_MCP_LOG_SCOPE
- IGLOO_MCP_NAMESPACED_LOGS
- IGLOO_MCP_REPORTS_ROOT
- IGLOO_MCP_CATALOG_ROOT
- IGLOO_MCP_DEBUG
- SNOWFLAKE_DEFAULT_CONNECTION_NAME
- SNOWCLI_MCP_TRANSPORT
- SNOWCLI_MCP_ENDPOINT
- SNOWCLI_MCP_LOG_LEVEL
- SNOWFLAKE_REST_ACCOUNT
- SNOWFLAKE_REST_USER
- SNOWFLAKE_REST_PRIVATE_KEY
- SNOWFLAKE_REST_WAREHOUSE
- SNOWFLAKE_REST_DATABASE
- SNOWFLAKE_REST_SCHEMA
- SNOWFLAKE_REST_ROLE
- SNOWFLAKE_REST_HOST
- IGLOO_MCP_MAX_QUERY_TIMEOUT_SECONDS
- IGLOO_MCP_SQL_PERMISSIONS
Security Notes
The server implements robust security measures including: comprehensive SQL validation to prevent dangerous operations (e.g., DELETE, DROP) with customizable allow/disallow lists; stringent path validation to prevent directory traversal attacks; and careful escaping of SQL identifiers and session parameters to mitigate SQL injection risks. It also performs early validation of Snowflake profiles. While relying on an external `snow` CLI means its security posture is also relevant, the project demonstrates a strong focus on secure coding practices.
Similar Servers
cupertino
Cupertino is an Apple Documentation Crawler & MCP Server that provides accurate, up-to-date Apple API documentation and sample code to AI agents and developers for offline and AI-assisted development.
mcp-server-computer
This server acts as a Spring AI MCP Server component to provide cross-platform computer configuration information (OS, user, Java, and platform-specific details) to an AI agent.
meds-mcp
A Medical Context Protocol (MCP) server for retrieving and analyzing de-identified patient EHR data, facilitating LLM-powered chat interaction and evidence review with medical ontologies and faceted search.
dotbox-mcp
An MCP server that enables LLMs to execute .NET workloads in isolated Docker containers for C# code execution, project management, and web API hosting.