Skills
.Work. You
Rest

db-design-analysis

Community

Analyze and improve existing database designs.

Software Engineering#indexing#database#normalization#data-integrity#db-design#schema-analysis
Authorwfukatsu
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Existing database designs often suffer from unclear schemas, missing constraints, inefficient indexing, and normalization gaps that degrade performance and complicate maintenance. This agent analyzes an application's database design to extract table definitions, keys, indexes, constraints, and normalization status, delivering actionable insights.

Core Features & Use Cases

  • Table and column extraction: names, data types, NULL constraints, defaults.
  • Indexing analysis: assess index coverage, order, and redundancy.
  • Normalization assessment: detect 1NF-4NF issues and propose improvements.
  • Use Case: refactor an aging database schema to improve query performance and data integrity.

Quick Start

Call /db-design-analysis [target_path] to analyze the project's database design.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: db-design-analysis
Download link: https://github.com/wfukatsu/architecture-redesign-agent/archive/main.zip#db-design-analysis

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.