What is the benefit of the Mapper pattern included here?

The Mapper pattern decouples your internal database schema from your public-facing API types, allowing you to change your database structure without breaking your API contracts.

Can I use these patterns with any ORM?

Yes, while the examples use Prisma-like syntax, the patterns are designed to be customized for Drizzle, TypeORM, or any other database library you prefer.

How does this skill help prevent N+1 queries?

It provides specific implementation patterns for batch operations using Promise.all and in-memory mapping, ensuring efficient data fetching for related entities in a single trip.

What is the Result type pattern used in this skill?

It is a functional approach to error handling where functions return a structured object indicating success or failure instead of throwing exceptions, making error handling explicit and type-safe.

Service Architecture Patterns

Name: Service Architecture Patterns
Author: JaveedIshaq

byJaveedIshaq

•

API 개발

Implements clean architecture service layers with type-safe error handling and efficient data access patterns.

This skill provides a comprehensive set of templates for building robust backend service layers in TypeScript. It enforces the Result type pattern to eliminate unexpected exceptions, establishes a consistent base service with integrated logging, and provides best practices for data mapping, database transactions, and batch operations to prevent N+1 query performance issues. It is ideal for developers building scalable APIs who want to ensure maintainable, testable, and type-safe business logic that adheres to clean architecture principles.

주요 기능

011 GitHub stars

02Domain-driven Mapper patterns for separating database entities from domain types

03Optimized data access patterns including transaction management and batch processing

04Functional Result type pattern for type-safe error handling without exceptions

05Ready-to-use implementation templates for ORMs like Prisma, Drizzle, and TypeORM

06Standardized Base Service class with built-in logging and error context management

사용 사례

01Optimizing database performance by eliminating N+1 query bottlenecks in complex relationships

02Building a new TypeScript backend with Clean Architecture and Domain Driven Design

03Refactoring legacy catch-all error handling to a predictable Result-based flow

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add javeedishaq/ai-workflow-orchestrator service-patterns

For use in Claude.ai and ChatGPT

Download Skill