Schema E2E Validation & Generation

关于

The Schema E2E Validation skill provides a robust framework for managing data contracts by bridging YAML-based Single Source of Truth (SSoT) schemas with live ClickHouse environments. It streamlines the development lifecycle by automating the generation of Pydantic models, SQL DDL, and Markdown documentation while ensuring all changes are validated against production-like environments using Earthly. This skill is essential for teams practicing ADR-driven development who need to maintain strict consistency between their data models and their analytical infrastructure without manual overhead.

主要功能

• YAML schema contract validation against live ClickHouse Cloud instances
• Automated generation of Pydantic models, TypedDicts, and Python types
• Instant regeneration of ClickHouse DDL and Markdown documentation
• Secure secret injection and management via Doppler integration
• Containerized workflow orchestration using Earthly and Docker/Colima
• 2 GitHub stars

使用场景

• Verifying schema changes before commit to prevent production database drift
• Synchronizing backend Python types and documentation with updated data models
• Executing end-to-end schema validation workflows in local development environments