PostgreSQL

What is the PostgreSQL tool?

The PostgreSQL tool is a built-in capability in the Agno framework that allows AI agents to interact with postgresql databases. 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 PostgreSQL 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 PostgreSQL

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

3. 3

   Test in chat

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

4. 4

   Export Python code

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

Python code example

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

from agno.agent import Agent
from agno.models.openai import OpenAIChat
from agno.tools.postgres import PostgresTools

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

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

Install with: pip install agno