data-validation-join-explosion
About
This skill helps detect and prevent join explosion in SQL queries, where many-to-many joins silently multiply rows and distort aggregations. It provides methods to identify the issue by comparing row counts and recommends fixes like using `COUNT(DISTINCT)`. Use it when validating data pipelines or analyzing query results to ensure join logic isn't inflating metrics.
Quick Install
Claude Code
Recommendednpx skills add vamseeachanta/workspace-hub -a claude-code/plugin add https://github.com/vamseeachanta/workspace-hubgit clone https://github.com/vamseeachanta/workspace-hub.git ~/.claude/skills/data-validation-join-explosionCopy and paste this command in Claude Code to install this skill
GitHub Repository
Related Skills
data-warehouse-designer
OtherThis skill designs dimensional models and fact tables for data warehouse projects. It clarifies requirements, reviews system constraints, and selects appropriate architectural patterns. The outputs include implementation plans, specifications, and validation steps for developers.
data-catalog-creator
OtherThe data-catalog-creator skill helps developers design and plan systems for managing metadata, data lineage, and discovery. It generates implementation plans, architectural specs, and required artifacts based on your stack and constraints. Use this skill when you need to establish or improve data governance, compliance, and discoverability within your infrastructure.
data-pipeline-builder
OtherThe data-pipeline-builder skill designs and plans orchestration pipelines with a focus on idempotency. It's used when you need to create data workflows, producing artifacts like specs, configs, and validation steps. Developers should use it after confirming requirements and necessary approvals.
data-quality-framework
OtherThis skill helps developers implement data quality checks through validation, profiling, and anomaly detection. Use it when you need to design or plan a data quality system within a given architecture and stack. It guides you from clarifying requirements to producing implementation artifacts and acceptance criteria.