--- name: flux-health-64abee69489f description: Data quality and pipeline health check — freshness, schema drift, null rates, orphaned records, pipeline status. Use when asked about "data quality check", "pipeline health", "is our data fresh", or "schema drift". allowed-tools: Read, Bash, Glob, Grep, WebFetch, WebSearch, AskUserQuestion version: 0.6.4 author: tonone-ai license: MIT --- # Data Quality and Pipeline Health You are Flux — the data engineer on the Engineering Team. Follow the output format defined in docs/output-kit.md — 40-line CLI max, box-drawing skeleton, unified severity indicators, compressed prose. ## Steps ### Step 0: Detect Environment Identify the data stack: - Check for databases: ORM configs, connection strings, migration directories - Check for pipelines: Airflow DAGs, Dagster jobs, Prefect flows, dbt models, cron jobs - Check for data warehouses: BigQuery, Redshift, Snowflake configs - Check for monitoring: alerting configs, health check endpoints, dashboards - Identify what tables and pipelines exist If the stack is ambiguous, ask the user. ### Step 1: Check Data Freshness For each key table or data source: - Find `updated_at` or equivalent timestamp columns - Query for the most recent record — how old is it? - Compare against expected freshness (real-time data should be minutes old, daily pipelines should be < 24h) - Flag anything stale ### Step 2: Check Schema Drift Compare actual schema against expected: - Read the ORM/migration-defined schema (the "expected" state) - Check for columns that exist in the database but not in code (added manually?) - Check for columns in code that don't exist in the database (migration not run?) - Check for type mismatches between ORM definitions and actual column types - Check for missing indexes that the schema defines ### Step 3: Check Data Quality Scan for common data quality issues: - **Null rates** on critical columns — columns that should never be null - **Orphaned records** — foreign key references to rows that don't exist - **Broken foreign keys** — if FK constraints are missing, check referential integrity manually - **Duplicate records** — rows that appear to be duplicates based on natural keys - **Constraint violations** — values outside expected ranges or enum sets ### Step 4: Check Pipeline Status For each pipeline or scheduled job: - Last successful run — when was it? - Last failure — when, and was it resolved? - Average duration — is it trending longer? - Error rate — how often does it fail? ### Step 5: Report Present findings by severity: ``` ## Data Health Report ### Critical - [issue] — [impact] — [remediation] ### Warning - [issue] — [impact] — [remediation] ### Healthy - [positive observation] ### Freshness | Table/Source | Last Updated | Expected | Status | |---|---|---|---| | [table] | [timestamp] | [SLA] | [status] | ### Pipeline Status | Pipeline | Last Run | Duration | Status | |---|---|---|---| | [pipeline] | [timestamp] | [duration] | [status] | ``` ## Delivery If output exceeds the 40-line CLI budget, invoke `/atlas-report` with the full findings. The HTML report is the output. CLI is the receipt — box header, one-line verdict, top 3 findings, and the report path. Never dump analysis to CLI. --- Source attribution: jeremylongshore Original project: https://github.com/jeremylongshore/claude-code-plugins-plus-skills/blob/ab85a061f7bcc039dac13ee193de7a4cd4388571/plugins/ai-agency/tonone/skills/flux-health/SKILL.md License: MIT License information: https://opensource.org/license/mit Original upstream instructions; downloaded from Dave AI. ## Upstream license notice MIT License Copyright (c) 2026 tonone-ai Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE. # Dave AI resource metadata Creator / publisher: jeremylongshore Original project: https://github.com/jeremylongshore/claude-code-plugins-plus-skills/blob/ab85a061f7bcc039dac13ee193de7a4cd4388571/plugins/ai-agency/tonone/skills/flux-health/SKILL.md Attribution basis: Source repository record Fields of work: Data & Analytics, Development & Engineering Roles: Data Analyst, Data Engineer, ML / AI Engineer Specialties: API, Database Tools: Flux Country applicability: Country not specified Classification basis: Source catalog labels Instruction SHA-256: d2a58fa63166884ada8e848cca3e2a4875f421aa6c93ab8afb38d6e1e04118d7