Skip to main content
PostgreSQL persists agent conversations with JSONB metadata, connection pooling, and automatic serverless retry. 
from praisonaiagents import Agent, db

agent = Agent(
    name="ProductionBot",
    instructions="You are a helpful assistant.",
    db=db(database_url="postgresql://user:pass@localhost:5432/praisonai"),
    session_id="prod-session",
)
agent.start("Hello — save this to PostgreSQL")
The user talks to production agents; PostgreSQL stores conversations with JSONB metadata.

​
Quick Start

1

Simple Usage

pip install psycopg2-binary praisonai

from praisonaiagents import Agent, db

agent = Agent(
    name="ProductionBot",
    db=db(database_url="postgresql://user:pass@localhost:5432/praisonai"),
    session_id="session-1",
)
agent.start("Hello!")
2

With Configuration

from praisonai.persistence.conversation.postgres import PostgresConversationStore

store = PostgresConversationStore(
    url="postgresql://user:pass@localhost:5432/praisonai",
    schema="public",
    table_prefix="praison_",
    auto_create_tables=True,
    pool_size=10,
    max_retries=3,
    retry_delay=0.5,
)

​
How It Works

FeatureDescription
JSONB columnsRich metadata queries on session data
Serverless retryAuto SSL and retry for Neon, CockroachDB, Xata
Schema supportIsolate tables with a PostgreSQL schema

​
Configuration Options

OptionTypeDefaultDescription
urlstrNoneFull connection URL (overrides individual options)
hoststr"localhost"Database host
portint5432Database port
databasestr"praisonai"Database name
userstr"postgres"Database user
passwordstr""Database password
schemastr"public"PostgreSQL schema
table_prefixstr"praison_"Prefix for table names
auto_create_tablesboolTrueCreate tables automatically
pool_sizeint5Connection pool size
max_retriesint3Retries on connection errors (serverless cold-start)
retry_delayfloat0.5Base delay between retries in seconds

​
URL formats

db(database_url="postgresql://user:pass@localhost:5432/praisonai")
db(database_url="postgresql://user:pass@host:5432/db?sslmode=require")
Aliases: neon, cockroachdb, crdb, xata resolve to the postgres backend. For async, use create_conversation_store("async_postgres", ...).

​
Best Practices

Agent(db=db(database_url="postgresql://...")) is the simplest path — store wiring is automatic.
Set sslmode=require in the URL for encrypted connections.
Point at Neon or Xata URLs — SSL and retry are applied automatically.
Reuse the same session_id — conversation history loads on the next agent.start().

SQLite Persistence

Local file database for development

Database Persistence

Compare all persistence backends