Databases

Autonomous prior art search and analysis agent. Searches multiple databases, analyzes references, creates claim charts, and assesses patentability impact.

Proactively investigates Go SSO codebase to understand authentication flows, trace gRPC request paths, analyze clean architecture patterns, and provide comprehensive backend code insights. Use when users ask about SSO implementation, service structure, database queries, or need to understand how authentication/authorization works.

CLAUDE Framework coding standards for code quality, naming conventions, error handling, security, testing, database, and logging

Complete markdown guide for Universal Notion Uploader. Covers 14 element types (headings, callouts, highlights, toggles, embeds, columns, databases), upload modes, and API constraints.

Optimiza políticas RLS de Supabase usando el patrón (select auth.uid()) para mejor performance. Usa cuando trabajes con RLS policies, auth.uid() reevaluación, o tareas 1.3 y 2.1 del PLAN_MEJORAS.md.

Configure area charts in drizzle-cube dashboards for cumulative trends and stacked time series. Use when creating area charts, stacked area graphs, or cumulative visualizations.

Animation patterns using Anime.js v4 for UI feedback, transitions, and celebrations. Use when implementing hover effects, transitions, loading animations, or gamification feedback. Includes reduced motion handling. (project)

DDDアーキテクチャでHonoのバックエンドを新規実装または既存コードベースをリファクタリングする際のガイド。レイヤー構成（domain/application/infrastructure/controller）、依存方向、責務境界、Hono公式ミドルウェア/プラグインの活用、Hono OpenAPIプラグイン（hono-openapi）とzod-openapiの必須採用、Drizzle ORMの利用、トランザクション境界、エラーハンドリング、テスト指針、ESLint/Prettierの必須導入を含む。

Use when users don't notice feedback, miss state changes, or can't tell if their action worked

Analyzes and optimizes database queries for performance and efficiency

Use when educators need to validate if their lesson plan covers all 3 Delegation subcategories (Problem/Platform/Task Awareness).Analyzes lesson plans and provides objective scores (0-10) with actionable feedback.Works in Claude.ai, Claude Code, and API for maximum portability.

Senior Backend Developer with 10+ years Java and 5+ years Spring Boot experience. Use when implementing Spring Boot features, writing Java code, creating REST APIs, working with databases (R2DBC, JPA), implementing business logic, or writing unit/integration tests.

Start real-time log streaming from connected Android device using adb logcat. Shows only app's log messages. Use when monitoring app behavior, debugging, or viewing Android logs.

Reviews finished and in-progress digital products to assess adherence to design specifications and discover potential issues with those specifications. Validates implementation against design intent, identifies visual and interaction discrepancies, and provides actionable feedback for design and engineering teams.

Format concise, actionable test plans for Jira tickets using existing fptest tools and minimal MongoDB operations

Build production-grade FastAPI backends with SQLModel, Dapr integration, and JWT authentication.Use when building REST APIs with Neon PostgreSQL, implementing event-driven microservices withDapr pub/sub, scheduling jobs, or creating CRUD endpoints with JWT/JWKS verification.NOT when building simple scripts or non-microservice architectures.

Use when testing Android apps on ADB-connected devices/emulators - UI automation, screenshots, location spoofing, navigation, app management. Triggers on ADB, emulator, Android testing, location mock, UI test, screenshot walkthrough.

Expert skill for implementing Better Auth with JWT tokens and JWKS (JSON Web Key Set) for secure authentication between Next.js frontend and FastAPI backend. Handles JWT token generation, verification, JWKS endpoint setup, and secure API communication. Includes setup for database integration, session management, and user isolation. Use when implementing authentication between frontend (Next.js) and backend (FastAPI) services with JWT tokens and JWKS.

Implement client-side data storage with localStorage, IndexedDB, or SQLite WASM. Use when storing user preferences, caching data, or building offline-first applications.

Development: Cleanup and maintenance for the development environment.Removes build artifacts, caches, containers, and recovers disk space.Run from repository root with 'just clean'. Use when developers needto free disk space or reset the build environment.