Show HN: Chkit – Schema, migrations and backfills for ClickHouse (like Drizzle)

Category: database

Tags: clickhouse, schema-migration, typescript, database-tooling, drizzle-inspired

Score: 7.0/10 (Innovation: 6, Technical: 7, Documentation: 8, Utility: 7)

Chkit brings Drizzle-style schema definition and migration management to ClickHouse, letting developers define tables in TypeScript, generate reviewable SQL migrations, and detect schema drift in CI. It stands out for handling ClickHouse-specific constructs like materialized views and backfills, filling a real tooling gap for teams running ClickHouse in production.

Target audience: backend devs, data engineers, devops

Repository: https://github.com/obsessiondb/chkit · TypeScript · MIT · 42 stars

View on Hacker News