Amazon Redshift

What is the Amazon Redshift tool?

The Amazon Redshift tool is a built-in capability in the Agno framework that allows AI agents to query amazon redshift data warehouses. 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 tool requires a AWS_ACCESS_KEY_ID environment variable. Get your API key at console.aws.amazon.com.

How to use Amazon Redshift 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 Amazon Redshift

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

3. 3

   Add your API key

   Enter your AWS_ACCESS_KEY_ID in the tool configuration. Your key stays in your browser and is never stored on our servers.

4. 4

   Test in chat

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

5. 5

   Export Python code

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

Python code example

This is the code Agno Builder exports when you use Amazon Redshift:

from agno.agent import Agent
from agno.models.openai import OpenAIChat
from agno.tools.redshift import RedshiftTools

agent = Agent(
    name="Amazon Redshift Agent",
    model=OpenAIChat(id="gpt-4o"),
    tools=[RedshiftTools()],
    instructions=["Use the amazon redshift tool to help the user."],
    markdown=True,
)

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

Install with: pip install agno # + set AWS_ACCESS_KEY_ID