PostgresDb | Agno

PostgresDb is a class that implements the Db interface using PostgreSQL as the backend storage system. It provides robust, relational storage for agent sessions with support for JSONB data types, schema versioning, and efficient querying.

Parameter	Type	Default	Description
`id`	`Optional[str]`	-	The ID of the database instance. UUID by default.
`db_url`	`Optional[str]`	-	The database URL to connect to.
`db_engine`	`Optional[Engine]`	-	The SQLAlchemy database engine to use.
`db_schema`	`Optional[str]`	-	The database schema to use.
`session_table`	`Optional[str]`	-	Name of the table to store Agent, Team and Workflow sessions.
`runs_table`	`Optional[str]`	-	Name of the table to store the runs of each session.
`memory_table`	`Optional[str]`	-	Name of the table to store memories.
`metrics_table`	`Optional[str]`	-	Name of the table to store metrics.
`eval_table`	`Optional[str]`	-	Name of the table to store evaluation runs data.
`knowledge_table`	`Optional[str]`	-	Name of the table to store knowledge content.
`traces_table`	`Optional[str]`	-	Name of the table to store traces.
`spans_table`	`Optional[str]`	-	Name of the table to store spans.
`versions_table`	`Optional[str]`	-	Name of the table to store schema versions.
`components_table`	`Optional[str]`	-	Name of the table to store components.
`component_configs_table`	`Optional[str]`	-	Name of the table to store component configurations.
`component_links_table`	`Optional[str]`	-	Name of the table to store links between components.
`learnings_table`	`Optional[str]`	-	Name of the table to store learnings.
`schedules_table`	`Optional[str]`	-	Name of the table to store cron schedules.
`schedule_runs_table`	`Optional[str]`	-	Name of the table to store schedule run history.
`job_table`	`Optional[str]`	-	Name of the table to store durable background run jobs.
`approvals_table`	`Optional[str]`	-	Name of the table to store human approval requests.
`auth_tokens_table`	`Optional[str]`	-	Name of the table to store OAuth tokens for external services.
`service_accounts_table`	`Optional[str]`	-	Name of the table to store service accounts.
`mcp_oauth_clients_table`	`Optional[str]`	-	Name of the table to store MCP OAuth client registrations.
`mcp_oauth_transactions_table`	`Optional[str]`	-	Name of the table to store MCP OAuth transactions.
`mcp_oauth_codes_table`	`Optional[str]`	-	Name of the table to store MCP OAuth authorization codes.
`mcp_oauth_refresh_tokens_table`	`Optional[str]`	-	Name of the table to store MCP OAuth refresh tokens.
`mcp_oauth_keys_table`	`Optional[str]`	-	Name of the table to store MCP OAuth signing keys.
`create_schema`	`bool`	`True`	Whether to create the database schema if it doesn't exist. Set to `False` when the schema is managed externally.

Methods

`upsert_sessions`

Upsert multiple sessions in one method call.

Parameters:

sessions (List[Session]): List of sessions to upsert
deserialize (Optional[bool]): Whether to deserialize the sessions. Defaults to True
preserve_updated_at (bool): Request preservation of the sessions' existing updated_at timestamps; see adapter limitations below. Defaults to False

Returns: List[Union[Session, Dict[str, Any]]]

`upsert_memories`

Upsert multiple memories in one method call.

Parameters:

memories (List[UserMemory]): List of memories to upsert
deserialize (Optional[bool]): Whether to deserialize the memories. Defaults to True
preserve_updated_at (bool): Request preservation of the memories' existing updated_at timestamps; see adapter limitations below. Defaults to False

Returns: List[Union[UserMemory, Dict[str, Any]]]

Timestamp preservation by adapter

JsonDb, GcsJsonDb, FirestoreDb, RedisDb, DynamoDb, and InMemoryDb accept preserve_updated_at but do not forward it to their individual upserts. Their bulk methods replace timestamps even when it is True.

PostgresDb, SingleStoreDb, and ValkeyDb honor the flag. MySQLDb, SqliteDb, and MongoDb honor it on their optimized bulk path; their per-record fallback paths do not forward it. Verify timestamps when a migration depends on preserving them.

Methods

upsert_sessions

upsert_memories

Timestamp preservation by adapter

On this page

`upsert_sessions`

`upsert_memories`