snowflake-cortex-code

Snowflake AI Kit

Connect your AI coding agent to Snowflake. Plugins for Claude Code and OpenAI Codex that automatically detect Snowflake prompts and route them to Cortex Code — where 55+ built-in skills handle SQL, data governance, dynamic tables, ML, and more.

Quick Start

Claude Code

claude plugin install snowflake-cortex-code@claude-plugins-official

OpenAI Codex

From your terminal:

codex plugin marketplace add Snowflake-Labs/snowflake-ai-kit
codex plugin add snowflake-cortex-code@snowflake-ai-kit

Or inside Codex, open /plugins and install "Snowflake Cortex Code" from the Snowflake AI Kit marketplace.

That's it

Ask naturally — the plugin handles routing:

• "Show me my Snowflake warehouses"
• "What databases do I have access to?"
• "List all tables in my current schema"
• "Create a dynamic table that refreshes hourly"

Non-Snowflake prompts ("fix the bug in auth.py", "write a unit test") stay in your current agent.

How It Works

You → Claude Code / Codex → [Plugin detects Snowflake intent] → Cortex Code CLI → Snowflake

1. A lightweight keyword filter runs on every prompt (~50ms, no network)
2. If Snowflake intent is detected, the plugin routes to Cortex Code CLI
3. Cortex Code executes with 55+ specialized skills (SQL, governance, ML, streaming, etc.)
4. Results flow back to your agent session

To explicitly invoke Cortex Code (bypassing auto-detection):

$cortex-run show me my warehouses and their current state

See plugins/cortex-code/ for full documentation on security model, envelopes, and configuration.

Prerequisites

The plugin requires Cortex Code CLI (cortex) on your PATH. Install it from the official docs.

Snowflake Connection

Cortex Code CLI needs a Snowflake connection configured at ~/.snowflake/connections.toml:

snow connection add

Installer

The bundled installer sets up both Snowflake CLI (snow) and Cortex Code CLI (cortex):

Platform	Command
macOS / Linux	bash install.sh
Windows	.\install.ps1
npx (any)	npx @snowflake-labs/ai-kit

Flag	Description
--check / -Check	Check installation status without installing
--with-claude / -WithClaude	Also install Claude Code CLI + plugin
--with-codex / -WithCodex	Also install OpenAI Codex CLI + plugin
--help / -Help	Show help

Skills

Cortex Code CLI ships with 55+ built-in skills that activate automatically based on your prompt:

cortex skill list

Examples: semantic-view, cortex-agent, data-quality, dynamic-tables, cost-intelligence, machine-learning, iceberg, data-governance, cortex-ai-functions, deploy-to-spcs, lineage, dbt-projects-on-snowflake, snowflake-notebooks, security-investigation, workload-performance-analysis.

Skills are organized by source:

Category	Description
BUNDLED	Ship with the CLI binary. Updated on cortex update.
GLOBAL	User-installed in ~/.snowflake/cortex/skills/. Shared across projects.
EXTERNAL	Added via cortex skill add <path> or cortex skill add owner/repo.
PROJECT	Discovered from the current working directory.

Troubleshooting

Problem	Fix
cortex: command not found	Re-run bash install.sh or install from Cortex Code CLI docs.
snow: command not found	Ensure ~/.local/bin is in $PATH. Open a new terminal.
Connection errors	Run snow connection add. Docs: Specify credentials
Plugin not routing	Verify plugin is enabled in your agent's settings.
Installer hangs on Windows	Run PowerShell as Administrator.

Contributing