Snowflake Cortex MCP Server

Snowflake Cortex MCP Server

Snowflake MCP server providing Cortex AI tooling for MCP clients to query and orchestrate data.

1
Stars
0
Forks
0
Releases

Overview

This Snowflake MCP server provides tooling for Snowflake Cortex AI features, bringing Cortex capabilities to the MCP ecosystem. When connected to an MCP Client (e.g. Claude for Desktop, fast-agent, Agentic Orchestration Framework), users can leverage Cortex AI features for data querying and orchestration. The MCP server supports Cortex Search (unstructured data queries for Retrieval Augmented Generation), Cortex Analyst (structured data semantic modeling), and Cortex Agent (agentic orchestration across data types). It runs as a sidecar/service and communicates with MCP clients via stdio or sockets (not HTTP). Tools are exposed via server.tool('name', handler), enabling dynamic extension of capabilities such as SQL execution or search. The server uses the Snowflake Cortex REST API for authentication and connections, and supports Programmtic Access Token via environment variables. A Payload Builder constructs Cortex Agent requests dynamically, avoiding hard-coded tool definitions and enabling runtime resource configuration. Responses stream via Server-Sent Events (SSE) and are parsed with processSSEResponse. This separation clarifies that MCP servers are not Next.js API routes. Troubleshooting is aided by the MCP Inspector, which can be launched to diagnose issues.

Details

Owner
thisisbhanuj
Language
TypeScript
License
Updated
2025-12-07

Features

Cortex AI Capabilities

Integrates Cortex Search, Cortex Analyst, and Cortex Agent to enable unstructured data search, structured data semantic modeling, and agent orchestration within MCP.

Payload Builder

Dynamically construct MCP payloads for Cortex Agents, reducing hard-coded tool definitions and enabling runtime tool/resource configuration.

Tool Exposure via server.tool

Tools are exposed via server.tool(name, handler) and mapped to resources by exact name matching.

Streaming Responses

Responses are streamed via Server-Sent Events (SSE) and parsed with processSSEResponse.

Client-agnostic MCP Server

Works with various MCP clients and is not tied to a single frontend.

Snowflake Cortex REST API Integration

Uses the Cortex REST API for authentication and connections, with environment-based configuration and PAT support.

Multi-tool Support

You may add multiple instances of Cortex Search or Cortex Analysts; the MCP client selects appropriate tools.

Troubleshooting Tools

Includes MCP Inspector for debugging and troubleshooting of the MCP server.

Audience

MCP developersIntegrate Cortex AI tools into MCP client workflows to build dynamic agents.
MCP clientsConnect the MCP server to clients like Claude Desktop or Cursor for Cortex-enabled workflows.
Data engineersLeverage Cortex tools and SQL execution within MCP pipelines to extract insights.

Tags

SnowflakeCortex AIMCPCortex SearchCortex AnalystCortex AgentPayload BuilderTool exposureStreaming SSESnowflake Cortex REST APIPATSidecarClient-agnostic