Originally published byDev.to
I built a Claude Code plugin that adds Snowflake capabilities through Cortex Code and it is now available in Claude's official marketplace.
Run these inside Claude Code:
/plugin marketplace add anthropic/claude-plugins-official
/plugin install snowflake-cortex-code
This is how it works:
- You type a prompt in Claude Code
- A keyword filter (regex with word boundaries) checks if it's Snowflake-related. If ambiguous, a scoring system weighs Snowflake indicators (SQL patterns, Cortex skill triggers, "warehouse", "dynamic table") against non-Snowflake ones (git, local files, other databases).
- If Snowflake wins, it spawns a Cortex Code session and pipes the response back
- If not, Claude handles it normally
The permission model: Every tool call goes through a hard gate so Cortex asks permission before executing anything, and an envelope policy decides allow/deny.
The default envelope is RW: SQL writes are fine, but destructive bash (rm -rf, sudo, force push) gets blocked. Switch to RO and even CREATE/INSERT gets denied at the gate. It also keeps session state across turns, so follow-ups like "describe the largest one" work without re-explaining context.
Check it out and let me know what you think.
Cheers,
Dash
🇺🇸
More news from United StatesUnited States
NORTH AMERICA
Related News
How Braze’s CTO is rethinking engineering for the agentic area
10h ago
Amazon Employees Are 'Tokenmaxxing' Due To Pressure To Use AI Tools
21h ago

Implementing Multicloud Data Sharding with Hexagonal Storage Adapters
15h ago

DeepMind’s CEO Says AGI May Be ~4 Years Away. The Last Three Missing Pieces Are Not What Most People Think.
15h ago

CCSnapshot - A Claude Code Configs Transfer Tool
21h ago