Communitygithub.com

ComeOnOliver/skillshub

安全、可复用的数据访问模式,包含DTO和污点检查。适用于在Next.js中构建具有DTO和服务端污点检查的数据访问层。(触发条件:**/lib/data.ts、**/services/*.ts、**/dal/**、DAL、Data Access Layer、server-only、DTO)

skillshub 是什么?

该技能为Next.js应用提供了一种结构化且安全的数据访问层(DAL)实现方法。它强调将所有数据库和外部API的访问逻辑集中到专门的`services/`目录或`lib/data.ts`文件中,并严格使用`import 'server-only'`来防止后端逻辑泄露到客户端。核心安全措施包括:使用数据传输对象(DTO)过滤敏感字段(如`passwordHash`),并利用`experimental_taint` API中的`taintObjectReference`或`taintUniqueValue`进行污点检查,确保敏感数据不会意外传递到客户端组件。此外,该技能还要求在每一个DAL函数内部都内联授权检查(例如使用`await auth()`),并将函数包裹在React的`cache()`中以实现请求去重、优化性能。它明确了不能在客户端组件中直接导入DAL文件,必须通过Server Action或Route Handler作为桥梁,同时指出了常见的反模式,如未在DAL中进行授权检查、返回原始ORM实例、在服务端组件中使用`fetch('localhost/api')`等。此技能适用于所有使用Next.js框架、需要构建安全且高效的数据访问层的项目,是架构设计文档中的高级实践指南。

兼容平台~Claude Code~Codex CLI~Cursor
npx skills add https://github.com/ComeOnOliver/skillshub/tree/HEAD/skills/HoangNguyen0403/agent-skills-standard/nextjs-data-access-layer

在你喜欢的 AI 中提问

打开一个已预加载此 Agent Skill 的新对话。

文档

数据访问层 (DAL)

优先级: P1 (高)

集中所有数据访问(数据库和外部API),以确保一致的安全性、授权和缓存。

实现指南

  • 架构:在 services/ 或 lib/data.ts 文件中创建数据访问层 (DAL)。使用 import 'server-only' 来防止后端逻辑泄露到客户端 bundle。
  • DTO:在返回给组件之前,始终将原始数据库/API 数据转换为数据传输对象 (DTO)。这可以防止泄露敏感字段(例如 passwordHash)。
  • 安全:使用来自 experimental_taint API 的 taintObjectReference 或 taintUniqueValue,确保敏感数据绝不会意外到达客户端组件。
  • 授权:在每个 DAL 函数内部内联授权检查。不要依赖 UI 层来强制执行安全性。使用 await auth() 来验证用户。
  • 缓存:将 DAL 函数包裹在 React 的 cache() 中,以在单个渲染周期内对请求进行去重,防止冗余的数据库/API 调用。
  • 错误处理:抛出标准化错误(例如 NotFoundError、UnauthorizedError),以便由 Next.js error.tsx 或 notFound() 捕获。

限制

  • 客户端组件:无法导入 DAL 文件。必须使用 Server Action 或 Route Handler 作为桥梁。

反模式

  • 在 DAL 外部进行授权检查:授权验证必须位于 DAL 函数内部。
  • 返回原始 ORM 实例:在返回之前转换为纯 DTO 对象。
  • 在服务端组件中使用 fetch('localhost/api'):直接调用 DAL 函数。
  • 在客户端组件中导入 DAL:使用 Server Action 或 Route Handler 作为桥梁。

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

ComeOnOliver/skillshub

Create stunning, animation-rich HTML presentations from scratch or by converting PowerPoint files. Use when the user wants to build a presentation, convert a PPT/PPTX to web, or create slides for a talk/pitch. Helps non-designers discover their aesthetic through visual exploration rather than abstract choices.

ComeOnOliver/skillshub

Next.js 16+ 和 Turbopack — 增量打包、文件系统缓存、开发速度,以及何时使用 Turbopack 与 webpack。

ComeOnOliver/skillshub

SwiftUI architecture patterns, state management with @Observable, view composition, navigation, performance optimization, and modern iOS/macOS UI best practices.

ComeOnOliver/skillshub

See, Understand, Act on video and audio. See- ingest from local files, URLs, RTSP/live feeds, or live record desktop; return realtime context and playable stream links. Understand- extract frames, build visual/semantic/temporal indexes, and search moments with timestamps and auto-clips. Act- transcode and normalize (codec, fps, resolution, aspect ratio), perform timeline edits (subtitles, text/image overlays, branding, audio overlays, dubbing, translation), generate media assets (image, audio, video), and create real time alerts for events from live streams or desktop capture.

ComeOnOliver/skillshub

AI-assisted video editing workflows for cutting, structuring, and augmenting real footage. Covers the full pipeline from raw capture through FFmpeg, Remotion, ElevenLabs, fal.ai, and final polish in Descript or CapCut. Use when the user wants to edit video, cut footage, create vlogs, or build video content.

ComeOnOliver/skillshub

Next.js 15 애플리케이션을 위한 프론트엔드 개발 가이드라인. React 19, TypeScript, Shadcn/ui, Tailwind CSS를 사용한 모던 패턴. Server Components, Client Components, App Router, 파일 구조, Shadcn/ui 컴포넌트, 성능 최적화, TypeScript 모범 사례 포함. 컴포넌트, 페이지, 기능 생성, 데이터 페칭, 스타일링, 라우팅, 프론트엔드 코드 작업 시 사용.

ComeOnOliver/skillshub

Provides Tamagui patterns for config v4, compiler optimization, styled context, and cross-platform styling. Must use when working with Tamagui projects (tamagui.config.ts, @tamagui imports).

ComeOnOliver/skillshub

Create distinctive, production-grade frontend interfaces with high design quality. Use this skill when the user asks to build web components, pages, or applications. Generates creative, polished code that avoids generic AI aesthetics.

ComeOnOliver/skillshub

Create high-converting, visually distinctive landing pages. Use when building marketing pages, product launches, SaaS homepages, or any single-page conversion-focused website. Guides section-by-section composition with anti-AI-slop principles.

ComeOnOliver/skillshub

Auto-loaded context for Portfolio Buddy 2 development. Use for ANY task involving: React 19 development, TypeScript, portfolio analysis features, metrics calculations, trading strategy comparison, or working with the Portfolio Buddy 2 codebase. Contains tech stack, known issues, and architectural constraints.

ComeOnOliver/skillshub

Next.js development tooling via MCP. Inspect routes, components, build info, and debug Next.js apps. Use when working on Next.js applications, debugging routing, or inspecting app structure. NOT for general React or non-Next.js projects.

ComeOnOliver/skillshub

Implement UI using Shadcn MCP (atoms/theme) and 21st.dev MCP (complex sections). Use when adding buttons, layouts, or generating landing pages.

ComeOnOliver/skillshub

A conceptual skill for building an API client in Next.js that handles JWT tokens

ComeOnOliver/skillshub

Best practices and patterns for Next.js App Router, Server Actions, and Routing in this project.

ComeOnOliver/skillshub

The Design System, Theme, and UX rules for the Physical AI Hub.

ComeOnOliver/skillshub

Comprehensive frontend development skill for building modern, performant web applications using ReactJS, NextJS, TypeScript, Tailwind CSS. Includes component scaffolding, performance optimization, bundle analysis, and UI best practices. Use when developing frontend features, optimizing performance, implementing UI/UX designs, managing state, or reviewing frontend code.

ComeOnOliver/skillshub

This document captures learnings from fixing keyboard navigation issues when floating components (Select, DropdownMenu, Popover) have CSS open/close animations.

ComeOnOliver/skillshub

Build Next.js 16 applications with correct patterns and distinctive design. Use when creating pages, layouts, dynamic routes, upgrading from Next.js 15, or implementing proxy.ts. Covers breaking changes (async params/searchParams, Turbopack, cacheComponents) and frontend aesthetics. NOT when building non-React or backend-only applications.

ComeOnOliver/skillshub

Comprehensive Framer Motion animation library for React. Covers motion components, variants, gestures, page transitions, and scroll animations. Use when adding animations to React/Next.js applications.

ComeOnOliver/skillshub

Build interfaces that resonate, not just render. This skill enforces bold, intentional

相关技能