architecting-database-schema
Defines schema, attributes, indexes, and enums for Tourly collections. Use when setting up the database in Appwrite.
Defines schema, attributes, indexes, and enums for Tourly collections. Use when setting up the database in Appwrite.
Guidelines for creating efficient database indexes in Appwrite. Use to ensure search and filter operations stay fast.
LocalDB patterns, IndexedDB usage, and offline fallback strategies
Spring Boot search integration. Elasticsearch, Meilisearch, Typesense, Algolia. Trigger: apigen-search, SearchService, ElasticsearchRepository, indexing
Bootstrap a repository knowledge bank from repository evidence.
Conecta e realiza operações (CRUD e Aggregations) em bancos de dados MongoDB utilizando configurações de conexão salvas. Suporta queries JSON e auxílio na sua construção.
Use this agent when implementing backend file upload functionality to replace IndexedDB browser storage. <example> User: "Files stored in IndexedDB are lost when clearing cache" Agent: Use file-upload-system to implement backend storage </example> <example> User: "Add document upload to the documents module" Agent: Use file-upload-system to create upload endpoints </example>
Backend caching patterns with Redis including write-through, write-behind, cache-aside, and invalidation strategies. Use when implementing Redis cache, managing TTL/expiration, preventing cache stampede, or optimizing cache hit rates.
This skill should be used when working on MongoDB databases, designing document schemas, creating collections, or reviewing MongoDB code. It provides document modeling rules, BSON type guidance, collection design conventions, JSON Schema validator patterns, and existing repository compatibility checks for consistent MongoDB development.
This skill should be used when planning MongoDB sharding, selecting shard keys, configuring zone sharding, or diagnosing sharding performance issues. It provides shard key selection criteria covering cardinality, frequency, and monotonicity analysis, hashed vs ranged sharding trade-offs, zone sharding patterns for multi-tenancy and data residency, scatter-gather avoidance techniques, and chunk management best practices.
This skill should be used when implementing caching strategies, rate limiting, distributed locks, session management, job queues, or other Redis-based patterns.
This skill should be used when working with Redis, designing key schemas, selecting data structures, configuring Redis clients, or managing Redis memory.
Redis usage patterns for the restaurant platform — Pub/Sub channels, Streams with consumer groups, outbox pattern, rate limiting, token blacklist, and caching strategies. Trigger: When working on Redis integration, Pub/Sub, Streams, outbox events, rate limiting, token blacklist, or cache invalidation.
Adds Redis caching layer for active rule versions and compliance lists to meet performance NFRs.
Prisma ORM expert for schema design, migrations, query optimization, relations modeling, and database operations. Use PROACTIVELY for Prisma schema issues, migration problems, query performance, relation design, or database connection issues.
Docker Compose patterns for multi-container setup with MySQL, Redis, Spring Boot, and React. Health checks, profiles, and networking.
Centralized MongoDB database layer for Ottonomix sales prospecting. Provides shared data models, CRUD operations, and query capabilities for company-research and lead-discovery skills. Manages French companies, research snapshots, people, news events, signals, and discovered leads with Ottonomix-specific scoring.
Elasticsearch search and analytics engine operations including CRUD, aggregations, mappings, and reindexing.
Redis patterns — data structures, caching strategies, pub/sub, rate limiting, session management, and operational best practices.
Vérifie l'état du Config Store (Redis/Fichier) via les scripts utilitaires.