Databases

Comprehensive software architecture skill for designing scalable, maintainable systems using ReactJS, NextJS, Bun, Express, React Native, Swift, Kotlin, Flutter, Postgres, GraphQL, Go, Python. Includes architecture diagram generation, system design patterns, tech stack decision frameworks, and dependency analysis. Use when designing system architecture, making technical decisions, creating architecture diagrams, evaluating trade-offs, or defining integration patterns.

DevOps and server management for Skriptoteket on home server (hemma.hule.education). Branched skill covering deploy, database, users, CLI, security, network, DNS, and troubleshooting.

Database migration management for SQLAlchemy projects using Alembic

AWS CLI v2 quick-reference for experienced developers. Covers compute (Lambda, ECS, EKS), storage (S3, DynamoDB, Aurora), networking (VPC, SSM tunneling), security (IAM, Secrets Manager), and GitHub Actions CI/CD. Use when asked to "write aws commands", "debug aws access", "set up cross-account roles", "configure aws cli", "assume role", "S3 bucket operations", or "deploy to ECS".

Comprehensive DuckDB database backup toolkit supporting both file-based (cp) and native (ATTACH+COPY) backup approaches. Use when you need to backup DuckDB databases locally or to remote storage, create daily scheduled backups, verify backup integrity, or manage backup retention policies.

Follow these patterns when implementing quant domain resources like Dataset, Signal, Alpha, Portfolio, Strategy, Universe, Backtest, or MonitoringRun in OptAIC. Use for creating DB models, DTOs, services, and tests for trading-specific entities.

Aggregates user reviews from Amazon/Reddit and expert reviews from specialized sites with sentiment analysis. Use when user asks to 'get reviews', 'what do users say', 'aggregate reviews', 'user feedback', 'expert opinions', or when orchestrator needs sentiment analysis and pros/cons extraction. Synthesizes consensus patterns across sources.

This skill should be used when working with database migrations in SQLModel-based projects. Trigger when user asks to create migrations for new/modified models, generate database schema changes, or apply migrations. Enforces SQLModel as single source of truth and automatic migration generation only.

データベーススキーマ設計と最適化を支援します。正規化戦略、インデックス設計、パフォーマンス最適化を提供します。データモデル設計、データベース構造の最適化が必要な場合に使用してください。

Enterprise template management with code boilerplates, feedback templates, and project optimization workflows

This skill should be used when the user asks to "search Notion", "find in Notion", "search my Notion workspace", "create Notion page", "make a Notion page", "update Notion page", "edit Notion page", "query Notion database", "get Notion database", "read Notion page", "get page content from Notion", "list Notion pages", or mentions Notion integration, Notion workspace, or Notion API access.

Optimize AgentDB performance with quantization (4-32x memory reduction), HNSW indexing (150x faster search), caching, and batch operations. Use when optimizing memory usage, improving search speed, or scaling to millions of vectors.

Configure KPI text displays in drizzle-cube dashboards for showing metric values with custom text templates. Use when displaying KPIs with custom formatting, labels, or contextual text around numeric values.

Query PubMed and scientific databases for protocols, analyze biological data with Biopython, handle HIPAA-compliant data. Use for biology research, protocol searches, sequence analysis, or scientific data handling. Cross-validates sources for high accuracy. Triggers on "PubMed", "biology", "scientific data", "sequences", "protocols", "life sciences", "HIPAA".

Integrates MongoDB document database with Node.js applications using the official driver or Mongoose ODM. Use when building applications with flexible schemas, document storage, or when user mentions MongoDB, NoSQL, or document databases.

Analyze user feedback and edit existing skills to perfection by applying targeted enhancements. Use when users want to improve, refine, iterate on, or perfect an existing skill based on specific feedback. Triggers on requests like "improve this skill", "enhance the X skill", "this skill needs...", "make this skill better", "refine the skill based on...", or when users provide critique, suggestions, or observations about skill behavior that should be incorporated.

Use at the start of a Codex session (especially sandboxed) to run `scripts/codex-sandbox-preflight.sh` and interpret network + writable_roots constraints.

Comprehensive guide for building functional tools for LiveKit voice agents using the @function_tool decorator. Use when creating tools for LiveKit agents to enable capabilities like API calls, database queries, multi-agent coordination, or any external integrations. Covers tool design, RunContext handling, interruption patterns, parameter documentation, testing, and production best practices.

Complete literature retrieval capability combining search and filter skills.LOAD THIS SKILL WHEN: User needs "文獻檢索", "找文獻", "retrieve literature", "系統性搜尋" | starting systematic review | comprehensive literature search.CAPABILITIES: Multi-database search, MeSH expansion, quality filtering, PRISMA-compliant workflow.COMPOSITE SKILL: Combines literature-search + literature-filter.

Generate, optimize, and explain SQL queries with best practices. Use when writing database queries or optimizing SQL performance.