​
Code

cookbook/tools/sql_tools.py
from agno.agent import Agent
from agno.tools.sql import SQLTools

agent = Agent(
    tools=[SQLTools(db_url="sqlite:///database.db")],
    show_tool_calls=True,
    markdown=True,
)
agent.print_response("Show me all tables in the database and their schemas")

​
Usage

1

Create a virtual environment

Open the Terminal and create a python virtual environment.

python3 -m venv .venv
source .venv/bin/activate
2

Set your API key

export OPENAI_API_KEY=xxx
3

Install libraries

pip install -U sqlalchemy openai agno
4

Run Agent

python cookbook/tools/sql_tools.py