Pular para o conteúdo
TakoAPI
Voltar às skills

database-designer

por alirezarezvani

Coding Agents & IDEs
269Downloads informados pelo clawskills.sh
0Visualizações
0 curtidaEntre para curtir esta skill
—Ainda sem avaliações
Sua avaliação

Resumo

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

ENTRADA

User asks: Analyze this schema and suggest index improvements

AGENTE
  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

SAÍDA

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

Instalação

clawhub install alirezarezvani/database-designer

Execute o comando da CLI ou cole o prompt no Claude Code, Cursor, Codex ou no agente de código que você usa.

Links