Databases

A comprehensive, long-horizon skill for designing, coding, debugging, and scaling AI-integrated systems — including Python backends, React frontends, RAG pipelines, vector databases, and tool orchestration. Ensures production-grade quality and consistency across every code and architecture decision.

Implements Supabase PostgreSQL database with JavaScript client, Row Level Security, real-time subscriptions, and edge functions. Use when building apps with Supabase, implementing RLS policies, or needing real-time database features.

Obsidian LiveSync の CouchDbClient の構造と使用方法を説明します。CouchDbRepository トレイトの実装方法、HTTP プロキシパターン（forward_request）、longpoll リクエストの処理、メトリクス収集、ヘルスチェックの実装を理解・拡張する際に使用します。CouchDB 関連の機能追加、トラブルシューティング、パフォーマンス改善を依頼されたときに使用してください。

Core WordPress plugin development fundamentals including file structure, security patterns (sanitize, escape, nonces, capabilities), hooks system (actions/filters), database operations with wpdb, and coding standards. Use when creating plugins, implementing security, or working with core WordPress APIs.

Manage OmniFocus projects and tasks programmatically. This skill should be used when creating, reading, updating, or listing OmniFocus tasks and projects. Supports all OmniFocus versions through intelligent automation method detection (Omni Automation → AppleScript → SQLite read-only fallback). Use for task management workflows, project queries, task completion tracking, and OmniFocus data operations.

Auditar conexões R2DBC MySQL, tunar pools reativos e validar binding de secrets via Azure Key Vault/Swarm para o backend de resultados.

Production-grade agentic system development with LlamaIndex in Python. Covers semantic ingestion (SemanticSplitterNodeParser, CodeSplitter, IngestionPipeline), retrieval strategies (BM25Retriever, hybrid search, alpha weighting), PropertyGraphIndex with graph stores (Neo4j), context RAG (RouterQueryEngine, SubQuestionQueryEngine, LLMRerank), agentic orchestration (ReAct, Workflows, FunctionTool), and observability (Arize Phoenix). Use when asked to "build a LlamaIndex agent", "set up semantic chunking", "index source code", "implement hybrid search", "create a knowledge graph with LlamaIndex", "implement query routing", "debug RAG pipeline", "add Phoenix observability", or "create an event-driven workflow". Triggers on "PropertyGraphIndex", "SemanticSplitterNodeParser", "CodeSplitter", "BM25Retriever", "hybrid search", "ReAct agent", "Workflow pattern", "LLMRerank", "Text-to-Cypher".

Analyze system performance using throttle statistics, query logs, and resource metrics to identify bottlenecks and optimization opportunities

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