{"repo":"arsura/clicko","free":true,"listed":false,"github":"https://github.com/arsura/clicko","clone":"git clone https://github.com/arsura/clicko.git","description":"ClickHouse migration tool with cluster support, Go library and CLI","language":"Go","stars":11,"topics":["clickhouse","database-migration","go","golang","migration","migrator"],"license":"MIT","category":"self-hosted-apps","readme_excerpt":"clicko A ClickHouse migration tool built for self-hosted sharded clusters, inspired by pressly/goose. Works with ClickHouse Cloud too. Features - ON CLUSTER support. DDL propagates across all nodes; DELETE mutations run with mutations sync=2 . - Engine selection. Pick the engine for the migration tracking table: MergeTree standalone, ReplicatedMergeTree in cluster mode, or your own via --engine . - Insert quorum. --insert-quorum guarantees migration records reach N replicas before being marked applied. - SQL and Go migrations. Plain .sql files or Go functions, with --dry-run for both. Quick start Keep credentials out of your shell history. The URI contains a password, and anything passed as a command-line argument is visible in the process list ( ps ) and saved to shell history. Prefer the CLICKO URI environment variable, which clicko reads automatically when --uri is omitted: SQL migration files follow {version} {description}.{up down}.sql : ClickHouse Cloud: replication is managed for you, so skip --cluster , --engine , and --insert-quorum entirely: CLI reference Command Description --- --- up / up-to Apply pending migrations (all, or up to a version) down / down-to Rollback the last migration (or down to a version), skipping any forward-only migration along the way reset Rollback all applied migrations, skipping any forward-only migration along the way status Show migration status Flag Default Description --- --- --- --uri (required) Connection URI, e.g. clickhouse://user:","default_branch":null,"files":null,"tree":[],"storefront":"/r/arsura","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/arsura/clicko/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."}