ClickHouse Adapter

Stores Payload data in ClickHouse, with edge-ready HTTP access and an embedded local mode

Community 0 20/wk MIT v0.1.10

Installation

pnpm add @dotdo/db-clickhouse

About

This adapter lets a Payload project keep its documents in ClickHouse, a column-oriented database built for analytics. It connects over HTTP, so it runs on Cloudflare Workers and other edge runtimes, and it can also run against a ClickHouse server you already operate. A local mode embeds ClickHouse in the Node.js process with file-based storage, which avoids Docker for development and CI.

All collections share one table separated by namespace, and documents are stored as JSON, so no schema migrations are needed. Deletes are soft, and versions are tracked with a timestamp. Vector similarity search is available as an option.

ClickHouse is optimized for analytics rather than typical CMS writes, so it is marked experimental and suits specialized projects more than general sites.

Package info

Package name
@dotdo/db-clickhouse
Latest version
0.1.10
Unpacked size
946 kB
License
MIT
Weekly downloads
20
Last publish
Dec 30, 2025

More from dot-do

View profile

Database adapter that routes reads and writes between a local and a remote database

Payload admin preset for managing AI functions, workflows, models and evals

Similar adapters

More in Database

Database adapter that runs Payload on SurrealDB through its PostgreSQL-compatible SQL interface

Stores Payload data in a Postgres database, with migrations and read replica support

Vercel Postgres database adapter that stores Payload collections and globals in Postgres

Stores Payload data in Cloudflare D1 SQLite databases from Workers

Stores Payload collections and globals in a MongoDB database

Official SQLite database adapter that stores Payload collections and globals in SQLite