xataio/xata
Agent skills for Xata serverless PostgreSQL — the xata CLI, the Xata HTTP API, and PostgreSQL administration — plus the hosted Xata MCP server.
Diagnoses and troubleshoots PostgreSQL database issues including slow queries, high CPU, memory pressure, connection problems, locks, deadlocks, disk space, vacuum, autovacuum, table bloat, index optimization, performance tuning, backup, recovery, pg_dump, replication, replication lag, failover, security, permissions, pg_hba.conf, and general database health monitoring. Triggers when users mention PostgreSQL problems, database performance issues, or any database administration tasks.
Use the Xata HTTP API to manage organizations, projects, and branches, authenticate with an API key or OAuth, get a branch connection string, and understand pagination and error conventions. Triggers when calling the Xata API directly (curl, fetch, a Postgres driver, or an SDK), scripting against api.xata.tech, or building an app that programmatically manages Xata.
Manages Xata serverless PostgreSQL databases via the xata CLI. Triggers when working with Xata projects, branches, organizations, authentication, schema migrations (pgroll), data cloning, scratch (on-demand fast) branches, branch metrics, branch logs, or AI-powered SQL generation. Handles xata commands, database branch management, project setup, team management, connection strings, and database administration tasks.