ClickHouse

Asks about your data volume, query patterns, and latency needs, then recommends a specific table schema, ingestion method, and compression strategy with trade-offs explained.

Generates idiomatic queries, inserts, and client setup using the ClickHouse Node.js library. Handles JSON ingestion, result parsing, and connection pooling patterns.

Guides you through spinning up a ClickHouse Cloud instance, migrating data from local ClickHouse, configuring access, and validating the production setup end-to-end.

Swaps your slow pandas queries for a ClickHouse engine underneath — same API, same commands, but runs aggregations and joins on millions of rows in seconds.

Query a CSV, Parquet, JSON file, S3 bucket, or remote database (Postgres, MySQL, MongoDB, ClickHouse) with SQL — no server setup, no data upload needed.

Diagnoses socket hang-ups, Keep-Alive failures, and config mishaps in the @clickhouse/client library. Maps the error to a root cause and a tested fix.

Reviews your ClickHouse setup against 31 production rules, surfacing performance bottlenecks, data-modeling issues, and configuration risks with specific fixes.

Scaffolds a working ClickHouse instance on your machine with tables, sample data, and the boilerplate code to start querying. Skips the documentation hunt.