Xata Agent, your AI expert in PostgreSQL
5.2K
Xata Agent is an AI agent that monitors your PostgreSQL databases, investigates incidents, finds root causes, and suggests performance improvements. It does this by monitoring logs and metrics and by using extensions like pg_stat_statemets.
It is like having a new SRE hire that happens to be an expert in Postgres.
Example docker compose file:
services:
postgres:
image: postgres:17
environment:
POSTGRES_USER: ${POSTGRES_USER:-dbagent}
POSTGRES_PASSWORD: ${POSTGRES_PASSWORD:-changeme}
POSTGRES_DB: ${POSTGRES_DB:-dbagent}
ports:
- '5432:5432'
volumes:
- agent_postgres_data:/var/lib/postgresql/data
- ./init.sql:/docker-entrypoint-initdb.d/init.sql
xata-agent:
image: xataio/agent
environment:
DATABASE_URL: postgresql://${POSTGRES_USER:-dbagent}:${POSTGRES_PASSWORD:-changeme}@postgres:5432/${POSTGRES_DB:-dbagent}
NODE_ENV: production
AUTH_TRUST_HOST: ${AUTH_TRUST_HOST:-localhost}
env_file: '.env.production'
ports:
- '8080:8080'
depends_on:
- postgres
volumes:
agent_postgres_data:
And use an .env.production file like this:
# Public URL of the app
PUBLIC_URL=http://localhost:8080
# LLM API credentials
OPENAI_API_KEY=
DEEPSEEK_API_KEY=
ANTHROPIC_API_KEY=
The init.sql file should just create the database:
SELECT 'CREATE DATABASE dbagent' WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'dbagent');
Content type
Image
Digest
sha256:dc52c57b8…
Size
1.2 GB
Last updated
about 1 year ago
docker pull xataio/agent:0.4.0