Bỏ qua tới nội dung
TakoAPI
Quay lại kỹ năng

database-designer

bởi alirezarezvani

Coding Agents & IDEs
269Lượt tải do clawskills.sh công bố
0Lượt xem
0 lượt thíchĐăng nhập để thích kỹ năng này
—Chưa có đánh giá
Đánh giá của bạn

Tóm tắt

A comprehensive database design skill that provides expert-level analysis, optimization, and migration capabilities.

Mô tả

Kỹ năng này làm gì

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.

Khi nào nên dùng

  • 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

Quy trình ví dụ

ĐẦU VÀO

User asks: Analyze this schema and suggest index improvements

AGENT
  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

ĐẦU RA

List of recommended indexes with creation SQL, estimated performance impact, and notes on any redundant existing indexes

Cài đặt

clawhub install alirezarezvani/database-designer

Chạy lệnh CLI, hoặc dán prompt vào Claude Code, Cursor, Codex hay coding agent bạn đang dùng.

Liên kết