Does this skill support multi-tenancy?

Yes, it includes specific patterns for Clerk organization IDs and specialized tRPC procedures like organizationProcedure to ensure data isolation.

What technology stack does this skill support?

This skill is optimized for TypeScript environments using Prisma for ORM, tRPC for APIs, Zod for validation, and Clerk for authentication.

Can I use this for modifying existing entities?

Absolutely. The skill provides guidance for both adding new entities and modifying existing ones while maintaining architectural integrity across all layers.

How does it handle database migrations?

It provides a step-by-step checklist that includes running Bun-based Prisma migrations and regenerating the client to keep types in sync.

What is the benefit of the repository layer in this skill?

The repository layer abstracts data access logic, making your controllers cleaner and your code more testable by decoupling the database implementation from the business logic.

CRUD Architecture Manager

Name: CRUD Architecture Manager
Author: firstloophq

byfirstloophq

API Development

Implements and maintains standardized CRUD entities following a robust layered architecture pattern for full-stack applications.

About

The manage-crud-architecture skill streamlines the process of building scalable backend services by enforcing a consistent layered architecture. It guides developers through the complete lifecycle of a data entity, from Prisma schema definition and Zod validation to repository patterns and tRPC router implementation. By automating the boilerplate and providing checklists for dependency injection and authentication integration, this skill ensures that every new feature follows best practices for security, maintainability, and type safety, specifically optimized for the monotemplate stack.

Key Features

Standardized Zod schema generation for shared type safety
Integrated Clerk authentication and organization-scoping patterns
End-to-end CRUD workflow from database schema to tRPC endpoints
Layered architecture enforcement (Prisma, Repository, Controller, tRPC)
Automated dependency injection (DI) container registration
0 GitHub stars

Use Cases

Adding new database models and exposing them via a secure API
Refactoring existing backend logic into a clean, testable repository pattern
Implementing multi-tenant data access using Clerk organization contexts

About

Key Features

Standardized Zod schema generation for shared type safety
Integrated Clerk authentication and organization-scoping patterns
End-to-end CRUD workflow from database schema to tRPC endpoints
Layered architecture enforcement (Prisma, Repository, Controller, tRPC)
Automated dependency injection (DI) container registration
0 GitHub stars

Use Cases

Adding new database models and exposing them via a secure API
Refactoring existing backend logic into a clean, testable repository pattern
Implementing multi-tenant data access using Clerk organization contexts