Pandahouse Pandas interface for Clickhouse HTTP API Install pip install pandahouse Usage Writing dataframe to clickhouse connection = {'host': 'http://clickhouse-host:8123', 'database': 'test'} affected_rows = to_clickhouse(df, table='name', connection=connection) Reading arbitrary clickhouse query to pandas df = read_clickhouse('SELECT * FROM {db}.table', index_col='id', connection=connection)