SQL Queries
Data & Analyticsby anthropics
3/3 audits passApache-2.0
Write correct, performant SQL across all major data warehouse dialects (Snowflake, BigQuery, Databricks, PostgreSQL, etc.).
SQL Queries is a dialect reference and pattern library for writing correct, readable warehouse SQL. For PostgreSQL (including Aurora, RDS, Supabase and Neon), Snowflake, BigQuery, Redshift and Databricks it lists the date and time functions, string and pattern matching, JSON, array and semi-structured access, and the performance tips specific to each engine, such as filtering on partition columns in BigQuery, clustering keys in Snowflake and Delta Lake features in Databricks.
The common-patterns section covers window functions, CTEs for readability, cohort retention, funnel analysis and deduplication. A debugging checklist walks through the usual failures: dialect-specific syntax, column-not-found and case sensitivity, type mismatches that need an explicit cast, division by zero handled with NULLIF, ambiguous columns in joins and GROUP BY errors. Use it when writing analytical queries, translating a query between dialects or tidying a slow one. It is background knowledge Claude applies rather than a slash command, and it does not run queries itself.
In BusinessMCP, when a workspace has connected its own database, the AI business analyst can use this playbook while writing queries against it through read-only access, and the same guidance reaches Claude, Cursor or ChatGPT over the workspace's hosted MCP endpoint.
What you can do with it
- Write a cohort retention query in the warehouse's own dialect
- Translate a PostgreSQL query to BigQuery or Snowflake syntax
- Build a funnel analysis with CTEs and window functions
- Debug a failing query using the dialect error checklist
Run it on your business data
Imported into BusinessMCP, SQL Queries becomes a playbook your AI business analyst applies to your web analytics, funnels and connected databases.
Use SQL Queries in BusinessMCPInstall it in a coding agent
One command adds SQL Queries to your project.
npx skills add https://github.com/anthropics/knowledge-work-plugins --skill sql-queriesHow we vetted it
- Source
- anthropics/knowledge-work-plugins at da38ec1
- Licence
- Apache-2.0
- Security audits (skills.sh)
- Gen Agent Trust Hub: Pass · Socket: Pass · Snyk: Pass
- Bundled scripts
- None, instructions only
Checked 2026-09-25 against its skills.sh listing. How we vet skills
Related skills
All skillsSQL Optimization Patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.
Explore Data
Profile and explore a dataset to understand its shape, quality, and patterns. Use when encountering a new table or file, checking null rates and column distributions, spotting data quality issues like duplicates or…
PostgreSQL Table Design
Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
Frequently asked questions
Which SQL dialects does it cover?
PostgreSQL (including Aurora, RDS, Supabase and Neon), Snowflake, BigQuery, Redshift and Databricks SQL.
Does the skill execute queries?
No. It is reference guidance for writing and debugging SQL. Running a query depends on whatever database connection the agent has.
How do I install SQL Queries?
Run `npx skills add anthropics/knowledge-work-plugins --skill sql-queries`, or import it from the BusinessMCP dashboard to use it as a playbook in your workspace.