sql-queries
anthropics/knowledge-work-pluginsOfficial collectionData & analytics
sql-queries is a skill in anthropics/knowledge-work-plugins, last changed 13 Mar 2026. It is instructions only: no scripts, no named hosts and no pre-approved tools.
Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.). Use when writing queries, optimizing slow SQL, translating between dialects, or building complex analytical queries with CTEs, window functions, or aggregations.
At a glance
What it can touch
- Instructions only
It is instructions only: no scripts, no named hosts and no pre-approved tools.
How much a skill can do, not whether it is risky.
Pattern check
Nothing flagged
That isn't proof the skill is harmless.
Commit 2574e29 · 1 Nov 2026
How the check worksPattern check: nothing flagged
That isn't proof the skill is harmless.
Install
Each tab says whether it installs commit 2574e29, the one we checked, or the latest version.
OpenCode also looks in .agents/skills/ and ~/.agents/skills/, so use the Any agent steps.
Goose also looks in .agents/skills/ and ~/.agents/skills/, so use the Any agent steps.
Windsurf (Devin Desktop) also looks in .agents/skills/ and ~/.agents/skills/, so use the Any agent steps.
Zed also looks in .agents/skills/ and ~/.agents/skills/, so use the Any agent steps.
Roo Code also looks in .agents/skills/ and ~/.agents/skills/, so use the Any agent steps.
Factory Droid also looks in .agents/skills/ and ~/.agents/skills/, so use the Any agent steps.
Junie also looks in .agents/skills/ and ~/.agents/skills/, so use the Any agent steps.
Amp also looks in .agents/skills/ and ~/.agents/skills/, so use the Any agent steps.
No install command here reaches Kiro. Copy the skill's folder into .kiro/skills/ in your project, or ~/.kiro/skills/ for all your projects. anthropics/knowledge-work-plugins/data/skills/sql-queries (opens in a new tab)
Antigravity also looks in .agents/skills/, so the Any agent steps reach it with This project. For All projects, see where Antigravity looks.
Cline also looks in .claude/skills/, so the Claude Code steps reach it with This project. For All projects, see where Cline looks.
Claude Code
Pinned to commit 2574e29, the one we checked.
From your project's root folder:
tmp="$(mktemp -d)" &&git clone -q --depth 1 --filter=blob:none --no-checkout https://github.com/anthropics/knowledge-work-plugins.git "$tmp" &&git -C "$tmp" fetch -q --depth 1 origin 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&git -C "$tmp" sparse-checkout set -- data/skills/sql-queries &&git -C "$tmp" checkout -q 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&mkdir -p .claude/skills &&mkdir .claude/skills/sql-queries &&cp -R "$tmp"/data/skills/sql-queries/. .claude/skills/sql-queries/ &&rm -rf "$tmp"If Claude Code was already running and this created the skills folder, run /reload-skills.
Or install the data plugin it ships in. Installs the latest version, not the one we checked. Installs everything in the plugin, including any hooks, MCP servers and scripts our check doesn't cover.
claude plugin marketplace add anthropics/knowledge-work-plugins --scope project &&claude plugin install data@knowledge-work-plugins --scope projectClaude apps
Pinned to commit 2574e29, the one we checked.
Skills in the Claude apps belong to your account rather than to a project.
Make sql-queries.zip, with the skill folder at the top level:
tmp="$(mktemp -d)" &&git clone -q --depth 1 --filter=blob:none --no-checkout https://github.com/anthropics/knowledge-work-plugins.git "$tmp" &&git -C "$tmp" fetch -q --depth 1 origin 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&git -C "$tmp" sparse-checkout set -- data/skills/sql-queries &&git -C "$tmp" checkout -q 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&out="$(mktemp -d)" &&cp -R "$tmp"/data/skills/sql-queries "$out"/sql-queries &&(cd "$out" && zip -qr - sql-queries) > sql-queries.zip &&rm -rf "$tmp" "$out"In Claude, open Customize > Skills, select +, then + Create skill > Upload a skill, and choose sql-queries.zip.
On Free, Pro and Max plans, turn on Code execution and file creation (Create and edit files in newer settings) under Settings > Capabilities.
Codex
Pinned to commit 2574e29, the one we checked.
From your project's root folder:
tmp="$(mktemp -d)" &&git clone -q --depth 1 --filter=blob:none --no-checkout https://github.com/anthropics/knowledge-work-plugins.git "$tmp" &&git -C "$tmp" fetch -q --depth 1 origin 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&git -C "$tmp" sparse-checkout set -- data/skills/sql-queries &&git -C "$tmp" checkout -q 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&mkdir -p .agents/skills &&mkdir .agents/skills/sql-queries &&cp -R "$tmp"/data/skills/sql-queries/. .agents/skills/sql-queries/ &&rm -rf "$tmp"Codex picks up new skills on its own; restart it if this one does not appear.
Cursor
Pinned to commit 2574e29, the one we checked.
From your project's root folder:
tmp="$(mktemp -d)" &&git clone -q --depth 1 --filter=blob:none --no-checkout https://github.com/anthropics/knowledge-work-plugins.git "$tmp" &&git -C "$tmp" fetch -q --depth 1 origin 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&git -C "$tmp" sparse-checkout set -- data/skills/sql-queries &&git -C "$tmp" checkout -q 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&mkdir -p .cursor/skills &&mkdir .cursor/skills/sql-queries &&cp -R "$tmp"/data/skills/sql-queries/. .cursor/skills/sql-queries/ &&rm -rf "$tmp"Copilot & VS Code
Pinned to commit 2574e29, the one we checked.
From your project's root folder:
tmp="$(mktemp -d)" &&git clone -q --depth 1 --filter=blob:none --no-checkout https://github.com/anthropics/knowledge-work-plugins.git "$tmp" &&git -C "$tmp" fetch -q --depth 1 origin 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&git -C "$tmp" sparse-checkout set -- data/skills/sql-queries &&git -C "$tmp" checkout -q 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&mkdir -p .github/skills &&mkdir .github/skills/sql-queries &&cp -R "$tmp"/data/skills/sql-queries/. .github/skills/sql-queries/ &&rm -rf "$tmp"In a running Copilot CLI session, run /skills reload.
Or install it with gh skill, which also installs the commit we checked. Needs GitHub CLI 2.90 or later.
gh skill install anthropics/knowledge-work-plugins data/skills/sql-queries/SKILL.md@2574e29377c7173d0cecffef29a6ecbd7f8ccb5d --agent github-copilot --scope projectGemini CLI
Pinned to commit 2574e29, the one we checked.
From your project's root folder:
tmp="$(mktemp -d)" &&git clone -q --depth 1 --filter=blob:none --no-checkout https://github.com/anthropics/knowledge-work-plugins.git "$tmp" &&git -C "$tmp" fetch -q --depth 1 origin 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&git -C "$tmp" sparse-checkout set -- data/skills/sql-queries &&git -C "$tmp" checkout -q 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&mkdir -p .gemini/skills &&mkdir .gemini/skills/sql-queries &&cp -R "$tmp"/data/skills/sql-queries/. .gemini/skills/sql-queries/ &&rm -rf "$tmp"In a running session, run /skills reload.
Or use Gemini CLI’s own installer. Installs the latest version, not the one we checked.
gemini skills install https://github.com/anthropics/knowledge-work-plugins.git --path data/skills/sql-queries --scope workspaceAny agent
Pinned to commit 2574e29, the one we checked.
OpenCode, Goose, Windsurf (Devin Desktop), Zed, Roo Code, Factory Droid, Junie, Amp and Antigravity read .agents/skills in a project.
From your project's root folder:
tmp="$(mktemp -d)" &&git clone -q --depth 1 --filter=blob:none --no-checkout https://github.com/anthropics/knowledge-work-plugins.git "$tmp" &&git -C "$tmp" fetch -q --depth 1 origin 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&git -C "$tmp" sparse-checkout set -- data/skills/sql-queries &&git -C "$tmp" checkout -q 2574e29377c7173d0cecffef29a6ecbd7f8ccb5d &&mkdir -p .agents/skills &&mkdir .agents/skills/sql-queries &&cp -R "$tmp"/data/skills/sql-queries/. .agents/skills/sql-queries/ &&rm -rf "$tmp"Or use the skills CLI from skills.sh. Installs the latest version, not the one we checked. The skills CLI reports installs to skills.sh unless you set DISABLE_TELEMETRY=1.
npx skills@1.7.4 add anthropics/knowledge-work-plugins --skill sql-queriesWhat it can touch
From the files and frontmatter at commit 2574e29. This is how much a skill can do, not whether it is risky.
Instructions only
It is instructions only: no scripts, no named hosts and no pre-approved tools.
Pattern check
Pattern check: nothing flagged · commit 2574e29 · 1 Nov 2026
We checked every text file in this skill, at commit 2574e29 on 1 Nov 2026, against 45 published patterns such as download-and-run commands, hidden text and credential access. We don't run the skill, we don't read the web pages it points to, and we can't judge everything its instructions might lead an agent to do. In published tests, pattern checks like this one missed most malicious skills. Read the skill before you install it — especially anything it asks you to download or run.
Format check
Each agent reads SKILL.md a little differently. We check the file against each one's published rules; we don't run the skill in any agent.
Agent Skills specPasses with warnings
The open format from agentskills.io, held to what the strictest agents enforce, so one folder loads everywhere.
- Warning
Fields outside the spec: user-invocable (read by Claude Code and VS Code). Uploads to the Claude apps and API, and the spec's validator, reject the file; most agents ignore these fields. O1
Fix: Delete them for a portable skill, or keep them if you only target the agents that read them.
- Note
There is no license field, so readers can't tell whether they may reuse the skill. O2
Fix: Add license: with an SPDX name such as MIT or Apache-2.0, or the name of a bundled licence file.
- Warning
- Claude CodePasses
Claude apps & API uploadFails
Uploading to claude.ai or the Claude API, or packaging with Anthropic's script, accepts only the six spec fields and stops on anything else.
- Error
Upload and packaging fail on fields outside the spec: user-invocable. O1
Fix: Delete them, and keep your own data under metadata as text values.
- Note
The description is 285 characters. The claude.ai Help Center says 200 at most, though Anthropic's API docs and validator allow 1,024. D4
Fix: If the claude.ai upload refuses it, trim the description to 200 characters.
- Error
OpenAI (Codex & API)Passes with warnings
Codex finds SKILL.md by its exact name and needs a description; OpenAI's Skills API checks the frontmatter against the spec and caps uploads.
- Warning
Fields outside the spec: user-invocable. Codex ignores them; OpenAI doesn't say whether its upload accepts them. O1
Fix: Delete them, or move your own data under metadata as text values.
- Warning
- VS Code & CopilotPasses
SKILL.md
Files
1 file
| Path | Size |
|---|---|
| SKILL.md (opens in a new tab) | 10.9 KB |
More from anthropics/knowledge-work-plugins
Other Data & analytics skills
Same category, most repo stars first.