Code
cookbook/agent_concepts/vector_dbs/singlestore.py
from os import getenv
from agno.agent import Agent
from agno.knowledge.pdf_url import PDFUrlKnowledgeBase
from agno.vectordb.singlestore import SingleStore
from sqlalchemy.engine import create_engine
USERNAME = getenv("SINGLESTORE_USERNAME")
PASSWORD = getenv("SINGLESTORE_PASSWORD")
HOST = getenv("SINGLESTORE_HOST")
PORT = getenv("SINGLESTORE_PORT")
DATABASE = getenv("SINGLESTORE_DATABASE")
SSL_CERT = getenv("SINGLESTORE_SSL_CERT", None)
db_url = (
f"mysql+pymysql://{USERNAME}:{PASSWORD}@{HOST}:{PORT}/{DATABASE}?charset=utf8mb4"
)
if SSL_CERT:
db_url += f"&ssl_ca={SSL_CERT}&ssl_verify_cert=true"
db_engine = create_engine(db_url)
knowledge_base = PDFUrlKnowledgeBase(
urls=["https://agno-public.s3.amazonaws.com/recipes/ThaiRecipes.pdf"],
vector_db=SingleStore(
collection="recipes",
db_engine=db_engine,
schema=DATABASE,
),
)
knowledge_base.load(recreate=False)
agent = Agent(
knowledge=knowledge_base,
show_tool_calls=True,
search_knowledge=True,
read_chat_history=True,
)
agent.print_response("How do I make pad thai?", markdown=True)
Usage
1
Create a virtual environment
Open the
Terminal and create a python virtual environment.python3 -m venv .venv
source .venv/bin/activate
python3 -m venv .venv
.venv/scripts/activate
2
Set environment variables
export SINGLESTORE_HOST="localhost"
export SINGLESTORE_PORT="3306"
export SINGLESTORE_USERNAME="root"
export SINGLESTORE_PASSWORD="admin"
export SINGLESTORE_DATABASE="AGNO"
export SINGLESTORE_SSL_CA=".certs/singlestore_bundle.pem"
3
Install libraries
pip install -U sqlalchemy pymysql pypdf openai agno
4
Run Agent
python cookbook/agent_concepts/vector_dbs/singlestore.py
python cookbook/agent_concepts/vector_dbs/singlestore.py