clickhouse.build: An agentic CLI to accelerate Postgres apps with ClickHouse

clickhouse.build is an open-source, command-line interface tool designed to integrate ClickHouse into existing Postgres-backed TypeScript applications, enhancing analytical workloads by leveraging the strengths of both databases. It functions by scanning the codebase for analytical queries, identifying necessary tables, and automatically syncing these tables to ClickHouse Cloud using the ClickPipes API, while maintaining backward compatibility through a feature flag. Developed in collaboration with AWS Prototyping and Cloud Engineering, the tool utilizes multiple agents, including a scanner, data migrator, and code migrator, to facilitate the transition to a Postgres+ClickHouse architecture. Each agent plays a specific role in identifying queries, migrating relevant data, and updating code, while a QA sub-agent ensures the quality of changes. By using clickhouse.build, users can quickly achieve a proof of concept, allowing them to evaluate their application's performance with this dual-database backend. The project is open-source, inviting contributions and feedback from the community, with aspirations to expand support to other programming languages and databases in the future.