effective-sql
CommunityWrite maintainable SQL with clear CTE pipelines.
Authorgwenwindflower
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Non-trivial SQL often becomes hard to read and maintain; this skill guides you to structure queries using a consistent CTE pipeline to improve readability, testability, and reuse.
Core Features & Use Cases
- Import CTEs: pull in only the data you need and reduce early processing.
- Transformation CTEs: chain small, named steps for clarity and maintainability.
- Output CTE: expose a clean final schema and keep logic above it. Use cases include building pipelines for data warehousing, incremental transformations, and reusable query templates.
Quick Start
Define import, transformation, and output CTEs, then select from the final CTE.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 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: effective-sql Download link: https://github.com/gwenwindflower/dotfiles/archive/main.zip#effective-sql 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 471,000+ vetted skills library on demand.