Summary
This is the SQL reference you'll actually use when context-switching between warehouses. It covers the annoying dialect differences that trip you up: date arithmetic syntax, JSON access patterns, case sensitivity quirks. The dialect-specific sections for Snowflake, BigQuery, Postgres, Redshift, and Databricks are genuinely helpful, especially the performance tips like remembering that BigQuery bills per byte scanned or that Snowflake uses clustering keys instead of indexes. The common patterns section shows window functions and CTEs with real examples. It's comprehensive without being a full manual, which means you get answers fast when you're writing a query and can't remember if it's DATEADD or DATE_ADD in this particular warehouse.
Install to Claude Code
npx -y skills add anthropics/knowledge-work-plugins --skill sql-queries --agent claude-codeInstalls into .claude/skills of the current project.
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →
Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →
Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →
On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →
Files
SKILL.md
Select a file.
Featured
Keep your Mac awake while Claude Code and 40+ AI agents run. Sleeps when they're idle.
One time payment $9 →Integrate web data into your AI product. One API to scrape website & brand data.
Get API Key Now →Agent, run crypto. Access onchain data & trade routes via 1inch.
Install now →On Capafy, your Skill runs online 24/7 as an agent product, and you get paid every time someone uses it.
Start earning →Categories
