Databases Agent Skills for Codex CLI

Recalculates hashkeys and hashdiffs across an existing raw vault with datavault4dbt's rehashing macros after a change to the hash…

Design and review persistence boundaries and data-access abstractions in backend systems.

Expert workflow for creating, extending, and validating Reqvire structural ontology elements for IT engineering, systems engineering…

Checks session scope mismatch, missing cleanup, pool config, error path leaks, resource holding.

Agent retrieval policy for intelligent memory search.

Review application data structures, fixtures, schemas, TypeScript types, persistence models, API contracts, and UI projections.

Use when working with RisingWave — streaming SQL database, materialized views, sources, sinks, CDC from PostgreSQL/MySQL, Kafka ingestion…

Schema and data migration patterns across all engines.

Database schema design principles and patterns.

Enforces standardized PostgreSQL schema design patterns and best practices for robust relational data modeling.

PostgreSQL optimization including indexes, query plans, partitioning, JSONB operations, and connection pooling

Deep operational guide for 15 key-value stores.

Phase 2: The Razor. Filter and merge items based on the Lens.

When to activate: ActiveRecord, includes preload eager_load, N+1 queries, Bullet gem, database migrations, ActiveRecord::Rollback…

Query the witness-anchored ruLake cache — search, verify, explain, or refresh.

Run SQL queries against the WordPress development database.

When to activate: Rust database, sqlx, diesel, PostgreSQL, SQLite, MySQL, migrations, queries, connection pools, transactions

Ingest data from S3 into Bauplan safely using branch isolation and quality checks before publishing.

Use when adding/changing DB schema, migrations, RLS/policies, or data backfills.

Use when the user asks to design database schemas, plan data migrations, optimize queries, choose between SQL and NoSQL, or model data…

Optimizes database queries and improves performance across PostgreSQL and MySQL systems.