Skill Creator

djankies

100 published skills · 0 GitHub stars across the catalog. View on GitHub ↗

managing-dev-migrations

djankies's avatarfrom djankies

Use migrate dev for versioned migrations; db push for rapid prototyping. Use when developing schema changes locally.

optimizing-query-performance

djankies's avatarfrom djankies

Optimize queries with indexes, batching, and efficient Prisma operations for production performance.

optimizing-query-selection

djankies's avatarfrom djankies

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

djankies's avatarfrom djankies

Prevent leaking database errors and P-codes to clients. Use when implementing API error handling or user-facing error messages.

preventing-sql-injection

djankies's avatarfrom djankies

Prevent SQL injection by using $queryRaw tagged templates instead of $queryRawUnsafe. Use when writing raw SQL queries or dynamic queries.

reviewing-prisma-patterns

djankies's avatarfrom djankies

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

djankies's avatarfrom djankies

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

djankies's avatarfrom djankies

Use interactive transactions with $transaction callback for atomic operations and automatic rollback. Use when operations must succeed or fail together.

validating-query-inputs

djankies's avatarfrom djankies

Validate all external input with Zod before Prisma operations. Use when accepting user input, API requests, or form data.

composing-components

djankies's avatarfrom djankies

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

djankies's avatarfrom djankies

Fix React Rules of Hooks violations - conditional calls, hooks in loops/callbacks/classes

implementing-code-splitting

djankies's avatarfrom djankies

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

djankies's avatarfrom djankies

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

djankies's avatarfrom djankies

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

djankies's avatarfrom djankies

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

djankies's avatarfrom djankies

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

djankies's avatarfrom djankies

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

djankies's avatarfrom djankies

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

djankies's avatarfrom djankies

Teaches resource preloading APIs in React 19 including prefetchDNS, preconnect, preload, and preinit. Use when optimizing initial load or navigation performance.

reviewing-component-architecture

djankies's avatarfrom djankies

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

djankies's avatarfrom djankies

Review React hook usage for React 19 compliance and best practices

reviewing-performance-patterns

djankies's avatarfrom djankies

Review React 19 performance patterns including memoization, re-renders, and bundle size. Use when reviewing performance or optimization.

reviewing-server-actions

djankies's avatarfrom djankies

Review Server Actions for security, validation, and best practices in React 19. Use when reviewing forms, mutations, or server-side logic.

reviewing-state-management

djankies's avatarfrom djankies

Review state management patterns for React 19 best practices. Use when reviewing component state, Context usage, or state architecture.