How does this skill handle database migrations?

It implements the expand-contract pattern to facilitate zero-downtime migrations, ensuring safe column renames and structural changes without service interruption.

Can it help with SaaS data isolation?

Absolutely, it includes decision guides and patterns for shared schemas with Row-Level Security (RLS), schema-per-tenant, and database-per-tenant models.

Does it support modern primary key formats?

Yes, it provides detailed comparisons and implementation logic for UUID v7, ULID, KSUID, Snowflake IDs, and CUID2.

What database anti-patterns does this skill help avoid?

It identifies and prevents common pitfalls such as Entity-Attribute-Value (EAV) designs, polymorphic associations, over-indexing, and 'god tables' that hurt scalability.

Database Schema Design

Name: Database Schema Design
Author: rnavarych

byrnavarych

•

Database Management

Architects scalable database schemas using advanced normalization, modern primary key strategies, and zero-downtime migration patterns.

This skill equips Claude with deep expertise in database architecture, covering everything from initial modeling to long-term schema evolution. It provides guidance on normalization forms (1NF-BCNF), multi-tenancy strategies for SaaS applications, and modern identifier selection like UUID v7 or ULID. Whether you are designing a fresh database, implementing audit trails, or planning a complex migration using the expand-contract pattern, this skill ensures your data layer remains performant, maintainable, and free from common anti-patterns like EAV or god tables.

Key Features

01Advanced normalization and denormalization patterns

02Multi-tenancy architecture (shared schema vs. isolated)

03Temporal data management and SCD Type 2 implementation

04Zero-downtime schema evolution (expand-contract pattern)

0511 GitHub stars

06Modern Primary Key strategy comparison (UUID v7, ULID, KSUID)

Use Cases

01Refactoring a legacy schema to improve performance and normalization

02Implementing comprehensive audit trails and versioned data tracking

03Designing a new relational database for a multi-tenant SaaS application

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rnavarych/alpha-engineer schema-design

For use in Claude.ai and ChatGPT

Key Features

01Advanced normalization and denormalization patterns

02Multi-tenancy architecture (shared schema vs. isolated)

03Temporal data management and SCD Type 2 implementation

04Zero-downtime schema evolution (expand-contract pattern)

0511 GitHub stars

06Modern Primary Key strategy comparison (UUID v7, ULID, KSUID)

Use Cases

01Refactoring a legacy schema to improve performance and normalization

02Implementing comprehensive audit trails and versioned data tracking

03Designing a new relational database for a multi-tenant SaaS application

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add rnavarych/alpha-engineer schema-design

For use in Claude.ai and ChatGPT