- Home
- /
- Categories
- /
- Database
Database
Database management and queries
openproject-queries
by hoangvantuan
Manage OpenProject saved queries via API v3. Create, update, delete saved queries (views). Build complex filters for work packages. Use when creating custom views, saving filter configurations, or automating query management.
๐ง UNLINK-GLOBAL | AI OPERATIONAL SKILLS (v2.0)
by jiggoo0
Managed by: UNLINK-GLOBAL Architecture Unit 2026
security
by Alicoder001
Security best practices for web applications. Use when handling user input, authentication, or sensitive data. Covers XSS, SQL injection, CSRF, environment variables, and secure coding patterns.
fetch
by zap-studio
Use when building typed HTTP clients with schema-validated responses or replacing unsafe fetch assertions.
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.
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.
doc-generator-strategy
by samChang72
Use when generating or improving user manuals or documentation strategies. Focuses on Code-First Analysis, Process Restoration, and Structured Standards.
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.