Databases

Search local documents, files, notes, and knowledge bases. Index directories, search with BM25/vector/hybrid, get AI answers with citations. Use when user wants to search files, find documents, query notes, look up information in local folders, index a directory, set up document search, build a knowledge base, needs RAG/semantic search, or wants to start a local web UI for their docs.

Guides Supabase database migrations for CircleTel - creates migrations, RLS policies, validates schema changes, and handles rollbacks

Snowflake, BigQuery, Redshift, Delta Lake, and data warehouse design

Designs Redis caching strategies for Braiins API data, optimizing fordata freshness vs. API rate limits and response latency.

SQL and database best practices including query optimization, indexing, and schema design.

Supabase open-source Firebase alternative with Postgres, authentication, storage, and realtime subscriptions. Use when building full-stack applications requiring integrated backend services with Next.js, React, or Vue.

Firebase Emulator Suiteの起動・停止・管理ワークフロー。「エミュレーター」「Firebase」「Firestore」「Auth」「ローカル開発」などのキーワードで自動適用。

Redis database expert for caching, data structures, Pub/Sub, Streams, Lua scripting,and performance optimization using Bun.redis native client.Use when working with Redis, caching strategies, key-value stores, real-time data,vector search, or document databases. Works alongside bun-expert skill.

Load when working on member onboarding, retention strategies, feedback collection,NPS surveys, or improving the overall member journey. Contains frameworks forcreating exceptional member experiences at every touchpoint.

Database access layer guidelines for Quantum Skincare's Prisma-based data-access library. Covers Prisma schema design, DAO patterns, UUID primary keys, PostgreSQL role-based access control (RBAC), migration workflows, type-safe queries, transaction handling, soft deletes, and testing strategies. Use when working with Prisma schema, DAOs, database migrations, or data access patterns in libs/data-access.

Search technical documentation using executable scripts to detect query type, fetch from llms.txt sources (context7.com), and analyze results. Use when user needs: (1) Topic-specific documentation (features/components/concepts), (2) Library/framework documentation, (3) GitHub repository analysis, (4) Documentation discovery with automated agent distribution strategy | Dùng khi tìm tài liệu, hướng dẫn, docs, documentation, api docs, tham khảo.

Auditar configuração R2DBC MySQL (pool, migrations, tuning) assegurando conexões reativas seguras e resilientes no Swarm.

React 19 with TypeScript 5.9.3, TanStack Query V5, Zustand, and modern patterns. React Compiler handles memoization automatically. No manual optimization needed.

Uses Redis for caching, sessions, pub/sub, and data structures with Node.js. Use when implementing caching, session storage, real-time messaging, or high-performance data storage.

Type-safe ORM for Cloudflare D1 databases using Drizzle. This skill provides comprehensivepatterns for schema definition, migrations management, type-safe queries, relations, andCloudflare Workers integration.Use when: building D1 database schemas, writing type-safe SQL queries, managing databasemigrations with Drizzle Kit, defining table relations, implementing prepared statements,using D1 batch API for transactions, or encountering "D1_ERROR", transaction errors,foreign key constraint failures, migration apply errors, or schema inference issues.Prevents 12 documented issues: D1 transaction errors (SQL BEGIN not supported), foreign keyconstraint failures during migrations, module import errors with Wrangler, D1 binding not found,migration apply failures, schema TypeScript inference errors, prepared statement caching issues,transaction rollback patterns, TypeScript strict mode errors, drizzle.config.ts not found,remote vs local database confusion, and wrangler.toml vs wrangler.jsonc mixing.Keyw

Use when reviewing pull requests. Covers PR examination, code quality checks, adding feedback, and pass/fail decisions.

Use this skill whenever the user wants to create, restructure, or standardize a NestJS backend project in TypeScript, including folder layout, config, environment setup, tooling, and initial integrations (TypeORM-ready, testing-ready, and deployment-friendly).

Test escape room difficulty, collect player metrics, identify stuck points, and balance gameplay for 60-70% completion rate target. Implements alpha/beta testing protocols, feedback analysis, and iterative difficulty adjustment. Use when validating game balance, analyzing player behavior, or optimizing escape room challenge levels.

Integration templates for FastAPI endpoints, Next.js UI components, and Supabase schemas for ML model deployment. Use when deploying ML models, creating inference APIs, building ML prediction UIs, designing ML database schemas, integrating trained models with applications, or when user mentions FastAPI ML endpoints, prediction forms, model serving, ML API deployment, inference integration, or production ML deployment.

Query and manage local tRPC documentation mirror (25 docs). Search tRPC topics for end-to-end typesafe APIs, routers, procedures, React Query integration, and Next.js setup. Use when implementing tRPC features or answering tRPC-related questions. (user)