Does it support serverless database configurations?

Yes, it includes patterns for connection pooling and specific client configurations for serverless environments like Vercel and AWS Lambda.

How does this skill help with database performance?

It provides specific guidance on avoiding N+1 query issues, implementing proper compound indexes, and using cursor-based pagination for large datasets.

Can it assist with data security and compliance?

The skill includes patterns for automated audit trails and multi-tenant data isolation, which are critical for security-conscious and compliant applications.

Which ORMs are supported by this skill?

The skill provides specialized patterns for Prisma and Drizzle, but also includes raw SQL best practices applicable to any relational database system.

Database Patterns & Schema Design

Name: Database Patterns & Schema Design
Author: Wania-Kazmi

byWania-Kazmi

•

데이터베이스 관리

Implement production-grade database architectures, optimized queries, and robust migration strategies using modern ORMs and SQL best practices.

This skill equips Claude with specialized knowledge for architecting scalable and performant database layers. It focuses on normalization, efficient schema design, and advanced ORM patterns—specifically for Prisma and Drizzle. By providing standardized implementations for common enterprise requirements like soft deletes, audit trails, multi-tenancy, and connection pooling, it ensures that data layers are secure and maintainable. It also guides Claude in identifying and fixing performance bottlenecks such as N+1 queries and missing indexes, making it an essential tool for backend development and database refactoring.

주요 기능

01Safe migration strategies and connection management optimized for serverless and distributed environments

02Enterprise patterns for soft deletes, automated audit logging, and multi-tenant row-level security

03Advanced Prisma and Drizzle ORM patterns for complex CRUD, transactions, and pagination

044 GitHub stars

05Standardized schema design principles including 3NF normalization and UUID integration

06Query optimization techniques to eliminate N+1 problems and implement efficient indexing

사용 사례

01Optimizing slow database queries and refactoring existing ORM schemas for performance

02Designing a scalable, multi-tenant SaaS database architecture from scratch

03Implementing robust data integrity features like audit trails and safe deletion workflows

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add wania-kazmi/claude-code-autonomous-agent-workflow database-patterns

For use in Claude.ai and ChatGPT

Download Skill