Which databases are supported by this skill?

The skill supports relational databases like PostgreSQL, MySQL, and SQLite, document databases like MongoDB, and modern ORMs including Prisma, Drizzle, and TypeORM.

Does it support visual modeling?

It can generate detailed Entity-Relationship (ER) diagrams using Mermaid syntax to help you visualize table relationships and cardinality.

Can this skill help prevent production downtime during migrations?

Yes, it emphasizes safe migration patterns, such as additive changes, non-blocking index creation, and multi-step column updates to ensure high availability.

How does it help with database performance?

It provides checklists for index design, strategies for denormalization, and guidance on identifying slow queries through execution plan analysis.

How does it handle data integrity?

The skill follows a 'Data Integrity First' principle, enforcing constraints like foreign keys, checks, and unique indexes at the database level rather than just the application level.

Database Design

Name: Database Design
Author: srstomp

bysrstomp

•

Database Management

Designs efficient database schemas, plans safe migrations, and optimizes queries for relational and document databases using industry-best practices.

About

The Database Design skill transforms Claude into a senior database architect capable of guiding complex data modeling tasks. It provides a structured process for building maintainable, high-performance schemas—from initial entity-relationship modeling to implementing advanced indexing and zero-downtime migration plans. By prioritizing data integrity and explicit constraints, this skill helps developers avoid common anti-patterns while ensuring compatibility with modern ORMs like Prisma, Drizzle, and TypeORM.

Key Features

Comprehensive schema design with ER diagram generation using Mermaid syntax
Pre-built patterns for audit logs, soft deletes, and versioning constraints
Zero-downtime migration planning with safe additive change strategies
2 GitHub stars
Performance tuning via advanced index checklists and query optimization
Native integration patterns for Prisma, Drizzle, and TypeORM

Use Cases

Refactoring a legacy database to resolve N+1 query performance issues
Designing a scalable multi-tenant schema for a new SaaS application
Planning a complex column rename or type change without production downtime

About

Key Features

Comprehensive schema design with ER diagram generation using Mermaid syntax
Pre-built patterns for audit logs, soft deletes, and versioning constraints
Zero-downtime migration planning with safe additive change strategies
2 GitHub stars
Performance tuning via advanced index checklists and query optimization
Native integration patterns for Prisma, Drizzle, and TypeORM

Use Cases

Refactoring a legacy database to resolve N+1 query performance issues
Designing a scalable multi-tenant schema for a new SaaS application
Planning a complex column rename or type change without production downtime