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.

主な機能

01YAML schema contract validation against live ClickHouse Cloud instances

02Automated generation of Pydantic models, TypedDicts, and Python types

03Instant regeneration of ClickHouse DDL and Markdown documentation

04Secure secret injection and management via Doppler integration

05Containerized workflow orchestration using Earthly and Docker/Colima

062 GitHub stars

ユースケース

01Verifying schema changes before commit to prevent production database drift

02Synchronizing backend Python types and documentation with updated data models

03Executing end-to-end schema validation workflows in local development environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add terrylica/cc-skills schema-e2e-validation

For use in Claude.ai and ChatGPT

Download Skill