ORM

Data Lake architecture and management including medallion architecture (bronze/silver/gold zones), data catalog with AWS Glue, partitioning strategies, schema evolution, data quality, governance, cost optimization, S3 lifecycle policies, data retention, compliance, query optimization with Athena, data formats (Parquet, ORC, Avro), incremental processing, CDC patterns, and production best practices for scalable data lakes.

Production-ready authentication framework for TypeScript with Cloudflare D1 support via Drizzle ORM or Kysely. Use this skill when building auth systems as a self-hosted alternative to Clerk or Auth.js, particularly for Cloudflare Workers projects. CRITICAL: better-auth requires Drizzle ORM or Kysely as database adapters - there is NO direct D1 adapter. Supports social providers (Google, GitHub, Microsoft, Apple), email/password, magic links, 2FA, passkeys, organizations, and RBAC. Prevents 12+ common authentication errors including D1 adapter misconfiguration, schema generation issues, session serialization, CORS, OAuth flows, and JWT token handling.Keywords: better-auth, authentication, cloudflare d1 auth, drizzle orm auth, kysely auth, self-hosted auth, typescript auth, clerk alternative, auth.js alternative, social login, oauth providers, session management, jwt tokens, 2fa, two-factor, passkeys, webauthn, multi-tenant auth, organizations, teams, rbac, role-based access, google auth, github auth, micros

Use when creating or modifying forms in SikhAid project. Covers form patterns, validation logic, submission workflows, Firestore integration, error handling, and success feedback.

Configure radial bar charts in drizzle-cube dashboards for circular progress and gauge visualizations. Use when creating radial bars, circular progress indicators, or gauge charts.

CRITICAL: Use this skill when working with Prisma database models, API routes with includes/relations, or debugging "500 errors", "relation not found", "undefined from backend" errors.AUTO-ACTIVATE when user mentions (FR/EN): - prisma, relation, relations, mapping, PascalCase, camelCase - API 500, erreur 500, backend error, erreur backend - undefined, null, relation introuvable, relation not found - créer API, create API, endpoint, route API - include, select, findMany, findUnique, create, update - OperatingRoom, OperatingSector, Personnel, Assignment, SiteThis skill contains the COMPLETE mapping table for post-PascalCase migration (Oct 26, 2025). ALL 121 models with correct relation names and required fields.

Frontend development guidelines for React/TypeScript applications. Modern patterns including Suspense, lazy loading, useSuspenseQuery, file organization with features directory, MUI v7 styling, TanStack Router, performance optimization, and TypeScript best practices. Use when creating components, pages, features, fetching data, styling, routing, or working with frontend code.

Configure markdown content portlets in drizzle-cube dashboards for static text, documentation, and formatted content. Use when adding text, documentation, headers, or formatted content to dashboards.

Node.js/Express/TypeScript microservices development. Layered architecture (routes → controllers → services → repositories), BaseController, error handling, Sentry monitoring, Prisma, Zod validation, dependency injection. USE WHEN creating routes, controllers, services, repositories, middleware, API endpoints, database access, error tracking.

Reference and maintain consistency with the project's technical stack including frameworks, runtimes, languages, frontend libraries, databases, ORMs, testing tools, deployment platforms, and third-party services. Use this skill when making technology choices or selecting libraries that need to align with the existing stack, adding new dependencies to package.json, pnpm-workspace.yaml, requirements.txt, or other dependency management files, implementing features using the project's established frameworks, ORMs, databases, or APIs, writing code in the project's primary language and runtime environment, setting up testing infrastructure with the project's test frameworks, configuring CI/CD pipelines or deployment settings, integrating third-party services that match the project's existing integrations, ensuring compatibility with the project's build tools and bundlers, or ensuring any technical implementation decision aligns with the project's established technologies, architectural patterns, and conventions doc

