How do I install the Cortex Code skill?

Run npx skillmds@latest add snowflake-labs/cortex-code-2 in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Cortex Code safe to use?

This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Cortex Code?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Cortex Code free to use?

Yes. Installing skills from SkillMD is free. This skill is licensed under Proprietary.

Who published Cortex Code?

snowflake-labs (@snowflake-labs) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Cortex Code by snowflake-labs — Agent Skill

Name: Cortex Code
Author: snowflake-labs

File contents

Cortex Code Integration

Routes Snowflake queries to Cortex Code agent with conversation context enrichment.

When to Use

Use this skill when the user asks about:

Snowflake databases, warehouses, schemas, tables, views
SQL queries for Snowflake data ("How many databases?", "Show top customers")
Data quality checks, validation, profiling
Cortex AI features (Cortex Search, Cortex Analyst, ML functions)
Semantic views, data modeling
Snowpark, dynamic tables, streams, tasks
Snowflake security, roles, policies, governance

Instructions

Step 1: Build Enriched Context

Before executing, build an enriched prompt that includes:

Conversation Context (if relevant):
- Previous 2-3 exchanges from this conversation
- Any Snowflake-specific details already discussed
- User's stated goals or requirements
User's Question:
- The current query being asked

Step 2: Execute with Context

Pass the enriched context to Cortex Code:

python3 scripts/execute_cortex.py \
  --prompt "# Conversation Context
[relevant prior exchanges if any]

# Current Question
[USER'S QUESTION]" \
  --envelope "RO"

Example with Context

If user previously asked "Which databases have stock data?" and now asks "Show me the schema for the main table":

python3 scripts/execute_cortex.py \
  --prompt "# Recent Context
User previously identified databases with stock data: DB_STOCK, FINANCE__ECONOMICS

# Current Question
Show me the schema for the main table in DB_STOCK" \
  --envelope "RO"

Example without Context

For standalone questions:

python3 scripts/execute_cortex.py \
  --prompt "How many databases do I have in Snowflake?" \
  --envelope "RO"

How It Works

Agent builds enriched prompt with conversation context
Routes to Cortex Code agent (headless execution)
Cortex executes cortex CLI with stream-json format
Runs SQL queries via snowflake_sql_execute tool
Returns formatted results with analysis

Configuration

Approval mode: prompt by default; request user approval before execution
Security envelope: RO for reads; RW only for approved writes
Connection: Uses default Snowflake connection from cortex CLI

---name: cortex-code-2description: Routes Snowflake-related operations to Cortex Code agent for specialized Snowflake expertise. Use when querying databases, checking data quality, or asking about Snowflake features.license: Proprietary. See LICENSE for complete terms---# Cortex Code IntegrationRoutes Snowflake queries to Cortex Code agent with conversation context enrichment.## When to UseUse this skill when the user asks about:- Snowflake databases, warehouses, schemas, tables, views- SQL queries for Snowflake data ("How many databases?", "Show top customers")- Data quality checks, validation, profiling- Cortex AI features (Cortex Search, Cortex Analyst, ML functions)- Semantic views, data modeling- Snowpark, dynamic tables, streams, tasks- Snowflake security, roles, policies, governance## Instructions### Step 1: Build Enriched ContextBefore executing, build an enriched prompt that includes:1. **Conversation Context** (if relevant): - Previous 2-3 exchanges from this conversation - Any Snowflake-specific details already discussed - User's stated goals or requirements2. **User's Question**: - The current query being asked### Step 2: Execute with ContextPass the enriched context to Cortex Code:```bashpython3 scripts/execute_cortex.py \ --prompt "# Conversation Context[relevant prior exchanges if any]# Current Question[USER'S QUESTION]" \ --envelope "RO"```### Example with ContextIf user previously asked "Which databases have stock data?" and now asks "Show me the schema for the main table":```bashpython3 scripts/execute_cortex.py \ --prompt "# Recent ContextUser previously identified databases with stock data: DB_STOCK, FINANCE__ECONOMICS# Current QuestionShow me the schema for the main table in DB_STOCK" \ --envelope "RO"```### Example without ContextFor standalone questions:```bashpython3 scripts/execute_cortex.py \ --prompt "How many databases do I have in Snowflake?" \ --envelope "RO"```## How It Works1. Agent builds enriched prompt with conversation context2. Routes to Cortex Code agent (headless execution)3. Cortex executes `cortex` CLI with stream-json format4. Runs SQL queries via `snowflake_sql_execute` tool5. Returns formatted results with analysis## Configuration- **Approval mode**: prompt by default; request user approval before execution- **Security envelope**: RO for reads; RW only for approved writes- **Connection**: Uses default Snowflake connection from cortex CLI

Frequently asked questions

Cortex Code