SingleStore Search Tool

SingleStoreSearchTool

Description

Execute read‑only queries (SELECT/SHOW) against SingleStore with connection pooling and input validation.

Installation

uv add crewai-tools[singlestore]

Environment Variables

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.

Example

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()