Agent skill · software engineering · aradotso
xata-postgres-platform
Expert skill for Xata open-source cloud-native Postgres platform with copy-on-write branching, scale-to-zero, and Kubernetes deployment
Why this skill is useful
Adds executable scripts and specific commands for managing Xata's cloud-native Postgres platform that are not widely known.
What it needs
Requires docker, kind, kubectl, tilt installed locally. Requires xata account access. About 7k tokens when loaded. Last updated 2026-07-09. 70 stars on the source repository.
What this skill does
Xata Postgres Platform Skill by ara.so — Daily 2026 Skills collection. Xata is an open-source, cloud-native Postgres platform built on Kubernetes that provides copy-on-write (CoW) branching, scale-to-zero, auto-scaling, high-availability, PITR backups, and a serverless SQL driver. It sits on top of CloudNativePG and OpenEBS. Architecture Overview Prerequisites Docker Kind Tilt kubectl Local Development Setup Step 1: Create Kind Cluster Step 2: Deploy with Tilt Wait for all resources to become ready. First run downloads images and takes longer; subsequent runs are fast. Step 3: Install and Authenticate the CLI Step 4: Create Project and Branch CLI Reference Authentication Projects Branches Connecting to a Branch Configuration Environment Variables API Key Management (RBAC) Serverless SQL Driver (SQL over HTTP/WebSockets) Xata exposes a serverless driver for executing SQL over HTTP or WebSockets, useful for edge functions and environments without persistent TCP connections. HTTP SQL Query (Go) Direct Postgres Connection (Go) Common Patterns Preview Environment Workflow (CI/CD) Create a per-PR branch for isolated testing, then destroy it after merge: GitHub Actions Integration Programmatic Branch Management (Go) Scale-to-Zero Branches automatically hibernate after inactivity and wake up on the next connection. The SQL Gateway handles the wakeup transparently — clients may experience a short delay (~seconds) on the first connection after hibernation. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aradotso/xata-postgres-platform