How does it improve query performance?

It performs index gap analysis, suggests optimal composite index ordering, and identifies redundant indexes that may be slowing down write operations.

Can it help with database documentation?

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

What migration strategies are supported?

It specializes in zero-downtime strategies like the Expand-Contract pattern, ensuring schema changes can be deployed without interrupting application availability.

Does this skill support both SQL and NoSQL databases?

Yes, it provides specialized patterns for relational SQL databases as well as JSONB document models and graph data structures.

Database Designer

Name: Database Designer
Author: oabdelmaksoud

byoabdelmaksoud

0•

データベース管理

Architects, optimizes, and migrates complex database schemas using advanced normalization principles and performance analysis.

The Database Designer skill provides expert-level guidance for creating scalable and maintainable database architectures. It automates normalization analysis from 1NF to BCNF, identifies indexing gaps, and implements zero-downtime migration strategies using the expand-contract pattern. Ideal for both initial schema design and optimizing existing production databases, this skill helps developers avoid common pitfalls like partial dependencies, redundant indexes, and inefficient data types while providing visual ERD generation via Mermaid diagrams.

主な機能

01Zero-Downtime Migration Strategy Planning

020 GitHub stars

03ERD Generation from DDL using Mermaid

04Advanced Modeling for Star, Snowflake, and Document Schemas

05Automated Normalization Analysis (1NF through BCNF)

06Index Optimization & Redundancy Detection

ユースケース

01Refactoring legacy database schemas to improve data integrity and performance

02Designing high-concurrency indexing strategies for read-heavy applications

03Executing complex schema evolutions without application downtime

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add oabdelmaksoud/agention database-designer

For use in Claude.ai and ChatGPT

主な機能

01Zero-Downtime Migration Strategy Planning

020 GitHub stars

03ERD Generation from DDL using Mermaid

04Advanced Modeling for Star, Snowflake, and Document Schemas

05Automated Normalization Analysis (1NF through BCNF)

06Index Optimization & Redundancy Detection

ユースケース

01Refactoring legacy database schemas to improve data integrity and performance

02Designing high-concurrency indexing strategies for read-heavy applications

03Executing complex schema evolutions without application downtime

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add oabdelmaksoud/agention database-designer

For use in Claude.ai and ChatGPT