Code
cookbook/tools/sql_tools.py
Usage
1
Create a virtual environment
Open the
Terminal and create a python virtual environment.2
Set your API key
3
Install libraries
4
Run Agent
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
You are viewing v1 docs. For the latest documentation, visit docs.agno.com
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")
Create a virtual environment
Terminal and create a python virtual environment.python3 -m venv .venv
source .venv/bin/activate
python3 -m venv .venv
.venv/scripts/activate
Set your API key
export OPENAI_API_KEY=xxx
Install libraries
pip install -U sqlalchemy openai agno
Run Agent
python cookbook/tools/sql_tools.py
python cookbook/tools/sql_tools.py
Was this page helpful?