Does it support advanced analytics like window functions?

Absolutely. It provides standardized patterns for ranking, running totals, moving averages, lead/lag operations, and percent-of-total calculations.

Which SQL dialects does this skill support?

The skill supports all major data warehouses and databases including PostgreSQL, Snowflake, Google BigQuery, Amazon Redshift, and Databricks SQL.

Can it help debug SQL errors?

Yes, it provides a systematic approach to debugging common issues like syntax errors, type mismatches, ambiguous columns, and division-by-zero errors.

How does it handle non-relational data like JSON?

It contains specific syntax for each dialect to query semi-structured data, including JSON path navigation in Postgres and VARIANT flattening in Snowflake.

Can this skill help reduce my cloud data warehouse costs?

Yes, it includes dialect-specific performance tips, such as partition pruning for BigQuery and clustering keys for Snowflake, to minimize data scanned and compute used.

SQL Query Expert

Name: SQL Query Expert
Author: anthropics

byanthropics

•

8,000

•

数据库管理

Writes, optimizes, and translates performant SQL queries across major data warehouse dialects like Snowflake, BigQuery, and PostgreSQL.

The SQL Queries skill equips Claude with the specialized knowledge required to function as a senior data engineer or analyst. It provides precise, dialect-specific syntax for all major data platforms, including Snowflake, Google BigQuery, Amazon Redshift, PostgreSQL, and Databricks. Beyond simple query generation, this skill offers sophisticated implementation patterns for complex analytical tasks—such as cohort retention, funnel analysis, and window functions—while providing expert guidance on query optimization, semi-structured data handling, and cross-dialect translation.

主要功能

018,000 GitHub stars

02Advanced analytical patterns for cohort retention and funnel analysis

03Dialect-specific performance optimization and indexing strategies

04Comprehensive SQL debugging and cross-platform query translation

05Multi-dialect support for Snowflake, BigQuery, Redshift, PostgreSQL, and Databricks

06Expert handling of semi-structured data, JSON, and arrays

使用场景

01Refactoring slow-running warehouse queries to reduce compute costs and execution time

02Building high-performance analytical dashboards using window functions and CTEs

03Translating complex legacy PostgreSQL queries into optimized BigQuery or Snowflake syntax

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add anthropics/knowledge-work-plugins sql-queries

For use in Claude.ai and ChatGPT

Download Skill