Databases

FastAPI Python backend in api/. Covers routes, models, Supabase integration, authentication, R2 storage, and Cloudflare Workers deployment. Port 9999 for local dev. OpenAPI docs at /docs.

Search 76M+ patents using BigQuery (fast, zero setup) or PatentsView API (US patents with rich metadata).

Test Nuxt 3 / Nitro API handlers with real PostgreSQL, transaction rollback isolation, and typed factories. No mocks, real SQL.

Guide for building robust API integration layers in React/TypeScript applications. Use when implementing HTTP clients (axios/fetch), request/response interceptors, authentication token handling, error handling strategies, retry logic, request cancellation, or organizing API services. Triggers on questions about API client setup, custom hooks for data fetching, React Query/SWR integration, or service layer patterns.

Generate 3D printable STL files for woodworking jigs and fixtures using CadQuery. Use when the user requests lampshade jigs, circle cutting guides, angle wedges, spacing blocks, alignment fixtures, router jigs, or any custom 3D-printed woodworking aid. Optimized for Elegoo Neptune 4 Pro (225x225x265mm build volume, 0.2mm layer height). Always use metric measurements.

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

Implement secure, consistent input validation on both client and server sides. Use this skill when validating form inputs, API request bodies, or user-provided data. When sanitizing input to prevent injection attacks (SQL, XSS, command injection). When writing allowlist-based validation, type checking, or business rule validation. When providing field-specific error messages to users.

Design versioning, cache busting, progressive rollout, and rollback for remote WebF bundles. Use when the user mentions version pinning, cache busting, force update, rollback, feature flags, or staged rollout.

Post-workflow cache refresh for Repomix. Automatically refreshes compressed codebase representation after files are modified. Ensures next command has accurate context with 70% token savings. Invoke at end of any workflow that modifies source files. Takes ~2.4 seconds when refresh needed.

Discover and introspect SQL Server database schemas dynamically. Use this skill when you need to understand table structures, column types, primary/foreign key relationships, or when adding new entities to the extraction pipeline.

Complete knowledge domain for Cloudflare Workers KV - global, low-latency key-value storage on Cloudflare's edge network.Use when: creating KV namespaces, storing configuration data, caching API responses, managing user preferences,implementing TTL expiration, handling KV metadata, or encountering "KV_ERROR", "429 too many requests","kv rate limit", cacheTtl errors, or eventual consistency issues.Keywords: kv storage, cloudflare kv, workers kv, kv namespace, kv bindings, kv cache, kv ttl, kv metadata,kv list, kv pagination, cache optimization, edge caching, KV_ERROR, 429 too many requests, kv rate limit,eventually consistent, wrangler kv, kv operations, key value storage

LMS-ESID core architecture including one-class-three-teachers system, course structure, grade levels, role permissions, and database schema. Use this skill when understanding teacher types (LT/IT/KCFS/HT), course relationships, class naming conventions, academic year data, or table relationships.

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.

Validate backend development environment and authentication status. Use when (1) new backend developer onboarding, (2) checking required tools (gh CLI, Git, Node, pnpm, Supabase), (3) verifying GitHub auth and repo access, (4) orchestrator auto-runs at work start.

Use this skill for Next.js App Router patterns, Server Components, Server Actions, Cache Components, and framework-level optimizations. Covers Next.js 16 breaking changes including async params, proxy.ts migration, Cache Components with "use cache", and React 19.2 integration. For deploying to Cloudflare Workers, use the cloudflare-nextjs skill instead. This skill is deployment-agnostic and works with Vercel, AWS, self-hosted, or any platform.Keywords: Next.js 16, Next.js App Router, Next.js Pages Router, Server Components, React Server Components, Server Actions, Cache Components, use cache, Next.js 16 breaking changes, async params nextjs, proxy.ts migration, React 19.2, Next.js metadata, Next.js SEO, generateMetadata, static generation, dynamic rendering, streaming SSR, Suspense, parallel routes, intercepting routes, route groups, Next.js middleware, Next.js API routes, Route Handlers, revalidatePath, revalidateTag, next/navigation, useSearchParams, turbopack, next.config

Type-safe SQL ORM for TypeScript with zero runtime overhead. Use when building database layers requiring compile-time safety, minimal bundle size, or superior performance over Prisma. Supports PostgreSQL, MySQL, SQLite with native SQL generation, relational queries, and migration management via Drizzle Kit.

Enterprise Notion integration with MCP server architecture, database operations, and content management

Monitor active Teradata sessions using real-time resources, view SQL execution details, identify blocking issues, and optionally take control actions

REST Controller 전문가. Thin Controller 패턴, CQRS Command/Query Controller 분리,ResponseEntity<ApiResponse<T>> 래핑, @Valid 검증 필수. DELETE 금지(PATCH 사용).TestRestTemplate 필수 (MockMvc 금지). UseCase 의존. Mapper DI.

Deploys WitchCityRope to production environment on DigitalOcean. Automates build, registry push, server deployment, database migrations (if needed), health verification, and rollback capability. SINGLE SOURCE OF TRUTH for production deployment automation.