Does this skill support both SQL and NoSQL databases?

Yes, while it features deep relational expertise like normalization analysis, the optimization strategies and data modeling principles are applicable across various modern database systems.

Can it help me visualize my current database structure?

Absolutely. The Database Designer skill can automatically generate Mermaid-based Entity Relationship Diagrams (ERD) directly from your DDL or schema definitions.

Will it help reduce my database query costs?

Yes, by performing index gap analysis and identifying redundant or overlapping indexes, it helps optimize query execution and resource utilization.

How does it assist with production migrations?

It provides structured plans for zero-downtime migrations, utilizing the expand-contract pattern to ensure your application stays online during schema changes.

Database Designer

Name: Database Designer
Author: alirezarezvani

byalirezarezvani

•

5,225

•

Database Management

Optimizes database schemas, index strategies, and migration workflows for scalable and performant data architectures.

Database Designer is a comprehensive skill for Claude Code that provides expert-level analysis and implementation guidance for modern database systems. It enables developers to automate complex tasks such as normalization analysis (1NF to BCNF), index gap detection, and the generation of ERD diagrams using Mermaid syntax. By combining theoretical principles with practical patterns like zero-downtime 'expand-contract' migrations, this skill ensures that your database layer remains performant, secure, and maintainable as your application scales.

Key Features

015,225 GitHub stars

02Advanced index optimization including gap analysis and redundancy detection

03ERD generation and visual schema modeling using Mermaid diagrams

04Security auditing for constraint validation and SQL injection prevention

05Automated normalization analysis and denormalization strategy recommendations

06Zero-downtime migration planning using the expand-contract pattern

Use Cases

01Planning and executing complex schema evolutions without service downtime

02Designing a high-performance relational schema for a new production application

03Refactoring existing database indexes to resolve performance bottlenecks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add alirezarezvani/claude-skills database-designer

For use in Claude.ai and ChatGPT

Download Skill