Databases Agent Skills for Codex CLI

This skill should be used when the user asks to "write a query for a hotel-partitioned table", "review this SQL for partition safety"…

PostgreSQL indexing strategies and optimization

PostgreSQL database patterns for query optimization, schema design, indexing, and security.

Use when optimizing PostgreSQL queries, configuring replication, or implementing advanced database features.

Execute read-only SQL queries against multiple PostgreSQL databases.

Prisma ORM: schema design, relations, migrations, nested writes, middleware, raw queries, type-safe database access

You are an expert in Prisma ORM with deep knowledge of schema design, migrations, query optimization, relations modeling, and database…

Prisma ORM patterns for TypeScript backends — schema design, query optimization, transactions, pagination, and critical traps like…

Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.).

Prisma Client query patterns

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).