본문으로 건너뛰기
TakoAPI
스킬로 돌아가기

database-designer

alirezarezvani 제작

Coding Agents & IDEs
269clawskills.sh가 보고한 다운로드 수
0조회수
좋아요 0개로그인하면 이 스킬에 좋아요를 누를 수 있습니다
—아직 평가 없음
내 평가

요약

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. 1

    Parses DDL to extract tables, columns, and existing constraints

  2. 2

    Runs normalization analysis and flags violations up to BCNF

  3. 3

    Identifies foreign keys and query patterns missing index coverage

  4. 4

    Models selectivity and query cost for proposed indexes

  5. 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-designer

CLI 명령을 실행하거나, 프롬프트를 Claude Code, Cursor, Codex 등 사용하는 코딩 에이전트에 붙여넣으세요.

링크