Core client for the Sp00ky reactive local-first SurrealDB framework. Use when initializing Sp00kyClient, registering queries and subscriptions, performing mutations (create/update/delete), handling auth (signUp/signIn/signOut), working with file buckets, or using backend runs (HTTP outbox pattern).
Software Mansion's best practices for multithreading and background processing in React Native apps. Use when offloading heavy computation, running background tasks, using Web Workers, or working with the React Native New Architecture's concurrent features. Trigger on: 'background thread', 'Worklet', 'runOnJS', 'runOnUI', 'heavy computation', 'background processing', 'concurrent', or any request to move work off the JS thread in a React Native app.
v1からv2へのAI-DLC環境移行を実行するスキル。 プリフライト検証、データ移行、移行後検証を行う。 Use when the user says "start migrate", "aidlc migrate", "マイグレーション".
Create database migrations, define table schemas, and manage constant tables (enums). Use when: (1) creating a new database table, (2) running 'make migrate.create', (3) adding enum/status values, (4) modifying table structure. REQUIRED first step before add-domain-entity.
Create or update database seed scripts for development and testing environments. Use when setting up test data, initializing development databases, creating demo environments, resetting to known state, or generating realistic sample data.
Detect dangerous operations in database migrations before deployment
Seed JSON configuration files into database. Use ONCE at BAZINGA session initialization, BEFORE spawning PM.
Data access patterns with Spring Data JPA, Hibernate 7.1, Flyway migrations, HikariCP tuning, N+1 prevention, caching, and query optimization. Use when user mentions database, JPA, queries, migrations, N+1, or slow queries.
Create a new versioned config migration in server/migrations/ following the project's Flyway-style pattern. Use when adding new required/default fields to config files, renaming/restructuring fields, or adding default entries to providers.json, groups.json, tools.json, sources.json, etc.
Ruby on Rails performance conventions — N+1 prevention, caching, database tuning, benchmarking. Use when optimizing queries, adding caching, or profiling performance.
Use when services stuck on Waiting for database migrations to complete. Use when app expects separate migrator service.
Use when running commands inside a Zeabur service container. Use for one-off database operations like queries, data cleanup, or migrations (e.g. mongosh, psql, mysql, redis-cli). Use when user says "exec into container", "run command in service", "query database", "delete from database", "run mongo command", "run SQL", "check files in container", "debug inside service", or "shell into service". Use for container-level debugging like checking env vars, files, processes, or connectivity. NOT for deploying databases (use zeabur-template-deploy instead).
Create, run, and troubleshoot schema changes and migration application.
Use when migrating library code from thrown or rejected error flows to typed Result-based flows with better-result. Follow official better-result patterns for tagged errors, Result.try, generator composition, and matching.
Rename a skill across all its versions — transactional copy-verify-delete with platform context rebuild. Use when the user requests to "rename a skill."
KIPRIS API 기반 특허 검색 실행, 배치 내보내기, 중복 제거. Use when: (1) 특허 데이터 검색 및 다운로드 시, (2) 검색 계획 실행 시, (3) '특허 검색', 'search patents', 'collect patent data', 'export patents to Excel' 요청 시, (4) 키워드, 출원인, 출원번호, IPC 코드 기반 한국/해외 특허 배치 검색 시.
Evaluates SQL queries and database migrations for correctness, safety, performance, and reversibility.
Expert database optimizer specializing in query optimization, performance tuning, and scalability across multiple database systems. Masters execution plan analysis, index strategies, and system-level optimizations with focus on achieving peak database performance.
Manages grepai semantic search (setup, status, start, stop, reindex, optimize, upgrade).
Optimizes Claude Code memory files in 4 interactive steps: removes duplicates, migrates rules to CLAUDE.md/rules files, compresses remaining entries, validates with cleanup. Typical reduction: 30-50% on token count.
Database management for Guren with safety checks. Handles migrations, rollbacks, seeding, resets, and container management. Use when user mentions "database", "migration", "migrate", "rollback", "seed", "reset", "db:up", "db:down", "db:reset", "fresh database", or database-related tasks.
