Databases

Track complex, multi-session work with dependency graphs using bd (beads) issue tracker. Git-backed JSONL files are the source of truth, with SQLite as local cache. Use when work spans multiple sessions, has complex dependencies, or requires persistent context across compaction cycles. For simple single-session linear tasks, TodoWrite remains appropriate.

Deploy and manage Supabase Edge Functions with E2B sandbox integration for permit research agents. Includes automated deployment, database migrations, RLS policies, and validation workflows.

Expert database design and data modeling. Use when designing schemas, normalizing data, creating ER diagrams, or making architectural database decisions.

Cross-platform audio feedback system for task completion and user prompts. Provides non-intrusive sound notifications to improve workflow awareness.

Prisma ORM patterns for SQL Server (CAES_FARM_GATE database). Use when working with database schema, queries, migrations, or the repository layer.

Build RAG systems with Ollama local + cloud models. Latest cloud models include DeepSeek-V3.2 (GPT-5 level), Qwen3-Coder-480B (1M context), MiniMax-M2. Use for document Q&A, knowledge bases, and agentic RAG. Covers LangChain, LlamaIndex, ChromaDB, and embedding models.

React/Next.js data patterns - React Query hooks, ORPC client integration, error handling, cache invalidation. Complements frontend-design skill (visuals).

Use the project's specific technology stack including Next.js, React, TypeScript, Hono, PostgreSQL, Chakra UI, and Temporal for workflow automation. When setting up new features, choosing libraries, or making architectural decisions. When working on frontend code using React and Next.js. When implementing backend APIs with Hono. When working with PostgreSQL databases via Drizzle or Prisma. When styling with Chakra UI components. When implementing authentication with better-auth or workflows with Temporal. When adding dependencies or configuring build tools. This skill ensures technology choices align with the project's established stack.

Track blog post performance and generate insights for continuous improvement. USE WHEN user says 'track post performance', 'analyze blog metrics', 'what posts performed well', 'blog analytics', OR requests performance feedback on content.

DevOps automation for a Next.js (Vercel) frontend, Fly.io backend, and Supabase Postgres. The agent should prefer `just` recipes as the invocation surface. Internally, recipes use a hybrid MCP+CLI approach: Supabase CLI for writes/migrations (local & prod), Fly MCP preferred for ops with flyctl fallback, and Vercel CLI for deploy with optional MCP for env/status. Secrets are loaded exclusively via 1Password CLI; values are never printed.

查询集成连接器和API配置（v3_openapi数据库）。使用 exec_sql 工具执行查询。

Row Level Security policy templates for Supabase - multi-tenant patterns, user isolation, role-based access, and secure-by-default configurations. Use when securing Supabase tables, implementing RLS policies, building multi-tenant AI apps, protecting user data, creating chat/RAG systems, or when user mentions row level security, RLS, Supabase security, tenant isolation, or data access policies.

Invoke Claude Code CLI from Python orchestrators and shell scripts. Use when asked to"spawn claude as subprocess", "automate claude cli", "run claude headless","configure --allowedTools", "set up claude hooks", or "parallel claude invocation".Covers permissions, directory access (--add-dir), hooks, sandbox mode, and async patterns.

Implement comprehensive input validation on both client and server sides, using allowlists over blocklists, sanitizing user input, and providing specific error messages to prevent security vulnerabilities. Use this skill when writing validation logic for forms, API endpoints, function parameters, or any user input. Use this skill when implementing server-side validation to ensure data integrity and security, adding client-side validation for immediate user feedback, or sanitizing input to prevent injection attacks. Use this skill when working with form components, API route handlers, data processing functions, or validation schemas. Use this skill when defining validation rules for data types, formats, ranges, required fields, or business logic constraints across all application entry points.

Test game mechanics via SQL. Use game_* tools for gameplay flow.

Armazena e consulta memória persistente de projetos em banco PostgreSQL.Use quando: (1) tomar decisões técnicas importantes, (2) identificar TODOs/melhorias,(3) documentar contexto do projeto, (4) consultar decisões anteriores.O Claude deve AUTOMATICAMENTE salvar decisões importantes e consultar memória relevante.Identificação do projeto é automática via git repo + branch.

Prisma 스키마 및 마이그레이션 설정. Use when: Prisma 초기 설정 및 서비스별 스키마 구성 필요 시

Database patterns and best practices for ZZIK v5.1 Prisma schema design and queries.

Supabase database operations for BidDeed.AI and Life OS ecosystems. Handles inserts, queries, and data management for tables including insights, historical_auctions, activities, daily_metrics, michael_swim_times, learning_sessions. Use when logging data, querying Supabase, running insert_insight.yml workflows, or managing persistent storage. Database: mocerqjnksmhcjzxrewo.supabase.co

Next.js 14+ development with App Router, React Server Components, Server Actions, client components, streaming SSR, metadata API, parallel routes, intercepting routes, TypeScript best practices, TanStack Query for data fetching, Zustand state management, shadcn/ui components, Tailwind CSS styling, authentication patterns, API routes, middleware, error handling, performance optimization, SEO, and production deployment strategies.