Analytical (OLAP) database skills from ClickHouse.
Official ClickHouse skills for schema, query, architecture, Node.js troubleshooting, and in-process analytics.
Arranged in the author's recommended order. Walk through them in sequence, or open any one on its own.
MUST.
MUST.
Troubleshoot and resolve common issues with the ClickHouse Node.js client (@clickhouse/client).
Use when the user has tabular data (pandas DataFrame, parquet, csv, Arrow, json) and wants to filter, group, aggregate, join, or speed up slow pandas.
Use when the user wants to run SQL – especially analytical SQL – on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg.