ClickHouse

ClickHouse is an open-source column-oriented database built for real-time analytics at scale. It delivers sub-second query performance over billions of rows, supports full read/write SQL, and is used by companies like Tesla, GitLab, and Cloudflare for observability, analytics, and AI workloads.

The ClickHouse Wrapper brings your ClickHouse tables into Postgres as queryable foreign tables. Read and write ClickHouse data with plain SQL and join it against your application data. Supports aggregate pushdown so queries run on ClickHouse rather than locally, and works with Supabase Vault for secure connection string management.

Supported Operations

Object	Select	Insert	Update	Delete
Tables	✅	✅	✅	✅

Supported Data Types

Postgres Type	ClickHouse Type
boolean	Bool
"char"	Int8
smallint	UInt8, Int16
integer	UInt16, Int32
bigint	UInt32, Int64, UInt64
real	Float32
double precision	Float64
numeric	Decimal, UInt128, Int128
text	String, FixedString(N), UInt256, Int256
date	Date
timestamp	DateTime
uuid	UUID
boolean[]	Array(Boolean)
smallint[]	Array(Int16)
integer[]	Array(Int32)
bigint[]	Array(Int64)
real[]	Array(Float32)
double precision[]	Array(Float64)
text[]	Array(String)
any	Nullable(T)

Resources

• supabase/wrappers on GitHub