db

Plugin db in Adminhead/claude-plugins. Commands read from the repo's manifest — today.

Skills (4)

• database-design

  Portable relational schema design and review: entities, keys, relationships, NOT NULL/UNIQUE/CHECK/FK constraints and delete actions, normalization vs justified denormalization, logical access paths, and expand-contract migrations with backfills. Use when adding or changing tables, ORM models, or mi

• mysql

  Measured MySQL and MariaDB diagnosis and change: engine and version checks, EXPLAIN risk signals, composite index choice, upsert syntax differences, keyset pagination, InnoDB lock waits and deadlocks, SKIP LOCKED queue claims, online DDL, connection-pool timeouts, replica lag, and least-privilege gr

• postgres

  Measured PostgreSQL diagnosis and change: EXPLAIN/ANALYZE, index choice (B-tree, GIN, BRIN, partial, expression, INCLUDE), statistics, locks and wait events, MVCC/vacuum, isolation and serialization retries, SKIP LOCKED queues, partitioning, CREATE INDEX CONCURRENTLY, online DDL, row-level security

• redis

  Redis and Valkey usage in applications: choosing data structures, cache-aside and write-through caching, TTL and key design, eviction policy for caches versus queues, SCAN instead of KEYS, cache stampede control, fixed- and sliding-window rate limits, token-checked locks, Streams versus Pub/Sub, and