Skip to content
Brain Framework

PostgreSQL Adapter

The PostgreSQL Adapter provides robust database functionality with vector search capabilities, ideal for production deployments. Visit Elizaos PostgreSQL Adapter docs for more details.

Installation

Section titled “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

Section titled “Basic Setup”
import { AgentBuilder } from "@iqai/agent";
import PostgresAdapter from "@elizaos/adapter-postgres";


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

Key Features

Section titled “Key Features”
  • ✔️ Vector search support
  • ✔️ Comprehensive logging
  • ✔️ Production scaling

Best Practices

Section titled “Best Practices”
  • ✔️ Use for production deployments
  • ✔️ Enable connection pooling
  • ✔️ Implement proper indexing
  • ✔️ Monitor vector search performance