sql-queries
Write correct, performant SQL across all major data warehouse dialects
by anthropicsFree
Description
Sql-queries is an agent skill for writing correct and readable SQL across the major data warehouse dialects, including Snowflake, BigQuery, Databricks and PostgreSQL. It keeps dialect-specific reference notes so that functions behave as they should on each platform. The PostgreSQL section, which also covers Aurora, RDS, Supabase and Neon, shows the syntax for current date and time, date arithmetic with intervals, and truncating a timestamp to a period such as the month. The skill is for analysts and engineers who write queries against a warehouse or a Postgres database and want the syntax checked for the dialect they use. It is part of Anthropic's knowledge-work plugins.…
Highlights
- Covers Snowflake, BigQuery, Databricks and PostgreSQL
- Dialect-specific reference for dates, intervals and truncation
- Includes PostgreSQL notes for Aurora, RDS, Supabase and Neon
- Aims for correct and efficient queries
Ratings & Reviews
No ratings yet
Be the first to rate sql-queries.
People also visit
postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing
postgresql-optimization
Expert guidance on PostgreSQL-specific features, optimization patterns
snowflake-semanticview
Build and validate Snowflake semantic views using Snowflake CLI
sql-queries FAQ
Which databases does it cover?
Major data warehouses including Snowflake, BigQuery and Databricks, and PostgreSQL with notes for Aurora, RDS, Supabase and Neon.
What kind of help does it give?
Dialect-correct SQL for queries, with reference syntax for date and time functions and other platform-specific features.
Who is it for?
Data analysts and engineers who write SQL against a warehouse or a Postgres database.
How do I install it?
Run npx skills add https://github.com/anthropics/knowledge-work-plugins --skill sql-queries in your terminal.
Is it free?
Yes. The skill is listed as free on skills.sh.
What security audits has it passed?
skills.sh lists three audits: Gen Agent Trust Hub Pass, Socket Pass and Snyk Pass.
What are the best sql-queries alternatives?
Popular alternatives to sql-queries include write-query, sql-queries and postgres-patterns. See all sql-queries alternatives