DuckDB

What is the DuckDB tool?

The DuckDB tool is a built-in capability in the Agno framework that allows AI agents to run sql queries via embedded duckdb database. When added to an agent in Agno Builder, the agent can autonomously decide when to invoke this tool based on the user's request.

This is a free tool — no API key or external account is needed. It works out of the box when you add it to any agent.

How to use DuckDB in Agno Builder

1. 1

   Create an agent

   Drag an Agent node onto the canvas in Agno Builder, or use one of the built-in templates.

2. 2

   Enable DuckDB

   Click the agent, go to the Tools tab, and toggle on "DuckDB" from the data category.

3. 3

   Test in chat

   Open the chat panel and send a message. The agent will automatically use DuckDB when relevant.

4. 4

   Export Python code

   Click File > Export Python to get clean, runnable code with the correct imports for DuckDB.

Python code example

This is the code Agno Builder exports when you use DuckDB:

from agno.agent import Agent
from agno.models.openai import OpenAIChat
from agno.tools.duckdb import DuckDbTools

agent = Agent(
    name="DuckDB Agent",
    model=OpenAIChat(id="gpt-4o"),
    tools=[DuckDbTools()],
    instructions=["Use the duckdb tool to help the user."],
    markdown=True,
)

agent.print_response("Help me with a duckdb task")

Install with: pip install agno