Optimizes and manages complex database architectures through expert schema analysis, indexing strategies, and zero-downtime migration planning.
The Database Designer skill transforms Claude into an expert database architect capable of designing, optimizing, and evolving modern database systems. It provides deep analysis for schema normalization, identifies indexing gaps to boost query performance, and generates automated Mermaid ERD diagrams for visual clarity. Whether you are building a new application from scratch or managing high-stakes schema migrations for production environments, this skill ensures your data layer remains scalable, secure, and performant by applying industry-standard principles and automated validation tools.
主な機能
01Zero-downtime migration planning with expand-contract patterns and rollback scripts
02Advanced index optimization including composite strategy and redundancy detection
03Automated normalization analysis (1NF to BCNF) and denormalization strategies
040 GitHub stars
05Automatic ERD generation using Mermaid syntax directly from DDL code
06Security auditing for SQL injection prevention and least-privilege access control
ユースケース
01Planning and executing safe, zero-downtime schema migrations for high-traffic production environments
02Architecting a scalable schema for a new enterprise application with complex relationships
03Optimizing slow-running queries by identifying missing or redundant indexes in an existing database
