sql-queries
CommunityWrite SQL across all dialects.
Author8GG-Git
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill helps you write correct, performant, and readable SQL queries across a wide variety of database dialects, saving you time and preventing errors.
Core Features & Use Cases
- Cross-Dialect Support: Provides syntax and best practices for PostgreSQL, Snowflake, BigQuery, Redshift, and Databricks SQL.
- Performance Optimization: Offers tips for optimizing query speed and reducing resource consumption.
- Common Patterns: Includes examples for window functions, CTEs, cohort retention, funnel analysis, and deduplication.
- Use Case: You need to write a complex analytical query involving window functions and CTEs for a BigQuery table, but you're unsure about the exact syntax. This Skill provides a clear template and guidance.
Quick Start
Use the sql-queries skill to write a PostgreSQL query that calculates the 7-day moving average of daily revenue.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: sql-queries Download link: https://github.com/8GG-Git/knowledge-work-plugins/archive/main.zip#sql-queries Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.