Can it help with production performance issues?

Yes, it provides strategies for query optimization, index selection, and interpreting EXPLAIN ANALYZE output to resolve performance bottlenecks.

How does it handle database migrations?

It outlines safe migration patterns, such as adding nullable columns before backfilling, to ensure schema changes don't cause application downtime or data loss.

Is this skill useful for ORM users?

Yes. Even when using an ORM, understanding underlying database patterns like indexing and N+1 query avoidance is critical for building efficient applications.

Does this skill support NoSQL databases?

While it focuses primarily on relational SQL patterns, it includes guidance for document-style storage like JSONB and general data modeling principles applicable to many systems.

Database Design Patterns

Name: Database Design Patterns
Author: Zate

byZate

0•

数据库管理

Implements industry-standard database design patterns, indexing strategies, and migration best practices for optimized data persistence.

This skill provides Claude with expert-level guidance on architecting robust database schemas, optimizing query performance, and managing data migrations safely. It covers essential areas such as normalization levels, naming conventions, composite index ordering, and query anti-patterns. Whether you are designing a new data model from scratch or troubleshooting a legacy database with performance bottlenecks, this skill ensures your architecture is scalable, maintainable, and follows modern best practices for SQL and high-performance data environments.

主要功能

01Advanced indexing strategies including B-tree, GIN, and composite indexes

02Standardized naming conventions for tables, columns, and constraints

03Query optimization techniques and interpretation of execution plans

04Schema design and normalization guidance (1NF to BCNF)

05Safe migration patterns for zero-downtime database updates

060 GitHub stars

使用场景

01Identifying and refactoring slow queries through indexing and anti-pattern removal

02Architecting a scalable relational schema for a complex new application feature

03Planning and executing high-risk data migrations without table-locking or data loss

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add zate/cc-plugins database-patterns

For use in Claude.ai and ChatGPT

Download Skill