Skills
.Work. You
Rest

sqlx-patterns

Official

SQL/SQLX patterns for reliable data pipelines.

Data & Analytics#patterns#sql#deduplication#naming-conventions#sqlx#incremental#dataform
AuthorExpanly
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This skill standardizes SQL/SQLX coding patterns to ensure consistent, reliable data transformations.

Core Features & Use Cases

  • SQLX File Structure guidance for views, incremental tables, and base tables.
  • Dependency Patterns and Reference Resolution for Dataform projects.
  • Comprehensive patterns for Safe Operations, ID Normalization, Deduplication, CTEs, Window Functions, JSON handling, and Naming Conventions.
  • Real-world use case: Apply patterns to BigQuery/Dataform scoring pipelines to enforce consistency and governance.

Quick Start

Consult the documented patterns and implement them in your Dataform SQLX files to standardize transformations.

Dependency Matrix

Required Modules

None required

Components

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: sqlx-patterns
Download link: https://github.com/Expanly/expanly-claude-code-agents/archive/main.zip#sqlx-patterns

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.