This handles schema normalization analysis, index optimization based on query patterns, and migration script generation with rollback procedures for PostgreSQL and MySQL. You get Mermaid ERDs, composite index recommendations ordered by selectivity, and expand-contract patterns for zero-downtime migrations on large tables. The workflows are solid: feed it DDL or JSON schemas, run the analyzers, get actionable output. It catches the usual problems like missing foreign keys and over-indexing, plus generates validation queries for every migration step. The scope is clear about what it won't do (no live profiling, no NoSQL-specific design), which saves time. If you're designing schemas or planning migrations without locking production tables, this covers the mechanics well.
npx skills add https://github.com/borghei/claude-skills --skill database-designer