{"repo":"obsessiondb/chkit","free":true,"listed":false,"github":"https://github.com/obsessiondb/chkit","clone":"git clone https://github.com/obsessiondb/chkit.git","description":"ClickHouse schema and migration CLI for TypeScript projects","language":"TypeScript","stars":27,"topics":["cli","clickhouse","clickhouse-migrations","database","migrations","schema","typescript"],"license":"MIT","category":"cli-tools","readme_excerpt":"chkit ClickHouse schema and migration toolkit for TypeScript and Python. Define your ClickHouse tables, views, materialized views, and dictionaries in TypeScript or Python. chkit diffs your schema, generates migration SQL, applies it safely, and keeps your dev and production databases in sync -- all from the command line. Status: beta. chkit powers production workloads and the CLI surface and schema DSL are stable. We may still make small breaking changes to UX and internal APIs before 1.0. Key Features - TypeScript-native schema definitions -- tables, views, materialized views - Automatic migration generation -- diff-based SQL from your schema changes - Safe migration execution -- preview first, destructive-operation blocking - Schema drift detection -- compare live database to expected state - CI gate command -- chkit check fails your build on pending migrations or drift - TypeScript codegen -- row types and optional Zod schemas from your schema - Plugin system -- pull, codegen, backfill, or write your own - JSON output mode -- --json on every command for scripting Quick Start Define a table in src/db/schema/example.ts : Generate and apply your first migration: Commands Command Description --------- ------------- chkit init Scaffold config and example schema chkit generate Diff schema and generate migration SQL chkit migrate Preview and apply pending migrations chkit status Show migration counts and checksum status chkit drift Compare live database to expected schema chkit ","default_branch":null,"files":null,"tree":[],"storefront":"/r/obsessiondb","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/obsessiondb/chkit/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}