Snowflake Cortex MCP Server - NodeJS

Created By

BHANUJ4 months ago

This Snowflake MCP server provides tooling for Snowflake Cortex AI features, bringing these capabilities to the MCP ecosystem. When connected to an MCP Client (e.g. Claude for Desktop, fast-agent, Agentic Orchestration Framework), users can leverage these Cortex AI features. The MCP server currently supports the below Cortex AI capabilities: Cortex Search: Query unstructured data in Snowflake as commonly used in Retrieval Augmented Generation (RAG) applications. Cortex Analyst: Query structured data in Snowflake via rich semantic modeling. Cortex Agent: Agentic orchestrator across structured and unstructured data retrieval

# Snowflake

# Cortex

Overview Content Tools Comments

Overview

What is Snowflake Cortex MCP Server?

The Snowflake Cortex MCP Server is a NodeJS-based server that provides tooling for Snowflake Cortex AI features, enabling users to leverage these capabilities within the MCP ecosystem.

How to use Snowflake Cortex MCP Server?

To use the MCP server, connect it to an MCP Client (like Claude for Desktop or fast-agent) and run the server using the command: yarn dev. Ensure to configure the connection to Snowflake using environment variables for authentication.

Key features of Snowflake Cortex MCP Server?

Cortex Search: Query unstructured data in Snowflake for Retrieval Augmented Generation (RAG) applications.
Cortex Analyst: Query structured data in Snowflake using rich semantic modeling.
Cortex Agent: Acts as an orchestrator for structured and unstructured data retrieval.

Use cases of Snowflake Cortex MCP Server?

Integrating with various MCP Clients for enhanced data querying.
Utilizing AI capabilities for data analysis and retrieval.
Building dynamic agent requests for complex queries.

FAQ from Snowflake Cortex MCP Server?

How do I connect to Snowflake?

Use a Programmatic Access Token (PAT) set as an environment variable (SNOWFLAKE_PAT).

How do I try this?

The MCP server is part of the MCP ecosystem and requires an MCP Client to function.

Where is this deployed?

The server is intended to be started by the MCP client, with no separate remote service deployment necessary.

Server Config

{
  "mcpServers": {
    "Cortex Agent AI": {
      "command": "ABSOLUTE_PATH\\nodejs\\npx.cmd",
      "args": [
        "tsx",
        "--watch",
        "--env-file",
        "ABSOLUTE_PATH\\snowflake-cortex-mcp\\.env",
        "ABSOLUTE_PATH\\snowflake-cortex-mcp\\src\\mcp\\MCP.ts"
      ]
    }
  }
}

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.

Playwright McpPlaywright MCP server

DeepChatYour AI Partner on Desktop

Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.

Context7Context7 MCP Server -- Up-to-date code documentation for LLMs and AI code editors

Amap Maps高德地图官方 MCP Server

AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

WindsurfThe new purpose-built IDE to harness magic

BlenderBlenderMCP connects Blender to Claude AI through the Model Context Protocol (MCP), allowing Claude to directly interact with and control Blender. This integration enables prompt assisted 3D modeling, scene creation, and manipulation.

ChatWiseThe second fastest AI chatbot™