Works with the AI Agents you already use
data quality rules and monitoring
Testing and monitoring data quality manually is error-prone and slow.
$2.99
data quality rules and monitoring
Example session with this skill installed
Run a quality check on the 'user_onboarding_v2' sample. I've attached the schema with not_null rules for email and unique constraints on user_id. Compare against the baseline for drift.
- Read your context and instructions
- Compiled the data quality rules
The data quality execution for user_onboarding_v2 is complete. The run resulted in a needs_review status due to an alert-level failure rate in the uniqueness dimension.
Data Quality Report - user_onboarding_v2, 2023-10-27
1. Scope, sources and assumptions
- Sources: E1 (CSV upload)
- Dataset Approval: Approved by
data_admin_01 - Records: 1,000 supplied, 1,000 analysed, 0 excluded.
- Assumptions:
warn_ratedefaults to 0.01 andalert_rateto 0.05 per user_supplied configuration.
2. Quality ruleset
| Rule | Dimension | Type | Severity | Warn | Alert |
|---|---|---|---|---|---|
| R001 | Completeness | not_null | High | 0.00 | 0.01 |
| R002 | Uniqueness | unique | Critical | 0.00 | 0.00 |
3. Rule results and alerts
| Rule | Status | Evaluated | Failing | Failure rate |
|---|---|---|---|---|
| R001 | ok | 1000 | 2 | 0.0020 |
| R002 | alert | 1000 | 12 | 0.0120 |
Overall pass rate: 98.60 percent.
SLA Status: Breach detected on R002 (Uniqueness).
4. Exception feed
| Rule | Record | Reason | Observed |
|---|---|---|---|
| R002 | REC_089 | Duplicate ID | user_99 |
| R002 | REC_142 | Duplicate ID | user_99 |
5. Trend dashboard
No history was supplied.
6. Distribution drift
| Check | Column | Metric | Value | Warn | Alert | Status |
|---|---|---|---|---|---|---|
| D001 | signup_source | dist_shift | 0.08 | 0.05 | 0.10 | warn |
7. Remediation queue (draft)
| Priority | Level | Source | Id | Severity | Action |
|---|---|---|---|---|---|
| 1 | Block | R002 | user_99 | Critical | Management decision required |
8. Limitations and items for human review
- Information gap — organizational validation required: No historical trend data available for this source.
- [Computed result] The signup_source distribution has shifted significantly toward 'referral' compared to the baseline.
Analytical estimate — validation required: The 1.2% duplication rate suggests a potential race condition in the upstream registration service.
This analysis supports, and does not replace, the judgment of the accountable data owner.
Next steps
- Review the remediation queue to resolve duplicate
user_idrecords. - Investigate the
signup_sourcedrift to confirm if marketing changes explain the shift. - Upload historical run data to enable trend analysis.
Connects securely to your tools. The creator never sees your data.
About this skill
Testing and monitoring data quality manually is error-prone and slow. This skill turns your schemas, business constraints, and record samples into an executable, deterministic quality ruleset with automated drift and trend detection.
What it does
- Rule execution runs completeness, validity, uniqueness, integrity, timeliness, and consistency checks.
- Alerting & thresholds flags violations based on specific warn and alert rate tolerances you define.
- Drift & trend analysis compares current samples against baselines and historical failure rates to find regressions.
- Exception reporting generates a filtered feed of failing records and a prioritized draft remediation queue.
- Governance logging tracks dataset approvals, source references (E-numbers), and consent-based exclusions.
How it works
- Define the request by providing a dataset sample, schema, and quality expectations in a
request.jsonformat. - Execute the validator using the
scripts/run.pytool to perform exact arithmetic on the record sample. - Review the envelope to check for SLA breaches, status warnings, or rules excluded due to access scope.
- Iterate on remediation using the draft queue to identify records requiring management intervention or correction.
Frameworks & tools
This skill uses a Python-based execution environment (python3) to run deterministic validation logic. It interfaces with JSON schemas for input/output structure and generates standard Markdown reports for data governance.
Why this beats prompting it yourself
Generic prompts often hallucinate statistics or fail at precision arithmetic across large record samples. This skill uses a dedicated script to ensure every failure rate, drift metric, and trend slope is calculated with exact logic rather than LLM estimation.
Use cases
- Validating a new batch of ETL output against referential integrity and format rules.
- Monitoring for distribution drift in production datasets compared to a baseline.
- Generating a prioritized exception feed for data stewards to review and remediate.
- Tracking data quality trends across multiple runs to identify systemic pipeline issues.
Known limitations
This skill is for decision support only and cannot perform deletions or writes. It requires pre-approved datasets with source references and handles samples rather than full production databases.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse All Claude Skills.
Decision support only; no direct data cleaning/deletion. Requires dataset approval and source references. Analysis is limited to the provided record sample.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before buying a skill.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 2 days ago