> ## Documentation Index
> Fetch the complete documentation index at: https://docs.praison.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# ClickHouse

> ClickHouse vector store for PraisonAI

# ClickHouse

Column-oriented database with vector search.

## Setup

```bash theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
docker run -d -p 8123:8123 clickhouse/clickhouse-server
pip install clickhouse-connect
```

## Quick Start (Agent with Knowledge)

Use ClickHouse as a knowledge store with an agent:

```python theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
from praisonaiagents import Agent

agent = Agent(
    name="Assistant",
    instructions="You are a helpful assistant with access to documents.",
    knowledge=["./docs/guide.pdf"]
)

agent.chat("What does the guide say?")
```

## Advanced Usage (Direct Store)

```python theme={"theme":{"light":"vitesse-light","dark":"vitesse-dark"}}
from praisonai.persistence.factory import create_knowledge_store

store = create_knowledge_store(
    "clickhouse",
    host="localhost",
    port=8123
)

store.create_collection("documents", dimension=384)
store.insert("documents", [doc])
results = store.search("documents", query_embedding, limit=5)
```