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

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.

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.

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

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

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

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