Does it support both SQL and NoSQL databases?

Absolutely. It covers relational normalization and ACID principles for SQL, as well as document embedding and key-value access patterns for NoSQL databases like MongoDB and Redis.

Can it help with ORM-specific performance issues?

Yes, it includes tailored patterns for popular ORMs like SQLAlchemy and Prisma, focusing on eager loading, batching, and selecting only required columns to reduce memory overhead.

Can this skill help with existing slow queries?

Yes, it provides frameworks for reading EXPLAIN plans and implementing specific indexing strategies to identify and resolve performance bottlenecks in slow-running SQL queries.

How does it handle database migrations in production?

The skill follows zero-downtime migration patterns, such as the 'Expand and Contract' method, ensuring that schema changes don't lock tables or break running application code.

Database Design & Optimization

Name: Database Design & Optimization
Author: CloudAI-X

byCloudAI-X

•

1,300

•

데이터베이스 관리

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.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add cloudai-x/claude-workflow-v2 database-design

For use in Claude.ai and ChatGPT

Download Skill