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

# Cassandra Database

> Demonstrates Cassandra-backed knowledge with sync, async, and async-batching flows.

```python theme={null}
"""
Cassandra Database
==================

Demonstrates Cassandra-backed knowledge with sync, async, and async-batching flows.

Requirement:
- uv pip install cassandra-driver
"""

import asyncio

from agno.agent import Agent
from agno.knowledge.embedder.mistral import MistralEmbedder
from agno.knowledge.embedder.openai import OpenAIEmbedder
from agno.knowledge.knowledge import Knowledge
from agno.models.mistral import MistralChat
from agno.vectordb.cassandra import Cassandra

try:
    from cassandra.cluster import Cluster  # type: ignore
except (ImportError, ModuleNotFoundError):
    raise ImportError(
        "Could not import cassandra-driver python package.Please install it with uv pip install cassandra-driver."
    )


# ---------------------------------------------------------------------------
# Setup
# ---------------------------------------------------------------------------
def create_session():
    cluster = Cluster()
    session = cluster.connect()
    session.execute(
        """
        CREATE KEYSPACE IF NOT EXISTS testkeyspace
        WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 }
        """
    )
    return session


# ---------------------------------------------------------------------------
# Create Knowledge Base
# ---------------------------------------------------------------------------
def create_sync_knowledge(session) -> tuple[Knowledge, Cassandra]:
    vector_db = Cassandra(
        table_name="recipes",
        keyspace="testkeyspace",
        session=session,
        embedder=OpenAIEmbedder(dimensions=1024),
    )
    knowledge = Knowledge(name="My Cassandra Knowledge Base", vector_db=vector_db)
    return knowledge, vector_db


def create_async_knowledge(session, enable_batch: bool = False) -> Knowledge:
    vector_db = Cassandra(
        table_name="recipes",
        keyspace="testkeyspace",
        session=session,
        embedder=MistralEmbedder(enable_batch=enable_batch),
    )
    return Knowledge(vector_db=vector_db)


# ---------------------------------------------------------------------------
# Create Agent
# ---------------------------------------------------------------------------
def create_sync_agent(knowledge: Knowledge) -> Agent:
    return Agent(knowledge=knowledge)


def create_async_agent(knowledge: Knowledge) -> Agent:
    return Agent(model=MistralChat(), knowledge=knowledge)


# ---------------------------------------------------------------------------
# Run Agent
# ---------------------------------------------------------------------------
def run_sync(session) -> None:
    knowledge, vector_db = create_sync_knowledge(session)
    knowledge.insert(
        name="Recipes",
        url="https://agno-public.s3.amazonaws.com/recipes/ThaiRecipes.pdf",
        metadata={"doc_type": "recipe_book"},
    )

    agent = create_sync_agent(knowledge)
    agent.print_response(
        "What are the health benefits of Khao Niew Dam Piek Maphrao Awn?",
        markdown=True,
        show_full_reasoning=True,
    )

    vector_db.delete_by_name("Recipes")
    vector_db.delete_by_metadata({"doc_type": "recipe_book"})


async def run_async(session, enable_batch: bool = False) -> None:
    knowledge = create_async_knowledge(session, enable_batch=enable_batch)
    agent = create_async_agent(knowledge)

    if enable_batch:
        await knowledge.ainsert(path="cookbook/07_knowledge/testing_resources/cv_1.pdf")
        await agent.aprint_response(
            "What can you tell me about the candidate?", markdown=True
        )
    else:
        await knowledge.ainsert(url="https://docs.agno.com/basics/agents/overview.md")
        await agent.aprint_response(
            "What is the purpose of an Agno Agent?", markdown=True
        )


if __name__ == "__main__":
    cassandra_session = create_session()
    run_sync(cassandra_session)
    asyncio.run(run_async(cassandra_session, enable_batch=False))
    asyncio.run(run_async(cassandra_session, enable_batch=True))
```

## Run the Example

```bash theme={null}
# Clone and setup repo
git clone https://github.com/agno-agi/agno.git
cd agno/cookbook/07_knowledge/vector_db/cassandra_db

# Create and activate virtual environment
./scripts/demo_setup.sh
source .venvs/demo/bin/activate

python cassandra_db.py
```