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
This skill should be used when writing repository methods, performing MongoDB queries with Motor, handling upserts, preventing duplicate array entries, or designing new query patterns that require indexing.
Patterns for Redis caching — cache-aside, TTL strategies, rate limiting with INCR, frequency capping, pub/sub, session storage, and fail-open patterns. Use this skill when implementing caching, rate limiting, session management, frequency capping, or any Redis operations. Trigger on Redis, caching, rate limit, frequency cap, session store, TTL, or cache invalidation.
ioredis v5 reference for Node.js Redis client — connection setup, RedisOptions, pipelines, transactions, Pub/Sub, Lua scripting, Cluster, and Sentinel. Use when: (1) creating or configuring Redis connections (standalone, cluster, sentinel), (2) writing Redis commands with ioredis (get/set, pipelines, multi/exec), (3) setting up Pub/Sub or Streams, (4) configuring retryStrategy, TLS, or auto-pipelining, (5) working with Redis Cluster options (scaleReads, NAT mapping), or (6) debugging ioredis connection issues. Important: use named import `import { Redis } from 'ioredis'` for correct TypeScript types with NodeNext.
Expert in vector databases, embedding strategies, and semantic search implementation. Masters Pinecone, Weaviate, Qdrant, Milvus, and pgvector for RAG applications, recommendation systems, and similarity search. Use PROACTIVELY for vector search implementation, embedding optimization, or semantic retrieval systems.
