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 Integrations from the sidebar
- Select PostgreSQL from the catalog
- Click Add Integration Config
- Give the config a display name (e.g., "PostgreSQL - Production")
- Enter your Connection String (stored encrypted)
- Save the config
No separate authentication setup is needed — credentials are embedded in the connection string.
Using in Your Agent
- Open your agent in Agent Studio and select an Agent Step
- Under Attached Integration Configurations, click Attach configuration and choose your config
- Attach PostgreSQL tools from the tools panel
- 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 |