# ClickHouse Loom

> ClickHouse Loom is an open-source MCP server for databases. Self-hosted MCP server: shared agent memory, document search and a code index. It runs as a hosted remote server, so there is nothing to install locally.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** self-hosted, API, Linux, macOS
- **Repository:** https://github.com/clickhouse/loom
- **MCP Registry name:** io.github.ClickHouse/loom
- **Categories:** databases, knowledge and memory, developer tools
- **Listing updated:** 2026-11-14

## About

Loom is built by ClickHouse and keeps agent context and index data in ClickHouse, with Postgres selectable at first boot for live memory state. What one agent learns in a session can be found by the next, across Claude Code, Codex, Cursor or your own agents.

Beyond memory it offers a code index that answers questions about definitions, callers and change impact, document search with citations including PDF, docx and pptx, namespaces with roles and tokens for teams, and a record of runs, PR history and searchable conversations when recording is on. A dashboard ties memories, repositories and tasks together.

The README reports its own tests: with Loom, coding-agent runs cost about 20% less on one test and 21% on another, and memory retrieval cut reader tokens by 91% on LongMemEval-S. It says results are specific to the tested workloads. The stock install boots without API keys using a small local embedding model.

## Features

- **Shared agent memory:** Memories saved by one agent are retrievable by others.
- **Code index:** Definitions, callers and change impact for repositories.
- **Cited document search:** RAG over files including PDF, docx and pptx.
- **Multi-user mode:** Namespaces, roles and tokens for teams.
- **Run history:** Records runs, outcomes and PR history.
- **Docker and Helm:** Install with Docker or on Kubernetes.

## Good for

- Let coding agents share context across sessions
- Give an agent application per-user memory via the SDK
- Query where a function is called before changing it
- Search internal documents with citations

## FAQ

### Where does the data live?

In ClickHouse by default; Postgres can be chosen at first boot for memory and knowledge state.

### Does it need API keys to start?

No. The default install boots without keys, using a local embedding model and a placeholder LLM.

### How do I install it?

Run the release install script, which starts Loom and ClickHouse and prints a dashboard URL at localhost:7777.

### What is it not for?

The README says it is not an in-process library for short-lived memory, nor an agent framework.

### Is ClickHouse Loom free?

Yes. ClickHouse Loom is open source, so you can use and self-host it for free.

### What are the best alternatives to ClickHouse Loom?

The closest alternatives to ClickHouse Loom are REA, Codebase Memory, GitHub, Serena MCP: the IDE for your agent and XERJ.

## Alternatives

- [REA](https://ai-powered.com/mcp/rea): REA is an open-source MCP server for developer tools.
- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [GitHub](https://ai-powered.com/mcp/github-2): GitHub is an open-source MCP server for developer tools.
- [Serena MCP: the IDE for your agent](https://ai-powered.com/mcp/serena-mcp-the-ide-for-your-agent): Serena MCP: the IDE for your agent is an open-source MCP server for developer tools.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.
- [Ouroboros](https://ai-powered.com/mcp/ouroboros): Ouroboros is an open-source MCP server for developer tools.
- [Claude Code Ultimate Guide](https://ai-powered.com/mcp/claude-code-ultimate-guide): Claude Code Ultimate Guide is an open-source MCP server for ai models and llm tooling.
- [Nautilus Compass Memory](https://ai-powered.com/mcp/nautilus-compass-memory): Nautilus Compass Memory is an open-source MCP server for knowledge and memory.

---
Source: https://ai-powered.com/mcp/clickhouse-loom
