Architects high-performance database schemas, indexing strategies, and zero-downtime migration patterns for SQL and NoSQL systems.
The Database Design skill empowers Claude to act as a senior database administrator and architect. It provides structured workflows for designing normalized schemas, identifying and fixing N+1 query bottlenecks, and implementing sophisticated indexing strategies like partial and covering indexes. Whether you are building a new data model from scratch or refactoring a legacy system for performance, this skill provides the patterns needed for efficient query execution, safe migrations, and optimal connection pooling across various SQL and NoSQL environments.
主要功能
01Comprehensive schema normalization (1NF to 3NF) and strategic denormalization patterns.
02ORM best practices for modern tools like SQLAlchemy, Prisma, and bulk data operations.
03Advanced indexing strategy guidance including B-tree, GIN, GiST, and composite indexes.
04Query optimization frameworks using EXPLAIN plan analysis and N+1 detection.
051,300 GitHub stars
06Zero-downtime migration workflows for safe production schema updates.
使用场景
01Refactoring existing application code to eliminate performance-degrading N+1 query patterns.
02Designing a scalable multi-tenant database schema for a new SaaS application.
03Planning and executing a complex database migration without incurring application downtime.
