Databases Agent Skills for VS Code

Prisma relation modeling patterns

Prisma schema design patterns

Required reference for Prisma ORM 7 SQL driver adapter work.

Build read models and projections from event streams.

Use when writing, editing, reviewing, or debugging q/kdb+ code (.q files), querying kdb+ tables, translating Python to q, running q from…

High-performance vector similarity search engine for RAG and semantic search.

Diagnose and improve PostgreSQL query performance using measured workload evidence.

Execute use when you need to work with query optimization.

Translate SQL queries between different database dialects with function mapping and optimization

Writes and executes SQL queries from simple SELECTs to complex multi-table JOINs, aggregations, and subqueries.

Run read-only SQL against the local Postgres app database (SELECT, EXPLAIN, EXPLAIN ANALYZE on SELECT).

This skill should be used when the user asks "how do I build a job queue in Postgres", "what is SELECT FOR UPDATE SKIP LOCKED", "why are…

Manages PostgreSQL databases on Railway including automated provisioning, migrations, ORM integration, and backup workflows.

Azure Cosmos DB SDK for Python (NoSQL API).

Connect to Azure Database for PostgreSQL Flexible Server from Node.js/TypeScript using the pg (node-postgres) package.

Guides Go services that use database/sql directly with a lightweight in-house query builder (not an ORM like GORM or a codegen tool like…

Deep-dive into Amazon RDS and Aurora database design, engine selection, high availability, and operations.

Query the production Supabase Postgres read-only via psql using the SELECT-only agents_readonly role.

This skill should be used when the user asks "why is this query slow", "read this EXPLAIN output", "why is the planner not using my…

Redis caching patterns, pub/sub, sessions, rate limiting, and data structures.

Redis caching, sessions, and queue driver in WordPress via Acorn — lando redis-cli, Cache::remember(), Cache::tags(), cache invalidation…