mirror of
https://github.com/hwchase17/langchain.git
synced 2025-05-05 23:28:47 +00:00
600b7bdd61
Co-authored-by: Bagatur <baskaryan@gmail.com> Co-authored-by: Bagatur <22008038+baskaryan@users.noreply.github.com>
37 lines
1.1 KiB
Python
37 lines
1.1 KiB
Python
"""Tool for the Dataherald Hosted API"""
|
|
|
|
from typing import Optional, Type
|
|
|
|
from langchain_core.callbacks import CallbackManagerForToolRun
|
|
from langchain_core.tools import BaseTool
|
|
from pydantic import BaseModel, Field
|
|
|
|
from langchain_community.utilities.dataherald import DataheraldAPIWrapper
|
|
|
|
|
|
class DataheraldTextToSQLInput(BaseModel):
|
|
prompt: str = Field(
|
|
description="Natural language query to be translated to a SQL query."
|
|
)
|
|
|
|
|
|
class DataheraldTextToSQL(BaseTool): # type: ignore[override, override]
|
|
"""Tool that queries using the Dataherald SDK."""
|
|
|
|
name: str = "dataherald"
|
|
description: str = (
|
|
"A wrapper around Dataherald. "
|
|
"Text to SQL. "
|
|
"Input should be a prompt and an existing db_connection_id"
|
|
)
|
|
api_wrapper: DataheraldAPIWrapper
|
|
args_schema: Type[BaseModel] = DataheraldTextToSQLInput
|
|
|
|
def _run(
|
|
self,
|
|
prompt: str,
|
|
run_manager: Optional[CallbackManagerForToolRun] = None,
|
|
) -> str:
|
|
"""Use the Dataherald tool."""
|
|
return self.api_wrapper.run(prompt)
|