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

•

数据库管理

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

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.

主要功能

01Comprehensive schema design with ER diagram generation using Mermaid syntax

02Pre-built patterns for audit logs, soft deletes, and versioning constraints

03Zero-downtime migration planning with safe additive change strategies

042 GitHub stars

05Performance tuning via advanced index checklists and query optimization

06Native integration patterns for Prisma, Drizzle, and TypeORM

使用场景

01Refactoring a legacy database to resolve N+1 query performance issues

02Designing a scalable multi-tenant schema for a new SaaS application

03Planning a complex column rename or type change without production downtime

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add srstomp/pokayokay database-design

For use in Claude.ai and ChatGPT

Download Skill