Provides access to Snowflake Cortex AI capabilities, including Cortex Search for unstructured data, Cortex Analyst for querying structured data, and Cortex Agent for agent orchestration across different data types.

Installation

Yarn Dev

yarn dev

MCP Inspector

yarn inspector

MCP Inspector (NPX)

npx @modelcontextprotocol/inspector tsx --env-file .env dist/mcp/MCP.js

Configuration

Claude Desktop

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

Available Tools

Tool	Description
cortex_search	Query unstructured data in Snowflake for Retrieval Augmented Generation (RAG) applications
cortex_analyst_text_to_sql	Query structured data in Snowflake through advanced semantic modeling
cortex_agent	Agent orchestrator for extracting structured and unstructured data
sql_execution_tool	Execute SQL queries

Capabilities

• Cortex Search for querying unstructured data in RAG applications
• Cortex Analyst for querying structured data through semantic modeling
• Cortex Agent for agent orchestration across different data types
• Payload Builder for dynamic construction of agent requests
• Support for streaming responses via SSE
• Support for multiple Cortex Search and Analyst instances
• Configuration via environment variables

Environment Variables

Required

• SNOWFLAKE_PAT - Personal access token for Snowflake authentication

Optional

• SEMANTIC_MODEL_VIEW - Semantic model file for the Text2SQL tool
• VEHICLES_SEARCH_SERVICE - Name of the vehicle search service

Usage Examples

Show me the top selling brands by total sales quantity in TX for Books in 2003

Notes

MCP servers operate as companion services and communicate via stdio/sockets, not HTTP. They should not be confused with Next.js API backends. The server uses the Snowflake Cortex REST API for authentication and supports multiple MCP clients, including Claude Desktop, VS Code with GitHub Copilot, and others. Personal access tokens do not evaluate secondary roles and require proper role configuration.