# Backend Patterns

> Backend patterns for ORPC routers, Drizzle schemas, and server-side code. Use when creating API endpoints, database tables, or services.

- Skill: `diegosouzapw/backend-patterns-2` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add diegosouzapw/backend-patterns-2`
- Raw SKILL.md: https://api.skillmd.com/api/skills/diegosouzapw/backend-patterns-2/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Integrations & APIs
- Author: diegosouzapw (https://skillmd.com/u/diegosouzapw)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/diegosouzapw/backend-patterns-2

---


# Backend Patterns

Use these patterns when creating API endpoints, database schemas, or server-side logic.

## When to Use

- Creating new ORPC router procedures
- Adding database tables or schema changes
- Implementing server-side business logic
- Adding authentication/authorization logic

## Key Files

- `src/server/create-api.ts` - API factory with dependency injection
- `src/server/context.ts` - Request context with session and db
- `src/server/index.ts` - Procedure definitions (publicProcedure, protectedProcedure)
- `src/server/routers/index.ts` - Router definitions
- `src/db/schema/` - Table definitions

## Pattern Files

- [schema.md](schema.md) - SQLite schema patterns
- [router.md](router.md) - ORPC router patterns
- [service.md](service.md) - Service factory patterns