Skip to content

xataio/xata

v1.1.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

branching-postgresql-for-agents

Creates isolated Xata PostgreSQL branches with realistic data for fixing bugs, building features, and validating changes without querying the source or production database. Works with any coding assistant that has shell access; requires authenticated xata and installed psql, plus authenticated gh only for a supplied GitHub issue or pull request.

Install for Claude Code with the Xata CLI:

xata skill install branching-postgresql-for-agents --agent claude-code

This requires a CLI release containing xata skill install. The installer has merged into the frontend repository's main branch but is not yet released.

Alternatively, install with the skills CLI:

npx skills add xataio/skills --skill branching-postgresql-for-agents

The workflow is self-contained and includes its Apache-2.0 license; no other skill is required.

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.