PostgreSQL Database AgentConnect PostgreSQL for Object Store operations, aggregate queries, and agent memory.AgentsdocsAgentsdocsagentsdatabase
← Agents

Database

PostgreSQL Database

The PostgreSQL connection stores a database URL and powers the Object Store agent. It supports instance CRUD, bulk operations, aggregates, existence checks, and conversation memory persistence.

Common use cases

  1. Create, query, update, and delete object model instances.
  2. Run bulk inserts, updates, deletes, and aggregate queries.
  3. Load and save AI agent memory by conversation ID.

Capabilities

  • Create and query instances
  • Update and delete instances
  • Bulk create, update, and delete
  • Check existence and create-if-not-exists
  • Aggregates
  • Load and save memory

Connection types

postgres

Data handled

  • Object records
  • Aggregate rows
  • Conversation memory