moai-domain-database
Database specialist covering PostgreSQL, MongoDB, Redis, and advanced data patterns for modern applications
Database specialist covering PostgreSQL, MongoDB, Redis, and advanced data patterns for modern applications
High-performance temporary storage system using Redis. Supports namespaced keys (mema:*), TTL management, and session context caching. Use for: (1) Saving agent state, (2) Caching API results, (3) Sharing data between sub-agents.
Firestore data modeling best practices including subcollections vs root collections, document structure, relationships, query optimization, composite indexes, and atomic operations (transactions vs batches). Keywords: "subcollection", "root collection", "data model", "relationship", "index", "transaction", "batch"
Implement high-performance in-memory caching with trigger-based cache invalidation for C#/.NET applications. Use when creating new entities that need caching, optimizing database queries, implementing cache invalidation strategies, or setting up cache management for ASP.NET Core projects. Supports PostgreSQL and MSSQL databases. Can use Redis for hybrid (two-level) caching if available in the project, or pure in-memory caching if Redis is not present or desired.
Multi-layer caching strategies across CDN, browser, server, and database. PROACTIVELY activate for: (1) HTTP caching headers, (2) CDN configuration, (3) Server-side caching with Redis, (4) Cache invalidation strategies, (5) ETag implementation. Triggers: "caching", "cache strategy", "CDN", "browser cache", "server cache", "redis", "cache invalidation", "ETag", "Cache-Control"
Firestore data modeling best practices including subcollections, document structure, and atomic operations. PROACTIVELY activate for: (1) designing Firestore collection structures, (2) choosing between subcollections vs root collections, (3) implementing transactions vs batched writes. Triggers: "subcollection", "data model", "firestore"
Redis caching patterns for FastAPI: cache-aside, distributed locks, sessions, rate limiting, pub/sub, and semantic (vector) caching with pgvector. Use for: response caching, session storage, rate limiting, real-time events, leaderboards. Triggers: cache, Redis, caching, invalidation, session, rate limit, pub/sub, TTL, lock.
Manage Firebase/Firestore operations including CRUD, queries, batch processing, and index/rule guidance. Use when you need to create/update/query Firestore documents, run batch writes, troubleshoot missing indexes, or plan migrations. Trigger with phrases like "firestore operations", "create firestore document", "batch write", "missing index", or "fix firestore query".
Database specialist covering PostgreSQL, MongoDB, Redis, Oracle, and advanced data patterns for modern applications.
Firebase Firestore specialist covering NoSQL patterns, real-time sync, offline caching, and Security Rules. Use when building mobile-first apps with offline support, implementing real-time listeners, or configuring Firestore security.
Implement intelligent API response caching with Redis, Memcached, and CDN integration. Use when optimizing API performance with caching. Trigger with phrases like "add caching", "optimize API performance", or "implement cache layer".
A specialized guide for managing Qdrant Cloud collections, optimizing vector schemas for RAG, and executing precise semantic search queries in Python.
Reference guide for MongoDB performance patterns: index strategies (ESR rule, compound, partial, TTL), explain plan interpretation, and performance checklists. Use as background knowledge when advising on indexing or performance. For hands-on optimization of a specific slow query, trigger the query-advisor agent instead.
Redis performance optimization and best practices. Use this skill when working with Redis data structures, Redis Query Engine (RQE), vector search with RedisVL, semantic caching with LangCache, or optimizing Redis performance.
Decision frameworks for Redis. When to use which data structure, caching strategies, and common patterns for queues and real-time features.
Redis caching playbook (cache-aside/read-through/write-through), TTL strategy, cache stampede protection, and invalidation/versioning. Produces cache key spec + invalidation strategy.
MongoDB schema design, query optimization, aggregation pipelines, and database operations for the PMS database layer. Use for database design, query optimization, and data modeling.
Apply NoSQL best practices for MongoDB, Convex, and document databases. Use when designing schemas, writing queries, optimizing performance, or building applications with non-relational databases. Use with database-expert for query optimization and DBA-level tuning (20+ years experience).
Redis performance optimization and best practices. Use this skill when working with Redis data structures, Redis Query Engine (RQE), vector search with RedisVL, semantic caching with LangCache, or optimizing Redis performance.
Implement multi-level caching with Redis and in-memory LRU patterns. Use when adding caching layers, implementing Redis, or optimizing API performance. Triggers on requests for caching setup, Redis configuration, cache invalidation, or performance caching.
Database specialist covering PostgreSQL, MongoDB, Redis, and advanced data patterns for modern applications