Show HN: Insert-tools – bulk insert with schema check and column match in CH

Hi HN! I’ve built insert-tools, a Python CLI utility designed for easy and safe bulk data insertion into ClickHouse.

Features:

Inserts data via SELECT queries with automatic column name matching

Automatically casts types to ensure safe inserts and avoid errors

Supports JSON-based configuration and a user-friendly CLI interface

Comes with integration tests and basic argument validation

You can install it from PyPI: https://pypi.org/project/insert-tools/ Source code is available here: https://github.com/castengine/insert-tools

Looking forward to feedback, suggestions, and contributions!