Data Quality Checker
Generate dbt tests and Great Expectations suites to validate data pipelines
What You Can Do
You can analyze your data structure and content to identify quality risks, then generate production-ready dbt tests and Great Expectations validation suites. Claude creates schema conformance checks, uniqueness constraints, referential integrity validations, completeness gap detection, and data freshness monitoring—all in code-first formats (YAML and Python) that integrate seamlessly with modern data stacks.
Features
detects data type mismatches, unexpected columns, and structural anomalies
enforces foreign key relationships and cross-table dependencies
identifies missing values and incomplete records across datasets
flags stale data and latency issues in your pipelines
creates YAML-based tests for uniqueness, not-null, and custom SQL assertions
builds statistical and rule-based validation profiles in Python
enforces business logic constraints on numeric, categorical, and temporal data
sets up statistical thresholds for outliers and distribution changes
Example Output
Example 1: dbt Tests for Orders Table
version: 2
models:
- name: orders
columns:
- name: order_id
tests:
- unique
- not_null
- name: customer_id
tests:
- relationships:
to: ref('customers')
field: customer_id
- name: order_date
tests:
- dbt_utils.accepted_values:
values: ['2024-01-01', '2024-01-02']
Example 2: Great Expectations Checkpoint
validation_results = context.run_checkpoint(
checkpoint_name='orders_validation',
validations=[
{'expectation_suite_name': 'orders.full'},
{'batch_request': {'datasource_name': 'postgres', 'data_connector_name': 'default'}}
]
)
Example 3: Data Freshness Alert Detects orders table not updated in last 24 hours and flags upstream dependency failures in your pipeline orchestrator.
What's Included
- SKILL.md instruction file with comprehensive framework for data quality rule generation:
- dbt test templates for schema, uniqueness, referential integrity, and custom SQL validations:
- Great Expectations suite builder: Python configuration templates for statistical profiling
- Data freshness checklist: timestamp validation patterns and staleness detection queries
- Quality rules documentation: YAML and Python code-first reference formats for version control
Who It's For
- Data engineers building or maintaining dbt projects and analytics engineering workflows
- Analytics engineers establishing data governance and quality frameworks
- Data quality specialists implementing validation suites across enterprise pipelines
- Data platform teams inheriting legacy pipelines and establishing baseline quality controls
- DevOps and infrastructure engineers automating data validation in CI/CD workflows
Best For
- Creating dbt test suites for new fact and dimension tables in dimensional warehouses
- Generating Great Expectations validation profiles from existing data structures
- Implementing referential integrity and schema conformance checks in inherited pipelines
- Building data freshness monitors and staleness detection rules for real-time dashboards
- Establishing completeness and value range constraints for regulatory compliance workflows
You might also like
Prepare comprehensive expert witness reports and testimony that meet Daubert standards for admissibility and withstand cross-examination scrutiny. You'll get structured case analyses integrating psychological assessments, relevant case law citations, and anticipated counterarguments. The skill helps you document your forensic opinions with the legal rigor required in criminal, civil, and family law proceedings.
by skillslib
You design robust motion control systems by generating control architectures, tuning PID and state-space controllers, and analyzing stability margins with detailed performance predictions. You'll get transfer functions, tuned gains, frequency response plots, real-time constraint validation, and code templates ready for implementation in MATLAB or Python.
by skillslib
You can systematically evaluate architectural options by building decision matrices, identifying trade-offs, and documenting design rationale. This skill generates comparison frameworks, risk assessments, and architecture decision records (ADRs) that help you choose between competing approaches based on concrete criteria like performance, scalability, cost, and team capabilities.
by skillslib
You provide a single core insight or perspective, and this skill transforms it into a complete, coordinated thought leadership content suite across every major channel. It generates optimized articles, social threads, email sequences, presentation outlines, and more—all reinforcing the same core message while adapting to each platform's unique audience and format. Every piece maintains strategic consistency while maximizing reach and engagement.
by skillslib
Analyze commercial insurance applications by extracting risk factors, evaluating loss history and industry exposure, and generating structured underwriting recommendations with standardized documentation. You'll reduce review time per application, ensure consistent decision criteria across your team, and maintain compliant audit trails for every underwriting action.
by skillslib
You can systematically diagnose flow problems in your Kanban board by analyzing stage-by-stage work accumulation, cycle time patterns, and throughput trends. The skill generates flow metrics dashboards, identifies capacity constraints, forecasts delivery dates based on historical data, and produces prioritized improvement recommendations with estimated impact—giving you objective evidence to guide WIP adjustments, process changes, and retrospective discussions.
by skillslib
You can map your game's features to certification requirements across ESRB, PEGI, USK, CLASSIND, and platform-specific standards simultaneously. The skill generates compliant test cases that prove adherence to each body's content and technical standards, tracks certification status to identify gaps before submission, and documents evidence trails for audits and appeals. This prevents costly certification rejections (2-8 week delays, $2,500-$10,000+ resubmission fees) by ensuring comprehensive compliance documentation from the QA phase onward.
by skillslib
You can design culturally appropriate survey instruments tailored to international development contexts, analyze mixed-methods data by integrating quantitative findings with qualitative insights, and implement robust data quality management systems for your field operations. Claude helps you create survey templates with adaptive logic, develop validation protocols, and produce data quality reports that highlight issues before analysis begins.
by skillslib