Xata Skills

A collection of agent skills for AI coding assistants.

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

Reference	Description
monitoring	Health checks, metrics review
slow-queries	Query analysis, EXPLAIN plans
high-cpu	CPU investigation
memory	Memory pressure, OOM
connections	Connection management
locks	Locks and deadlocks
disk-space	Storage management
vacuum	Vacuum, autovacuum, bloat
indexes	Index optimization
tuning	Configuration tuning
backup	Backup and recovery
replication	Replication, failover
security	Access 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

Reference	Description
auth	Login, profiles, tokens
projects	Project setup, configuration
branches	Branch management, URLs
migrations	Schema migrations (pgroll)
organizations	Team and org management
keys	API key management
clone	Database 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.