🗄️
DataPython

SQL Queries

by anthropics

SQL Queries is a Data skill for Claude Code, published by anthropics in knowledge-work-plugins.

23.3K stars2.8K forkson anthropics/knowledge-work-pluginsAdded 2026/07/19Repository updated 2026/08/06
Install in seconds
Install SQL Queries
Copy SQL Queries into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.
terminal
npx degit https://github.com/anthropics/knowledge-work-plugins/tree/main/data/skills/sql-queries ~/.claude/skills/sql-queries

Requires Node.js. Downloads this skill only — not the rest of the repository — into your Claude Code skills folder.

Without Node.js

git clone https://github.com/anthropics/knowledge-work-plugins.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file
data/skills/sql-queries/SKILL.md in anthropics/knowledge-work-plugins
Installs to
~/.claude/skills/sql-queries
Collection
One of 26 skills cataloged from this repository
Category
Data812 skills

What SQL Queries 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.

SQL Queries is cataloged under Data on DirSkills.

Documentation

README

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)

-- Extract parts
EXTRACT(YEAR FROM created_at)
EXTRACT(DOW FROM created_at)  -- 0=Sunday

-- Format
TO_CHAR(created_at, 'YYYY-MM-DD')

This is the opening of the README. Read the full README on GitHub.

Frequently asked about SQL Queries

  • What else does anthropics publish alongside SQL Queries?

    SQL Queries is one of 26 skills that DirSkills catalogs from anthropics/knowledge-work-plugins, the repository it ships in. Its siblings there include Accessibility Review, Analyze Data and Bio-Research Start. Each one is a separate skill with its own page in this directory, installs the same way SQL Queries does, and is maintained by anthropics in that same repository. The rest of the collection is listed on the anthropics/knowledge-work-plugins page.

  • How does SQL Queries compare to other Data skills?

    SQL Queries ranks #92 by stars among the 812 Data skills in this catalog. The most-starred ones next to it are Benchmark Methodology, Jupyter Notebook and Solana. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of SQL Queries against them. Open each page to compare what they document and how they install.

More from anthropics/knowledge-work-plugins

SQL Queries is one of 26 skills cataloged on DirSkills from anthropics/knowledge-work-plugins.

See all 26 skills
2026/07/19

Accessibility Review

Run a WCAG 2.1 AA accessibility audit on a design or web page. Use when reviewing color contrast, keyboard navigation, touch target size, or screen reader behavior before handoff.
Quality
23.3K2.8K
📊
2026/07/19

Analyze Data

Answer data questions -- from quick lookups to full analyses. Use when looking up a single metric, investigating what's driving a trend or drop, comparing segments over time, or preparing a formal data report for stakeholders.
Data
23.3K2.8K
🧬
2026/07/19

Bio-Research Start

Set up your bio-research environment and explore available tools. Use when first getting oriented with the plugin, checking which literature, drug-discovery, or visualization MCP servers are connected, or surveying available analysis skills before starting a new project.
AI Engineering
23.3K2.8K
🧬
2026/07/19

Bioinformatics Pipelines

Run nf-core bioinformatics pipelines (rnaseq, sarek, atacseq) on sequencing data. Use for analyzing RNA-seq, WGS/WES, or ATAC-seq data from local FASTQs or public GEO/SRA datasets.
Data
23.3K2.8K
📊
2026/07/19

Build Dashboard

Build a self-contained HTML dashboard with charts, filters, and tables. Use when creating an executive overview with KPI cards, turning query results into a shareable report, building a team monitoring snapshot, or needing a browser-openable file with multiple charts and filters.
Data
23.3K2.8K
⚙️
2026/07/19

Cowork Plugin Customization

Customize a Claude Code plugin for a specific organization's tools and workflows. Use when setting up or modifying a plugin's configuration to match team conventions and services.
Automation
23.3K2.8K