docs/en/tools/database-data/singlestoresearchtool.mdx
SingleStoreSearchToolExecute read‑only queries (SELECT/SHOW) against SingleStore with connection pooling and input validation.
uv add crewai-tools[singlestore]
Variables like SINGLESTOREDB_HOST, SINGLESTOREDB_USER, SINGLESTOREDB_PASSWORD, etc., can be used, or SINGLESTOREDB_URL as a single DSN.
Generate the API key from the SingleStore dashboard, docs here.
from crewai import Agent, Task, Crew
from crewai_tools import SingleStoreSearchTool
tool = SingleStoreSearchTool(
tables=["products"],
host="host",
user="user",
password="pass",
database="db",
)
agent = Agent(
role="Analyst",
goal="Query SingleStore",
tools=[tool],
verbose=True,
)
task = Task(
description="List 5 products",
expected_output="5 rows as JSON/text",
agent=agent,
)
crew = Crew(
agents=[agent],
tasks=[task],
verbose=True,
)
result = crew.kickoff()