sql-query-optimizer
Analyze plans and improve query performance.
Analyze plans and improve query performance.
Desarrollo con Redis y BullMQ. Usar cuando: crear/modificar jobs de cola, debugging de workers, métricas de jobs, persistencia en Redis, caching, pub/sub, o cualquier operación con ioredis y BullMQ.
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.
Persist rich-link images and related metadata into the committed OpenLinks cache when links are added or updated.
Provides comprehensive guidance for Redis including data structures, commands, pub/sub, persistence, clustering, and caching patterns. Use when the user asks about Redis, needs to use Redis for caching, implement Redis data structures, or work with Redis features.
Advanced management for Magento 2 on DDEV with MariaDB, Redis, OpenSearch/Elasticsearch 8, RabbitMQ, Varnish, PhpMyAdmin, and XHGui/XHProf.
Padrões e armadilhas do Firebase no RazaiSystem. Use quando trabalhar com Firestore, criar queries, índices, regras de segurança, deploy, ou resolver erros de Firebase.
Database specialist covering PostgreSQL, MongoDB, Redis, and advanced data patterns for modern applications
Redis 7.8 version-specific expert. Deep knowledge of new data type enhancements, cluster improvements, enhanced observability features, and performance optimizations. WHEN: "Redis 7.8", "Redis 7.8 features", "Redis 7.8 cluster", "Redis 7.8 improvements".
MongoDB 7.0 version-specific expert. Deep knowledge of compound wildcard indexes, Queryable Encryption GA, metadata in change streams, ShardingReady state, improved $merge/$out, automergeable chunks, $percentile/$median operators, and Atlas Search score details. WHEN: "MongoDB 7.0", "Mongo 7.0", "compound wildcard index", "Queryable Encryption GA", "ShardingReady", "reshardCollection", "automergeable chunks", "$median", "$percentile", "MongoDB 7".
MongoDB 6.0 version-specific expert. Deep knowledge of Queryable Encryption (preview), cluster-to-cluster sync, new aggregation operators ($densify, $fill, $setWindowFields enhancements), time-series collection improvements, and change stream enhancements. WHEN: "MongoDB 6.0", "Mongo 6.0", "Queryable Encryption preview", "cluster-to-cluster sync", "mongosync", "$densify", "$fill", "change stream pre/post images", "MongoDB 6".
Elasticsearch technology expert covering ALL versions. Deep expertise in full-text search, index management, cluster operations, Query DSL, aggregations, mappings, and operational tuning. WHEN: "Elasticsearch", "elastic", "ELK", "Kibana", "Logstash", "index management", "Query DSL", "mapping", "analyzer", "shard", "replica", "cluster health", "_cat API", "bulk API", "ingest pipeline", "ILM", "snapshot", "cross-cluster".
Elasticsearch 9.x version-specific expert. Deep knowledge of Lucene 10, logsdb index mode as default, TSDB enhancements, breaking changes from 8.x, removed deprecated features, and migration guidance. WHEN: "Elasticsearch 9", "ES 9", "Lucene 10", "ES upgrade to 9", "logsdb", "ES 9 breaking changes", "ES 9 migration", "Elasticsearch 9.0".
Elasticsearch 8.x version-specific expert. Deep knowledge of security by default, kNN vector search, NLP inference, TSDB index mode, serverless architecture, Elastic Agent, and migration from 7.x. WHEN: "Elasticsearch 8", "ES 8", "kNN search", "vector search elastic", "NLP inference", "security by default", "ES 8 migration", "dense_vector", "HNSW", "Elastic Agent", "Fleet", "TSDB", "searchable snapshots", "ES 8.0", "ES 8.1", "ES 8.2", "ES 8.3", "ES 8.4", "ES 8.5", "ES 8.6", "ES 8.7", "ES 8.8", "ES 8.9", "ES 8.10", "ES 8.11", "ES 8.12", "ES 8.13", "ES 8.14", "ES 8.15", "ES 8.16", "ES 8.17".
Amazon ElastiCache and MemoryDB expert. Deep expertise in managed Redis/Valkey/Memcached, cluster mode, replication, failover, and caching strategies. WHEN: "ElastiCache", "MemoryDB", "ElastiCache Redis", "ElastiCache Memcached", "ElastiCache Valkey", "ElastiCache Serverless", "cache node", "replication group", "ElastiCache cluster mode", "ElastiCache Global Datastore".
Schema design with Mongoose: embedded vs referenced documents, validation rules, compound indexes, TTL indexes, sparse indexes. Use when designing MongoDB schemas for a Node.js application.
Use when migrating SendGrid email integration to Resend - detects @sendgrid/mail, sgMail, sendgrid-ruby, sendgrid-go, sendgrid-java, sendgrid-php, or SENDGRID_API_KEY patterns.
Build reference mapping CSV, match parsed city to county, lookup County__c record ID
Redis 快取架構專家,專精於 ioredis 整合、快取策略設計、Cluster 配置、Pub/Sub 實作與效能調校。
Activates when user requests Redis architecture design, caching patterns, distributed locks, pub/sub messaging, high availability setup, or queue system design. Do NOT use for SQL database design. Examples: 'Design Redis cache strategy', 'Implement distributed lock'.
LNX distributed search cluster configuration. Use when setting up multi-node search clusters, need fault tolerance, or horizontal scaling requirements.
Database query optimization, schema design, indexing, migration safety, and performance tuning. Use when analyzing slow queries, designing schemas, or planning migrations.
Backend development for robochi_bot using Python, Django, PostgreSQL, Redis, and Celery.