Database adapter that routes reads and writes between a local and a remote database
ClickHouse Adapter
Stores Payload data in ClickHouse, with edge-ready HTTP access and an embedded local mode
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 profilePayload admin preset for managing AI functions, workflows, models and evals
Similar adapters
More in DatabaseDatabase 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