Controlled batch execution of implementation plans with review checkpoints between phases. Loads plan, critically reviews for issues, executes tasks in batches, then pauses for architect feedback before continuing. Use when you have a complete implementation plan from brainstorming/writing-plans and want structured execution with quality gates. Do NOT use for ad-hoc implementation, exploratory coding, or when you don't have a formal plan - just implement directly with code review at the end.

Define and structure database models with clear naming conventions, timestamps, data integrity constraints, appropriate data types, and relationship definitions. Use this skill when creating or modifying database model files in directories like models/, entities/, schemas/, src/models/, app/models/, or any ORM model definition folders. Use this when defining model classes with ORMs like Sequelize, TypeORM, Prisma schema, Django ORM models, Rails ActiveRecord models, SQLAlchemy models, Mongoose schemas, or any database ORM framework, adding or modifying database constraints like NOT NULL, UNIQUE, CHECK constraints, or foreign key relationships to enforce data integrity at the database level, defining model relationships such as hasMany, belongsTo, hasOne, belongsToMany, ManyToMany, or OneToMany associations between entities to represent how data is connected, implementing validation rules at the model layer for data integrity including required fields, format validation, and custom business rule validation, ch

Expertise senior/lead React developer 20 tahun dengan TanStack ecosystem (Query, Router, Table, Form, Start). Gunakan skill ini ketika: (1) Membuat aplikasi React dengan TanStack libraries, (2) Review/refactor kode React untuk clean code, (3) Debugging React/TanStack issues, (4) Setup project structure yang maintainable, (5) Optimasi performa React apps, (6) Memilih library yang tepat untuk use case tertentu, (7) Mencegah common bugs dan memory leaks, (8) Implementasi best practices KISS dan less is more. Trigger keywords: React, TanStack, React Query, TanStack Router, TanStack Table, TanStack Form, TanStack Start, Vinxi, clean code, refactor, performance, debugging.

Prisma ORM best practices for Shopify apps including multi-tenant data isolation, query optimization, transaction patterns, and migration strategies. Auto-invoked when working with database operations.

Project Support Officer - Interface to the organization's project management system. Manages project list (project-list.csv), activity logs (project-activity-logs.csv), and project artifacts in org/projects/. Use when agents need to: create new projects, query project status, get active/all projects, record activity, save/get project artifacts, update project details, or close projects. All operations require caller identification (agent name/role). Only project managers can close projects. The PSO answers project-related questions and updates projects via scripts but does not perform non-project work.

Production-tested setup for AutoAnimate (@formkit/auto-animate) - a zero-config, drop-in animation librarythat automatically adds smooth transitions when DOM elements are added, removed, or moved. This skill shouldbe used when building UIs that need simple, automatic animations for lists, accordions, toasts, or form validationmessages without the complexity of full animation libraries.Use when: Adding smooth animations to dynamic lists, building filter/sort interfaces, creating accordion components,implementing toast notifications, animating form validation messages, needing simple transitions without animation code,working with Vite + React + Tailwind, deploying to Cloudflare Workers Static Assets, or encountering SSR errors withanimation libraries.Keywords: auto-animate, @formkit/auto-animate, formkit, zero-config animation, automatic animations, drop-in animation,list animations, accordion animation, toast animation, form validation animation, lightweight animation, 2kb animation,prefers-reduce

Manage database schema changes with version control. Use when modifying DB schema, adding tables/columns, or setting up new projects. Covers Prisma, Drizzle, and migration best practices.

Manage database schemas, Drizzle ORM, migrations, and data modeling. Use when creating tables, modifying columns, or planning database changes.

Detect N+1 query patterns in the codebase. Finds loops that contain database or API calls that should be batched. Works across all languages. Use when user asks to find performance issues or N+1 patterns.

React/TypeScript development guidelines. Suspense, lazy loading, useSuspenseQuery, features directory, MUI v7, TanStack Router, performance optimization. USE WHEN creating components, pages, features, data fetching, styling, routing, or frontend work.

Create interactive analytics dashboards with React components from drizzle-cube/client. Use when building dashboards, configuring portlets, setting up grid layouts, or creating analytics UIs with drizzle-cube React components.