What is the primary purpose of this Claude Code skill?

This skill automates the validation of YAML-based schemas against live ClickHouse databases and regenerates associated code artifacts like SQL DDL and Python types.

Can I use this skill to design a new ClickHouse schema?

This skill is focused on validation and artifact generation. For the design and optimization of ClickHouse schemas, it is recommended to use the clickhouse-architect skill first.

Does this skill require external software to run?

Yes, it requires Earthly for workflow orchestration, Docker (or Colima) for the build runtime, and Doppler if you are running tests that require secrets.

How does the skill handle secrets for ClickHouse Cloud?

It uses a specialized wrapper script to inject secrets from Doppler, ensuring sensitive credentials like CLICKHOUSE_PASSWORD are never stored in plaintext within the repository.

Which artifacts are produced by the generation commands?

The skill generates Pydantic models in the types directory, ClickHouse SQL DDL files in the ddl directory, and Markdown documentation in the docs directory.

Schema E2E Validation & Generation

Name: Schema E2E Validation & Generation
Author: terrylica

byterrylica

•

データベース管理

Automates YAML schema validation, ClickHouse contract testing, and code generation using Earthly and Docker.

概要

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

概要

主な機能

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