ClickHouse

Column-oriented database with vector search.

Setup

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:

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)

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)