write-query
Write optimized SQL for your dialect with best practices. Use when translating a natural-language data need into SQL, building a multi-CTE query with joins and aggregations, optimizing a query against a large partitioned table, or getting d
- License
- Apache-2.0
- SKILL.md tokens
- 1,188
- Bundled files
- 0
- Bundled tokens (estimated)
- 0
Cost per 1,000 loads
Estimated input cost per 1,000 loads of SKILL.md only (characters ÷ 4). Bundled files, output tokens and execution are excluded.
| Model | Input / 1M tokens | 1,000 loads |
|---|---|---|
| Claude Opus 5 | $5.00 | $5.94 |
| Claude Sonnet 5 | $2.00 | $2.38 |
| Claude Haiku 4.5 | $1.00 | $1.19 |
Safety flags
Detected automatically from files; not a security audit.
- Runs scripts
- No
- Network access
- No
- Shell commands
- No
Works with
Open SKILL.md format
- Claude Code
- Codex
- Cursor
- GitHub Copilot
- Gemini CLI
- OpenCode
- Goose
Install
npx skills add anthropics/knowledge-work-plugins --skill write-queryLast verified:
write-query FAQ
What does the write-query skill do?
Write optimized SQL for your dialect with best practices. Use when translating a natural-language data need into SQL, building a multi-CTE query with joins and aggregations, optimizing a query against a large partitioned table, or getting d Source: https://github.com/anthropics/knowledge-work-plugins/blob/main/data/skills/write-query/SKILL.md
What does the write-query skill cost to load?
SKILL.md is about 1,188 tokens. Estimated input cost per 1,000 loads: Claude Opus 5 $5.94; Claude Sonnet 5 $2.38; Claude Haiku 4.5 $1.19. Estimated input cost per 1,000 loads of SKILL.md only (characters ÷ 4). Bundled files, output tokens and execution are excluded. Prices: https://docs.anthropic.com/en/docs/about-claude/pricing
How do I install the write-query skill?
Skills CLI: npx skills add anthropics/knowledge-work-plugins --skill write-query. Claude Code: /plugin marketplace add anthropics/knowledge-work-plugins, then install the plugin from that marketplace. Download the write-query skill folder as a ZIP and upload it in Claude.ai skills settings.
Is the write-query skill safe?
No runs-scripts, network-access or shell-command flags were detected. Flags are detected automatically from the skill's files and are not a security audit; review the SKILL.md before installing.