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.

Related MCP server: Snowflake Cortex AI MCP Server

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

📊 Living Reports

🏥 Health & Diagnostics

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

When to Use Igloo MCP

Resources

• 📖 Getting Started Guide

• 🔧 API Reference

• 📊 Living Reports User Guide

• 💡 Examples

• 📝 Changelog

• 💬 Discussions

MIT Licensed | Built for agentic efficiency