---
title: Self-hosted agent memory on ClickHouse
---

Loom runs on your own infrastructure, with Docker or on Kubernetes with its Helm chart, and
stores agent memory, documents, conversations and code indexes as tables in ClickHouse. A
deployment can choose Postgres at first boot for live memory and knowledge state. Data is
stored only in your stores (the hosted model providers and trace sinks you configure
receive what they process), and what your agents know is queryable with SQL.

## What you get

- **Docker or Kubernetes.** The one-line installer starts the local stack; the Helm chart
  runs N identical replicas behind one URL. [Deployment](/operations/deployment) ·
  [Kubernetes](/operations/kubernetes) · [Running N replicas](/operations/replicas)
- **ClickHouse OSS or ClickHouse Cloud.** [Choosing the ClickHouse](/operations/deployment#choosing-the-clickhouse) ·
  [ClickHouse Cloud and Managed Postgres](/operations/clickhouse-cloud)
- **One store for vectors, text and audit.** Under the default ClickHouse authority,
  vector, lexical and graph search, filters, audit and erasure are SQL in one database.
  [Storage authority](/architecture/storage-authority)
- **Multi-user.** Orgs, namespaces, roles, tokens and single sign-on.
  [Identities and namespaces](/concepts/identities-and-namespaces) ·
  [Single sign-on](/operations/sso)
- **Local models.** The released stack embeds on CPU with a bundled local model, and
  the embedding provider accepts an OpenAI-compatible endpoint you run.
  [Models and API keys](/getting-started/models-and-keys)

## Measured

A synthetic load of memories with 2.4 versions per key and 3072-dimension embeddings (two
vectors per row) took about 13.6 KB per key in ClickHouse, almost all of it the embedding
row; a smaller embedder takes less, and parts with few rows carry somewhat more per row
until they merge.
[Memory at scale](/benchmarks/results#memory-at-scale)

## Start

[Quickstart](/getting-started/quickstart) · [Prerequisites](/getting-started/overview#prerequisites) ·
[Upgrades](/operations/upgrades) · [Backup and recovery](/operations/backup-and-recovery)
