資料庫

Redis data structures and commands including strings, lists, hashes, sets, sorted sets, streams, and transactions for high-performance caching and real-time applications.

Enhanced Just-In-Time document loading system that intelligently discovers, loads, and caches relevant documentation based on user intent and project context. Use when users need specific documentation, when working with new technologies, when answering domain-specific questions, or when context indicates documentation gaps.

Comprehensive retrospective analysis of 2025 for BidDeed.AI, Everest Capital USA, Life OS, and Shapira family achievements. Use when Ariel requests year-end review, 2025 analysis, annual retrospective, or wants to understand what was accomplished across all domains (business, family, technical) throughout 2025. Generates detailed analysis with metrics, visualizations, and insights across GitHub repos, Supabase data, Life OS tracking, and conversation history.

AWS cloud infrastructure and services expert. Use when working with AWS CLI, Terraform for AWS, Lambda, S3, EC2, DynamoDB, IAM, API Gateway, or any AWS service configuration, deployment, troubleshooting, or best practices.

Query and interact with Supabase databases using real-time subscriptions and PostgreSQL-compatible queries. Supports SELECT operations with Row Level Security (RLS), filtering, ordering, and pagination. Activated when users mention "supabase", "realtime database", or need Supabase backend features.

PROACTIVELY USED when reviewing a PR, branch, or Jira story. Handles code review against requirements and provides actionable feedback.

PCE (Process Context Engine) のメンテナンススキル。現存する Claim の品質を維持し、間違い・不要・古い・重複した Claim を整理する。pce_memory_feedback を使用して更新・削除・評価を行う。メモリの健全性を保ちたい場合、Claim の品質問題を発見した場合、定期的なメモリ整理を行いたい場合に使用する。Observation 収集、AC の構築、タスクごとのメモリ最適化は行わない。

Configure connection pool sizing for optimal performance. Use when configuring DATABASE_URL or deploying to production.

Comprehensive audit of Expo/React Native app API integration layer. Use when asked to: (1) Review API interactions, auth handling, or token management, (2) Find hardcoded data or screens bypassing API, (3) Verify user interactions properly sync to backend, (4) Analyze offline behavior and caching, (5) Audit Orval/OpenAPI code generation, (6) Check for API security issues. Supports TanStack Query, Zustand, axios, Expo Router, expo-secure-store, and expo-constants patterns.

Implement Supabase database patterns for PhotoVault including RLS policies, TypeScript queries, and storage operations. Use when working with database schemas, Row Level Security, migrations, storage buckets, auth.uid() policies, or debugging empty query results. Includes PhotoVault table structure and client setup patterns.

Verify errors are handled gracefully with meaningful user feedback. Issues result in WARNINGS.

Comprehensive systematic debugging agent for hunting down complex bugs, root causes, and error propagation across full stack (frontend, backend, APIs, databases). Use when diagnosing errors, troubleshooting issues, analyzing stack traces, investigating bugs, examining logs, debugging performance problems, or tracking down error causes. Also use when users mention debugging, errors, bugs, failures, crashes, exceptions, or unexpected behavior.

Comprehensive Confluence documentation management. Use when asked to"upload to Confluence", "download Confluence pages", "convert Markdownto Wiki Markup", "sync documentation to Confluence", "search Confluence","create Confluence page", "update Confluence page", "export Confluence","publish to Confluence", or "Confluence CQL query". Handles Wiki Markupconversion, Mermaid/PlantUML diagrams, image handling, large documentuploads without size limits, and Git-to-Confluence sync with mark CLI.

AIフィードバックループ最適化スキル。プロンプト→出力→評価→改善の反復サイクルを自動化。段階的改善、A/Bテスト、収束判定、ベスト出力選択で最高品質の結果を生成。

Use this skill when gathering requirements for new BigQuery data models OR when asked to edit existing queries in bqetl. For new models, guides structured requirements interviews. For existing queries, understands current model, checks downstream dependencies, and gathers requirements for changes. Works as pre-planning before query-writer skill.

Creates Next.js API routes with Firebase. Use when adding GET/POST/PATCH/DELETE endpoints, implementing pagination, adding auth checks, or handling file uploads. Includes route templates and error handling.

Google's mobile and web application development platform.

Write secure, performant database queries using parameterized queries, eager loading, proper indexing, and transactions. Use this skill when writing database query code, ORM query methods, SQL statements, or data fetching logic. Use this when preventing SQL injection with parameterized queries, optimizing queries to avoid N+1 problems with eager loading, selecting specific columns instead of SELECT *, implementing database transactions for related operations, adding query timeouts, or caching expensive queries. Use this when working on repository files, service files with database access, query builder code, or any file that retrieves or manipulates data from databases.

Redis best practices including data modeling, caching patterns, and performance optimization.

Implement and validate FastAPI authentication strategies including JWT tokens, OAuth2 password flows, OAuth2 scopes for permissions, and Supabase integration. Use when implementing authentication, securing endpoints, handling user login/signup, managing permissions, integrating OAuth providers, or when user mentions JWT, OAuth2, Supabase auth, protected routes, access control, role-based permissions, or authentication errors.