后端与数据库

sql-queries

Name: sql-queries
Author: anthropics

anthropics/know…-plugins

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.

4505 次安装
3.4万星标
收录于 2026.01.31

安装命令

$ npx skills add https://github.com/anthropics/knowledge-work-plugins --skill sql-queries

SKILL.md

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:

-- Current date/time
CURRENT_DATE, CURRENT_TIMESTAMP, NOW()

-- Date arithmetic
date_column + INTERVAL '7 days'
date_column - INTERVAL '1 month'

-- Truncate to period
DATE_TRUNC('month', created_at)

SKILL.md

SQL Queries Skill

Dialect-Specific Reference

PostgreSQL (including Aurora, RDS, Supabase, Neon)

相关 Skills