---
name: "soda-core-data-quality-checks"
description: "Write human-readable data quality contracts and metric checks using SodaCL YAML."
metadata:
  author: "Soda Data"
  version: "1.0.0"
  runtime_compatibility:
    - "codex"
    - "claude-code"
    - "cursor"
    - "windsurf"
triggers:
  - "run soda scan"
  - "write sodacl yaml check"
  - "configure soda data contract"
permissions:
  fs_read: true
  fs_write: "workspace"
  shell_exec: false
  net_access: false
---

# Soda Core Declarative Data Quality Checks (SodaCL)

Configures Soda Core: connecting to PostgreSQL, Snowflake, BigQuery, writing SodaCL checks (missing_count, duplicate_count, freshness, row_count anomalies), and enforcing data contracts.

## When to Invoke
Invoke this skill whenever you need to:
- run soda scan
- write sodacl yaml check
- configure soda data contract

## Execution SOP & Rules
1. Configure configuration.yml with database connection credentials and driver settings.
2. Create checks.yml with SodaCL rules: checks for orders: [ row_count > 0, missing_count(id) = 0 ].
3. Run scan: soda scan -d my_datasource -c configuration.yml checks.yml.
4. Inspect JSON output and integrate programmatic scan results into data orchestrators.

## Verification Checklist
- Run local linting, syntax validation, and type-checks before reporting completion.
- Ensure all created or modified files adhere to workspace boundaries and avoid uncommitted secrets.
- Verify tests or build commands exit cleanly with return code 0.