Databases Agent Skills

Generate realistic seed/fixture data based on schema analysis

Redis command-line interface (redis-cli) reference and usage guide.

Designs, implements, and reviews production-grade Redis architectures for caching, distributed locking, rate limiting, and session…

Enforces Redis best practices and safety standards across multiple languages to prevent performance bottlenecks and memory leaks.

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