Data Quality Test Framework Builder
Generate Data Quality Tests & Anomaly Detection for dbt
What You Can Do
You'll build comprehensive data quality test suites that validate transformations, detect anomalies, and document standards across your dbt and SQL pipelines. This skill generates production-ready test configurations, anomaly detection protocols, and validation rules that catch data issues before they impact analytics.
Features
Automatically create YAML test configurations for freshness, completeness, uniqueness, and relationships
Build statistical methods to flag outliers, value distributions, and unexpected data patterns
Generate parameterized SQL queries that validate data ranges, constraints, and business logic
Create schedules and thresholds to monitor when tables were last updated and alert on staleness
Auto-generate test descriptions, ownership, SLAs, and remediation playbooks for your data quality standards
Identify which tables and columns lack tests and prioritize high-impact validation rules
Generate tests for dbt Cloud, Snowflake, BigQuery, PostgreSQL, and other SQL platforms
Build notification configurations that route data quality incidents to the right team members
Example Output
Example 1: dbt Test Suite Configuration
version: 2
models:
- name: customers
columns:
- name: customer_id
tests:
- unique
- not_null
- name: email
tests:
- unique
- matches_pattern:
pattern: '^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\\.[a-zA-Z]{2,}$'
tests:
- dbt_utils.recency:
datepart: day
interval: 1
field_name: updated_at
Example 2: Anomaly Detection Query
WITH stats AS (
SELECT
AVG(order_value) as mean_value,
STDDEV_POP(order_value) as std_dev
FROM orders
WHERE DATE(created_at) >= CURRENT_DATE - INTERVAL 30 DAY
)
SELECT
order_id,
order_value,
ROUND((order_value - stats.mean_value) / stats.std_dev, 2) as z_score
FROM orders, stats
WHERE DATE(created_at) = CURRENT_DATE
AND ABS((order_value - stats.mean_value) / stats.std_dev) > 3
Example 3: Test Report
✓ Completeness: 99.8% of required fields populated
✓ Freshness: Last update 2 hours ago (within 4-hour SLA)
✗ Anomalies: 12 outlier orders detected (values > 3σ)
⚠ Coverage: 18/22 columns tested (82%)
What's Included
- SKILL.md: Full framework for building data quality tests
- dbt test templates: Pre-built test patterns for common validation scenarios
- SQL validation library: Reusable queries for constraint checks, distribution analysis, and freshness monitoring
- Anomaly detection playbook: Statistical methods (z-score, IQR, seasonal decomposition) with implementation examples
- Test documentation generator: Template for auto-generating test ownership, SLAs, and remediation runbooks
- Multi-warehouse guide: Syntax and best practices for Snowflake, BigQuery, PostgreSQL, Redshift, and Databricks
Who It's For
- Data engineers — Build robust data quality frameworks for ETL/ELT pipelines and dbt projects
- Analytics engineers — Validate transformations and ensure data reliability for downstream analytics
- QA engineers — Create automated data validation suites that test data pipelines like you'd test code
- Data analysts — Document and enforce data quality standards to reduce data quality incidents
- Analytics platform teams — Implement organization-wide data quality governance and monitoring
Best For
- Setting up production dbt test suites from scratch
- Building anomaly detection for high-volume transaction tables
- Automating data validation across multiple warehouses
- Creating SLA-driven data quality dashboards and alerts
- Documenting and scaling data quality standards across teams
You might also like
This skill helps you systematically diagnose failures in distributed ML training and serving infrastructure. You provide system logs, metrics, and error traces, and Claude performs structured root-cause analysis to identify the underlying issue—whether it's resource exhaustion, distributed system deadlock, data pipeline corruption, or model serving misconfiguration. You get a detailed diagnosis with remediation steps ranked by likelihood and implementation effort.
by moonwell-fi
You can systematically diagnose why your RAG system isn't returning relevant results and identify specific misalignments between queries and context. This skill walks you through analyzing retrieval quality, scoring context relevance, and optimizing prompt-retrieval alignment to improve your RAG accuracy. You'll get concrete, actionable recommendations for fixing bottlenecks in your pipeline.
by moonwell-fi
You'll handle difficult guest conversations with structured communication templates that de-escalate tension while protecting your property. Generate professional damage assessments, complaint responses, and resolution protocols that document interactions clearly and mitigate liability. Create personalized communication strategies tailored to each guest situation, from minor maintenance requests to serious damage claims.
by moonwell-fi
You can create well-structured semantic layer specifications that define business metrics, dimensions, and relationships from your raw data schemas. This skill validates your semantic layer design for consistency, identifies naming issues, detects redundancy, and generates comprehensive documentation and data dictionaries that keep your entire team aligned.
by moonwell-fi
Systematically evaluate your Claude prompts using quantitative scoring frameworks to identify weaknesses in clarity, task alignment, and output quality. You'll receive detailed optimization recommendations with A/B testing guidance to improve prompt effectiveness and consistency across different use cases and input variations.
by moonwell-fi
You can prepare your domain-specific datasets, train fine-tuned Claude models optimized for your use case, benchmark performance against base models, and deploy production-ready custom models. This skill automates the entire fine-tuning pipeline from raw data to live inference, complete with cost-benefit analysis and version control.
by moonwell-fi
You get structured guidance for designing controlled experiments, selecting appropriate metrics, and analyzing results with statistical rigor. Claude helps you identify confounding variables, calculate required sample sizes, interpret statistical significance, and document methodology for reproducible benchmarking that stands up to scrutiny.
by moonwell-fi
This skill transforms high-level feature requests into actionable implementation plans by conducting deep requirement interviews, analyzing existing codebases (or planning greenfield projects), and producing comprehensive handoff documents. It distinguishes between brownfield development (with existing code to integrate) and greenfield projects (starting from scratch), ensuring your technical strategy accounts for your actual constraints and patterns.
by moonwell-fi