1. Conduid
  2. Data
  3. Igloo MCP
MCP server · Data

Igloo MCP

by · github.com/Evan-Kim2028/igloo-mcp

Igloo MCP - Snowflake MCP Server for agentic querying

Unclaimed MIT last commit 6 months ago data
InstallView source
56Fair

Scored 3 months ago · breakdown

About Igloo MCP

Igloo MCP is an MCP server published by Evan-Kim2028 in the Data category: igloo MCP - Snowflake MCP Server for agentic querying. It has been installed 0 times through Conduid.

The repository has 1 stars and 1 forks, with the last commit 6 months ago. Six months or more without a commit doesn't mean the server is broken, but check the open issues (0) before depending on it in production.

Install

Install
npx igloo-mcp

This server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.

Ask AI

✦

Ask AI about Igloo MCP

Powered by Claude · Grounded in docs

I know everything about Igloo MCP. Ask me about installation, configuration, usage, or troubleshooting.

Security checks

  • ·README presentNot checked yet.
  • ·License declaredNot checked yet.
  • ·Tests presentNot checked yet.
  • ·Dependencies pinnedNot checked yet.
  • ·No dynamic code executionNot checked yet.
  • !Scoped permissionsDoesn't declare a permission scope. Assume it can do anything its process can.

README

Igloo MCP

PyPI version GitHub Release

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

README mirrored from the source repository 3 months ago. The original is authoritative.

Questions

About Igloo MCP

How do I install Igloo MCP?

Run npx igloo-mcp, then add the server to your MCP client's configuration. Conduid has recorded 0 installs, so the command is known to work with current clients.

Is Igloo MCP safe to use with an AI agent?

Its trust score is 56 out of 100 (fair). It passes 0 of 1 static security checks; the failures are listed above. It has no ConduID identity yet, so agent calls to it are not receipted.

Is Igloo MCP still maintained?

The last commit was 6 months ago, with 0 open issues. That's long enough that you should check whether the maintainer is responding to issues before depending on it.