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 dialect-specific syntax for Snowflake, BigQuery, Postgres, etc.
Install
npx skills add anthropics/knowledge-work-plugins --skill write-querynpx skills add anthropics/knowledge-work-plugins --skill write-query -a claude-code -gnpx skills add anthropics/knowledge-work-plugins --skill write-query -a codex -ggemini skills install https://github.com/anthropics/knowledge-work-plugins.git --path data/skills/write-querygh skill install anthropics/knowledge-work-plugins write-querygit clone --depth 1 https://github.com/anthropics/knowledge-work-plugins /tmp/anthropics__knowledge-work-plugins
mkdir -p ~/.claude/skills ~/.agents/skills
cp -R /tmp/anthropics__knowledge-work-plugins/data/skills/write-query ~/.claude/skills/write-query # Claude Code
cp -R /tmp/anthropics__knowledge-work-plugins/data/skills/write-query ~/.agents/skills/write-query # Codex, Cursor, Gemini CLI, Copilot, OpenCode