Can it improve my query performance?

Absolutely. It performs index gap analysis, identifies redundant indexes, and recommends optimal composite index ordering to reduce query cost and improve selectivity.

Can this skill help me visualize my database structure?

Yes, the Database Designer can automatically generate visual Entity Relationship Diagrams (ERDs) using Mermaid syntax based on your DDL or existing schema definitions.

How does this skill handle database migrations?

It provides structured execution planning for zero-downtime migrations using the expand-contract pattern, including automated data transformation scripts and rollback strategies.

Does it support specific SQL dialects?

The skill focuses on universal database principles and standard SQL, making it highly effective for PostgreSQL, MySQL, SQL Server, and other major relational database systems.

Database Designer

Name: Database Designer
Author: zhangzhang-111-i

byzhangzhang-111-i

0•

Database Management

Architects and optimizes high-performance database schemas with expert-level normalization, indexing, and migration strategies.

The Database Designer skill transforms Claude into a senior database architect capable of designing scalable data models, optimizing query performance through advanced indexing, and managing complex schema migrations. It automates normalization analysis up to BCNF, generates visual Entity Relationship Diagrams (ERD) using Mermaid syntax, and implements safe, zero-downtime migration patterns like expand-contract, making it an essential tool for developers building robust, production-grade backends.

Key Features

010 GitHub stars

02Zero-downtime migration planning using the expand-contract pattern.

03Visual ERD generation using Mermaid diagrams directly from DDL scripts.

04Intelligent index gap analysis and composite index strategy optimization.

05Automated normalization analysis from 1NF through BCNF with denormalization recommendations.

06Comprehensive constraint validation including foreign keys, null checks, and unique constraints.

Use Cases

01Planning and executing complex, zero-downtime schema migrations for high-traffic applications.

02Refactoring a legacy database schema to improve performance and data integrity.

03Designing a new relational data model from scratch with industry best practices.

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

Key Features

010 GitHub stars

02Zero-downtime migration planning using the expand-contract pattern.

03Visual ERD generation using Mermaid diagrams directly from DDL scripts.

04Intelligent index gap analysis and composite index strategy optimization.

05Automated normalization analysis from 1NF through BCNF with denormalization recommendations.

06Comprehensive constraint validation including foreign keys, null checks, and unique constraints.

Use Cases

01Planning and executing complex, zero-downtime schema migrations for high-traffic applications.

02Refactoring a legacy database schema to improve performance and data integrity.

03Designing a new relational data model from scratch with industry best practices.

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