跳到正文
TakoAPI
返回技能列表

database-designer

由 alirezarezvani 提供

Coding Agents & IDEs
269下载量由 clawskills.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 或你在用的任意编程智能体里。

链接