Autonomously diagnose Magento 2 cron problems — jobs missed, stuck running, error spikes, cron_schedule bloat, consumer-runner not draining queues, distributed-cron contention — and scaffold new cron jobs (crontab.xml + handler, optional admin-editable schedule). Produces a Cron Report with environment, root cause, fix, and verification.
Autonomously diagnose Magento 2 catalog search problems — missing products, 0 results, wrong relevance, stuck reindex, cluster red/yellow, disk-watermark read-only — and advise on ES 7 → ES 8 or ES 7 → OpenSearch migrations. Produces a Search Report with engine, version, cluster health, root cause, fix, and verification.
Autonomously diagnose Magento 2 slow queries, missing indexes, deadlocks, and N+1 patterns; propose db_schema.xml changes with whitelist regeneration; assess online-DDL feasibility per engine (MySQL 8 vs MariaDB). Produces a SQL Report with root cause, proposed index/rewrite, schema diff, and verification plan.
Configure, diagnose, and tune Magento 2 cron — crontab.xml, cron_groups.xml, the cron_schedule lifecycle, consumer-runner, distributed-cron, and Adobe Commerce Cloud crons. Use when scheduling jobs, debugging stuck/missed runs, or tuning history retention.
Configure and tune Magento 2 catalog search across Elasticsearch 7.x, Elasticsearch 8.x, and OpenSearch 1.x/2.x. Covers env.php per-engine and per-provider (AWS OpenSearch Service, Elastic Cloud, self-host), searchable attributes, aliases, synonyms, stop words, query templates, relevance diagnosis via _search?explain=true, and engine migration decisions.
Write safe, fast SQL in Magento 2 — Select builder, placeholders, batch ops, transactions, composite indexes, db_schema.xml best practices, whitelist, and MySQL 8 / MariaDB features (INSTANT DDL, invisible/functional indexes, histograms). Use when writing queries, designing indexes, diagnosing slow reads, or editing db_schema.xml.
Autonomously diagnose Magento 2 message queue problems — backlog growth, stuck consumers, broker connectivity, DLQ overflow — and scaffold new queues (communication, topology, consumer, publisher) from a specification. Produces an AMQP Report with root cause and fix.
Autonomously diagnose Magento 2 cache issues — FPC bypass, Redis pressure, stale blocks, and invalidation failures — and scaffold custom cache types. Produces a Cache Report with root cause and fix.