Assistant Agent PostgreSQL — assistant-agent-pg

The database for the AI assistant agent service.

Details

Field	Value
Server name	assistant-agent-pg-62be6d5f
FQDN	assistant-agent-pg-62be6d5f.postgres.database.azure.com
Resource group	assistant-agent-rg
Region	Central India
Engine	PostgreSQL 16
SKU	Standard_B1ms (Burstable)
Storage	32 GB

Databases

Database	Owner Service	Purpose
assistant_agent	Assistant Agent	Agent sessions, conversations, state
postgres	System	Default admin database

Connecting

# Direct connection (if public access is enabled)
psql "host=assistant-agent-pg-62be6d5f.postgres.database.azure.com \
  dbname=assistant_agent user=<admin-user> sslmode=require"

# Via Azure CLI tunnel
az postgres flexible-server connect \
  --name assistant-agent-pg-62be6d5f \
  --resource-group assistant-agent-rg \
  --admin-user <admin-user> \
  --admin-password <password> \
  --database-name assistant_agent

Backups

Azure automatically retains backups for 7 days.

# Restore to a new server
az postgres flexible-server restore \
  --resource-group assistant-agent-rg \
  --name assistant-agent-pg-restored \
  --source-server assistant-agent-pg-62be6d5f \
  --restore-time "2026-05-29T12:00:00Z"