Skip to content

xataio/xata

v1.0.0Apache-2.0

Agent skills for Xata serverless PostgreSQL — the xata CLI, the Xata HTTP API, and PostgreSQL administration — plus the hosted Xata MCP server.

GitHubOpen Website

Xata Skills

A collection of agent skills for AI coding assistants, packaged as an Agent Plugin.

A client that implements the standard loads it from a clone of this repository:

plugin.json    # manifest
mcp.json       # hosted Xata MCP server
skills/        # one directory per skill, each with a SKILL.md

MCP server

The plugin declares Xata's hosted MCP server at https://api.xata.tech/mcp, adding typed tools for organizations, projects, branches, and SQL. It is remote (nothing to install) and speaks Streamable HTTP only.

Authentication is handled by your client — no credentials are committed here. Most clients run the browser OAuth flow on first connection. For headless use, add the server with an API key directly instead:

claude mcp add --transport http xata https://api.xata.tech/mcp \
  --header "Authorization: Bearer $XATA_API_KEY"

See the Xata MCP documentation for per-client setup.

Installation

Install all skills:

npx skills add xataio/skills

Install a specific skill:

npx skills add xataio/skills --skill managing-postgresql

For more information about skills, visit skills.sh.

Available Skills

managing-postgresql

Diagnoses and troubleshoots PostgreSQL database issues including slow queries, high CPU, memory pressure, connections, locks, vacuum, indexes, and replication.

npx skills add xataio/skills --skill managing-postgresql
ReferenceDescription
monitoringHealth checks, metrics review
slow-queriesQuery analysis, EXPLAIN plans
high-cpuCPU investigation
memoryMemory pressure, OOM
connectionsConnection management
locksLocks and deadlocks
disk-spaceStorage management
vacuumVacuum, autovacuum, bloat
indexesIndex optimization
tuningConfiguration tuning
backupBackup and recovery
replicationReplication, failover
securityAccess control, permissions

using-xata-cli

Manages Xata serverless PostgreSQL databases via the xata CLI. Covers authentication, projects, branches, schema migrations (pgroll), organizations, API keys, and database cloning with anonymization.

npx skills add xataio/skills --skill using-xata-cli
ReferenceDescription
authLogin, profiles, tokens
projectsProject setup, configuration
branchesBranch management, URLs
migrationsSchema migrations (pgroll)
organizationsTeam and org management
keysAPI key management
cloneDatabase cloning

using-xata-api

Uses 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.

npx skills add xataio/skills --skill using-xata-api

Contributing

See CONTRIBUTING.md for guidelines on creating and maintaining skills.