# Snowflake Cortex AI

> Use this tool when you need to leverage AI-powered natural language access to Snowflake's data warehouses, converting queries into SQL and retrieving documents from PDF content. It solves problems for business users, analysts, and organizations requiring conversational data exploration, semantic search, and direct SQL execution without writing code. The tool takes natural language inputs and outputs SQL queries, search results, and streaming responses, making it ideal for use cases involving data analysis, document retrieval, and AI-driven insights.

Canonical page: https://skillsregistry.net/skills/snowflake-cortex  
JSON: https://api.skillsregistry.net/v1/skills/snowflake-cortex

## Description

Snowflake Cortex MCP server by BHANUJ that provides AI assistants with natural language access to Snowflake's AI capabilities through three integrated tools: Text2SQL for converting natural language queries into SQL using Cortex Analyst with semantic models, Cortex Search for document retrieval from PDF content stored in Snowflake stages, and direct SQL execution for running generated queries against data warehouses. Built with TypeScript and the MCP SDK, the implementation uses configurable tool definitions with environment variable substitution, supports streaming responses from Cortex agents, and includes sample data setup for TPC-DS retail analytics and vehicle contract documents. Designed for business users who need conversational access to enterprise data warehouses, analysts requiring semantic search across document repositories, and organizations leveraging Snowflake's native AI services for data exploration without writing SQL directly.

## Trust

- **Trust score (0–1):** 0.92
- **Verification tier:** verified
- **Last scanned:** 2026-09-28

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** database
- **Updated:** 2026-09-28

## Source

- **Source listing:** [PulseMCP](https://www.pulsemcp.com/servers/snowflake-cortex)
- **Repository:** <https://github.com/thisisbhanuj/snowflake-cortex-mcp-server>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "snowflake-cortex"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/snowflake-cortex` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/snowflake-cortex/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt