Database
Database management and queries
prevalidating-bulk-operations
by squirrel289
"Route bulk file operations (3+ similar files) to systematic validation pattern or direct implementation. Use when: (1) Planning bulk updates, (2) Need to decide sample-validation approach, (3) Assessing validation risk in bulk operations. Evaluates file count, schema discoverability, and operation type to determine routing: PATTERN_REQUIRED, PATTERN_CONDITIONAL, or DIRECT."
media-storage
by dev-goraebap
"파일 업로드·저장소·첨부 관리 패턴. Actions: 파일 업로드, 이미지 업로드, 파일 처리, 저장소 연동, 썸네일 첨부, 색상 추출, file upload, image upload, storage, attachment, thumbnail. Patterns: Active Storage, blobs 테이블, attachments 테이블, 다형적 첨부, 중복 파일 감지. Storage: Cloudflare R2, AWS S3, @aws-sdk/client-s3, UUID key, 2-level 디렉토리, CDN URL, presigned URL. DB: Drizzle ORM, blob, checksum, MD5, metadata JSON, MIME, byte_size. Color: 지배적 색상 추출, dominant color, Gemini API, hex, blobs.metadata. Query: 썸네일 조회, 서브쿼리, leftJoin, view-model, CDN URL 변환. Stack: SvelteKit, +server.ts, TypeScript."
Database Skill
by Sytex
```
dotnet-backend-patterns
by TriNgo0108
Master C#/.NET backend development patterns for building robust APIs, MCP servers, and enterprise applications. Covers async/await, dependency injection, Entity Framework Core, Dapper, configuration, caching, and testing with xUnit. Use when developing .NET backends, reviewing C# code, or designing API architectures.
react-development
by jacobporci
React development best practices for functional components, hooks, state management, and performance optimization. Use when asked for "React help", "component creation", "refactoring components", "state management advice", or "fixing re-render issues". Optimized for senior developers building scalable applications.
migration-rollback
by ShotaIuchi
Rollback planning for migrations. Apply when designing rollback procedures, feature flags, safe fallback paths, rollback triggers, and step-by-step revert instructions.
tanstack-query
by Alicoder001
TanStack Query (React Query) patterns for data fetching, caching, mutations, and optimistic updates. Use when implementing server state management, API caching, or data synchronization in React applications.
market-spas-b2b
by SeanLysten
Contexte projet pour le portail B2B Market Spas (revendeurs spas/jacuzzis FR/BE/LU). À utiliser dès qu'une tâche touche au repo market-spas-b2b — toute modification de catalogue, panier, commandes, leads, partenaires, SAV, pièces détachées, admin dashboard, carte partenaires, intégrations Meta/Mollie/Resend/supplier, ou backend tRPC/Drizzle.
typescript
by lorenzogirardi
TypeScript conventions for ecommerce monorepo. Covers Next.js, Fastify, Prisma, Zod validation, React Query, and testing patterns. Triggers on "typescript", "type error", "ts", "tsx", "type hints", "zod schema", "prisma", "react query", "next.js", "fastify routes", "api types". PROACTIVE: MUST invoke when writing or editing .ts or .tsx files.
managing-dev-migrations
by djankies
Use migrate dev for versioned migrations; db push for rapid prototyping. Use when developing schema changes locally.
voluum-command-composer
by markab21
Compose safe, copy/paste-ready voluum-cli commands from user intent using public API workflows.
mysql-best-practices
by jcastillotx
MySQL database development standards. Triggers when working with MySQL databases, queries, schema design, or optimization.
angular-migration
by TriNgo0108
Migrate from AngularJS to Angular using hybrid mode, incremental component rewriting, and dependency injection updates. Use when upgrading AngularJS applications, planning framework migrations, or modernizing legacy Angular code.
repo-scan-2-jira
by ReGYChang
Scan a repo scope for actionable work items (bugs, TODO/FIXME, doc inconsistencies, performance/maintainability risks) and emit Jira-ready issues in a strict JSON schema. Use when asked to scan a specific module/path/page/route and produce evidence-backed Jira tickets.
reviewing-server-actions
by djankies
Review Server Actions for security, validation, and best practices in React 19. Use when reviewing forms, mutations, or server-side logic.
umbraco-mcp-dev-ops
by NikiSkaarup
Guide Claude to perform Umbraco developer and ops tasks via MCP tools safely.
data-modeling
by Ippollo
Use when designing database schemas, adding tables/collections, choosing SQL vs NoSQL, writing migration scripts, or optimizing query performance via indexing. Covers normalization, relationship patterns, ORM best practices, and zero-downtime migrations.
implementing-server-actions
by 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'.
tree-of-thoughts
by kimasplund
Systematic evaluation methodology for finding THE best solution among known options. Explores multiple reasoning paths, scores branches, and prunes low-confidence paths.
twenty-crm
by leto-labs
Manage Twenty CRM through API-first workflows for both record operations (Core API) and data-model administration (Metadata API). Use when tasks involve querying/updating CRM records, creating or changing objects/fields/views/layouts, generating code from Twenty OpenAPI, or keeping integrations aligned with workspace-specific schema behavior. Includes baseline-default spec usage plus targeted sync for metadata-driven drift.
env-file-generator
by ehtbanton
Generate properly structured .env environment files with common variables, documentation comments, and secure placeholder patterns. Triggers on "create .env file", "generate environment variables", "env file for", "dotenv template".
dba-admin
by shaul1991
DBA Admin Agent. 백업, 복구, 보안, 권한 관리를 담당합니다.
wrangler
by hocgin
Cloudflare Workers CLI for deploying, developing, and managing Workers, KV, R2, D1, Vectorize, Hyperdrive, Workers AI, Containers, Queues, Workflows, Pipelines, and Secrets Store. Load before running wrangler commands to ensure correct syntax and best practices.
fastapi
by ederheisler
"Build Python APIs with FastAPI, Pydantic v2, and SQLAlchemy 2.0 async. Covers project structure, JWT auth, validation, and database integration with uv package manager. Prevents 7 documented errors. Use when: creating Python APIs, implementing JWT auth, or troubleshooting 422 validation, CORS, async blocking, form data, background tasks, or OpenAPI schema errors."