database-designer
alirezarezvani 제작
Coding Agents & IDEs요약
A comprehensive database design skill that provides expert-level analysis, optimization, and migration capabilities.
설명
이 스킬이 하는 일
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.
사용 시점
- 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
예시 워크플로
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
설치
clawhub install alirezarezvani/database-designerCLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.