Database Designer

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.

Install to Claude Code

npx -y skills add borghei/claude-skills --skill database-designer --agent claude-code