SQL Queries
w95/awesome-claude-corporate-skills
Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.).
Routes Snowflake-related operations to Cortex Code CLI for specialized Snowflake expertise.
Install Cortex Code
The automated check flagged lines worth reading first. See the safety section below.
$ npx skills add Kilo-Org/kilo-marketplace --skill cortex-code -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install Kilo-Org/kilo-marketplace cortex-code --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/cortex-code .claude/skills/cortex-code && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "cortex-code" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/cortex-code into .claude/skills/cortex-code/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cortex-code", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/cortex-codeType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add Kilo-Org/kilo-marketplace --skill cortex-code -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install Kilo-Org/kilo-marketplace cortex-code --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .agents/skills && cp -r skills-src/skills/cortex-code .agents/skills/cortex-code && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "cortex-code" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/cortex-code into .agents/skills/cortex-code/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cortex-code", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add Kilo-Org/kilo-marketplace --skill cortex-code -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install Kilo-Org/kilo-marketplace cortex-code --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/skills/cortex-code .cursor/skills/cortex-code && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "cortex-code" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/cortex-code into .cursor/skills/cortex-code/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cortex-code", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/Kilo-Org/kilo-marketplace.git --path skills/cortex-code--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add Kilo-Org/kilo-marketplace --skill cortex-code -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install Kilo-Org/kilo-marketplace cortex-code --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/skills/cortex-code .gemini/skills/cortex-code && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "cortex-code" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/cortex-code into .gemini/skills/cortex-code/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cortex-code", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install Kilo-Org/kilo-marketplace cortex-codeInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add Kilo-Org/kilo-marketplace --skill cortex-code -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .github/skills && cp -r skills-src/skills/cortex-code .github/skills/cortex-code && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "cortex-code" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/cortex-code into .github/skills/cortex-code/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cortex-code", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add Kilo-Org/kilo-marketplace --skill cortex-code -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install Kilo-Org/kilo-marketplace cortex-code --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/Kilo-Org/kilo-marketplace.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/skills/cortex-code .opencode/skills/cortex-code && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "cortex-code" agent skill from https://github.com/Kilo-Org/kilo-marketplace/tree/main/skills/cortex-code into .opencode/skills/cortex-code/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "cortex-code", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
cortex-code- GitHub stars
- 189
- Token cost
- ~4.6k tokens
- SKILL.md length
- 1,854 words
- Files
- 19 (incl. scripts)
- Skills in repo
- 87
- Repo updated
- First seen
- Licence
- Proprietary
At a glance
Routes Snowflake-related operations to Cortex Code CLI for specialized Snowflake expertise.
- Works in 9 steps: Discover Cortex Capabilities → Load Routing Context → Analyze Request with LLM-Based Routing → …
- User asks about Snowflake databases
- SKILL.md covers Prerequisite, Architecture Overview, Security and Fast Path for Repeat Queries, plus 5 more sections
- Runs Python scripts from its folder
What it does
Cortex Code is an agent skill from Kilo-Org/kilo-marketplace. Routes Snowflake-related operations to Cortex Code CLI for specialized Snowflake expertise. Use when user asks about Snowflake databases, data warehouses, SQL queries on Snowflake, Cortex AI features, Snowpark, dynamic tables, data governance in Snowflake, Snowflake security, or mentions "Cortex" explicitly. Do NOT use for general programming, local file operations, non-Snowflake databases, web development, or infrastructure tasks unrelated to Snowflake.
Its SKILL.md is about 4.6k tokens, which your agent loads only when the skill is triggered. The skill folder holds 21 other files, including scripts (for example `scripts/discover_cortex.py`, `scripts/execute_cortex.py` and `scripts/predict_tools.py`).
It sits in Databases, covering Data warehousing, SQL and Data governance. It works with Snowflake and SQL. The repository describes itself as: Kilo Marketplace - A curated collection of Skills, MCP Servers, and Modes for enhancing AI agent capabilities across the Kilo ecosystem—including Kilo Code (VS Code extension)…
When your agent uses it
- User asks about Snowflake databases
- Data warehouses
- SQL queries on Snowflake
- Cortex AI features
Example prompts
- “Cortex”
- “Use the cortex-code skill to route Snowflake-related operations to Cortex Code CLI for specialized Snowflake expertise”
- “/cortex-code”
Requirements
- Python 3
Workflow steps
9 steps, taken from the step headings in SKILL.md.
- Discover Cortex Capabilities
- Load Routing Context
- Analyze Request with LLM-Based Routing
- Execute Based on Routing Decision
- Choose Security Envelope and Handle Approval
- Enrich Context for Cortex
- Execute Cortex Code Headlessly
- Handle Permission Requests
- Return Results to User
What it can do on your machine
Read from SKILL.md and the folder at commit ff51758. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
Ships 6 files in scripts/ (Python, from the files we listed), which the agent can run.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Cortex Code loads about 4.6k tokens when it runs. Until then it costs about 118 tokens; SKILL.md has 1,854 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check: warnings
The automated check found patterns that need a careful read before installing.
- WarningMentions a credentials file (SSH keys, cloud or package-manager tokens)SKILL.md:400
hs matching credential allowlist (e.g., ~/.ssh/, .env)
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.
SKILL.md
Its licence (Proprietary) doesn't allow us to republish the file, so here is its outline and opening line. It has 1,854 words (~4,577 tokens).
“This marketplace skill is already installed; do not install or replace skill instructions dynamically. Cortex Code CLI must be installed and configured from the official Snowflake documentation. Verify the reviewed installation with:”
- name
- cortex-code
- metadata.author
- Snowflake Integration Team
- metadata.version
- 1.0.0
- metadata.compatibility
- Requires Cortex Code CLI installed and configured
- metadata.category
- data
Files
SKILL.md and 18 other files (scripts) in skills/cortex-code of Kilo-Org/kilo-marketplace.
- SKILL.md
- LICENSE
- config.yaml.example
- cortex-snowflake-routing.mdc
- local.patch
- scripts/discover_cortex.py
- scripts/execute_cortex.py
- scripts/predict_tools.py
- scripts/read_cortex_sessions.py
- scripts/route_request.py
- scripts/security_wrapper.py
- security/__init__.py
- security/approval_handler.py
- security/audit_logger.py
- security/cache_manager.py
- security/config_manager.py
- security/default_policy.yaml
- security/policies/default_policy.yaml
- … and 1 more
Open the folder on GitHubat commit ff51758
Compare with similar skills
Cortex Code next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Cortex Code this skillKilo-Org/kilo-marketplace | 189 | — | ~4.6k | Automated safety check: Warn | Proprietary | |
| SQL Queriesw95/awesome-claude-corporate-skills | 235 | 3 repos | ~2.8k | Automated safety check: Pass | MIT | |
| Optimizing Query By IdAltimateAI/data-engineering-skills | 127 | — | ~919 | Automated safety check: Pass | MIT | |
| Snowflake Developmentsickn33/agentic-awesome-skills | 47k | 2 repos | ~2.1k | Automated safety check: Pass | MIT | |
| Warehouse SQLHybridAIOne/hybridclaw | 158 | — | ~1.8k | Automated safety check: Pass | MIT | |
| Snowflake Developmentalirezarezvani/claude-skills | 28k | — | ~3.2k | Automated safety check: Pass | MIT |
Similar skills
Optimizing Query By Id
AltimateAI/data-engineering-skills
Optimizes Snowflake query performance using query ID from history.
Snowflake Development
sickn33/agentic-awesome-skills
Comprehensive Snowflake development assistant covering SQL best practices, data pipeline design (Dynamic Tables, Streams, Tasks, Snowpipe), Cortex AI functions, Cortex Agents, Snowpark Python, dbt…
Warehouse SQL
HybridAIOne/hybridclaw
Review and run read-only natural-language SQL against a customer data warehouse with cached schema introspection and explicit write grants.
Snowflake Development
alirezarezvani/claude-skills
A skill your agent uses when writing Snowflake SQL, building data pipelines with Dynamic Tables or Streams/Tasks, using Cortex AI functions, creating Cortex Agents, writing Snowpark Python…
SQL Sentinel
sickn33/agentic-awesome-skills
Audit SQL for the cost & performance anti-patterns that burn warehouse credits.
More from Kilo-Org/kilo-marketplace
All 87 skills in this repoAzureML Project Scaffolding
Kilo-Org/kilo-marketplace
Sets up and maintains AzureML-ready Python projects as uv workspaces with devcontainers, a Makefile and job YAML, so local runs match cloud jobs and experiments stay reproducible.
Jupyter Notebook Builder
Kilo-Org/kilo-marketplace
Creates, inspects, edits and runs Jupyter notebooks, scaffolding experiment or tutorial notebooks from templates and preferring a Jupyter MCP server over raw JSON edits.
Tableau Dashboard Creator
Kilo-Org/kilo-marketplace
Takes a plain-language dashboard request through brand setup, data exploration, planning, an interactive HTML mock and a Tableau implementation spec.
Elasticsearch File Ingest
Kilo-Org/kilo-marketplace
Ingest and transform data files (CSV/JSON/Parquet/Arrow IPC) into Elasticsearch with stream processing and custom transforms.
Nifi Flow Layout
Kilo-Org/kilo-marketplace
A skill your agent uses when arranging Apache NiFi processors, process groups, ports, comments, numbering, crossing connections, dense fan-in/fan-out, or reusable readable canvas layouts.
Splunk Ingest Processor Setup
Kilo-Org/kilo-marketplace
Render Cisco Data Fabric ingest-time routing workflows and Splunk Cloud Platform Ingest Processor setup plans with SPL2 pipelines, source types, destinations, lifecycle handoffs, queue and…
Related
Categories
Questions about Cortex Code
What does Cortex Code do?
Routes Snowflake-related operations to Cortex Code CLI for specialized Snowflake expertise. Cortex Code is an agent skill from Kilo-Org/kilo-marketplace. Routes Snowflake-related operations to Cortex Code CLI for specialized Snowflake expertise.
When should I use Cortex Code?
Cortex Code fits situations like: user asks about Snowflake databases; data warehouses; SQL queries on Snowflake; cortex AI features.
How do I install Cortex Code in Claude Code?
Run `npx skills add Kilo-Org/kilo-marketplace --skill cortex-code -a claude-code`. Or copy the skill folder (skills/cortex-code in Kilo-Org/kilo-marketplace) into .claude/skills/cortex-code in your project. Claude Code loads it when a task matches its description.
How do I install Cortex Code in Codex?
Run `npx skills add Kilo-Org/kilo-marketplace --skill cortex-code -a codex`. Or copy the skill folder (skills/cortex-code in Kilo-Org/kilo-marketplace) into .agents/skills/cortex-code in your project. Codex loads it when a task matches its description.
Can I use Cortex Code in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add Kilo-Org/kilo-marketplace --skill cortex-code -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/cortex-code, .gemini/skills/cortex-code, .github/skills/cortex-code and .opencode/skills/cortex-code in your project.
What does Cortex Code need to run?
Going by SKILL.md and its folder, Cortex Code needs Python for the scripts in its folder. Our summary lists: Python 3.
Does Cortex Code access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Cortex Code safe to install?
Our automated static check of SKILL.md flagged 1 warning(s): mentions a credentials file (ssh keys, cloud or package-manager tokens). Read the flagged lines before installing; the check is not a guarantee either way. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.
What licence does Cortex Code use?
Cortex Code carries a proprietary licence (from the LICENSE file in the skill folder). It is published on GitHub, but it is not open source: read the licence file before using or sharing it.
How many tokens does Cortex Code use?
About 4.6k tokens (SKILL.md is roughly 18k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Cortex Code?
Skills that share tags, products or a category with Cortex Code: SQL Queries (w95/awesome-claude-corporate-skills, 235 stars), Optimizing Query By Id (AltimateAI/data-engineering-skills, 127 stars), Snowflake Development (sickn33/agentic-awesome-skills, 47k stars) and Warehouse SQL (HybridAIOne/hybridclaw, 158 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Cortex Code?
Kilo-Org (a GitHub organization) maintains it in Kilo-Org/kilo-marketplace, which has 189 GitHub stars. The repository holds 87 skills in this directory. The repository was last updated on September 28, 2026.
Source: Kilo-Org/kilo-marketplace on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.