database-designer

Topics in the source

• Database Designer - POWERFUL Tier Skill
• Overview
• Core Competencies
• Schema Design & Analysis
• Index Optimization
• Migration Management
• Tool Workflow (run these — do not analyze schemas by hand)
• 1. Analyze the schema

A comprehensive database design skill that provides expert-level analysis, optimization, and migration capabilities for modern database systems. This skill combines theoretical principles with practical tools to help architects and developers create scalable, performant, and maintainable database schemas. Normalization Analysis: Automated detection of normalization levels (1NF through BCNF) Denormalization Strategy: Smart recommendations for performance optimization Data Type Optimization: Identification of inappropriate types and size issues Constraint Analysis: Missing foreign keys, unique constraints, and null checks Naming Convention Validation: Consistent table and column naming patterns ERD Generation: Automatic Mermaid diagram creation from DDL Index Gap Analysis: Identification of missing indexes on foreign keys and query patterns Composite Index Strategy: Optimal column ordering for multi-column indexes Index Redundancy Detection: Elimination of overlapping and unused indexes Performance Impact Modeling: Selectivity estimation and query cost analysis Index Type Selection: B-tree, hash, partial, covering, and specialized indexes Zero-Downtime Migrations: Expand-contract pat

This is an excerpt. Refer to the complete source and its current requirements.