How does this skill improve database performance?

It identifies missing indexes, suggests optimal composite index ordering, and detects redundant indexes to reduce query costs and storage overhead.

What levels of normalization does it check?

The skill provides automated detection and analysis of normalization levels ranging from First Normal Form (1NF) through Boyce-Codd Normal Form (BCNF).

Does it support database visualization?

Yes, the skill can automatically generate Entity Relationship Diagrams (ERDs) using Mermaid syntax directly from your DDL or schema definitions.

Can it help with migrating production databases?

Yes, it specializes in zero-downtime migration patterns like expand-contract and provides automated scripts with rollback strategies for safe schema evolution.

Database Designer

Name: Database Designer
Author: zhangzhang-111-i

byzhangzhang-111-i

0•

数据库管理

Architects, optimizes, and migrates complex database schemas using expert-level analysis and performance-driven best practices.

The Database Designer skill empowers Claude to act as a senior database architect, providing comprehensive support for the entire database lifecycle. It enables automated normalization analysis, intelligent indexing strategies, and safe schema migration planning to ensure data systems are scalable, performant, and secure. Whether you are designing a new system from scratch or refactoring a legacy database, this skill offers practical tools like ERD generation and zero-downtime migration scripts to streamline complex database management tasks.

主要功能

01Zero-downtime migration planning with expand-contract patterns

02Intelligent index gap analysis and composite index strategies

03Data type optimization and naming convention validation

04Automated normalization analysis from 1NF through BCNF

05Automatic ERD generation using Mermaid diagram syntax

060 GitHub stars

使用场景

01Designing high-performance schemas for new applications

02Optimizing production databases to resolve slow queries and index redundancy

03Planning and executing safe, zero-downtime schema migrations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add zhangzhang-111-i/claude-skills111 database-designer

For use in Claude.ai and ChatGPT

主要功能

01Zero-downtime migration planning with expand-contract patterns

02Intelligent index gap analysis and composite index strategies

03Data type optimization and naming convention validation

04Automated normalization analysis from 1NF through BCNF

05Automatic ERD generation using Mermaid diagram syntax

060 GitHub stars

使用场景

01Designing high-performance schemas for new applications

02Optimizing production databases to resolve slow queries and index redundancy

03Planning and executing safe, zero-downtime schema migrations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add zhangzhang-111-i/claude-skills111 database-designer

For use in Claude.ai and ChatGPT