Skip to content
Brain Framework

PostgreSQL Adapter

The PostgreSQL Adapter provides robust database functionality with vector search capabilities, ideal for production deployments.

Installation

  1. Install required packages:

    Terminal window
    npm i github:elizaos-plugins/adapter-postgres

  2. Setup env variable:

    Terminal window
    POSTGRES_URL=postgresql://user:pass@localhost:5432/db

  3. Enable vector search extension:

    Terminal window
    CREATE EXTENSION vector;

Basic Setup

import { AgentBuilder } from "@iqai/agent";
import PostgresAdapter from "@elizaos/adapter-postgres";


const agent = new AgentBuilder()
  .withDatabase(PostgresAdapter)
  // ... other configuration
  .build();

Key Features

  • ✔️ Vector search support
  • ✔️ Comprehensive logging
  • ✔️ Production scaling

Best Practices

  • ✔️ Use for production deployments
  • ✔️ Enable connection pooling
  • ✔️ Implement proper indexing
  • ✔️ Monitor vector search performance