MCP (Model Context Protocol) server that lets Claude or other MCP-compatible clients run SQL against Snowflake, expose schema/context resources and maintain an insights memo.
https://github.com/isaacwasserman/mcp-snowflake-serverStop copying and pasting SQL results into Claude. This MCP server gives Claude direct access to your Snowflake data warehouse, turning every conversation into a powerful data exploration session.
You know the drill: someone asks a question about the data, you write SQL, copy results, paste into Claude, ask follow-ups, write more SQL, repeat. Meanwhile, Claude can't see your schema, doesn't understand your data relationships, and loses context between queries.
This MCP server changes that completely. Claude gets direct read access to your Snowflake instance, can explore schemas autonomously, and maintains a running memo of insights across your entire conversation.
Direct Query Execution: Claude runs SELECT queries against your data warehouse and sees results immediately. No more manual SQL-to-Claude workflows.
Schema Intelligence: Claude can list databases, explore schemas, describe tables, and understand your data structure without you explaining it every time.
Persistent Insights: The built-in memo system captures discoveries and patterns Claude finds, building institutional knowledge across sessions.
Safe by Default: Write operations are disabled unless explicitly enabled. Claude can explore freely without accidentally modifying production data.
Data Investigation: "Analyze customer churn patterns in the past quarter" - Claude explores your customer tables, identifies trends, and builds a comprehensive analysis without you writing a single query.
Schema Discovery: New team member needs to understand your data model? Claude can map relationships between tables and explain the structure conversationally.
Insight Accumulation: Each analysis session builds on previous discoveries. Claude remembers what it learned about your data patterns and applies that knowledge to new questions.
Ad-Hoc Analysis: Skip the dashboard creation for one-off questions. Claude becomes your instant analytics interface.
Installation takes under 5 minutes with Smithery:
npx -y @smithery/cli install mcp_snowflake_server --client claude
Or configure manually with your existing Claude Desktop setup. The server handles Snowflake authentication through environment variables or external browser auth - whatever your security team prefers.
Flexible Security: Control access with role-based permissions in Snowflake. Enable write operations only when needed. Use exclusion patterns to hide sensitive databases or tables.
Production Ready: Built on the official Snowflake Python connector with proper connection pooling and error handling.
Your Snowflake data becomes as accessible as having a conversation. Claude understands your schema, runs queries intelligently, and builds insights that persist across sessions.
This isn't just another database connector - it's turning your AI assistant into a data analyst who knows your business.