finds.dev

xataio/agent

AI agent expert in PostgreSQL

View on GitHubHomepage ↗

★ 1,094TypeScriptApache-2.0updated Apr 2026

// the take

An open-source agent that watches a Postgres instance, runs read-only diagnostic queries (pg_stat_statements, pg_locks, vacuum stats), and suggests fixes for things like high CPU, bloated connections, or slow queries. Built by the Xata team from their own on-call experience running lots of Postgres instances. Good fit if you want an LLM doing first-pass triage before a human looks at the dashboard.

It's playbook-driven rather than a free-roaming agent — troubleshooting steps are written out and the tool calls are a fixed set of preset SQL, which cuts down on an LLM improvising destructive queries. It's not locked to one model vendor: OpenAI, Anthropic, Deepseek, Ollama, and LiteLLM are all wired in through a provider abstraction. The AWS RDS/Aurora and GCP Cloud SQL integrations go beyond 'paste a connection string' — there's an actual onboarding flow to pull instance metadata and CloudWatch logs. It also has a real eval suite (judge-eval, tool-choice tests in vitest) that checks the agent picks the right tool for a scenario, which most LLM-agent repos skip entirely.

The 'never run destructive commands' guarantee rests on the preset tool list being exhaustive, not on a runtime approval gate — that's still an open roadmap item, so a bad prompt or a gap in the tool set is the actual safety boundary right now. Self-hosting means running a second Postgres just to store the agent's own config/history/chat state, on top of the Next.js app itself — real operational weight for something pitched as a lightweight on-call helper. Azure Postgres and DigitalOcean aren't supported, and the two MCP integrations (acting as a server, calling tools over the network) are both unchecked on the roadmap, so interoperability with other agent tooling isn't there yet. The hosted/cloud version is waitlist-only, so self-hosting is the only way to actually use it today.

We read the README, the directory tree and a key source file in November 2026. Nobody pays to be listed. How we judge →

// at a glance

Stars
1,094
Forks
81
Language
TypeScript
License
Apache-2.0
Last commit
20 Apr 2026

// nearby

If agent isn't quite it.

All repos →