Snowflake Agent

About

The Snowflake Model Context Protocol (MCP) server provides a comprehensive toolkit for AI agents to interact with Snowflake's robust data platform. It seamlessly integrates advanced Snowflake Cortex AI capabilities—including Cortex Search for unstructured data, Cortex Analyst for rich semantic modeling, and Cortex Agent for orchestrating data retrieval—with essential data management functions like object creation, modification, and SQL execution. By connecting to various MCP clients such as Claude Desktop, Cursor, fast-agent, and GitHub Copilot, users can empower their AI assistants to intelligently query, manage, and analyze both structured and unstructured data within Snowflake, all while respecting fine-grained SQL statement permissions and role-based access control.

Key Features

• Object Management for basic Snowflake object operations (create, drop, update)
• SQL Execution with user-configured permissions for LLM-generated queries
• Cortex Analyst for querying structured data via semantic modeling
• Cortex Search for querying unstructured data in RAG applications
• 189 GitHub stars
• Cortex Agent for orchestrating structured and unstructured data retrieval

Use Cases

• Building Retrieval Augmented Generation (RAG) applications using Snowflake data
• Creating natural language data assistants integrated with IDEs like VS Code
• Empowering AI agent clients (e.g., Claude, Cursor, fast-agent) to interact with Snowflake's data platform