PostgreSQL
PostgreSQL database integration for querying, inserting, updating, and deleting data
The PostgreSQL integration lets your agents query, insert, update, and delete data in PostgreSQL databases.
Prerequisites
You need:
- PostgreSQL connection string — The connection URI for your PostgreSQL instance (e.g.,
Host=myserver;Database=mydb;Username=user;Password=pass;). This includes authentication credentials.
Setup
- Open your agent in Agent Studio
- In the Integrations panel, click Add Integration Config
- Select PostgreSQL from the integration list
- Give the config a display name (e.g., "PostgreSQL - Production")
- Enter your Connection String (stored encrypted)
- Save the agent revision
No separate authentication setup is needed — credentials are embedded in the connection string.
Using in Your Agent
- In an Agent Step, attach PostgreSQL tools from the tools panel
- The agent uses your integration config for all PostgreSQL operations
- Tools are referenced as
postgresql.query,postgresql.insert, etc.
Available Tools
| Tool | Description | Action Type |
|---|---|---|
list_tables | List all tables in the database | ReadOnly |
describe_table | Get the schema of a table | ReadOnly |
query | Execute a SELECT query | ReadOnly |
insert | Insert rows into a table | Reversible |
update | Update rows in a table | Reversible |
delete | Delete rows from a table | Irreversible |