SingleStore Search Tool

The SingleStoreSearchTool safely executes SELECT/SHOW queries on SingleStore with pooling.

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

Code

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