Snowflake

Snowflake

Open-source MCP server for Snowflake Cortex with object management, SQL execution, and semantic view querying.

182
Stars
61
Forks
6
Releases

Overview

Snowflake Cortex MCP Server is an open-source MCP server that exposes Cortex-powered tooling to the MCP ecosystem for Snowflake. It enables Cortex Search for unstructured data, Cortex Analyst for structured data via semantic models, and Cortex Agent for orchestration across data retrieval. It also provides object management capabilities (create, drop, update, etc.), SQL execution governed by user-configured permissions, and semantic view discovery and querying. Configuration is driven by a YAML file that groups Cortex services (agent, search, analyst) and other tool groups (object_manager, query_manager, semantic_manager). The server enforces RBAC and supports all authentication methods offered by the Snowflake Python Connector (username/password, key pair, OAuth, SSO, MFA). It can run with stdio or HTTP transports and supports container deployments via Docker or Docker Compose. It is designed to be client-agnostic, working with Claude Desktop, Cursor, fast-agent, Codex, and other MCP clients. Tools are exposed as REST endpoints, and semantic models or semantic views can be used by analysts. Debugging tooling and troubleshooting guidance are included.

Details

Owner
Snowflake-Labs
Language
Python
License
Apache License 2.0
Updated
2025-12-07

Features

Cortex Search

Query unstructured Snowflake data for Retrieval Augmented Generation (RAG) workflows.

Cortex Analyst

Query structured Snowflake data via semantic modeling to support analytical tasks.

Cortex Agent

Agentic orchestrator across structured and unstructured data retrieval and actions.

Object Management

Create, drop, update, and other basic operations on Snowflake objects.

SQL Execution

Execute LLM-generated SQL with permissions controlled by sql_statement_permissions.

Semantic View Querying

Discover and query Snowflake Semantic Views and their components.

RBAC & Fine-Grained Permissions

Enforce RBAC and per-operation permissions via configuration-driven controls.

Client-Agnostic MCP Integration

Works with Claude Desktop, Cursor, fast-agent, Codex, and other MCP clients.

Audience

Snowflake Cortex UsersOrchestrate Cortex tools and data access within Snowflake via MCP.
MCP DevelopersIntegrate Snowflake Cortex features with MCP clients for tooling and deployment.
Data EngineersAccess object management, SQL execution, and semantic views via MCP integrations.

Tags

SnowflakeCortexMCPRBACObject ManagementSQL ExecutionSemantic View QueryingAuthenticationContainer DeploymentCortex AgentCortex AnalystCortex Search