Python Code:
from sqlalchemy import create_engine
from agno.agent import Agent
from agno.tools.sql import SQLTools
user = “user”
password = “password”
host = “host”
port = 1234
schema = “schema”
dialect = “mysql”
db_url = f"mysql+pymysql://{user}:{password}@{host}:{port}/{schema}"
db_engine = create_engine(db_url)
sql_tools = SQLTools(
user=user,
password=password,
host=host,
port=port,
schema=schema,
dialect=dialect,
db_engine=db_engine )
agent = Agent(
model=Ollama(id=“qwen2.5:3b-instruct”),
tools=[sql_tools]
)
agent.print_response(
“List the tables in the database. Tell me about contents of one of the tables”,
markdown=True,
)
Error:
Traceback (most recent call last):
File “/home/mohkaab/PycharmProjects/CareVision/care_vision_siri/working.py”, line 469, in
agent.print_response(
File “/home/mohkaab/PycharmProjects/PythonProject/.venv/lib/python3.12/site-packages/agno/agent/agent.py”, line 3511, in print_response
run_response = self.run(
^^^^^^^^^
File “/home/mohkaab/PycharmProjects/PythonProject/.venv/lib/python3.12/site-packages/agno/agent/agent.py”, line 870, in run
return next(resp)
^^^^^^^^^^
File “/home/mohkaab/PycharmProjects/PythonProject/.venv/lib/python3.12/site-packages/agno/agent/agent.py”, line 592, in _run
model_response = self.model.response(messages=run_messages.messages)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/home/mohkaab/PycharmProjects/PythonProject/.venv/lib/python3.12/site-packages/agno/models/base.py”, line 163, in response
assistant_message, has_tool_calls = self._process_model_response(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/home/mohkaab/PycharmProjects/PythonProject/.venv/lib/python3.12/site-packages/agno/models/base.py”, line 287, in _process_model_response
response = self.invoke(messages=messages)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/home/mohkaab/PycharmProjects/PythonProject/.venv/lib/python3.12/site-packages/agno/models/ollama/chat.py”, line 203, in invoke
return self.get_client().chat(
^^^^^^^^^^^^^^^^^^^^^^^
File “/home/mohkaab/PycharmProjects/PythonProject/.venv/lib/python3.12/site-packages/ollama/_client.py”, line 340, in chat
tools=[tool for tool in _copy_tools(tools)],
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/home/mohkaab/PycharmProjects/PythonProject/.venv/lib/python3.12/site-packages/ollama/_client.py”, line 1142, in _copy_tools
yield convert_function_to_tool(unprocessed_tool) if callable(unprocessed_tool) else Tool.model_validate(unprocessed_tool)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File “/home/mohkaab/PycharmProjects/PythonProject/.venv/lib/python3.12/site-packages/pydantic/main.py”, line 627, in model_validate
return cls.pydantic_validator.validate_python(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
pydantic_core._pydantic_core.ValidationError: 1 validation error for Tool
function.parameters.properties.limit.type
Input should be a valid string [type=string_type, input_value=[‘number’, ‘null’], input_type=list]
For further information visit Redirecting...