Skill Creator
djankies
100 published skills · 0 GitHub stars across the catalog. View on GitHub ↗
managing-dev-migrations
Use migrate dev for versioned migrations; db push for rapid prototyping. Use when developing schema changes locally.
optimizing-query-performance
Optimize queries with indexes, batching, and efficient Prisma operations for production performance.
optimizing-query-selection
Optimize queries by selecting only required fields and avoiding N+1 problems. Use when writing queries with relations or large result sets.
preventing-error-exposure
Prevent leaking database errors and P-codes to clients. Use when implementing API error handling or user-facing error messages.
preventing-sql-injection
Prevent SQL injection by using $queryRaw tagged templates instead of $queryRawUnsafe. Use when writing raw SQL queries or dynamic queries.
reviewing-prisma-patterns
Review Prisma code for common violations, security issues, and performance anti-patterns found in AI coding agent stress testing. Use when reviewing Prisma Client usage, database operations, or performing code reviews on projects using Prisma ORM.
upgrading-to-prisma-6
Migrate from Prisma 5 to Prisma 6 handling breaking changes including Buffer to Uint8Array, implicit m-n PK changes, NotFoundError to P2025, and reserved keywords. Use when upgrading Prisma, encountering Prisma 6 type errors, or migrating legacy code.
using-interactive-transactions
Use interactive transactions with $transaction callback for atomic operations and automatic rollback. Use when operations must succeed or fail together.
validating-query-inputs
Validate all external input with Zod before Prisma operations. Use when accepting user input, API requests, or form data.
composing-components
Teaches component composition patterns in React 19 including children prop, compound components, and render props. Use when designing component APIs, creating reusable components, or avoiding prop drilling.
following-the-rules-of-hooks
Fix React Rules of Hooks violations - conditional calls, hooks in loops/callbacks/classes
implementing-code-splitting
Teaches code splitting with lazy() and Suspense in React 19 for reducing initial bundle size. Use when implementing lazy loading, route-based splitting, or optimizing performance.
implementing-optimistic-updates
Teaches useOptimistic hook for immediate UI updates during async operations in React 19. Use when implementing optimistic UI patterns, instant feedback, or reducing perceived latency.
implementing-server-actions
Teaches Server Actions in React 19 for form handling and data mutations. Use when implementing forms, mutations, or server-side logic. Server Actions are async functions marked with 'use server'.
managing-local-vs-global-state
Teaches when to use local state vs global state (Context) in React 19. Use when deciding state management strategy, avoiding prop drilling, or architecting component state.
managing-server-vs-client-boundaries
Teaches when to use Server Components vs Client Components in React 19, including the 'use client' directive and boundary patterns. Use when architecting components, choosing component types, or working with Server Components.
migrating-from-forwardref
Teaches migration from forwardRef to ref-as-prop pattern in React 19. Use when seeing forwardRef usage, upgrading React components, or when refs are mentioned. forwardRef is deprecated in React 19.
optimizing-with-react-compiler
Teaches what React Compiler handles automatically in React 19, reducing need for manual memoization. Use when optimizing performance or deciding when to use useMemo/useCallback.
preloading-resources
Teaches resource preloading APIs in React 19 including prefetchDNS, preconnect, preload, and preinit. Use when optimizing initial load or navigation performance.
reviewing-component-architecture
Review component architecture for React 19 best practices including size, composition, Server/Client boundaries, and anti-patterns. Use when reviewing component design.
reviewing-hook-patterns
Review React hook usage for React 19 compliance and best practices
reviewing-performance-patterns
Review React 19 performance patterns including memoization, re-renders, and bundle size. Use when reviewing performance or optimization.
reviewing-server-actions
Review Server Actions for security, validation, and best practices in React 19. Use when reviewing forms, mutations, or server-side logic.
reviewing-state-management
Review state management patterns for React 19 best practices. Use when reviewing component state, Context usage, or state architecture.