FruxonDocs

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

  1. Open Integrations from the sidebar
  2. Select PostgreSQL from the catalog
  3. Click Add Integration Config
  4. Give the config a display name (e.g., "PostgreSQL - Production")
  5. Enter your Connection String (stored encrypted)
  6. Save the config

No separate authentication setup is needed — credentials are embedded in the connection string.

Using in Your Agent

  1. Open your agent in Agent Studio and select an Agent Step
  2. Under Attached Integration Configurations, click Attach configuration and choose your config
  3. Attach PostgreSQL tools from the tools panel
  4. Tools are referenced as postgresql.query, postgresql.insert, etc.

Available Tools

ToolDescriptionAction Type
list_tablesList all tables in the databaseReadOnly
describe_tableGet the schema of a tableReadOnly
queryExecute a SELECT queryReadOnly
insertInsert rows into a tableReversible
updateUpdate rows in a tableReversible
deleteDelete rows from a tableIrreversible

On this page