Database
Database management and queries
rag-research-template
by dozybot001
Advanced RAG-style research schema with literature-grounded fields. Use when RefineIdea for hardware-aware or citation-heavy proposals.
five-whys-analysis
by ddunnock
Conduct rigorous 5 Whys root cause analysis with guided questioning, quality scoring, and professional report generation. Use when performing root cause analysis, investigating problems, conducting 5 Whys sessions, troubleshooting recurring issues, or when user mentions "5 whys", "root cause", "why did this happen", "find the cause", or needs to identify underlying causes of defects, failures, or process problems. Includes validation tests, scoring rubric, and countermeasure development.
mail-from
by aashari
Show all emails from a specific person, email address, or domain. Summarize the relationship and communication history. Use when user asks about emails from someone, or wants to see what a specific sender has sent them. Arguments: person name, email address, or domain (e.g. "john@company.com", "amazon.com", "my boss Sarah").
effect-testing
by front-depiction
Write comprehensive tests using @effect/vitest for Effect code and vitest for pure functions. Use this skill when implementing tests for Effect-based applications, including services, layers, time-dependent effects, error handling, and property-based testing.
context-witness
by front-depiction
Decide between Context Tag witness and capability patterns for dependency injection, understanding coupling trade-offs
layer-design
by front-depiction
Design and compose Effect layers for clean dependency management
service-implementation
by front-depiction
Implement Effect services as fine-grained capabilities avoiding monolithic designs
mongodb-transactions-consistency
by romiluz13
MongoDB transaction correctness, consistency, and retry safety. Use when implementing multi-document writes, debugging transaction failures, choosing readConcern/writeConcern, handling TransientTransactionError or UnknownTransactionCommitResult, or deciding when transactions are required. Triggers on "transaction", "withTransaction", "session", "read concern", "write concern", "causal consistency", "snapshot", "retry commit", "ACID", "TransientTransactionError", and "UnknownTransactionCommitResult".
jpa-patterns
by Ashfaqbs
JPA/Hibernate patterns for entity design, relationships, query optimization, transactions, auditing, indexing, pagination, and pooling in Spring Boot.
effect-ai-language-model
by front-depiction
Master the Effect AI LanguageModel service for text generation, structured output, streaming, and tool calling. Use when working with LLM interactions, schema-validated responses, or building conversational AI systems.
domain-predicates
by front-depiction
Generate comprehensive predicates and orders for domain types using typeclass patterns
effect-ai-tool
by front-depiction
Define and implement AI tools using @effect/ai's Tool and Toolkit APIs. Use when building LLM integrations with type-safe tool definitions, parameter validation, and handler implementations. Covers user-defined tools, provider-defined tools, and toolkit composition.
schema-composition
by front-depiction
Master Effect Schema composition patterns including Schema.compose vs Schema.pipe, transformations, filters, and validation. Use this skill when working with complex schema compositions, multi-step transformations, or when you need to validate and transform data through multiple stages.
mongodb-schema-design
by romiluz13
MongoDB schema design patterns and anti-patterns. Use when designing data models, reviewing schemas, migrating from SQL, or troubleshooting performance issues caused by schema problems. Triggers on "design schema", "embed vs reference", "MongoDB data model", "schema review", "unbounded arrays", "one-to-many", "tree structure", "16MB limit", "schema validation", "JSON Schema".
mongodb-ai
by romiluz13
MongoDB Atlas Vector Search and AI integration. Use when creating vector indexes, writing $vectorSearch queries, building RAG applications, implementing hybrid search, or storing AI agent memory. Triggers on "vector search", "vector index", "$vectorSearch", "embedding", "semantic search", "RAG", "retrieval augmented generation", "numCandidates", "similarity search", "cosine similarity", "hybrid search", "$rankFusion", "$scoreFusion", "rerank", "two-stage retrieval", "AI agent", "LLM memory", "quantization", "multi-tenant", "Search Nodes", "explain vectorsearch", "HNSW", "automated embedding", "autoEmbed", "Voyage AI", "voyage-4", "voyage-4-large", "voyage-code-3", "input_type", "asymmetric retrieval", "lexical prefilter", "fuzzy search vector", "phrase filter".
mongodb-query-and-index-optimize
by romiluz13
MongoDB query optimization and indexing strategies. Use when writing queries, creating indexes, building aggregation pipelines, or debugging slow operations. Triggers on "slow query", "create index", "optimize query", "aggregation pipeline", "explain output", "COLLSCAN", "ESR rule", "compound index", "partial index", "TTL index", "text search", "geospatial", "$indexStats", "profiler".
mongodb-search
by romiluz13
MongoDB Search engine architecture, query composition, and search operations. Use when creating Atlas Search indexes, writing $search or $searchMeta pipelines, choosing analyzers, tuning lexical relevance, handling Search alerts/metrics, deploying Search in Community, or orchestrating hybrid search with $rankFusion/$scoreFusion. Triggers on "Atlas Search", "$search", "$searchMeta", "autocomplete", "synonyms", "facet", "compound", "search score", "highlight", "storedSource", "returnStoredSource", "returnScope", "mongot", "searchCoordinator", "Search Max Fields Indexed", "nGram fields", "$rankFusion", "$scoreFusion", and "hybrid search".
rails-model-patterns
by ag0os
ActiveRecord model patterns and conventions for Rails. Automatically invoked when working with models, associations, validations, scopes, callbacks, or database schema design. Triggers on "model", "ActiveRecord", "association", "has_many", "belongs_to", "validation", "validates", "scope", "callback", "migration", "schema", "index", "foreign key".
skill-system-memory
by arthur0824hao
Persistent shared memory for AI agents backed by PostgreSQL (fts + pg_trgm, optional pgvector). Includes compaction logging and maintenance scripts.
quickbooks-online-api
by linehaul-ai
Expert guide for QuickBooks Online API integration covering authentication, CRUD operations, batch processing, and best practices for invoicing, payments, and customer management.
synapse
by pmaojo
"Synapse: High-performance neuro-symbolic knowledge graph for OpenClaw. Provides structured long-term memory, reasoning, and hybrid search."
taiwan-mrt-fareastern-empty-train
by pigfoot
Find empty trains (空車) at 亞東醫院 MRT station. Use when user asks about empty trains, 空車, or uncrowded trains at 亞東醫院/Far Eastern Hospital station on the Bannan line.
queryset-optimizer
by ragnarok22
Optimize Django ORM performance by detecting N+1 query patterns, missing select_related/prefetch_related, and likely index gaps. Run targeted static scans, optional runtime query capture, and produce a prioritized remediation plan with expected query-count impact. Use when users ask to speed up Django endpoints, reduce database hits, investigate slow views/serializers, or audit QuerySet efficiency before release.
plan-review
by yelban
互動式計畫審查：在實作前檢視計畫的完整性、方向、風險與範圍。 適用 codex-plan 產出、plan mode 計畫、或任何實作計畫文件。 觸發詞：/plan-review、review plan、審查計畫、檢視計畫