How does it assist with query performance?

The skill performs index gap analysis, evaluates column selectivity for composite indexes, and suggests covering indexes to minimize table lookups.

Can this skill help with zero-downtime deployments?

Yes, it specializes in the 'expand-contract' migration pattern, providing detailed phases to update schemas without taking the application offline.

What database systems does this skill support?

The Database Designer skill provides universal principles and patterns applicable to all major SQL systems like PostgreSQL, MySQL, and SQL Server, as well as NoSQL and Document models.

Does it generate visual diagrams?

Yes, it can automatically generate Entity-Relationship Diagrams (ERD) using Mermaid syntax from your existing DDL or proposed schema changes.

Database Designer

Name: Database Designer
Author: oabdelmaksoud

byoabdelmaksoud

0•

Gestión de Bases de Datos

Architects high-performance database schemas and manages complex migrations using expert-level normalization and indexing strategies.

The Database Designer skill transforms Claude into a senior database architect capable of handling every phase of data modeling and management. It provides automated analysis of normalization levels from 1NF to BCNF, detects missing or redundant indexes, and generates robust migration scripts using zero-downtime patterns like expand-contract. By combining theoretical design principles with practical performance modeling, this skill helps developers build scalable, performant database layers that can evolve without service interruption, making it indispensable for both greenfield projects and legacy refactoring.

Características Principales

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

02Advanced data modeling patterns for Relational, Document, and Graph data

03Automated normalization analysis (1NF to BCNF) and denormalization optimization

04Intelligent index gap detection and composite index strategy modeling

05Automatic Mermaid ERD generation from SQL DDL scripts

060 GitHub stars

Casos de Uso

01Executing complex schema evolutions in production environments without service downtime

02Architecting scalable schemas for new enterprise applications with high data integrity

03Refactoring legacy databases to resolve performance bottlenecks and redundancy

Características Principales

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

02Advanced data modeling patterns for Relational, Document, and Graph data

03Automated normalization analysis (1NF to BCNF) and denormalization optimization

04Intelligent index gap detection and composite index strategy modeling

05Automatic Mermaid ERD generation from SQL DDL scripts

060 GitHub stars

Casos de Uso

01Executing complex schema evolutions in production environments without service downtime

02Architecting scalable schemas for new enterprise applications with high data integrity

03Refactoring legacy databases to resolve performance bottlenecks and redundancy