Databases Agent Skills

This skill should be used when the user asks "which isolation level do I need", "why did concurrent requests break this invariant"…

ACID properties, isolation levels, locks, deadlocks, and transaction design.

Wrap multi-write operations in transactions; use dispatchAfterCommit and idempotency patterns to ensure consistency

Design and review transaction boundaries, isolation, locking, retries, and consistency for backend workflows.

Diagnoses common datavault4dbt failures — satellites capturing too many or too few rows, multi-source high-water-mark issues…

TypeORM migration patterns

Optimize slow analytical SQL by reading query/EXPLAIN plans, cutting scanned data, fixing join strategy, and using partitioning…

Provision a zero-config, no-signup, temporary Upstash Redis database for an AI agent with a single POST to…

In-memory caching in Golang using samber/hot — eviction algorithms (LRU, LFU, TinyLFU, W-TinyLFU, S3FIFO, ARC, TwoQueue, SIEVE, FIFO)…

usql is a universal command-line interface for SQL databases including PostgreSQL, MySQL, SQLite, Oracle, SQL Server, and dozens more.

Connect to live PostgreSQL database to validate schema assumptions, compare pg_dump vs pgschema output, and query system catalogs…

This skill utilizes the data-validation-engine plugin to ensure database integrity.

Vector database operations for embeddings and semantic search.

Work with the @upstash/vector TypeScript/JavaScript SDK, a serverless vector database for embeddings, similarity search, semantic search…

Veeva Vault migration deep dive for enterprise operations.

Integrate Redis-compatible Vercel KV for caching, session management, and rate limiting in Next.js applications.

Vercel KV (Redis-compatible key-value storage via Upstash).

ClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.

Use when preparing a PVLDB artifact for the pVLDB Reproducibility Evaluation or the ACM availability badge, covering the mandatory…

Use when engineering reproducibility into a VLDB paper before submission, covering hardware and configuration disclosure, dataset and…

Universal database IDE CLI — query PostgreSQL, MySQL, SQLite, BigQuery, MongoDB with cost projection