database-designer
por alirezarezvani
Coding Agents & IDEsResumo
A comprehensive database design skill that provides expert-level analysis, optimization, and migration capabilities.
Descrição
O que esta skill faz
Analyzes and optimizes database schemas through automated normalization detection, index gap analysis, and migration planning. Generates ERD diagrams from DDL and produces zero-downtime migration scripts with rollback support.
Combines schema analysis, index optimization, and migration planning in one workflow instead of using separate tools for each.
Quando usá-la
- Detecting normalization violations in a legacy schema
- Generating an ERD diagram from existing DDL
- Planning a zero-downtime column type migration
- Finding missing indexes on foreign key columns
- Designing composite indexes for slow queries
Exemplo de fluxo de trabalho
User asks: Analyze this schema and suggest index improvements
- 1
Parses DDL to extract tables, columns, and existing constraints
- 2
Runs normalization analysis and flags violations up to BCNF
- 3
Identifies foreign keys and query patterns missing index coverage
- 4
Models selectivity and query cost for proposed indexes
- 5
Generates index creation statements with rationale
List of recommended indexes with creation SQL, estimated performance impact, and notes on any redundant existing indexes
Instalação
clawhub install alirezarezvani/database-designerExecute o comando da CLI ou cole o prompt no Claude Code, Cursor, Codex ou no agente de código que você usa.