Igloo MCP

A lightweight Snowflake MCP server that connects your AI assistant to Snowflake with built-in safety, caching, and auditing. Query databases, build catalogs, and create living reports—all through natural language.

Why Igloo MCP?

🔒 Query Safely

Block dangerous DDL/DML by default, auto-cancel slow queries, and log every execution. Use execute_query with configurable guardrails and test_connection to validate authentication before running queries.

⚡ Work Faster

Minimize token usage through progressive disclosure and smart result caching. Tools like get_report support multiple retrieval modes (summary/sections/insights/full), and search_catalog lets you find tables without hitting Snowflake.

📋 Stay Audited

Maintain complete query history with source attribution for compliance tracking. Every execute_query call logs to history, and Living Reports track all modifications with full audit trails via evolve_report.

📊 Build Living Reports

Create auditable, evolving business reports with create_report, modify them safely with evolve_report, attach charts to insights, and export to HTML/PDF/Markdown via render_report.

Quick Start

Prerequisites

# Install igloo-mcp
uv pip install igloo-mcp

# Configure Snowflake connection (uses Snowflake CLI)
snow connection add --connection-name quickstart --account <account> --user <user> --authenticator externalbrowser --warehouse <warehouse>

Cursor Setup

Add to ~/.cursor/mcp.json:

{
  "mcpServers": {
    "igloo-mcp": {
      "command": "igloo_mcp",
      "args": ["--profile", "quickstart"]
    }
  }
}

Restart Cursor and ask: "Preview the customers table"

Claude Code Setup

Run from terminal:

claude mcp add --scope user --transport stdio igloo-mcp -- igloo_mcp --profile quickstart

Or add to ~/.claude.json manually:

{
  "mcpServers": {
    "igloo-mcp": {
      "type": "stdio",
      "command": "igloo_mcp",
      "args": ["--profile", "quickstart"]
    }
  }
}

Restart Claude Code and ask: "Show me the schema for my database"

Note: The executable is igloo_mcp (underscore), not igloo-mcp (dash).

Full setup guide: docs/installation.md

Core Tools

🔍 Query & Explore

Tool	Description
`execute_query`	Run SQL with guardrails, timeouts, and auto-insights
`build_catalog`	Export Snowflake metadata for offline search
`search_catalog`	Find tables/columns without querying Snowflake
`build_dependency_graph`	Visualize table lineage and dependencies

📊 Living Reports

Tool	Description
`create_report`	Initialize auditable JSON-backed reports
`evolve_report`	Modify reports with LLM assistance and audit trail
`evolve_report_batch`	Perform multiple operations atomically
`render_report`	Export to HTML, PDF, or Markdown via Quarto
`get_report`	Read reports with progressive disclosure modes
`search_report`	Find reports by title or tags
`search_citations`	Search citations by source type or provider
`get_report_schema`	Discover valid structures and section templates at runtime
`validate_report`	Quality checks: citations, empty sections, stale content

🏥 Health & Diagnostics

Tool	Description
`test_connection`	Validate Snowflake authentication
`health_check`	Monitor server, profile, and catalog status

View all 16 tools: docs/api/TOOLS_INDEX.md

When to Use Igloo MCP

Choose Igloo MCP	Choose Snowflake Labs MCP
AI assistant for dev/analytics workflows	Production Cortex AI integration
Simple SnowCLI-based setup	Enterprise service architecture
Query safety + automatic caching	Full Snowflake object management
Built-in auditing and compliance	Container-based deployment

Resources

MIT Licensed | Built for agentic efficiency

Metadata

Release files for igloo-mcp 0.5.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for igloo-mcp 0.5.1
File	Size	Uploaded
igloo_mcp-0.5.1.tar.gz	241.0 kB	Mar 22, 2026	Details

Built distribution (wheel)

Table of built distributions (wheels) for igloo-mcp 0.5.1
File	Interpreter	ABI	Platform	Reset
igloo_mcp-0.5.1-py3-none-any.whl 285.5 kB Mar 22, 2026	Python 3	none	any	Details

Total release size: 526.5 kB

Release files / igloo_mcp-0.5.1.tar.gz

Download URL	igloo_mcp-0.5.1.tar.gz
Size	241.0 kB
Tags	Source
SHA-256 checksum How to use checksums	`6ca7db8a1159fce5c15f21429ef0d890e7fdcf707a4add4d72c333551a9acb66`
BLAKE2b-256 checksum How to use checksums	`f81d4643b4bb6fb1a28aac17810b828f6675d5f19844e99df1de22cc200969e1`
Upload date	Mar 22, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`uv/0.9.13 {"installer":{"name":"uv","version":"0.9.13"},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}`

Release files / igloo_mcp-0.5.1-py3-none-any.whl

Download URL	igloo_mcp-0.5.1-py3-none-any.whl
Size	285.5 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`a95aabe719605f5c11e57f2d5df485748d4625f6a4b2de92f3abfd1930a803e0`
BLAKE2b-256 checksum How to use checksums	`673440428660a51ed27c36443f2c5acaa53064894bbc497f24ce762dfdfda2b7`
Upload date	Mar 22, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`uv/0.9.13 {"installer":{"name":"uv","version":"0.9.13"},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}`