Implement caching strategies using @delon/cache. Use this skill when adding memory cache, LocalStorage cache, SessionStorage cache, or cache interceptors for HTTP requests. Supports TTL-based expiration, cache invalidation, cache grouping, and persistent storage. Optimizes performance by reducing redundant API calls and database queries.
Generate Firebase Repository classes following the project's three-layer architecture (UI → Service → Repository). Use this skill when creating data access layers for Firestore collections, implementing CRUD operations with proper error handling, exponential backoff retry logic, and type-safe entity mapping. This skill ensures repositories extend FirestoreBaseRepository, inject @angular/fire services directly (no FirebaseService wrapper), and follow the Result Pattern for async operations.
Use this when changing the database schema, generating/applying Drizzle migrations for Cloudflare D1 (SQLite), or working with Better Auth schema generation.
Use when working with SQLiteData library (@Table, @FetchAll, @FetchOne macros) for SQLite persistence, queries, writes, migrations, or CloudKit private database sync.
Database repository pattern using BaseMysqliRepository with prepared statements for IBL5. Use when creating repositories, writing database queries, or extending BaseMysqliRepository.
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
Converts Oracle SQL DDL into production-ready Spring Boot JPA Entities and Repositories. Use this when the user provides a SQL CREATE TABLE statement or asks to generate an entity from a database table.
Armazena e consulta memória persistente de projetos em banco PostgreSQL. Use quando: (1) tomar decisões técnicas importantes, (2) identificar TODOs/melhorias, (3) documentar contexto do projeto, (4) consultar decisões anteriores. O Claude deve AUTOMATICAMENTE salvar decisões importantes e consultar memória relevante. Identificação do projeto é automática via git repo + branch.
Modify database repository adapters using sqlc-generated SQLite queries.
PostgreSQL performance optimization techniques and query tuning
Describes the structure of the Food Journal database that allows to store and read food journal entries
Use when asked "cómo hacer queries con relaciones", "obtener productos con variaciones", "filtrar por categoría", "ordenar por precio", "consultas a Supabase", or working with Supabase database queries in Muma Estudio
Supabase database query patterns and best practices for Splits Network
Comprehensive error handling patterns for Splits Network services and apps
Improve code structure and maintainability while strictly preserving existing behavior.
Conduct a comprehensive architecture and code review based on the Well-Architected Framework's five pillars. Use when user says "well-architected review", "wa review", or "architecture review". Analyzes Reliability, Security, Cost Optimization, Operational Excellence, and Performance Efficiency.
