sql-queries Skill
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. Published by anthropics in knowledge-work-plugins.
Decision snapshot
Is this a fit?
Database workflows, Data analysis, Writing, Includes SKILL.md
Compatibility not yet detected.
Permission behavior not yet detected.
Copy skill directory
23 days ago · Apache-2.0 license
No specific cautions were detected. Review the source and requested permissions before installing.
What is sql-queries Skill?
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. Published by anthropics in knowledge-work-plugins. This profile combines repository metadata with install, compatibility, and usage signals so developers can quickly decide whether it fits their agent workflow before opening the source repository.
Automated repository signals based on public metadata such as recency, license, installation evidence, and adoption. These are not a security audit or endorsement. See how SkillIndex evaluates profiles.
Key capabilities
- Includes SKILL.md support
- Reusable instructions support
- Database workflows
- Data analysis
- Writing
- Database workflows use cases
- Data analysis use cases
Declared skill metadata
- Source file: data/skills/sql-queries/SKILL.md
These fields retain source and confidence evidence from the indexed SKILL.md.
Compatibility and setup
- Install or run with Copy skill directory
When to use sql-queries Skill
- Use it for database workflows.
- Use it for data analysis.
- Use it for writing.
Built with
Editorial notes
Source
- Creator: anthropics
- Repository: anthropics/knowledge-work-plugins
- Skill file: data/skills/sql-queries/SKILL.md
What it does
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.
Skill instructions
SQL Queries Skill Write correct, performant, readable SQL across all major data warehouse dialects. Dialect-Specific Reference PostgreSQL (including Aurora, RDS, Supabase, Neon) Date/time: sql -- Current date/time CURRENTDATE, CURRENTTIMESTAMP, NOW() -- Date arithmetic datecolumn + INTERVAL '7 days' datecolumn - INTERVAL '1 month' -- Truncate to period DATETRUNC('month', createdat) -- Extract parts EXTRACT(YEAR FROM createdat) EXTRACT(DOW FROM createdat) -- 0=Sunday -- Format TOCHAR(createdat, 'YYYY-MM-DD') String functions: sql -- Concatenation firstname || ' ' || lastname CONCAT(firstname, ' ', lastname) -- Pattern matching column ILIKE '%pattern%' -- case-insensitive column ~ '^regexpattern$' -- regex -- String manipulation LEFT(str, n), RIGHT(str, n) SPLITPART(str, delimiter, position) REGEXPREPLACE(str, pattern, replacement) Arrays and JSON: sql -- JSON access data-'key' -- text data-'nested'-'key' -- json data'{path,to,key}' -- nested text -- Array operations ARRAYAGG(column) ANY
Verified compatibility and discovery
Frequently asked questions
What is sql-queries?
sql-queries is a open-source AI agent skill with Copy skill directory. Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.).
Who is sql-queries best for?
sql-queries is best for reusing agent instructions, scripts, and references, database workflows, data analysis workflows, writing workflows.
How do I install sql-queries?
Install or run sql-queries using Copy skill directory. Check sql-queries for the latest setup command.
Is sql-queries actively maintained?
sql-queries may need a closer maintenance check before production use.
Project health auto-fetched from the source repository.
Maintain this resource?
Review this source-backed profile, send a correction with evidence, or link to it from your documentation. Claims verify your relationship to the project; profile facts still require source evidence and editorial review.
