Databases

Reference and maintain documentation of the project's technical stack including frameworks, languages, databases, testing tools, and third-party services. Use this skill when choosing technologies for implementation, adding new dependencies or libraries, setting up project infrastructure, configuring build tools and package managers, integrating third-party services (authentication, email, monitoring), selecting appropriate frameworks for features, ensuring consistency with existing technology choices, documenting technology decisions, reviewing technology compatibility, or onboarding team members to the tech stack. Apply this skill when making technology decisions, adding new tools or services, documenting the stack, or ensuring new code aligns with the project's established technical architecture.

Linear issue tracking API via curl. Use this skill to create, update, and query issues, projects, and teams using GraphQL.

Expert knowledge of frontend JavaScript for API integration including fetch/axios patterns, async/await error handling, form validation and submission, pagination implementation, loading states, DOM manipulation, event listeners, query parameter building, and vanilla JS best practices. Use when working with public/script.js, adding UI features, debugging client-side API issues, implementing forms, or managing client-side state.

Build and execute semantic queries with filters, time dimensions, aggregations, and ordering in drizzle-cube. Use when querying analytics data, filtering results, working with date ranges, aggregating measures, or building reports with drizzle-cube.

Deploy containerized web applications to any Linux server using Kamal. Use when users need to deploy, configure, debug, or manage Kamal deployments including initial setup, configuration of deploy.yml, deployment workflows, rollbacks, managing accessories (databases, Redis), troubleshooting deployment issues, or understanding Kamal commands and best practices.

Production-ready React Native screen creator that implements screens following established project patterns, enforcing best practices (NO mock data, real Supabase queries, BaseScreen wrapper, safe navigation, analytics tracking). Use when user says "create screen", "implement screen", "build [ScreenName]", or after analyzing existing screen. ALWAYS reads PROJECT_MEMORY.md, applies ACCEPTANCE_CHECKLIST.md, and avoids known errors.

Load when handling moderation issues, conflict resolution, rule enforcement,or developing moderation policies. Contains Discord-specific guidelines andbest practices for maintaining a healthy, safe community.

Expert knowledge on how to properly maintain and update the central Amplify Gen 2 handbook

BigQuery Object Tables를 활용한 비정형 데이터(오디오, 이미지 등) 분석 및 Audio Analytics Agent 구축 가이드. GCS 데이터 연동, 메타데이터 캐싱, AI 모델 통합, ADK 에이전트 구현 패턴을 다룹니다.

Build Next.js 16 apps with App Router, Server Components/Actions, Cache Components ("use cache"), and async route params. Includes proxy.ts (replaces middleware.ts) and React 19.2.Use when: building Next.js 16 projects, or troubleshooting async params (Promise types), "use cache" directives, parallel route 404s (missing default.js), or proxy.ts CORS.

Gene, drug compound, and disease research using NCBI Extended databases. Triggers: 基因, gene, 藥物, drug, compound, PubChem, ClinVar, 變異, variant, 臨床意義

Implement RAG systems using Weaviate vector database. Use when building semantic search, document retrieval, or knowledge base systems.

Spawn a Claude worker to address PR feedback, fix CI failures, or continue work on a pull request. Use when a PR needs updates based on review comments or failing checks.

Comprehensive Django best practices covering project structure, models (field choices, Meta options, managers, QuerySets, migrations), views (CBVs vs FBVs, generic views), Django REST Framework (serializers, ViewSets, permissions), forms, templates, security (CSRF, XSS, SQL injection), performance (N+1 queries, select_related, prefetch_related, caching), testing, and common anti-patterns. Essential reference for Django code reviews and development.

Use this skill whenever the user wants to set up, refactor, or optimize Supabase usage in a Next.js (App Router) + TypeScript project, including auth, database, storage, RLS-safe patterns, edge functions, and secure client/server integration.

Master profiling, benchmarking, and optimization techniques. Learn caching strategies, database optimization, code optimization, and system-level tuning to build lightning-fast applications. Identify bottlenecks and achieve 10x-100x performance improvements.

Manage exercise data, validate schemas, sync with Supabase, and maintain the Exicon database. Use when adding exercises, validating data, debugging data issues, or syncing. Keywords: exercise, exicon, supabase, data, json, validation, sync.

Real-time observability dashboard for multi-agent Claude Code sessions.Visualize agent interactions, tool usage, and session flows in real-time through a web dashboard. Track multiple agents running in parallel with swim lane visualization, event filtering, and live charts.**Key Features:**- 🔴 Real-time event streaming via WebSocket- 📊 Agent swim lanes showing parallel execution- 🔍 Event filtering by agent, session, event type- 📈 Live charts for tool usage patterns- 💾 Filesystem-based (no database required)**Inspired by [@indydevdan](https://github.com/indydevdan)**'s work on multi-agent observability.**Our approach:** Filesystem + in-memory streaming vs. indydevdan's SQLite database approach.

Write clear git commits with Conventional Commits format. Detects project conventions from history and config. Guides commit granularity. Use when: (1) Completing working code, (2) Code builds and tests pass, (3) Ready to save, (4) Before pushing, (5) After review feedback. Triggers: automatically when finishing commitable work that builds and passes tests.

Guide for implementing client-side state management in React applications. Use when building state architecture, selecting state libraries (Context, Zustand, Redux, Jotai), implementing caching strategies (React Query, SWR), optimistic updates, state persistence, or optimizing re-renders. Triggers on questions about global vs local state, state normalization, or selector patterns.