資料庫

Create and harden systemd service unit files following modern best practices. Use when writing new systemd units for web applications, background workers, or daemons, or when hardening existing services with security sandboxing and isolation features. Covers service types, dependencies, restart policies, security options, and filesystem restrictions.

Define database models and schemas with proper data types, constraints, relationships, and validation rules. Use this skill when creating or modifying database models, ORM entities, schema definitions, or data validation layers. When working on Prisma schema files, TypeORM entities, Drizzle schema definitions, Mongoose models, database model classes, files defining table structures and relationships, validation schemas for database entities, or files implementing data integrity constraints and cascading behaviors.

Build enterprise Blazor applications with MudBlazor component library. Use when creating forms, data grids, dialogs, navigation, theming, layout systems, or integrating with Neatoo domain objects. Covers installation, components, validation, data display, and enterprise patterns.

Drizzle ORMを使用したデータベース操作を支援。スキーマ変更、マイグレーション、シードデータ投入、DBリセットで使用。トリガー例：「DBを更新」「スキーマ変更」「テーブル追加」「カラム追加」「シード実行」「マイグレーション」

This skill should be used when the user asks to "access LSEG data", "query Refinitiv", "get market data from Refinitiv", "download fundamentals from LSEG", "access ESG scores", "convert RIC to ISIN", or needs the LSEG Data Library Python API.

Deploy and manage Docker containers on Cloudflare's global network alongside Workers. Use when building applications that need to run Python code, process large files (multi-GB zips, video transcoding), execute CLI tools, run AI inference, create code sandboxes, or any workload requiring more memory/CPU than Workers provide. Triggers include requests to run containers, execute arbitrary code, process large files, deploy backend services in Python/Go/Rust, or integrate heavyweight compute with Workers.

Async SQLAlchemy 2.0+ database patterns for FastAPI including session management, connection pooling, Alembic migrations, relationship loading strategies, and query optimization. Use when implementing database models, configuring async sessions, setting up migrations, optimizing queries, managing relationships, or when user mentions SQLAlchemy, async database, ORM, Alembic, database performance, or connection pooling.

SQL for data analysis with exploratory analysis, advanced aggregations, statistical functions, outlier detection, and business insights. 50+ real-world analytics queries.

Standardize Drizzle schema/migration/seed workflow for Viet K-Connect. Use when adding or changing DB tables, especially DB-driven visa rulesets and document templates (no hardcoding).

Guide for implementing Obsidian knowledge management - vault operations, plugin development, URI scheme automation, markdown extensions, and Local REST API integration. Use when working with Obsidian vaults, creating plugins, automating note workflows, querying notes via API, or implementing knowledge graph features.

Helps turn app ideas into shippable MVPs with opinionated guidance on scoping, tech stack (Next.js, Supabase, Vercel), and avoiding feature creep. Use when the user wants to plan an MVP, create a PRD, generate Claude Code prompts, scope features, make product decisions, or needs help staying focused on shipping. Triggers include "plan this app", "help me scope this", "create a PRD", "what should I build first", "generate a Claude Code prompt", or any request to turn an idea into something shippable.

Go database integration patterns using sqlx, pgx, and migration tools like golang-migrate

This skill provides guidance for implementing robust Qdrant vector database integration with RAG (Retrieval Augmented Generation) systems, including proper async client handling, error management, and performance optimization.

Zero-downtime Elixir/Phoenix database migrations and rollback strategies

Dokploy 셀프호스팅 PaaS 플랫폼의 전체 관리 스킬. SSH 및 API를 통한 서버 관리,애플리케이션 배포, Docker Compose/Swarm 관리, 데이터베이스(PostgreSQL, MySQL, MongoDB, Redis) 관리,Traefik 리버스 프록시 설정, SSL 인증서(Let's Encrypt, Cloudflare Origin CA), 도메인 설정,볼륨 백업/복원, 컨테이너 모니터링, 서버 문제 해결 및 디버깅을 지원합니다.이 스킬 사용 시점:(1) "Dokploy", "dokploy" 언급 시(2) 애플리케이션 배포/재배포 요청(3) Docker Compose 또는 Swarm 관련 작업(4) 도메인 설정, SSL 인증서, HTTPS 설정(5) Traefik 설정 확인/수정, 502 에러, 도메인 접속 문제(6) 데이터베이스 생성, 백업, 복원(7) 볼륨 백업/복원, S3 연동(8) 컨테이너 로그 확인, 서버 상태 점검(9) 서버 유지보수, Dokploy 업데이트(10) 빌드 타입 선택 (Nixpacks, Dockerfile, Buildpack)

Implement comprehensive input validation with server-side security, client-side UX feedback, sanitization, and consistent error messages. Use this skill when validating user input in forms, API endpoints, or data processing. When writing validation rules for data types, formats, ranges, or required fields. When sanitizing input to prevent injection attacks (SQL, XSS, command injection). When providing field-specific error messages to users. When implementing validation at system boundaries like API endpoints or background jobs.

Records agent execution results, performance metrics, and errors to SQLite database. Use after completing any agent task, when logging task results, or when an agent fails. Tracks success/failure rates and execution times for continuous improvement.

セキュアな開発・運用のための実装指針、機密情報管理、通信の確保、入力値検証、依存ライブラリ管理のガイドラインを定義する。セキュリティ実装時、認証・認可実装時、API開発時、またはユーザーがセキュリティ、機密情報、暗号化、XSS対策、SQL injection、脆弱性管理に言及した際に使用する。

Comprehensive guide for PostgreSQL psql - the interactive terminal client for PostgreSQL. Use when connecting to PostgreSQL databases, executing queries, managing databases/tables, configuring connection options, formatting output, writing scripts, managing transactions, and using advanced psql features for database administration and development.

Hash-based data structures and techniques including frequency counting, duplicate detection, and LRU cache implementation.