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.
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.
Key capabilities
- Includes SKILL.md support
- Reusable instructions support
- Database workflows
- Data analysis
- Writing
- Database workflows use cases
- Data analysis use cases
Technical details
- 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
Explore related resources
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.
Auto-fetched from GitHub.
