# xataio/agent

AI agent expert in PostgreSQL

Repository: https://github.com/xataio/agent
Canonical: https://ross.abutalabs.com/products/xataio-agent
Homepage: https://xata.io
Language: TypeScript
License: Apache-2.0
License Family: permissive
Topics: agent, ai, anthropic, llm, openai, postgres, postgresql
Archived: true
Last push: 2026-04-20T06:50:54+00:00

## Health v2 (maintenance only)
Score: 10/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 78, release rhythm 49, longevity 40
- inputs: {"age_days": 562, "days_push": 135, "days_rel": 341, "gap_med": 7, "n_releases_24m": 6}
- flags: archived
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1085, forks 81 (observed 2026-08-28T04:03:31.655120+00:00)

## What it is
Xata Agent is an open-source AI agent that acts as a PostgreSQL expert, monitoring database logs and metrics, diagnosing root causes of issues, and suggesting fixes like configuration tuning and indexing. It supports models from OpenAI, Anthropic, and Deepseek, and is self-hosted via Docker with a Postgres backend for its own state.

## Use cases
- monitor postgres database for issues with ai
- troubleshoot high cpu usage in postgresql
- get indexing suggestions for slow queries
- tune postgres configuration automatically
- ai sre for database operations
- vacuum and maintenance help for postgres
- slack alerts when database is unhealthy

## When to choose
- you run Postgres (including RDS/Aurora) and want proactive AI-driven monitoring and troubleshooting
- you want an open-source, self-hosted alternative to DBA-as-a-service
- you need safe, read-only diagnostics since the agent never runs destructive commands

## When to avoid
- you need a general-purpose SQL client or database GUI
- you don't use PostgreSQL
- you want fully autonomous agents that can execute schema changes or destructive operations

## Facets
- artifact type: service
- maturity: active
- function: agent-framework, monitoring, llm-inference, database, alerting, chatbot
- domain: databases, monitoring, large-language-models
- platform: self-hosted
- tags: postgres, database-observability, sre, performance-tuning, slack-notifications, cloudwatch, rds, openai, anthropic, ai-agents, devops, docker, web-server, typescript

## Member repositories
- xataio/agent (main) score 10

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:31.655120+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:49:54.157199+00:00, confidence not recorded.
  - readme: https://github.com/xataio/agent (fetched 2026-08-28T04:03:31.655120+00:00, sha 76fb09dfd6af)
  - homepage: https://xata.io (fetched 2026-08-29T12:52:43.380913+00:00, sha 611bf017601f)
  - site_page: https://xata.io/docs/overview (fetched 2026-08-29T12:52:43.390365+00:00, sha 482f495c09f3)
  - site_page: https://xata.io/about (fetched 2026-08-29T12:52:43.394652+00:00, sha d5286d577289)
  - site_page: https://xata.io/pricing (fetched 2026-08-29T12:52:43.392366+00:00, sha 1a3badf7f79b)
- Data as of 2026-08-30T08:39:29.467469+00:00.