Communitygithub.com

ComeOnOliver/skillshub

安全的、可重複使用的資料存取模式,包含 DTO 和 Taint 檢查。用於在 Next.js 中建置具有 DTO 和伺服器端 Taint 檢查的資料存取層。(觸發條件:**/lib/data.ts、**/services/*.ts、**/dal/**、DAL、Data Access Layer、server-only、DTO)

skillshub 是什麼?

此技能提供一套完整的資料存取層(DAL)實作模式,專為 Next.js 應用程式設計,以確保資料存取的統一性、安全性與快取效率。它強制要求將所有資料庫與外部 API 的存取集中於服務層(如 services/ 或 lib/data.ts),並使用 server-only 標記防止後端邏輯洩漏至客戶端。透過定義資料傳輸物件(DTO)來轉換原始資料,避免敏感欄位(例如 passwordHash)意外暴露。此外,它整合了 experimental_taint API 的 taintObjectReference 與 taintUniqueValue 機制,對敏感資料進行標記,防止其意外傳遞至客戶端元件。此技能支援 Next.js 平台,並利用 React 的 cache() 函數在單一渲染週期內對請求進行去重,減少重複資料庫或 API 呼叫。它還要求在每個 DAL 函數內進行授權檢查,並拋出標準化錯誤(如 NotFoundError、UnauthorizedError),以便與 Next.js 的錯誤處理機制(error.tsx、notFound())整合。常見的反模式包括在 DAL 外部進行驗證、返回原始 ORM 實例,以及在伺服器元件中使用 fetch('localhost/api'),這些都會被明確禁止。

相容平台~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' 以防止後端邏輯洩漏至客戶端套件組合。
  • DTO:在將原始資料庫/API 資料返回給元件之前,務必將其轉換為資料傳輸物件 (DTO)。這可以防止洩漏敏感欄位(例如 passwordHash)。
  • 安全性:使用 experimental_taint API 中的 taintObjectReference 或 taintUniqueValue,確保敏感資料絕不會意外傳遞至客戶端元件。
  • 授權:將授權檢查置於每個 DAL 函數內部。不要依賴 UI 層來強制執行安全性。使用 await auth() 驗證使用者。
  • 快取:使用 React 的 cache() 包裝 DAL 函數,以在單一渲染週期內對請求進行去重,防止重複的資料庫/API 呼叫。
  • 錯誤處理:拋出標準化錯誤(例如 NotFoundError、UnauthorizedError),以便被 Next.js error.tsx 或 notFound() 捕獲。

限制

  • 客戶端元件:無法匯入 DAL 檔案。必須使用 Server Actions 或 Route Handlers 作為橋樑。

反模式

  • 不在 DAL 外部進行授權檢查:驗證邏輯必須內建於 DAL 函數中。
  • 不返回原始 ORM 實例:返回前須轉換為純 DTO 物件。
  • 不在伺服器元件中使用 fetch('localhost/api'):應直接呼叫 DAL 函數。
  • 不在客戶端元件中匯入 DAL:應使用 Server Actions 或 Route Handlers 作為橋樑。

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

相關技能