In order to enter pkg> mode, enter a REPL and press ], then:

pkg> add ClickHouse

Usage examples

Usage examples can be found on the usage page.

Supported data types

  • String, FixedString(N)
  • Float32, Float64
  • Int8, Int16, Int32, Int64
  • UInt8, UInt16, UInt32, UInt64
  • Date, DateTime, DateTime64
  • Enum
  • UUID
  • Tuple
  • LowCardinality(T)
  • Nullable(T)
  • Array(T)
  • Nothing
  • SimpleAggregateFunction
  • IPv4, IPv6
  • Decimals


  • Transfer compression is currently not implemented
  • Timezone conversion of DateTime / DateTime64 for columns that have a timezone assigned in ClickHouse doesn't happen automatically. All DateTime objects are naive, meaning they aren't timezone aware. For reasoning, see this post and this post.