資料庫

Use Lockplane for safe database schema management - define schemas in .lp.sql files, validate, and apply with shadow DB testing

OWASP Cheat Sheet Series に基づくセキュリティレビューと実装支援。コードレビュー依頼、セキュリティ関連の実装・調査、脆弱性チェック時に使用する。XSS, SQL Injection, CSRF, 認証認可などのセキュリティトピックを扱う。

Configure KPI delta displays in drizzle-cube dashboards for showing metrics with change indicators and trends. Use when displaying KPIs with trends, growth rates, or comparison to previous period.

CLI tool (arxivterminal) for fetching, searching, and managing arXiv papers locally. Use when working with arXiv papers using the arxivterminal command - fetching new papers by category, searching the local database, viewing papers from specific dates, or managing the local paper database.

Go database integration patterns using sqlx, pgx, and migration tools like golang-migrate. Covers repository pattern, connection pooling, transaction handling, and schema evolution. Use when building data access layers or managing database schemas.

TypeScript-first ORM patterns for PostgreSQL, MySQL, and SQLite. Use when writing database schemas, queries, migrations, relations, or transactions with Drizzle ORM.

AiMinder 프로젝트 로컬 PostgreSQL 데이터베이스 조회 및 관리 도구.사용 시점: (1) 로컬 DB 데이터 조회, (2) 테이블 구조 확인, (3) SQL 쿼리 실행, (4) 사용자/목표/일정 데이터 분석

Execute SQL queries on Danmarks Statistik data stored in DuckDB. Use when user needs specific data analysis, filtering, aggregation, or joins. Also includes table summary functionality.

ViewModel, LiveData, Room database, Navigation Component, Hilt. Use when building with Jetpack.

Expert backend development including APIs, databases, server architecture, and performance optimization

ALWAYS use this skill when users ask to "create a skill", "make a skill for...", "add a new skill", or similar requests. This skill guides the creation of effective skills in the bigquery-etl repository that extend Claude's capabilities with specialized knowledge for BigQuery ETL workflows, Mozilla data platform conventions, or telemetry analysis. CRITICAL - First checks for conflicts with existing skills and recommends using/updating existing skills when appropriate. Do NOT attempt to create skills without invoking this skill first.

Activates automatically when designing or implementing Cloudflare Workers APIs,orchestrating multi-provider API calls, implementing D1 database operations,or managing KV-based caching strategies.Ensures proper error handling, provider tagging, fallback chains, andorchestration patterns for BooksTrack backend infrastructure.Auto-activates on:- File patterns: *.worker.js, *-api.ts, *-service.ts in backend code- Keywords: "api orchestration", "multi-provider", "fallback chain", "D1 query"- Context: Cloudflare Workers development, API design discussions

Chief Architect review - critically evaluate peer feedback on an engineering spec. Integrate valid suggestions, push back on scope creep, and maintain alignment with the PRD. Enforce startup simplicity.

Embedding/vector caching for AI cost optimization

Enterprise comprehensive code review automation with AI-powered quality analysis, TRUST 5 enforcement, multi-language support, Context7 integration, security scanning, performance analysis, test coverage validation, and automated review feedback generation

Instrument human approval workflows, feedback loops, and escalations

Master MongoDB find queries with filters, projections, sorting, and pagination. Learn query operators, comparison, logical operators, and real-world query patterns. Use when retrieving data from MongoDB collections.

Master LINQ and EF Core query optimization including N+1 prevention, eager loading, projections, and performance patterns. Use when: (1) fixing N+1 queries, (2) optimizing slow queries, (3) implementing efficient data access, (4) reducing database load.

This skill should be used when users ask questions about pod network development, pod smart contract language, pod APIs, pod tooling, or pod-specific features. It provides semantic search over the pod network knowledge base to retrieve relevant documentation, code examples, and best practices.

Generate Firebase Repository classes following the project's three-layer architecture (UI → Service → Repository). Use this skill when creating data access layers for Firestore collections, implementing CRUD operations with proper error handling, exponential backoff retry logic, and type-safe entity mapping. This skill ensures repositories extend FirestoreBaseRepository, inject @angular/fire services directly (no FirebaseService wrapper), and follow the Result Pattern for async operations.