Skip to content

Instantly share code, notes, and snippets.

@danalloway
danalloway / claude-snowflake-mcp-integration-guide.sql
Created February 6, 2026 15:47 — forked from johnib/claude-snowflake-mcp-integration-guide.sql
Setup script for connecting Claude.ai to Snowflake via native MCP connector with OAuth. Includes role configuration, troubleshooting guide, and known limitations (read-only not enforceable due to Claude.ai OAuth scope limitation).
-- ============================================================================
-- CLAUDE.AI SNOWFLAKE MCP CONNECTOR - SETUP SCRIPT
-- ============================================================================
-- This script configures Snowflake for Claude.ai's native MCP connector
-- with OAuth authentication.
--
-- Run as ACCOUNTADMIN in Snowflake (Snowsight or SnowSQL)
--
-- Replace all <placeholders> with your actual values before running.
-- ============================================================================